| 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 | citations.id | |
| 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 | users.id |
Indexes:
| 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 |
|
