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))