Columns
| Column | Type | Size | Nulls | Auto | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|
| years_type_id | int4 | 10 | √ |
|
|
Primary key (automatically incremented). |
|
| name | varchar | 2147483647 |
|
|
The name of the year type, e.g., ‘Radiocarbon’, ‘Calendar’. |
||
| description | text | 2147483647 | √ |
|
|
A detailed explanation of the year type. |
|
| date_updated | timestamptz | 35,6 | √ |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| tbl_years_types_pkey | Primary key | Asc | years_type_id |
| tbl_years_types_name_key | Must be unique | Asc | name |
| tbl_years_types_name_unique | Must be unique | Asc | name |
Relationships
Close relationships within degrees of separation
