| Table: pfts |
Legend:
Primary key columns
Indexed columns
| Column | Type | Size | Nulls | Auto | Default | References | Comments |
|---|---|---|---|---|---|---|---|
| id | bigserial | 19 | χ | √ | nextval('pfts_id_seq'::regclass) | ||
| definition | text | 2147483647 | χ | χ | Defines the creator and context under which the pft will be used. | ||
| created_at | timestamp | 29,6 | √ | χ | utc_now() | ||
| updated_at | timestamp | 29,6 | √ | χ | utc_now() | ||
| name | varchar | 255 | χ | χ | pft names are unique within a given model type. | ||
| parent_id | int8 | 19 | √ | χ | null | pfts.id | |
| pft_type | varchar | 255 | χ | χ | 'plant'::character varying | ||
| modeltype_id | int8 | 19 | χ | χ | modeltypes.id |
Indexes:
| Column(s) | Type | Sort | Constraint Name |
|---|---|---|---|
| id | Primary key | Asc | pfts_pkey |
| name + modeltype_id | Must be unique | Asc/Asc | unique_name_per_model |
| name + modeltype_id | Must be unique | Asc/Asc | unique_names_per_modeltype |
|
