eh_erd
Tables (4)
TMEA0300 (Untitled4)
- COM_CODE (법인코드) — Primary key — NOT NULL
- PRO_CODE (상품코드) — Primary key — NOT NULL
- COM_CODE (법인코드2) — Foreign key → TMEB0101.COM_CODE — NOT NULL
- CNTRCT_NO (계약번호) — Foreign key → TMEB0101.CNTRCT_NO — NOT NULL
TMEB0100 (Untitled)
- COM_CODE (법인코드) — Primary key — NOT NULL
- CUS_NO (회원번호) — Primary key — NOT NULL
TMEB0101 (Untitled2)
- COM_CODE (법인코드) — Primary key — NOT NULL
- CNTRCT_NO (계약번호) — Primary key — NOT NULL
- CUS_NO (회원번호)
- COM_CODE (법인코드2) — Foreign key → TMEB0100.COM_CODE — NOT NULL
- CUS_NO (회원번호2) — Foreign key → TMEB0100.CUS_NO — NOT NULL
TMEB0102 (Untitled3)
- COM_CODE (법인코드) — Primary key — NOT NULL
- CNTRCTC_NO (계약번호) — Primary key — NOT NULL
- CNTRCT_ACCT_NO (구좌) — Primary key — NOT NULL
- COM_CODE (법인코드2) — Foreign key → TMEB0101.COM_CODE — NOT NULL
- CNTRCT_NO (계약번호2) — Foreign key → TMEB0101.CNTRCT_NO — NOT NULL