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