Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| company_id | uuid | 2147483647 | null |
|
|
|||||||||||||||
| name | varchar | 120 | null |
|
|
|||||||||||||||
| status | varchar | 20 | null |
|
|
|||||||||||||||
| created_at | timestamptz | 35,6 | CURRENT_TIMESTAMP |
|
|
|||||||||||||||
| updated_at | timestamptz | 35,6 | CURRENT_TIMESTAMP |
|
|
|||||||||||||||
| version | int8 | 19 | 0 |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| pk_company | Primary key | Asc | company_id |
Check Constraints
| Constraint Name | Constraint |
|---|---|
| ck_company_updated_at | (updated_at >= created_at) |
| ck_company_version | (version >= 0) |
| ck_company_status | ((status)::text = ANY ((ARRAY['ACTIVE'::character varying, 'SUSPENDED'::character varying, 'DISABLED'::character varying])::text[])) |
| ck_company_name_not_blank | (char_length(TRIM(BOTH FROM name)) > 0) |
Relationships
Close relationships within degrees of separation
