ChooSeok
Tables (12)
Untitled (seoul_traffic_gate)
- Key (gate) — VARCHAR(32) — Primary key — NOT NULL
- Key (dt_id) — int — Foreign key → Untitled.Key — NOT NULL
- Field (in_traffic) — int
- Field (out_traffic) — int
Untitled (incheon_airport)
- Field (destination) — VARCHAR(32) — Primary key
- Field (airline) — VARCHAR(32) — Primary key
- Key (dt_id) — int — Foreign key → Untitled.Key — NOT NULL
- Field (dep_flight) — int
- Field (arr_flight) — int
- Field (dep_psg) — int
- Field (arr_psg) — int
Untitled (airenv)
- Field (region) — VARCHAR(32) — Primary key
- Key (dt_id) — int — Foreign key → Untitled.Key — NOT NULL
- Field (dust) — float
Untitled (datetime_record)
- Key (dt_id) — int — Primary key — NOT NULL
- Field (s_date) — date
- Field (s_hour) — int
Untitled (weather)
- Key (dt_id) — int — Foreign key → Untitled.Key — NOT NULL
- Field (rain) — float
- Field (wind_spd) — float
- Field (wind_dir) — int
- Field
Untitled3 (traffic_region)
- Key (region) — VARCHAR(32) — Primary key — NOT NULL
- Key (dt_id) — int — Foreign key → Untitled.Key — NOT NULL
- Field (in_traffic) — int
- Field (out_traffic) — int
boxoffice
- movie_name — VARCHAR(64) — Primary key — NOT NULL
- releases_date (release_date) — date — Primary key — NOT NULL
- Key (region) — VARCHAR(32) — Primary key — NOT NULL
- Key (dt_id) — int — Foreign key → Untitled.Key — NOT NULL
- income — bigint
- views — int
- screen — int
- play_count — int
- is_Korean (is_korean) — CHAR(1)
naver_category (n_sp_category)
- cat_id — int — Primary key — NOT NULL
- parent_id — int
- title — VARCHAR(32)
- level — int
seoul_daily_population
- gu_id — int — Primary key — NOT NULL
- Key (dt_id) — int — Foreign key → Untitled.Key — NOT NULL
- avg_pop — float
- max_pop — int
- min_pop — int
- day_pop — int
- night_pop — int
- gu_name — VARCHAR(32)
seoul_time_population
- sex — CHAR(1) — Primary key
- age — int — Primary key
- Key3 (gu_id) — int — Primary key — NOT NULL
- Key (dt_id) — int — Foreign key → Untitled.Key — NOT NULL
- gu_name — VARCHAR(32)
- population — int
seoul_time_total_population
- Key (gu_id) — int — Primary key — NOT NULL
- Key (dt_id) — int — Foreign key → Untitled.Key — NOT NULL
- population — int
shopping_trend_per_category (n_sp_trend)
- cat_id — int — Foreign key → naver_category.cat_id — NOT NULL
- Key (dt_id) — int — Foreign key → Untitled.Key — NOT NULL
- ratio — float