goodprompt

Tables (21)

assessment_results

  • id — UUID — Primary key — NOT NULL
  • assessment_id — UUID — Foreign key → assessments.id — NOT NULL
  • enrollment_id — UUID — Foreign key → enrollments.id — NOT NULL
  • student_id — UUID — Foreign key → users.id — NOT NULL
  • score — NUMERIC(5,2)
  • feedback_text — TEXT
  • embedding — VECTOR(1536)
  • embedding_model — VARCHAR(50)
  • created_at — TIMESTAMPTZ — NOT NULL

assessments

  • id — UUID — Primary key — NOT NULL
  • course_id — UUID — Foreign key → courses.id — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • type — VARCHAR(20) — NOT NULL
  • description — TEXT
  • created_at — TIMESTAMPTZ — NOT NULL

assignment_submissions

  • id — UUID — Primary key — NOT NULL
  • assignment_id — UUID — Foreign key → assignments.id — NOT NULL
  • student_id — UUID — Foreign key → users.id — NOT NULL
  • content — TEXT
  • file_url — TEXT
  • status — VARCHAR(20) — NOT NULL
  • score — NUMERIC(5,2)
  • feedback — TEXT
  • submitted_at — TIMESTAMPTZ — NOT NULL
  • graded_at — TIMESTAMPTZ
  • graded_by — UUID — Foreign key → users.id

assignments

  • id — UUID — Primary key — NOT NULL
  • course_id — UUID — Foreign key → courses.id — NOT NULL
  • lecture_id — UUID — Foreign key → lectures.id
  • title — VARCHAR(200) — NOT NULL
  • description — TEXT
  • due_type — VARCHAR(20) — NOT NULL
  • due_at — TIMESTAMPTZ
  • due_after_days — INTEGER
  • max_score — NUMERIC(5,2) — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

categories

  • id — SERIAL — Primary key — NOT NULL
  • parent_id — INTEGER — Foreign key → categories.id
  • name — VARCHAR(100) — NOT NULL
  • slug — VARCHAR(100) — NOT NULL
  • order_index — INTEGER

certificates

  • id — UUID — Primary key — NOT NULL
  • enrollment_id — UUID — Foreign key → enrollments.id — NOT NULL
  • certificate_number — VARCHAR(50) — NOT NULL
  • pdf_url — TEXT
  • issued_at — TIMESTAMPTZ — NOT NULL

course_answers

  • id — UUID — Primary key — NOT NULL
  • question_id — UUID — Foreign key → course_questions.id — NOT NULL
  • author_id — UUID — Foreign key → users.id — NOT NULL
  • content — TEXT — NOT NULL
  • is_instructor_answer — BOOLEAN
  • created_at — TIMESTAMPTZ — NOT NULL

course_content_embeddings

  • course_id — UUID — Foreign key → courses.id — NOT NULL
  • content_vector — VECTOR(1536) — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

course_questions

  • id — UUID — Primary key — NOT NULL
  • course_id — UUID — Foreign key → courses.id — NOT NULL
  • lecture_id — UUID — Foreign key → lectures.id
  • student_id — UUID — Foreign key → users.id — NOT NULL
  • title — VARCHAR(200)
  • content — TEXT — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

course_reviews

  • id — UUID — Primary key — NOT NULL
  • course_id — UUID — Foreign key → courses.id — NOT NULL
  • student_id — UUID — Foreign key → users.id — NOT NULL
  • enrollment_id — UUID — Foreign key → enrollments.id — NOT NULL
  • rating — SMALLINT — NOT NULL
  • comment — TEXT
  • instructor_reply — TEXT
  • created_at — TIMESTAMPTZ — NOT NULL

course_sections

  • id — UUID — Primary key — NOT NULL
  • course_id — UUID — Foreign key → courses.id — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • order_index — INTEGER — NOT NULL

courses

  • id — UUID — Primary key — NOT NULL
  • instructor_id — UUID — Foreign key → users.id — NOT NULL
  • category_id — INTEGER — Foreign key → categories.id
  • title — VARCHAR(200) — NOT NULL
  • subtitle — VARCHAR(300)
  • description — TEXT
  • thumbnail_url — TEXT
  • intro_video_url — TEXT
  • level — VARCHAR(20)
  • price — NUMERIC(10,2) — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • language — VARCHAR(10)
  • total_duration_seconds — INTEGER
  • average_rating — NUMERIC(3,2)
  • student_count — INTEGER
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL
  • published_at — TIMESTAMPTZ

enrollments

  • id — UUID — Primary key — NOT NULL
  • student_id — UUID — Foreign key → users.id — NOT NULL
  • course_id — UUID — Foreign key → courses.id — NOT NULL
  • price_paid — NUMERIC(10,2) — NOT NULL
  • progress_percent — NUMERIC(5,2) — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • enrolled_at — TIMESTAMPTZ — NOT NULL
  • completed_at — TIMESTAMPTZ

instructor_profiles

  • user_id — UUID — Foreign key → users.id — NOT NULL
  • headline — VARCHAR(150)
  • bio — TEXT
  • career — JSONB
  • settlement_bank — VARCHAR(50)
  • settlement_account — VARCHAR(50)
  • revenue_share_rate — NUMERIC(4,2)
  • is_approved — BOOLEAN — NOT NULL
  • approved_at — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ — NOT NULL

lecture_progress

  • id — UUID — Primary key — NOT NULL
  • enrollment_id — UUID — Foreign key → enrollments.id — NOT NULL
  • lecture_id — UUID — Foreign key → lectures.id — NOT NULL
  • is_completed — BOOLEAN — NOT NULL
  • last_watched_position_seconds — INTEGER
  • completed_at — TIMESTAMPTZ
  • updated_at — TIMESTAMPTZ — NOT NULL

lectures

  • id — UUID — Primary key — NOT NULL
  • section_id — UUID — Foreign key → course_sections.id — NOT NULL
  • course_id — UUID — Foreign key → courses.id — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • content_type — VARCHAR(20) — NOT NULL
  • video_url — TEXT
  • video_duration_seconds — INTEGER
  • order_index — INTEGER — NOT NULL
  • is_preview — BOOLEAN — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

order_items

  • id — UUID — Primary key — NOT NULL
  • order_id — UUID — Foreign key → orders.id — NOT NULL
  • course_id — UUID — Foreign key → courses.id — NOT NULL
  • price_at_purchase — NUMERIC(10,2) — NOT NULL

orders

  • id — UUID — Primary key — NOT NULL
  • student_id — UUID — Foreign key → users.id — NOT NULL
  • total_amount — NUMERIC(10,2) — NOT NULL
  • payment_method — VARCHAR(30)
  • payment_status — VARCHAR(20) — NOT NULL
  • pg_transaction_id — VARCHAR(100)
  • created_at — TIMESTAMPTZ — NOT NULL
  • paid_at — TIMESTAMPTZ

student_competency_profiles

  • id — UUID — Primary key — NOT NULL
  • student_id — UUID — Foreign key → users.id — NOT NULL
  • course_id — UUID — Foreign key → courses.id
  • competency_vector — VECTOR(1536) — NOT NULL
  • based_on_result_count — INTEGER
  • updated_at — TIMESTAMPTZ — NOT NULL

users

  • id — UUID — Primary key — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • password_hash — VARCHAR(255) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • profile_image_url — TEXT
  • phone — VARCHAR(20)
  • is_instructor — BOOLEAN — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • last_login_at — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

wishlists

  • student_id — UUID — Foreign key → users.id — NOT NULL
  • course_id — UUID — Foreign key → courses.id — NOT NULL
  • added_at — TIMESTAMPTZ — NOT NULL