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
pft_type varchar 255  χ   χ  'plant'::character varying
modeltype_id int8 19  χ   χ
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