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 — 수정시간