khanes
Tables (5)
KHANES_MAIN_TABLE
- index — INT — Primary key — NOT NULL
- survey — varchar(10)
- description (descriptino) — varchar(50)
KHANES_TABLE_LIST
- table_name — varchar(20) — Primary key — NOT NULL
- survey — varchar(10) — Foreign key → KHANES_MAIN_TABLE.index — NOT NULL
- year — decimal(4)
KHANES_{SUR}_COLUMNS
- id — INT — Primary key — NOT NULL
- survey — varchar(10) — Foreign key → KHANES_MAIN_TABLE.index — NOT NULL
- code — varchar(10)
- name — varchar(10)
- attribute (attr) — varchar(15)
- dtype — varchar(20)
- year — decimal(4)
KHANES_{SUR}_DICT
- index — INT — Primary key — NOT NULL
- id — INT — Foreign key → KHANES_{SUR}_COLUMNS.id — NOT NULL
- key — varchar(10)
- description — varchar(30)
KHANES_{YEAR}_{SUR}
- index — INT — Primary key — NOT NULL
- column1
- column2
- column3
- ...