Demo

테이블 (11)

Department (Untitled2)

  • departmentNum (Key) — 기본 키 — NOT NULL
  • name (Field)
  • space (Field2)

Student (Untitled)

  • studentNo (Key) — int — 기본 키 — NOT NULL
  • name (Field) — varchar — NOT NULL
  • age (Field2) — tinyint
  • gender (Field3) — char
  • departmentNum (Key2) — 외래 키 → Department.departmentNum — NOT NULL

aStudent (CopyOfUntitled)

  • studentNo (Key) — int — 기본 키 — NOT NULL
  • name (Field) — varchar — NOT NULL
  • age (Field2) — tinyint
  • gender (Field3) — char

aSubject (Untitled3)

  • subjectNo (Key2) — 기본 키 — NOT NULL
  • subjectName (Key) — NOT NULL

bStudent (CopyOfCopyOfUntitled)

  • studentNo (Key) — int — 기본 키 — NOT NULL
  • name (Field) — varchar — NOT NULL
  • age (Field2) — tinyint
  • gender (Field3) — char

bSubject (CopyOfUntitled3)

  • subjectNo (Key2) — 기본 키 — NOT NULL
  • subjectName (Key) — NOT NULL

dept (Untitled6)

  • dept_id (Key) — 기본 키 — NOT NULL
  • dept_name (Field)

employee (Untitled5)

  • emp_id (Key) — 기본 키 — NOT NULL
  • name (Field)
  • dept_id (Key2) — 외래 키 → dept.dept_id — NOT NULL
  • job_id (Key3) — 외래 키 → job.job_id — NOT NULL

job (Untitled7)

  • job_id (Key) — 기본 키 — NOT NULL
  • job_name (Field)

수강신청 (Untitled4)

  • 수강번호 (Key3) — 기본 키 — NOT NULL
  • studentNo (Key) — int — 외래 키 → aStudent.studentNo — NOT NULL
  • subjectNo (Key2) — 외래 키 → aSubject.subjectNo — NOT NULL
  • 학점 (Field)

수강신청 (CopyOfUntitled4)

  • studentNo (Key) — int — 외래 키 → bStudent.studentNo — NOT NULL
  • subjectNo (Key2) — 외래 키 → bSubject.subjectNo — NOT NULL
  • 학점 (Field)