depart_member
Tables (5)
Department (부서)
- 부서코드 (Key) — varchar(50) — Primary key — NOT NULL
- 부서 (Field) — varchar(50)
Employee (사원)
- 사번 (Key) — varchar(50) — Primary key — NOT NULL
- 이름 (Field) — varchar(50)
employee_department (Untitled)
- 사번부서코드id (Key3) — Primary key — NOT NULL
- 사번 (Key) — varchar(50) — Foreign key → Employee.사번 — NOT NULL
- 부서코드 (Key2) — varchar(50) — Foreign key → Department.부서코드 — NOT NULL
order (Untitled3)
- order_id (Key) — Primary key — NOT NULL
- user_id (Key2) — Foreign key → user.user_id — NOT NULL
- order_cnt (Field)
user (Untitled2)
- user_id (Key) — Primary key — NOT NULL
- user_name (Field)
- user_email (Field2)