cardgroups

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 gen_random_uuid()
cards.cardgroup_id cards_cardgroup_id_fkey C
user_preferences.last_viewed_cardgroup_id user_preferences_last_viewed_cardgroup_id_fkey N
owner_id uuid 2147483647 null
users.id cardgroups_owner_id_fkey C
name text 2147483647 null
created_at timestamptz 35,6 now()
updated_at timestamptz 35,6 now()

Indexes

Constraint Name Type Sort Column(s)
cardgroups_pkey Primary key Asc id
idx_cardgroups_owner_id Performance Asc owner_id
idx_cardgroups_updated_at Performance Asc updated_at

Check Constraints

Constraint Name Constraint
cardgroups_name_length ((char_length(TRIM(BOTH FROM name)) >= 1) AND (char_length(TRIM(BOTH FROM name)) <= 100))

Relationships

Close relationships within degrees of separation