실습

테이블 (5)

department (Untitled2)

  • dID (Key) — int(10) — 기본 키 — NOT NULL
  • dName (Field) — char(30)
  • Field2

employee (Untitled)

  • pID (Key) — int(13) — 기본 키 — NOT NULL
  • name (Field) — char(30)
  • address (Field2) — char(50)
  • wage (Field3) — float
  • gender (Field4) — char(10)
  • birthdate (Field5) — date
  • dID (Key2) — int(10) — 외래 키 → department.dID — NOT NULL

employeeFamily (Untitled4)

    project (Untitled3)

    • pName (Field) — char(30)
    • Field2

    work_on (Untitled5)

    • Field