subway1

Tables (11)

coordinate

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

dim_date

  • date_key — INT — Primary key — NOT NULL
  • full_date — DATE — Foreign key → holiday_check.날짜 — 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) — Foreign key → station_name_rep.역명 — NOT NULL
  • representative_no — VARCHAR(20) — Foreign key → coordinate.역번호 — 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_h — DECIMAL(12, 6) — NOT NULL
  • s_w — DECIMAL(12, 6) — NOT NULL
  • s_c — DECIMAL(12, 6) — NOT NULL
  • n_h — DECIMAL(12, 6) — NOT NULL
  • n_w — DECIMAL(12, 6) — NOT NULL
  • n_c — DECIMAL(12, 6) — NOT NULL
  • 기본_분류 — VARCHAR(20) — NOT NULL
  • 광고_집행_전략 — 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
  • 휴무일구분 — VARCHAR(20) — NOT NULL
  • 출근_승차합 — BIGINT — NOT NULL
  • 출근_하차합 — BIGINT — NOT NULL
  • 출근_전체합 — BIGINT — NOT NULL
  • 오전_승차합 — BIGINT — NOT NULL
  • 오전_하차합 — BIGINT — NOT NULL
  • 오전_전체합 — BIGINT — NOT NULL
  • 오후_승차합 — BIGINT — NOT NULL
  • 오후_하차합 — BIGINT — NOT NULL
  • 오후_전체합 — BIGINT — NOT NULL
  • 퇴근_승차합 — BIGINT — NOT NULL
  • 퇴근_하차합 — BIGINT — NOT NULL
  • 퇴근_전체합 — BIGINT — NOT NULL

station_name_rep

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

subway_total

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