inflab

테이블 (4)

course

  • Instructor Id (id2) — NOT NULL, — 외래 키 → 강사.Instructor Id — NOT NULL
  • id — bigint
  • description — text — NOT NULL
  • category — varchar(255) — NOT NULL
  • title — varchar(255) — NOT NULL
  • price — int — NOT NULL
  • status — varchar(255) — NOT NULL
  • student_number — int — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL
  • instructor_id — bigint — 외래 키 — NOT NULL

enrollment

  • course_id — bigint — 외래 키 → course.id — NOT NULL
  • student_id — bigint — 외래 키 → student.id — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL

student

  • id — bigint
  • email — varchar(255) — NOT NULL
  • nickname — varchar(255) — NOT NULL
  • introduction — varchar(255) — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL

강사 (instructor)

  • Instructor Id (id) — NOT NULL, — 기본 키 — NOT NULL
  • 이메일 (email) — NOT NULL — NOT NULL
  • 강사명 (name) — NOT NULL — NOT NULL
  • 소개 (introduction) — NOT NULL
  • created_at — datetime
  • updated_at — datetime
  • Field