Table: managements
Legend: Primary key columns Indexed columns
Column Type Size Nulls Auto Default References Comments
id bigserial 19  χ   √  nextval('managements_id_seq'::regclass)
citation_id int8 19  √   χ  null
date date 13  √   χ  null Date on which management was conducted.
dateloc numeric 4,2  √   χ  null Level of confidence in value given as date. See documentation for details.
mgmttype varchar 255  χ   χ  Type of management
level float8 17,17  √   χ  null Amount applied, not always required.
units varchar 255  √   χ  null units, standardized for each management type.
notes text 2147483647  χ   χ  ''::text
created_at timestamp 29,6  √   χ  utc_now()
updated_at timestamp 29,6  √   χ  utc_now()
user_id int8 19  √   χ  null
Column(s) Type Sort Constraint Name
id Primary key Asc managements_pkey
citation_id Performance Asc index_managements_on_citation_id
user_id Performance Asc index_managements_on_user_id