Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| ctx_id | serial | 10 | √ | nextval('tbl_contexts_ctx_id_seq'::regclass) |
|
|
||||
| site_code | varchar | 50 | √ | null |
|
|
||||
| context | int4 | 10 | √ | null |
|
|
||||
| unique_id | varchar | 255 | √ | null |
|
|
||||
| trench | varchar | 50 | √ | null |
|
|
||||
| site_sub_div | varchar | 50 | √ | null |
|
|
||||
| assess_phase | varchar | 50 | √ | null |
|
|
||||
| assess_period | varchar | 50 | √ | null |
|
|
||||
| analysis_phase | int4 | 10 | √ | null |
|
|
||||
| analysis_period | int4 | 10 | √ | null |
|
|
||||
| part_of_group | int4 | 10 | √ | null |
|
|
||||
| part_of_subgroup | int4 | 10 | √ | null |
|
|
||||
| context_type | varchar | 50 | √ | null |
|
|
||||
| description | text | 2147483647 | √ | null |
|
|
||||
| interpretation | text | 2147483647 | √ | null |
|
|
||||
| category | varchar | 50 | √ | null |
|
|
||||
| rank | int4 | 10 | √ | null |
|
|
||||
| comments | text | 2147483647 | √ | null |
|
|
||||
| spot_date | varchar | 255 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| pkey_contexts | Primary key | Asc | ctx_id |
| context_idx | Must be unique | Asc | context |
Relationships
Close relationships within degrees of separation
