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
  • ...