| Table bety.public.treatments |
Legend:
Primary key columns
Indexed columns
| Column | Type | Size | Nulls | Auto | Default | References | Comments |
|---|---|---|---|---|---|---|---|
| id | serial | 10 | χ | √ | nextval('treatments_id_seq'::regclass) | ||
| name | varchar | 255 | √ | χ | null | Name of treatment, should be easy to associate with treatment name in original study. | |
| definition | varchar | 255 | √ | χ | null | Description of treatment, e.g. levels of fertilizer applied, etc. This information may be redundant with 'levels' information recorded in Managements table. | |
| created_at | timestamp | 29,6 | √ | χ | null | ||
| updated_at | timestamp | 29,6 | √ | χ | null | ||
| control | bool | 1 | √ | χ | null | Boolean, indicates if treatment is a control or observational (1) or experimental treatment (0). | |
| user_id | int4 | 10 | √ | χ | null |
Indexes:
| Column(s) | Type | Sort | Constraint Name |
|---|---|---|---|
| id | Primary key | Asc | treatments_pkey |
| user_id | Performance | Asc | index_treatments_on_user_id |
|
