MCS Tickting
Tables (12)
CTE_ATMS (Untitled4)
- GROUP_NO (Key) — Primary key — NOT NULL
- Field
T_ATM (Untitled)
- TERM_ID (Key) — Primary key — NOT NULL
- NODE_CD (Field2) — Primary key
- GROUP_NO (Key2) — Foreign key → CTE_ATMS.GROUP_NO — NOT NULL
- Field3
T_ATMSTATUS (Untitled5)
- TERM_ID (Key) — Foreign key → T_ATM.TERM_ID — NOT NULL
- NODE_CD (Field2) — Foreign key → T_ATM.NODE_CD
- SERVICE_STATUS (Field)
T_EJPULLMASTER (Untitled10)
- TERM_ID (Field) — Primary key
- NODE_CD (Field2) — Primary key
T_EVENT_HIS (selectEventHis)
- JNL_DATE (Field3) — Primary key
- JNL_TIME (Field4) — Primary key
- CMPL_CD (Field5) — Primary key
- TERM_ID (Key) — Foreign key → T_ATM.TERM_ID — NOT NULL
- TERM_ID (Field) — Foreign key → T_EJPULLMASTER.TERM_ID
- NODE_CD (Field2) — Foreign key → T_ATM.NODE_CD
- APPLY_FLAG (Field6)
T_RULE (Untitled3)
- RULE_ID (Field) — Primary key
T_RULE_EVT (Untitled2)
- EVT_ID (Key) — Primary key — NOT NULL
- RULE_ID (Field) — Foreign key → T_RULE.RULE_ID
- EVT_ORDER (Field2)
- CMPL_CD (Field3)
T_RULE_HIS (insertTicketToRuleHis)
- JNL_DATE (Field3) — Primary key
- JNL_TIME (Field4) — Primary key
- RULE_ID (Field) — Foreign key → T_RULE_EVT.RULE_ID
- TERM_ID (Key) — Foreign key → T_EVENT_HIS.TERM_ID — NOT NULL
- CMPL_CD (Field5) — Foreign key → T_EVENT_HIS.CMPL_CD
- TERM_ID (Field6) — Foreign key → T_EVENT_HIS.TERM_ID
- NODE_CD (Field2) — Foreign key → T_EVENT_HIS.NODE_CD
T_RULE_TICKET_HIS (Untitled6)
- JNL_DATE (Field32) — Foreign key → T_EVENT_HIS.JNL_DATE
- JNL_TIME (Field42) — Foreign key → T_EVENT_HIS.JNL_TIME
- TERM_ID (Key) — Foreign key → T_EVENT_HIS.TERM_ID — NOT NULL
- RULE_ID (Field2) — Foreign key → T_RULE_EVT.RULE_ID
- CMPL_CD (Field5) — Foreign key → T_EVENT_HIS.CMPL_CD
- TERM_ID (Field) — Foreign key → T_EVENT_HIS.TERM_ID
- NODE_CD (Field22) — Foreign key → T_EVENT_HIS.NODE_CD
T_TICKET_ALERT_CONDITION (Untitled7)
- DEVICE_ID (Field2)
- ALERT_TYPE (Field3)
- TICKET_TYPE (Field4)
- MIDDLE_TYPE (Field5)
- PRIORITY_CD (Field6)
- CMPL_CD (Field52) — Foreign key → T_RULE_HIS.CMPL_CD
- TN_NO (Key) — Foreign key → T_TICKET_NEW.TN_NO — NOT NULL
- TERM_ID (Field62) — Foreign key → T_RULE_HIS.TERM_ID
- NODE_CD (Field23) — Foreign key → T_RULE_HIS.NODE_CD
T_TICKET_IF_SEND (Untitled9)
- IF_NO (Key2) — Primary key — NOT NULL
- TN_NO (Key) — Foreign key → T_TICKET_NEW.TN_NO — NOT NULL
- JNL_DATE (EVENT_DATE) — Foreign key → T_TICKET_NEW.JNL_DATE
- JNL_TIME (EVENT_TIME) — Foreign key → T_TICKET_NEW.JNL_TIME
- TERM_ID (Field6) — Foreign key → T_TICKET_NEW.TERM_ID
- NODE_CD (Field23) — Foreign key
- TERM_ID (Field)
- TERM_NO (Field2)
- NODE_CD (Field3)
- CMPL_CD (Field4)
T_TICKET_NEW (Untitled8)
- TN_NO (Key) — Primary key — NOT NULL
- JNL_DATE (EVENT_DATE) — Foreign key → T_RULE_HIS.JNL_DATE
- JNL_TIME (EVENT_TIME) — Foreign key → T_RULE_HIS.JNL_TIME
- TERM_ID (Field6) — Foreign key → T_RULE_HIS.TERM_ID
- TERM_ID (Key2) — Foreign key → T_ATM.TERM_ID — NOT NULL
- TICKET TYPE_CD (Field)
- ATM_ERR_CD (Field2)
- TICKET_TOP_TYPE_CD (Field3)
- NODE_CD (Field4)
- TERM_NO (Field5)
- NODE_CD (Field23) — Foreign key → T_ATM.NODE_CD