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