agencies

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
agency_id uuid 2147483647 null
token_verifications.agency_id Implied Constraint R
users.agency_id Implied Constraint R
agency_code varchar 50 √ null
agency_name varchar 50 null
owner_name varchar 100 null
owner_email varchar 200 null
status varchar 20 null
varchar 255 √ null
favicon varchar 255 √ null
communication_email varchar 255 √ null
primary_color varchar 50 √ null
secondary_color varchar 50 √ null
created_at timestamp 29,6 CURRENT_TIMESTAMP
updated_at timestamp 29,6 √ null
created_by uuid 2147483647 √ null
updated_by uuid 2147483647 √ null
is_master bool 1 √ false

Indexes

Constraint Name Type Sort Column(s)
agencies_pkey Primary key Asc agency_id
agencies_agency_code_key Must be unique Asc agency_code
agencies_owner_email_key Must be unique Asc owner_email

Relationships

Close relationships within degrees of separation