be_test

Tables (5)

account (account(계정))

  • id — INTEGER — Primary key — NOT NULL
  • email — VARCHAR(255) — NOT NULL — 사용자 이메일, 계정으로 사용(UNIQUE)
  • role — VARCHAR(255) — NOT NULL — STUDENT / INSTRUCTOR
  • created_at — TIMESTAMP — NOT NULL — 생성시간
  • updated_at — TIMESTAMP — NOT NULL — 수정시간

course (course(강의))

  • id — INTEGER — Primary key — NOT NULL
  • id (instructor_id) — INTEGER — Foreign key → instructor.id — NOT NULL — ON UPDATE CASCADE
  • title — VARCHAR(255) — NOT NULL — 강의 제목 UNIQUE
  • description — TEXT — NOT NULL — 강의 설명
  • category — VARCHAR(255) — NOT NULL — 카테고리
  • price — INTEGER — NOT NULL — CHECK (price > 0)
  • is_visible — BOOLEAN — NOT NULL — 공개 여부
  • created_at — TIMESTAMP — NOT NULL — 생성시간
  • updated_at — TIMESTAMP — NOT NULL — 수정시간

instructor (instructor(강사))

  • id — INTEGER — Primary key — NOT NULL
  • account_id — INTEGER — Foreign key → account.id — NOT NULL — ON UPDATE / ON DELETE CASCADE
  • nickname — VARCHAR(255) — NOT NULL — 닉네임
  • created_at — TIMESTAMP — NOT NULL — 생성시간
  • updated_at — TIMESTAMP — NOT NULL — 수정시간

student (student(수강생))

  • id — INTEGER — Primary key — NOT NULL
  • account_id — INTEGER — Foreign key → account.id — NOT NULL — ON UPDATE / ON DELETE CASCADE
  • nickname — VARCHAR(255) — NOT NULL — 닉네임
  • created_at — TIMESTAMP — NOT NULL — 생성시간
  • updated_at — TIMESTAMP — NOT NULL — 수정시간

student_course (student_course(수강신청))

  • id — INTEGER — Primary key — NOT NULL
  • account_id (course_id) — INTEGER — Foreign key → student.id — NOT NULL
  • id (student_id) — INTEGER — Foreign key → course.id — NOT NULL — ON UPDATE / ON DELETE CASCADE
  • created_at — TIMESTAMP — NOT NULL — 생성시간(수강신청한 시간)
  • updated_at — TIMESTAMP — NOT NULL — 수정시간