Columns
| Column | Type | Size | Nulls | Auto | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|
| site_type_group_id | int4 | 10 | √ |
|
|
Primary key (automatically incremented). |
||||
| site_type_group_abbrev | varchar(40) | 40 |
|
|
Unique abbreviated code used to identify the site type group. |
|||||
| site_type_group | varchar(255) | 255 |
|
|
Name of the site type group. |
|||||
| description | text | 2147483647 |
|
|
Description of the site type group. |
|||||
| origin_code | varchar(40) | 40 | √ |
|
|
Code classifying the group origin as natural, anthropogenic, mixed, or unknown. |
||||
| origin_description | text | 2147483647 |
|
|
Text description of the group origin code. |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| tbl_site_type_groups_pkey | Primary key | Asc | site_type_group_id |
| tbl_site_type_groups_site_type_group_abbrev_key | Must be unique | Asc | site_type_group_abbrev |
Relationships
Close relationships within degrees of separation
