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