erd
Tables (15)
MRT_BUS_ROUTE_PASNG_ANAL
- STATION_ID — VARCHAR(10) — NOT NULL
- STATION_NM — VARCHAR(100)
- MOBILE_NO — VARCHAR(10)
- ANAL_TIME — VARCHAR(10) — NOT NULL
- MEAN_CD — VARCHAR(4) — NOT NULL
- RIDEPASSENGERS — NUMBER(10,0)
- LNDIPASSENGERS — NUMBER(10,0)
MRT_BUS_ROUTE_PASNG_ANAL_MONTH
- ANAL_TIME — VARCHAR(2) — NOT NULL
- MEAN_CD — VARCHAR(4) — NOT NULL
- RIDEPASSENGERS — NUMBER(10,0)
- LNDIPASSENGERS — NUMBER(10,0)
PRECISION_MAP_LINK
- ID — VARCHAR(12) — Primary key — NOT NULL
- RoadRank — NUMBER(2,0)
- RoadType — NUMBER(2,0)
- RoadNo — NUMBER(2,0)
- LinkType — NUMBER(2,0)
- LaneNo — NUMBER(2,0)
- R_LinkID — VARCHAR(12)
- L_LinkID — VARCHAR(12)
- FromNodeID — VARCHAR(12)
- ToNodeID — VARCHAR(12)
- SectionID — VARCHAR(12)
- Length — NUMBER(5,2)
- ITSLinkID — VARCHAR(10)
- Maker — VARCHAR(10)
- Longitude — NUMBER(13,10)
- Latitude — NUMBER(12,10)
- geometry — VARCHAR(20000)
- exNodeID — VARCHAR(12)
- exDrctCD — VARCHAR(2)
PRECISION_MAP_NODE
- ID — VARCHAR(12) — Primary key — NOT NULL
- NodeType — NUMBER(2,0)
- ITSNodeID — VARCHAR(10)
- Maker — VARCHAR(10)
- Longitude — NUMBER(13,10)
- Latitude — NUMBER(12,10)
- exNodeID — VARCHAR(12)
PVD
- VEHICLE_ID — VARCHAR(20) — Primary key — NOT NULL
- VEHICLE_NUM — VARCHAR(10)
- MAKER — VARCHAR(10)
- VEHICLE_SHORT_NUM — VARCHAR(10)
- VEHICLE_TYPE — VARCHAR(20)
- VEHICLE_CLASS — VARCHAR(20)
- HLS_ADDR — VARCHAR(600)
PVD_STAT
- VEHICLE_ID — VARCHAR(20) — Primary key — NOT NULL
- LAT_CRDN — NUMBER(12,10)
- LNG_CRDN — NUMBER(13,10)
- SPEED — NUMBER(5,2)
- ELEVATION — NUMBER(10,0)
- HEADING — NUMBER(5,0)
- RACE_NUM — NUMBER(5,0)
- RACE_STAT — NUMBER(1,0)
- START_TM — TIMESTAMP(6)
- END_TM — TIMESTAMP(6)
- CLCT_DT — TIMESTAMP(6)
- RECV_TM — TIMESTAMP(6)
- UPDT_TM — TIMESTAMP(6)
- NODE_ID — VARCHAR(10)
SPAT_NODE
- NODE_ID — VARCHAR(10) — Primary key — NOT NULL
- NODE_NM — VARCHAR(50)
- LAT_CRDN — NUMBER(12,10)
- LNG_CRDN — NUMBER(13,10)
- NODE_SHORT_NUM — NUMBER(3,0)
- NODE_NM_ENG — VARCHAR(100)
SPAT_STAT
- NODE_ID — VARCHAR(10) — Primary key — NOT NULL
- DRCT_CD — VARCHAR(2) — Primary key — NOT NULL
- SIG_MEAN — NUMBER(1,0) — Primary key — NOT NULL
- MSG_REVISION — NUMBER(4,0)
- PHS_HOLD — NUMBER(1,0)
- PPC — NUMBER(1,0)
- TRANSITION — NUMBER(1,0)
- RESPONSIVE — NUMBER(1,0)
- LIGHT_OFF — NUMBER(1,0)
- FLASHING — NUMBER(1,0)
- MANUAL — NUMBER(1,0)
- SCU_ERROR — NUMBER(1,0)
- CENTER_ERROR — NUMBER(1,0)
- CNTRD_ERROR — NUMBER(1,0)
- DRCT_ADD — NUMBER(1,0)
- TM_RLTY — NUMBER(1,0)
- PED_PUSH — NUMBER(1,0)
- EXT_CTRL_ST — NUMBER(1,0)
- BLINKER_ST — NUMBER(1,0)
- DISP_TM — NUMBER(5,0)
- REMAIN_TM — NUMBER(5,0)
- CLCT_DT — TIMESTAMP(6)
- RECV_TM — TIMESTAMP(6)
- UPDT_TM — TIMESTAMP(6)
TMS_EMERG_VEH_DASHBOARD
- SERVICE_ID — VARCHAR(50) — Primary key — NOT NULL
- DEPARTURE_TIME — DATE — NOT NULL
- SERVICE_NAME — VARCHAR(200)
- START_NAME — VARCHAR(200)
- END_NAME — VARCHAR(200)
- ESTIMATED_TIME — NUMBER(5)
- FIRESTATIN_NAME — VARCHAR(200)
- ROUTE_LENGTH — NUMBER
- DEVICE_ID — VARCHAR(200)
- ARRIVAL_TIME — DATE
- IXR_LIST — VARCHAR(600)
- SGNL_LIST — VARCHAR(200)
- IXR_NM_LIST — VARCHAR(600)
- NOW_IXR_LIST — VARCHAR(600)
- NOW_IXR_NM_LIST — VARCHAR(600)
WEB_PARKINGSTAT
- PKNG_ID — NUMBER(10) — NOT NULL
- REMAINCNT — NUMBER(10,0)
- CLCT_DT — TIMESTAMP(6)
WEB_ROADSTAT
- ROAD_ID — VARCHAR(12) — NOT NULL
- STAT_CD — VARCHAR(3)
- TEMPERATURE — NUMBER(4,2)
- HUMIDITY — NUMBER(5,2)
- SNSHT_PATH — VARCHAR(256)
- BATTERYRATE — NUMBER(5,2)
- POWERTYPE — VARCHAR(1)
- STATUS — VARCHAR(3)
- CLCT_DT — TIMESTAMP(6)
WEB_ROADSTATINFO
- ROAD_ID — VARCHAR(12) — NOT NULL
- RODE_NAME — VARCHAR(30)
- AREA_ID — VARCHAR(10)
- GISPOX_X — NUMBER(13,10)
- GISPOX_Y — NUMBER(12,10)
- RODE_NICKNM — VARCHAR(30)
WEB_ROADSTATLOG
- OCRN_DT — TIMESTAMP(6) — NOT NULL
- ROAD_ID — VARCHAR(12) — NOT NULL
- STAT_CD — VARCHAR(3)
- TEMPERATURE — NUMBER(4,2)
- HUMIDITY — NUMBER(5,2)
- MSEAT — TIMESTAMP(6)
- SNSHT_PATH — VARCHAR(256)
- FILEAT — TIMESTAMP(6)
- BATTERYRATE — NUMBER(5,2)
- POWERTYPE — VARCHAR(1)
- STATUS — VARCHAR(3)
- STATUSAT — TIMESTAMP(6)
WEB_SGNLOPENINFO
- SORT_NO — NUMBER(2,0) — NOT NULL
- SGNL_NO — NUMBER(5,0)
- IXR_NM — VARCHAR(100)
- OB_TYPE — VARCHAR(100)
- LNG_CRDN — NUMBER(13,10)
- LAT_CRDN — NUMBER(12,10)
- NODE_ID — VARCHAR(10)
WEB_WEATHER
- CLCT_DT — TIMESTAMP(6) — NOT NULL
- SKY — NUMBER(2)
- TMP — NUMBER(4,2)
- REH — NUMBER(5,2)
- RN — VARCHAR(10)