[제안서] 택시분석
테이블 (5)
DIM_REGION
- SIGUNGU_CD — VARCHAR(5)
- SIGUNGU_NM — VARCHAR(50)
- SIDO_CD — VARCHAR(2)
DIM_VEHICLE
- VEHICLE_NO — VARCHAR(15)
- LICENSE_TYPE — VARCHAR(10)
- SIGUNGU_CD — VARCHAR(5)
TB_DEMAND_METER
- METER_ID — INT
- VEHICLE_NO — VARCHAR(15)
- STATUS_CD — VARCHAR(5)
- PICKUP_DT — TIMESTAMP
- DROPOFF_DT — TIMESTAMP
- PICKUP_ZONE_ID — VARCHAR(20)
- DROPOFF_ZONE_ID — VARCHAR(20)
- DRIVING_DIST — DECIMAL(8,2)
- EMPTY_DIST — DECIMAL(8,2)
- FARE_AMT — INT
- SURCHARGE_AMT — INT
- PAY_METHOD — VARCHAR(10)
- APP_CALL_YN — VARCHAR(1)
TB_MACRO_SUPPLY_STAT
- STAT_YYYYMM — VARCHAR(6)
- SIGUNGU_CD — VARCHAR(5)
- LICENSE_TYPE — VARCHAR(10)
- TOTAL_LICENSE_CNT — INT
- OPERABLE_CNT — INT
- COMPANY_CNT — INT
TB_MICRO_SUPPLY_DTG
- DTG_ID — INT
- VEHICLE_NO — VARCHAR(15)
- DTG_TIMESTAMP — TIMESTAMP
- GPS_X — DECIMAL(10,6)
- GPS_Y — DECIMAL(10,6)
- AZIMUTH — INT
- SPEED — INT
- RPM — INT
- BRAKE_SIG — VARCHAR(1)
- ACCEL_X — DECIMAL(5,2)
- DAILY_MILEAGE — DECIMAL(10,2)