DB_Team1
Tables (9)
AGE_GROUP
- age_code — VARCHAR(10)
- range_text — VARCHAR(20)
AGE_INDUSTRY_PREF
- age_code — VARCHAR(10)
- ind_l1_id — VARCHAR(10)
- score_amt — DECIMAL(10, 2)
CARD_CONSUMPTION
- ta_ymd — DATE — Primary key — NOT NULL
- region_code — VARCHAR(10) — Primary key — NOT NULL
- hour_code — INT — Primary key — NOT NULL
- sex_code — CHAR(1) — Primary key — NOT NULL
- age_code — VARCHAR(10) — Primary key — NOT NULL
- ind_l2_id — VARCHAR(10) — Primary key — NOT NULL
- amt — INT
- cnt — INT
INDUSTRY_L1
- ind_l1_id — VARCHAR(10)
- name — VARCHAR(50)
INDUSTRY_L2
- ind_l2_id — VARCHAR(10)
- ind_l1_id — VARCHAR(10) — NOT NULL
- name — VARCHAR(50)
REGION
- region_code — VARCHAR(10)
- region_name — VARCHAR(50)
REGION_DETAIL
- region_code — VARCHAR(10)
- population_2024 — INT
- area_km2 — DECIMAL(10, 2)
SEX_CODE
- sex_code — CHAR(1)
- sex_name — VARCHAR(10)