| Column Name | Data Type | Description |
|---|---|---|
| key_id | integer |
Unique ID number, primary key. (Each number can only occur once in this table) (Records have one-to-one relationship with entries in the AFT, HACT) (Records have one-to-many relationship with entries in VNT, AHT, TST) (Records have many-to-one relationship with entries in PGT, AST, VCT,DPT) |
| pinyin_name | character (80) | Name of entry in pinyin romanization. |
| char_name | character (80) | Name of entry in Chinese characters. |
| beg_date | integer |
Date when a particular instance of administrative division became current. Format: yyyymmdd (for BCE years, format: -yyyymmdd) |
| end_date | integer |
Date when the division was next changed or ceased to exist. Format: yyyymmdd (for BCE years, format: -yyyymmdd) |
| known_date | integer |
Date when a particular instance of administrative division was known to exist, if not a beginning or end date. Format: yyyymmdd (for BCE years, format: -yyyymmdd) |
| approx_date | integer |
Approximate date when a particular instance of administrative division was known to exist to the closest year, or period (as listed in the Dynastic Period Table), and if not a beginning, end, or known date. Format: yyyy0000 (for BCE years, format: -yyyy0000) Query mechanism should be designed for this date to be found by beginning date queries (ie. should default to yyyy0101), and also to be found by end date queries (ie. should default to yyyy1231). |
| date_notes | character (80) | Notes on dates, name of person who checked the source. Mandatory entry. |
| date_source | character (80) | Source of date information. Mandatory entry. |
| hac_code | character(40) | Complete Historical Administrative Code. |
| stv_code | character(80) | Complete Spatio-Temporal Variant Code. |
| place_geocode | character(24) | Location of unit if it was, at any time, a settlement or populated place. (If the location of this settlement served as a county seat, or capital of an administrative unit at any time, it will have a "YES" flag for this occurence in the "admin_seat" or "capital" fields in the Place Geocode Table, and each such occurrence will have its own record in the Administrative Seat Table or Capital Feature Table, respectively). |
| cap_code | character(24) | Location of capital is given as a Place Geocode. |
| var_feat | character(24) | Lists file names or codes for variant AFTs. |
| var_spat | character(24) | Lists file names or variant spatial data tables. |
| var_hier | character(2) |
Default (NULL)= unit does not have a simultaneous status in an alternative Administrative Hierarchy (such as military, inspectorate, or other kinds of jurisdiction).
If (Y) = yes, unit does have such status as listed in the Administrative Hierarchy Table. |