subway

Tables (11)

coordinate

  • 역번호 — VARCHAR(50) — Primary key — NOT NULL
  • 위도 — DECIMAL(10,7)
  • 경도 — DECIMAL(10,7)

dim_date

  • date_key — INT — Primary key — NOT NULL
  • full_date — DATE — NOT NULL
  • year_no — SMALLINT — NOT NULL
  • month_no — TINYINT — NOT NULL
  • day_no — TINYINT — NOT NULL
  • weekday_no — TINYINT — NOT NULL
  • weekday_name — VARCHAR(10) — NOT NULL
  • day_type — VARCHAR(20) — NOT NULL

dim_line

  • line_key — INT — Primary key — NOT NULL
  • line_name — VARCHAR(50) — NOT NULL

dim_station

  • station_key — BIGINT — Primary key — NOT NULL
  • station_name — VARCHAR(100) — NOT NULL
  • representative_no — VARCHAR(20) — NOT NULL
  • latitude — DECIMAL(10,7)
  • longitude — DECIMAL(10,7)

dim_time_slot

  • time_slot_key — INT — Primary key — NOT NULL
  • slot_code — VARCHAR(20) — NOT NULL
  • start_hour — TINYINT — NOT NULL
  • end_hour — TINYINT — NOT NULL
  • band_name — VARCHAR(20) — NOT NULL

fact_station_hourly_flow

  • flow_id — BIGINT — Primary key — NOT NULL
  • date_key — INT — Foreign key → dim_date.date_key — NOT NULL
  • station_key — BIGINT — Foreign key → dim_station.station_key — NOT NULL
  • line_key — INT — Foreign key → dim_line.line_key — NOT NULL
  • time_slot_key — INT — Foreign key → dim_time_slot.time_slot_key — NOT NULL
  • ride_type — CHAR(2) — NOT NULL
  • passengers — BIGINT — NOT NULL
  • src_year — SMALLINT — NOT NULL

holiday_check

  • 날짜 — DATE — Primary key — NOT NULL
  • 휴무일구분 — VARCHAR(20) — NOT NULL

mart_station_profile_score

  • profile_id — BIGINT — Primary key — NOT NULL
  • src_year — SMALLINT — NOT NULL
  • station_key — BIGINT — Foreign key → dim_station.station_key — NOT NULL
  • total_in — BIGINT — NOT NULL
  • total_out — BIGINT — NOT NULL
  • s_home — DECIMAL(12,6) — NOT NULL
  • s_work — DECIMAL(12,6) — NOT NULL
  • s_culture — DECIMAL(12,6) — NOT NULL
  • n_home — DECIMAL(12,6) — NOT NULL
  • n_work — DECIMAL(12,6) — NOT NULL
  • n_culture — DECIMAL(12,6) — NOT NULL
  • base_category — VARCHAR(20) — NOT NULL
  • ad_strategy — VARCHAR(30) — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

mart_station_timeband_summary

  • summary_id — BIGINT — Primary key — NOT NULL
  • src_year — SMALLINT — NOT NULL
  • station_key — BIGINT — Foreign key → dim_station.station_key — NOT NULL
  • day_type — VARCHAR(20) — NOT NULL
  • commute_in — BIGINT — NOT NULL
  • commute_out — BIGINT — NOT NULL
  • commute_total — BIGINT — NOT NULL
  • morning_in — BIGINT — NOT NULL
  • morning_out — BIGINT — NOT NULL
  • morning_total — BIGINT — NOT NULL
  • afternoon_in — BIGINT — NOT NULL
  • afternoon_out — BIGINT — NOT NULL
  • afternoon_total — BIGINT — NOT NULL
  • evening_in — BIGINT — NOT NULL
  • evening_out — BIGINT — NOT NULL
  • evening_total — BIGINT — NOT NULL

station_name_rep

  • 역명 — VARCHAR(100) — Primary key — NOT NULL
  • 대표역번호 — VARCHAR(50) — Foreign key → coordinate.역번호 — NOT NULL

subway_total

  • row_id — BIGINT — Primary key — NOT NULL
  • 날짜 — DATE — Foreign key → holiday_check.날짜 — NOT NULL
  • 호선 — VARCHAR(50) — NOT NULL
  • 역번호 — VARCHAR(50) — NOT NULL
  • 역명 — VARCHAR(100) — NOT NULL
  • 구분 — VARCHAR(20) — NOT NULL
  • 05~06 — BIGINT — NOT NULL
  • 06~07 — BIGINT — NOT NULL
  • 07~08 — BIGINT — NOT NULL
  • 08~09 — BIGINT — NOT NULL
  • 09~10 — BIGINT — NOT NULL
  • 10~11 — BIGINT — NOT NULL
  • 11~12 — BIGINT — NOT NULL
  • 12~13 — BIGINT — NOT NULL
  • 13~14 — BIGINT — NOT NULL
  • 14~15 — BIGINT — NOT NULL
  • 15~16 — BIGINT — NOT NULL
  • 16~17 — BIGINT — NOT NULL
  • 17~18 — BIGINT — NOT NULL
  • 18~19 — BIGINT — NOT NULL
  • 19~20 — BIGINT — NOT NULL
  • 20~21 — BIGINT — NOT NULL
  • 21~22 — BIGINT — NOT NULL
  • 22~23 — BIGINT — NOT NULL
  • 23~24 — BIGINT — NOT NULL
  • src_year — SMALLINT — NOT NULL