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