startupdb

Tables (8)

age_gender_sales

  • yqc_id (yqc) — char(5) — Primary key — NOT NULL
  • dcm_id (dcm) — char(8) — Primary key — NOT NULL
  • sic_id (sic) — char(8) — Primary key — NOT NULL
  • yqc_id — char(5) — Foreign key → year_quarter_code.yqc_code — NOT NULL
  • dcm_id — char(8) — Foreign key → dong_code_master.dcm_code — NOT NULL
  • sic_id — char(8) — Foreign key → svc_industry_code.sic_code — NOT NULL
  • ags_male — varchar(255)
  • ags_female — varchar(255)
  • Fieldags_age10 (ags_age10) — varchar(255)
  • Fieldags_age20 (ags_age20) — varchar(255)
  • ags_age30 — varchar(255)
  • ags_age40 — varchar(255)
  • ags_age50 — varchar(255)
  • ags_age60 — varchar(255)

commercial_area_infra

  • yqc_id (yqc) — char(5) — Primary key — NOT NULL
  • dcm_id (dcm) — char(8) — Primary key — NOT NULL
  • yqc_id — char(5) — Foreign key → year_quarter_code.yqc_code — NOT NULL
  • dcm_id — char(8) — Foreign key → dong_code_master.dcm_code — NOT NULL
  • cai_franchise — integer
  • cai_government — integer
  • cai_bank — integer
  • cai_gen_hospital — integer
  • cai_hospital — integer
  • cai_phamacy — integer
  • cai_kindergarten — integer
  • cai_school_ele — integer
  • Fieldcai_school_mid (cai_school_mid) — integer
  • cai_school_hig — integer
  • cai_university — integer
  • cai_department — integer
  • cai_supermarket — integer
  • cai_theater — integer
  • cai_accommodation — integer
  • cai_airport — integer
  • cai_railway — integer
  • cai_bus_terminal — integer
  • cai_subway — integer
  • cai_bus_stop — integer
  • Field

dong_code_master

  • dcm_code — char(8) — Primary key — NOT NULL
  • dcm_gu — varchar(10) — NOT NULL
  • dcm_dong — varchar(10) — NOT NULL
  • dcm_report — varchar(255)

float_populat

  • yqc_code (yqc) — char(5) — Primary key — NOT NULL
  • dcm_code (dcm) — char(8) — Primary key — NOT NULL
  • yqc_code — char(5) — Foreign key → year_quarter_code.yqc_code — NOT NULL
  • dcm_code — char(8) — Foreign key → dong_code_master.dcm_code — NOT NULL
  • fp_total — integer
  • fp_male — integer
  • fp_female — integer
  • fp_age10 — integer
  • fp_age20 — integer
  • fp_age30 — integer
  • fp_age40 — integer
  • fp_age50 — integer
  • fp_age60 — integer

quarter_sales

  • yqc_id (yqc) — char(5) — Primary key — NOT NULL
  • dcm_id (dcm) — char(8) — Primary key — NOT NULL
  • sic_id (sic) — char(8) — Primary key — NOT NULL
  • yqc_id — char(5) — Foreign key → year_quarter_code.yqc_code — NOT NULL
  • dcm_id — char(8) — Foreign key → dong_code_master.dcm_code — NOT NULL
  • sic_id — char(8) — Foreign key → svc_industry_code.sic_code — NOT NULL
  • qs_sales — varchar(255)
  • qs_weekday — varchar(255)
  • qs_weekend — varchar(255)
  • qs_,mon — varchar(255)
  • qs_tue — varchar(255)
  • qs_wed — varchar(255)
  • Fieldqs_thu (qs_thu) — varchar(255)
  • Fieldqs_fri (qs_fri) — varchar(255)
  • Fieldqs_sat (qs_sat) — varchar(255)
  • Fieldqs_sun (qs_sun) — varchar(255)

store_status_info

  • yqc_id (yqc) — char(5) — Primary key — NOT NULL
  • dcm_id (dcm) — char(8) — Primary key — NOT NULL
  • yqc_id — char(5) — Foreign key → year_quarter_code.yqc_code — NOT NULL
  • dcm_id — char(8) — Foreign key → dong_code_master.dcm_code — NOT NULL
  • ssi_cnt — integer
  • ssi_similar_cnt — integer
  • ssi_open_rate — float
  • ssi_open_cnt — integer
  • ssi_close_rate — float
  • ssi_close_cnt — integer

svc_industry_code

  • sic_code — char(8) — Primary key — NOT NULL
  • sic_industry_group — varchar(20) — NOT NULL
  • sic_svc_industry — varchar(20) — NOT NULL
  • sic_report — varchar(255)

year_quarter_code

  • yqc_code — char(5) — Primary key — NOT NULL
  • yqc_year — char(4) — NOT NULL
  • yqc_quarter — char(1) — NOT NULL
  • yqc_report — varchar(255)