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)