Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| ics_id | int4 | 10 | null |
|
|
PK. Unique identifier. Generated by database |
||||
| ics_name | varchar | 50 | null |
|
|
Name of the time period |
||||
| earliest_age | numeric | 12,4 | √ | null |
|
|
Earliest age |
|||
| latest_age | numeric | 12,4 | √ | null |
|
|
Latest age |
|||
| ics_parent_id | int4 | 10 | √ | null |
|
|
Parent id, refers to the ics_id column |
|||
| timestamp_created | timestamptz | 35,6 | now() |
|
|
|||||
| timestamp_modified | timestamptz | 35,6 | √ | now() |
|
|
||||
| ics_level | int4 | 10 | √ | null |
|
|
Level of age unit 1=Eonothem, 2=Erathem, 3=System, 4=Series, 5=Stage |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| ics_age_id | Primary key | Asc | ics_id |
| dic_ics_age_lower_idx | Performance |
Relationships
Close relationships within degrees of separation
