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)