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