SmartWMS ERD
Tables (13)
BACKUP_ORANGE
- AA — VARCHAR2
- BB — VARCHAR2
- CC — VARCHAR2
- DD — VARCHAR2
- EE — VARCHAR2
- FF — VARCHAR2
- GG — VARCHAR2
- HH — VARCHAR2
CM_CAR
- SITE_CD — VARCHAR2 — Primary key — NOT NULL
- STORE_CD — VARCHAR2 — Primary key — NOT NULL
- DRIVER_CD — VARCHAR2 — Primary key — NOT NULL
- DRIVER_NM — VARCHAR2
- HP_NO — VARCHAR2
- CAR_NO — VARCHAR2
- DRCOM_CD — VARCHAR2
- CAR_TYPE — VARCHAR2
- PREFER_ROUTE — VARCHAR2 — NOT NULL
- START_TIME — VARCHAR2
- TRAVEL_TIME1 — NUMBER
- TRAVEL_TIME2 — NUMBER
- SERVICE_TIME — NUMBER
- MEMO — VARCHAR2
- USE_AT — CHAR
- RGT_DATE — DATE
- RGTER — VARCHAR2
- UPT_DATE — DATE
- UPTER — VARCHAR2
CM_USEINFO
- SAVE_MONEY_ID — VARCHAR2 — NOT NULL
- MBER_ID — VARCHAR2
- SITE_CD — VARCHAR2
- SAVE_USE_GB — CHAR — NOT NULL
- SAVE_USE_DT — DATE
- SAVE_USE_AMT — NUMBER
COMTNPOPUPMANAGE
- SITE_CD — VARCHAR2 — Primary key — NOT NULL
- POPUP_ID — VARCHAR2 — Primary key — NOT NULL
- POPUP_SJ_NM — VARCHAR2
- FILE_URL — VARCHAR2
- POPUP_WIDTH_LC — VARCHAR2
- POPUP_WIDTH_SIZE — NUMBER
- NTCE_BGNDE — CHAR
- NTCE_ENDDE — CHAR
- STOPVEW_SETUP_AT — CHAR
- NTCE_AT — CHAR
- POPUP_VRTICL_LC — VARCHAR2
- POPUP_VRTICL_SIZE — NUMBER
- FRST_REGISTER_ID — VARCHAR2
- FRST_REGIST_PNTTM — DATE
- LAST_UPDUSR_ID — VARCHAR2
- LAST_UPDT_PNTTM — DATE
MSG_QUEUE
- MSEQ — NUMBER — Primary key — NOT NULL
- MSG_TYPE — CHAR — NOT NULL
- SEND_TYPE — CHAR — NOT NULL
- DKEY — VARCHAR2 — NOT NULL
- DCNT — NUMBER — NOT NULL
- DSTADDR — VARCHAR2 — NOT NULL
- CALLBACK — VARCHAR2
- STAT — CHAR — NOT NULL
- SUBJECT — VARCHAR2 — NOT NULL
- TEXT_TYPE — CHAR — NOT NULL
- TEXT — VARCHAR2 — NOT NULL
- EXPIRETIME — NUMBER
- FILECNT — NUMBER — NOT NULL
- FILELOC1 — VARCHAR2
- FILESIZE1 — NUMBER
- FILELOC2 — VARCHAR2
- FILESIZE2 — NUMBER
- FILELOC3 — VARCHAR2
- FILESIZE3 — NUMBER
- FILELOC4 — VARCHAR2
- FILESIZE4 — NUMBER
- FILELOC5 — VARCHAR2
- FILESIZE5 — NUMBER
- FILECNT_CHECKUP — NUMBER — NOT NULL
- INSERT_TIME — DATE — NOT NULL
- REQUEST_TIME — DATE — NOT NULL
- SEND_TIME — DATE
- REPORT_TIME — DATE
- TCPRECV_TIME — DATE
- SAVE_TIME — DATE
- TELECOM — VARCHAR2
- RESULT — CHAR
- REPCNT — NUMBER — NOT NULL
- SERVER_ID — NUMBER
- OPT_ID — VARCHAR2
- OPT_CMP — VARCHAR2
- OPT_POST — VARCHAR2
- OPT_NAME — VARCHAR2
- EXT_COL0 — NUMBER
- EXT_COL1 — VARCHAR2
- EXT_COL2 — VARCHAR2
- EXT_COL3 — VARCHAR2
MSG_QUEUE_BLOCK
- DSTADDR — VARCHAR2 — Primary key — NOT NULL
- MSG_TYPE — CHAR — Primary key — NOT NULL
- REG_TIME — DATE
- MEMO — VARCHAR2
MSG_RESULT_201507
- MSEQ — NUMBER — NOT NULL
- MSG_TYPE — CHAR — NOT NULL
- SEND_TYPE — CHAR — NOT NULL
- DKEY — VARCHAR2 — NOT NULL
- DCNT — NUMBER — NOT NULL
- DSTADDR — VARCHAR2 — NOT NULL
- CALLBACK — VARCHAR2
- STAT — CHAR — NOT NULL
- SUBJECT — VARCHAR2
- TEXT_TYPE — CHAR — NOT NULL
- TEXT — VARCHAR2 — NOT NULL
- EXPIRETIME — NUMBER
- FILECNT — NUMBER — NOT NULL
- FILELOC1 — VARCHAR2
- FILESIZE1 — NUMBER
- FILELOC2 — VARCHAR2
- FILESIZE2 — NUMBER
- FILELOC3 — VARCHAR2
- FILESIZE3 — NUMBER
- FILELOC4 — VARCHAR2
- FILESIZE4 — NUMBER
- FILELOC5 — VARCHAR2
- FILESIZE5 — NUMBER
- FILECNT_CHECKUP — NUMBER — NOT NULL
- INSERT_TIME — DATE — NOT NULL
- REQUEST_TIME — DATE — NOT NULL
- SEND_TIME — DATE
- REPORT_TIME — DATE
- TCPRECV_TIME — DATE
- SAVE_TIME — DATE
- TELECOM — VARCHAR2
- RESULT — CHAR
- REPCNT — NUMBER — NOT NULL
- SERVER_ID — NUMBER
- OPT_ID — VARCHAR2
- OPT_CMP — VARCHAR2
- OPT_POST — VARCHAR2
- OPT_NAME — VARCHAR2
- EXT_COL0 — NUMBER
- EXT_COL1 — VARCHAR2
- EXT_COL2 — VARCHAR2
- EXT_COL3 — VARCHAR2
MSG_RESULT_201509
- MSEQ — NUMBER — NOT NULL
- MSG_TYPE — CHAR — NOT NULL
- SEND_TYPE — CHAR — NOT NULL
- DKEY — VARCHAR2 — NOT NULL
- DCNT — NUMBER — NOT NULL
- DSTADDR — VARCHAR2 — NOT NULL
- CALLBACK — VARCHAR2
- STAT — CHAR — NOT NULL
- SUBJECT — VARCHAR2
- TEXT_TYPE — CHAR — NOT NULL
- TEXT — VARCHAR2 — NOT NULL
- EXPIRETIME — NUMBER
- FILECNT — NUMBER — NOT NULL
- FILELOC1 — VARCHAR2
- FILESIZE1 — NUMBER
- FILELOC2 — VARCHAR2
- FILESIZE2 — NUMBER
- FILELOC3 — VARCHAR2
- FILESIZE3 — NUMBER
- FILELOC4 — VARCHAR2
- FILESIZE4 — NUMBER
- FILELOC5 — VARCHAR2
- FILESIZE5 — NUMBER
- FILECNT_CHECKUP — NUMBER — NOT NULL
- INSERT_TIME — DATE — NOT NULL
- REQUEST_TIME — DATE — NOT NULL
- SEND_TIME — DATE
- REPORT_TIME — DATE
- TCPRECV_TIME — DATE
- SAVE_TIME — DATE
- TELECOM — VARCHAR2
- RESULT — CHAR
- REPCNT — NUMBER — NOT NULL
- SERVER_ID — NUMBER
- OPT_ID — VARCHAR2
- OPT_CMP — VARCHAR2
- OPT_POST — VARCHAR2
- OPT_NAME — VARCHAR2
- EXT_COL0 — NUMBER
- EXT_COL1 — VARCHAR2
- EXT_COL2 — VARCHAR2
- EXT_COL3 — VARCHAR2
MSG_RESULT_201510
- MSEQ — NUMBER — NOT NULL
- MSG_TYPE — CHAR — NOT NULL
- SEND_TYPE — CHAR — NOT NULL
- DKEY — VARCHAR2 — NOT NULL
- DCNT — NUMBER — NOT NULL
- DSTADDR — VARCHAR2 — NOT NULL
- CALLBACK — VARCHAR2
- STAT — CHAR — NOT NULL
- SUBJECT — VARCHAR2
- TEXT_TYPE — CHAR — NOT NULL
- TEXT — VARCHAR2 — NOT NULL
- EXPIRETIME — NUMBER
- FILECNT — NUMBER — NOT NULL
- FILELOC1 — VARCHAR2
- FILESIZE1 — NUMBER
- FILELOC2 — VARCHAR2
- FILESIZE2 — NUMBER
- FILELOC3 — VARCHAR2
- FILESIZE3 — NUMBER
- FILELOC4 — VARCHAR2
- FILESIZE4 — NUMBER
- FILELOC5 — VARCHAR2
- FILESIZE5 — NUMBER
- FILECNT_CHECKUP — NUMBER — NOT NULL
- INSERT_TIME — DATE — NOT NULL
- REQUEST_TIME — DATE — NOT NULL
- SEND_TIME — DATE
- REPORT_TIME — DATE
- TCPRECV_TIME — DATE
- SAVE_TIME — DATE
- TELECOM — VARCHAR2
- RESULT — CHAR
- REPCNT — NUMBER — NOT NULL
- SERVER_ID — NUMBER
- OPT_ID — VARCHAR2
- OPT_CMP — VARCHAR2
- OPT_POST — VARCHAR2
- OPT_NAME — VARCHAR2
- EXT_COL0 — NUMBER
- EXT_COL1 — VARCHAR2
- EXT_COL2 — VARCHAR2
- EXT_COL3 — VARCHAR2
MSG_RESULT_201604
- MSEQ — NUMBER — NOT NULL
- MSG_TYPE — CHAR — NOT NULL
- SEND_TYPE — CHAR — NOT NULL
- DKEY — VARCHAR2 — NOT NULL
- DCNT — NUMBER — NOT NULL
- DSTADDR — VARCHAR2 — NOT NULL
- CALLBACK — VARCHAR2
- STAT — CHAR — NOT NULL
- SUBJECT — VARCHAR2
- TEXT_TYPE — CHAR — NOT NULL
- TEXT — VARCHAR2 — NOT NULL
- EXPIRETIME — NUMBER
- FILECNT — NUMBER — NOT NULL
- FILELOC1 — VARCHAR2
- FILESIZE1 — NUMBER
- FILELOC2 — VARCHAR2
- FILESIZE2 — NUMBER
- FILELOC3 — VARCHAR2
- FILESIZE3 — NUMBER
- FILELOC4 — VARCHAR2
- FILESIZE4 — NUMBER
- FILELOC5 — VARCHAR2
- FILESIZE5 — NUMBER
- FILECNT_CHECKUP — NUMBER — NOT NULL
- INSERT_TIME — DATE — NOT NULL
- REQUEST_TIME — DATE — NOT NULL
- SEND_TIME — DATE
- REPORT_TIME — DATE
- TCPRECV_TIME — DATE
- SAVE_TIME — DATE
- TELECOM — VARCHAR2
- RESULT — CHAR
- REPCNT — NUMBER — NOT NULL
- SERVER_ID — NUMBER
- OPT_ID — VARCHAR2
- OPT_CMP — VARCHAR2
- OPT_POST — VARCHAR2
- OPT_NAME — VARCHAR2
- EXT_COL0 — NUMBER
- EXT_COL1 — VARCHAR2
- EXT_COL2 — VARCHAR2
- EXT_COL3 — VARCHAR2
MSG_RESULT_201608
- MSEQ — NUMBER — NOT NULL
- MSG_TYPE — CHAR — NOT NULL
- SEND_TYPE — CHAR — NOT NULL
- DKEY — VARCHAR2 — NOT NULL
- DCNT — NUMBER — NOT NULL
- DSTADDR — VARCHAR2 — NOT NULL
- CALLBACK — VARCHAR2
- STAT — CHAR — NOT NULL
- SUBJECT — VARCHAR2
- TEXT_TYPE — CHAR — NOT NULL
- TEXT — VARCHAR2 — NOT NULL
- EXPIRETIME — NUMBER
- FILECNT — NUMBER — NOT NULL
- FILELOC1 — VARCHAR2
- FILESIZE1 — NUMBER
- FILELOC2 — VARCHAR2
- FILESIZE2 — NUMBER
- FILELOC3 — VARCHAR2
- FILESIZE3 — NUMBER
- FILELOC4 — VARCHAR2
- FILESIZE4 — NUMBER
- FILELOC5 — VARCHAR2
- FILESIZE5 — NUMBER
- FILECNT_CHECKUP — NUMBER — NOT NULL
- INSERT_TIME — DATE — NOT NULL
- REQUEST_TIME — DATE — NOT NULL
- SEND_TIME — DATE
- REPORT_TIME — DATE
- TCPRECV_TIME — DATE
- SAVE_TIME — DATE
- TELECOM — VARCHAR2
- RESULT — CHAR
- REPCNT — NUMBER — NOT NULL
- SERVER_ID — NUMBER
- OPT_ID — VARCHAR2
- OPT_CMP — VARCHAR2
- OPT_POST — VARCHAR2
- OPT_NAME — VARCHAR2
- EXT_COL0 — NUMBER
- EXT_COL1 — VARCHAR2
- EXT_COL2 — VARCHAR2
- EXT_COL3 — VARCHAR2
MSG_RESULT_201610
- MSEQ — NUMBER — NOT NULL
- MSG_TYPE — CHAR — NOT NULL
- SEND_TYPE — CHAR — NOT NULL
- DKEY — VARCHAR2 — NOT NULL
- DCNT — NUMBER — NOT NULL
- DSTADDR — VARCHAR2 — NOT NULL
- CALLBACK — VARCHAR2
- STAT — CHAR — NOT NULL
- SUBJECT — VARCHAR2
- TEXT_TYPE — CHAR — NOT NULL
- TEXT — VARCHAR2 — NOT NULL
- EXPIRETIME — NUMBER
- FILECNT — NUMBER — NOT NULL
- FILELOC1 — VARCHAR2
- FILESIZE1 — NUMBER
- FILELOC2 — VARCHAR2
- FILESIZE2 — NUMBER
- FILELOC3 — VARCHAR2
- FILESIZE3 — NUMBER
- FILELOC4 — VARCHAR2
- FILESIZE4 — NUMBER
- FILELOC5 — VARCHAR2
- FILESIZE5 — NUMBER
- FILECNT_CHECKUP — NUMBER — NOT NULL
- INSERT_TIME — DATE — NOT NULL
- REQUEST_TIME — DATE — NOT NULL
- SEND_TIME — DATE
- REPORT_TIME — DATE
- TCPRECV_TIME — DATE
- SAVE_TIME — DATE
- TELECOM — VARCHAR2
- RESULT — CHAR
- REPCNT — NUMBER — NOT NULL
- SERVER_ID — NUMBER
- OPT_ID — VARCHAR2
- OPT_CMP — VARCHAR2
- OPT_POST — VARCHAR2
- OPT_NAME — VARCHAR2
- EXT_COL0 — NUMBER
- EXT_COL1 — VARCHAR2
- EXT_COL2 — VARCHAR2
- EXT_COL3 — VARCHAR2
TAX_INVOICE_REQ
- SITE_CD — VARCHAR2 — Primary key — NOT NULL
- ORDER_NO — VARCHAR2 — Primary key — NOT NULL
- REQ_SEQ — NUMBER — Primary key — NOT NULL
- ENTRPRS_MBER_ID — VARCHAR2 — NOT NULL
- BIZRNO — VARCHAR2
- REPORT_STAT — CHAR
- FRST_REGISTER_ID — VARCHAR2
- FRST_REGIST_PNTTM — DATE
- LAST_UPDUSR_ID — VARCHAR2
- LAST_UPDT_PNTTM — DATE