ERD

Tables (3)

T_EMP (사원)

  • EMP_NO — Primary key — NOT NULL
  • CUSTOMER_NUMBER — Primary key — NOT NULL
  • DEPT_CODE
  • Field
  • Field2
  • Field3

T_ITEM (아이템)

  • P_LEVEL_1 — Primary key — NOT NULL
  • P_LEVEL_NAME_1 — Primary key

T_ITEM_EMP (사원_제품)

  • EMP_NO — Foreign key → T_EMP.EMP_NO — NOT NULL
  • CUSTOMER_NUMBER — Foreign key → T_EMP.CUSTOMER_NUMBER — NOT NULL
  • P_LEVEL_1 — Foreign key → T_ITEM.P_LEVEL_1 — NOT NULL
  • P_LEVEL_NAME_1 — Foreign key → T_ITEM.P_LEVEL_NAME_1
  • YYYYMM