transport
테이블 (5)
?쒖슱?쒖꽕怨듬떒_援먰넻?쇱옟
- id — int — 기본 키 — NOT NULL
- ?좎쭨 — datetime
- ?⑷퀎 — int
- 吏뺤닔李⑤웾?뚭퀎 — int
- ?꾧툑吏뺤닔?뚭퀎 — int
- ?쇰컲李⑤웾?꾧툑吏뺤닔 — int
- 寃쎌감?꾧툑吏뺤닔 — int
- ?꾩옄?쒓렇?꾧툑吏뺤닔 — int
- 移대뱶(?좊텋?꾨텋)?뚭퀎 — int
- ?쇰컲李⑤웾移대뱶(?좊텋?꾨텋)吏뺤닔?뚭퀎 — int
- 寃쎌감移대뱶(?좊텋?꾨텋)吏뺤닔?뚭퀎 — int
- ?꾩옄?쒓렇移대뱶(?좊텋?꾨텋)吏뺤닔?뚭퀎 — int
- ?좊텋移대뱶吏뺤닔?뚭퀎 — int
- ?쇰컲李⑤웾?좊텋移대뱶吏뺤닔 — int
- 寃쎌감?좊텋移대뱶吏뺤닔 — int
- ?꾩옄?쒓렇?좊텋移대뱶吏뺤닔 — int
- ?꾨텋移대뱶吏뺤닔?뚭퀎 — int
- ?쇰컲李⑤웾?꾨텋移대뱶吏뺤닔 — int
- 寃쎌감?꾨텋移대뱶吏뺤닔 — int
- ?꾩옄?쒓렇?꾨텋移대뱶吏뺤닔 — int
- 荑좏룿吏뺤닔?뚭퀎 — int
- ?쇰컲李⑤웾荑좏룿吏뺤닔 — int
- 寃쎌감荑좏룿吏뺤닔 — int
- ?꾩옄?쒓렇荑좏룿吏뺤닔 — int
- 誘몄쭠?섏감?됱냼怨? — int
- 誘몃궔李⑤웾誘몄쭠?? — int
- 硫댁젣李⑤웾?뚭퀎 — int
- ?쇰컲硫댁젣李⑤웾誘몄쭠?? — int
- ?꾩옄?쒓렇硫댁젣李⑤웾誘몄쭠?? — int
- ?섎텋嫄댁닔 — int
dim_date
- date_id — int — 기본 키 — NOT NULL
- date_value — date
- year — int
- month — int
- day — int
- day_of_week — varchar(10)
dim_payment
- payment_id — int — 기본 키 — NOT NULL
- payment_category — varchar(20)
- payment_method — varchar(20)
dim_vehicle
- vehicle_id — int — 기본 키 — NOT NULL
- vehicle_type — varchar(20)
fact_toll
- fact_id — int — 기본 키 — NOT NULL
- date_id — int — 외래 키 → dim_date.date_id
- vehicle_id — int — 외래 키 → dim_vehicle.vehicle_id
- payment_id — int — 외래 키 → dim_payment.payment_id
- count — int