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