pjt 22

Tables (6)

Class (class)

  • Campus (campus) — VARCHAR(25) — Primary key — NOT NULL
  • Num (num) — INT(10) — Primary key — NOT NULL
  • No (coach_no) — VARCHAR(25) — Foreign key → Coach.No — NOT NULL
  • No (consultant_no) — VARCHAR(25) — Foreign key → Consultant.No — NOT NULL
  • Field

Coach (coach)

  • No (no) — VARCHAR(25) — Primary key — NOT NULL
  • Job_Code (job_code) — VARCHAR(25) — Foreign key → Job.Code — NOT NULL

Consultant (consultant)

  • No (no) — VARCHAR(25) — Primary key — NOT NULL
  • Job_Code (job_code) — VARCHAR(25) — Foreign key → Job.Code — NOT NULL

Course (course)

  • Course (course) — VARCHAR(25) — Primary key — NOT NULL

Job (job)

  • Code (code) — VARCHAR(25) — Primary key — NOT NULL

Student (student)

  • No (no) — VARCHAR(25) — Primary key — NOT NULL
  • Campus (campus) — VARCHAR(25) — Foreign key → Class.Campus — NOT NULL
  • Num (num) — INT(10) — Foreign key → Class.Num — NOT NULL
  • No (no2) — VARCHAR(25) — Foreign key → Class.No — NOT NULL
  • Course (course) — VARCHAR(25) — Foreign key → Course.Course — NOT NULL
  • Year (year) — int(10) — NOT NULL
  • MajorYN (majorYn) — VARCHAR(10)
  • attendYN (attendYn) — VARCHAR(10)