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