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