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