12 Foreign Key Constraints
| Constraint Name | Child Column | Parent Column | Delete Rule | ||
|---|---|---|---|---|---|
| cardgroups_owner_id_fkey |
|
|
Cascade on delete | ||
| user_card_fsrs_card_id_fkey |
|
|
Cascade on delete | ||
| user_card_fsrs_user_id_fkey |
|
|
Cascade on delete | ||
| swipe_records_user_id_fkey |
|
|
Cascade on delete | ||
| swipe_records_card_id_fkey |
|
|
Cascade on delete | ||
| user_preferences_last_viewed_cardgroup_id_fkey |
|
|
Null on delete | ||
| user_preferences_user_id_fkey |
|
|
Cascade on delete | ||
| master_cards_master_cardgroup_id_fkey |
|
|
Cascade on delete | ||
| users_id_fkey |
|
|
Cascade on delete | ||
| cards_cardgroup_id_fkey |
|
|
Cascade on delete | ||
| user_roles_role_id_fkey |
|
|
Cascade on delete | ||
| user_roles_user_id_fkey |
|
|
Cascade on delete |
Check Constraints
| Table | Constraint Name | Constraint |
|---|---|---|
| master_cardgroups | master_cardgroups_name_length | ((char_length(TRIM(BOTH FROM name)) >= 1) AND (char_length(TRIM(BOTH FROM name)) <= 100)) |
| master_cardgroups | master_cardgroups_status_values | (status = ANY (ARRAY['draft'::text, 'published'::text])) |
| cardgroups | cardgroups_name_length | ((char_length(TRIM(BOTH FROM name)) >= 1) AND (char_length(TRIM(BOTH FROM name)) <= 100)) |
| swipe_records | swipe_records_rating_check | ((rating >= 1) AND (rating <= 4)) |
| user_preferences | user_preferences_learn_display_mode_check | (learn_display_mode = ANY (ARRAY['flip_to_reveal'::text, 'always_visible'::text])) |
| master_cards | master_cards_back_length | ((char_length(TRIM(BOTH FROM back)) >= 1) AND (char_length(TRIM(BOTH FROM back)) <= 500)) |
| master_cards | master_cards_front_length | ((char_length(TRIM(BOTH FROM front)) >= 1) AND (char_length(TRIM(BOTH FROM front)) <= 500)) |
| cards | cards_back_length | ((char_length(TRIM(BOTH FROM back)) >= 1) AND (char_length(TRIM(BOTH FROM back)) <= 500)) |
| cards | cards_front_length | ((char_length(TRIM(BOTH FROM front)) >= 1) AND (char_length(TRIM(BOTH FROM front)) <= 500)) |