courseregistration

Tables (4)

courses (강의)

  • id (강의ID) — UUID — Primary key — NOT NULL
  • creator_id (강사ID) — UUID — Foreign key → users.id — NOT NULL
  • title (제목) — VARCHAR(100)
  • description (설명) — TEXT
  • price (가격) — INTEGER
  • capacity (정원) — INTEGER
  • enrollment_count (수강신청인원) — INTEGER
  • start_date (시작일) — DATE
  • end_date (종료일) — DATE
  • status (강의 상태) — VARCHAR(20)
  • created_at (생성일자) — TIMESTAMPTZ
  • updated_at (수정일자) — TIMESTAMPTZ

enrollments (수강 신청)

  • id (수강신청ID) — UUID — Primary key — NOT NULL
  • course_id (강의ID) — UUID — Foreign key → courses.id — NOT NULL
  • student_id (수강생ID) — UUID — Foreign key → users.id — NOT NULL
  • status (수강신청 상태) — VARCHAR(20)
  • enrolled_at (수강신청일자) — TIMESTAMPTZ
  • confirmed_at (결제완료일자) — TIMESTAMPTZ
  • cancelled_at (취소일자) — TIMESTAMPTZ
  • created_at (생성일자) — TIMESTAMPTZ
  • updated_at (수정일자) — TIMESTAMPTZ

users (사용자)

  • id (사용자ID) — UUID — Primary key — NOT NULL
  • name (이름) — VARCHAR(20)
  • email (이메일) — VARCHAR(100)
  • role (권한) — VARCHAR(20)
  • created_at (생성일자) — TIMESTAMPTZ
  • updated_at (수정일자) — TIMESTAMPTZ

waitlists (대기열)

  • id (대기열Id) — UUID — Primary key — NOT NULL
  • student_id (학생ID) — UUID — Foreign key → users.id — NOT NULL
  • course_id (강의ID) — UUID — Foreign key → courses.id — NOT NULL
  • status (대기상태) — VARCHAR(20)
  • created_at (생성일자) — TIMESTAMPTZ
  • updated_at (수정일자) — TIMESTAMPTZ