esb

Tables (8)

DETAIL1_RECV

  • DETAIL1_ID (INT) — Primary key — NOT NULL
  • MASTER_ID (INT2) — Foreign key → MASTER_RECV.MASTER_ID — NOT NULL
  • DETAIL1_NAME (VARCHAR(225))

DETAIL1_SEND

  • DETAIL1_ID (INT) — Primary key — NOT NULL
  • MASTER_ID (INT2) — Foreign key → MASTER_SEND.MASTER_ID — NOT NULL
  • DETAIL1_NAME (VARCHAR(225))

DETAIL2_RECV

  • DETAIL2_ID (INT) — Primary key — NOT NULL
  • MASTER_ID (INT2) — Foreign key → MASTER_RECV.MASTER_ID — NOT NULL
  • DETAIL2_NAME (VARCHAR(225))

DETAIL2_SEND

  • DETAIL2_ID (INT) — Primary key — NOT NULL
  • MASTER_ID (INT2) — Foreign key → MASTER_SEND.MASTER_ID — NOT NULL
  • DETAIL2_NAME (VARCHAR(225))

DETAIL3_RECV

  • DETAIL3_ID (INT) — Primary key — NOT NULL
  • MASTER_ID (INT2) — Foreign key → MASTER_RECV.MASTER_ID — NOT NULL
  • DETAIL3_NAME (VARCHAR(225))

DETAIL3_SEND

  • DETAIL3_ID (INT) — Primary key — NOT NULL
  • MASTER_ID (INT2) — Foreign key → MASTER_SEND.MASTER_ID — NOT NULL
  • DETAIL3_NAME (VARCHAR(225))

MASTER_RECV

  • MASTER_ID (INT) — Primary key — NOT NULL
  • MASTER_NAME (VARCHAR(225))
  • ESB_TX_ID (VARCHAR(30))
  • ESB_STATE_CD (STRING)
  • ESB_TIME (VARCHAR(20))
  • ESB_RESULT (VARCHAR(1000))

MASTER_SEND (Untitled)

  • MASTER_ID (INT) — Primary key — NOT NULL
  • MASTER_NAME (VARCHAR(225))
  • ESB_TX_ID (VARCHAR(30))
  • ESB_STATE_CD (STRING)
  • ESB_TIME (VARCHAR(20))
  • ESB_RESULT (VARCHAR(1000))