test2
Tables (3)
app_user
- user_id — BIGSERIAL
- name — VARCHAR(100) — NOT NULL
enrollment
- enrollment_id — BIGSERIAL
- lecture_id — BIGINT — Foreign key → lecture.lecture_id — NOT NULL
- user_id — BIGINT — Foreign key → app_user.user_id — NOT NULL
- status — VARCHAR(20) — NOT NULL
- applied_at — TIMESTAMP — NOT NULL
- waitlisted_at — TIMESTAMP
- payment_due_at — TIMESTAMP
- confirmed_at — TIMESTAMP
- cancelled_at — TIMESTAMP
- active_user_id — BIGINT
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
lecture
- lecture_id — BIGSERIAL
- creator_id — BIGINT — Foreign key → app_user.user_id — NOT NULL
- title — VARCHAR(200) — NOT NULL
- description — TEXT — NOT NULL
- price — BIGINT — NOT NULL
- capacity — INTEGER — NOT NULL
- recruitment_start_at — TIMESTAMP — NOT NULL
- recruitment_end_at — TIMESTAMP — NOT NULL
- lecture_start_at — TIMESTAMP — NOT NULL
- lecture_end_at — TIMESTAMP — NOT NULL
- status — VARCHAR(20) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL