Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| id | serial | 10 | √ | nextval('criteria_id_seq'::regclass) |
|
|
|||||
| uuid | varchar | 2147483647 | null |
|
|
||||||
| qualification_name | varchar | 2147483647 | √ | null |
|
|
|||||
| qualification_code | int4 | 10 | √ | null |
|
|
|||||
| condition_names | json | 2147483647 | √ | null |
|
|
|||||
| condition_codes | json | 2147483647 | √ | null |
|
|
|||||
| range_sets | json | 2147483647 | √ | null |
|
|
|||||
| created_at | timestamp | 29,6 | now() |
|
|
||||||
| updated_at | timestamp | 29,6 | now() |
|
|
||||||
| deleted_at | timestamp | 29,6 | √ | null |
|
|
|||||
| quota_id | int4 | 10 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_91cd5f7ff7be5ade9bca5b98cfb | Primary key | Asc | id |
| UQ_c008d961adf5098d949eac6c644 | Must be unique | Asc | uuid |