1
Tables (10)
admin_dashboard
- id — SERIAL
- daily_visitors — INTEGER — NOT NULL
- daily_page_views — INTEGER — NOT NULL
- daily_revenue — DECIMAL(10, 2) — NOT NULL
- course_progress_stats — JSONB — NOT NULL
- created_at — TIMESTAMP
auth_tokens
- id — SERIAL
- user_id — INTEGER
- token — VARCHAR(500) — NOT NULL
- created_at — TIMESTAMP
certificates
- id — SERIAL
- course_id — INTEGER
- user_id — INTEGER
- issue_date — DATE — NOT NULL
courses
- id — SERIAL
- title — VARCHAR(255) — NOT NULL
- description — TEXT
- status — VARCHAR(50) — NOT NULL
mission_submissions
- id — SERIAL
- mission_id — INTEGER
- user_id — INTEGER
- answer — TEXT — NOT NULL
- submitted_at — TIMESTAMP
missions
- id — SERIAL
- course_id — INTEGER
- title — VARCHAR(255) — NOT NULL
- type — VARCHAR(50) — NOT NULL
- content — TEXT
payments
- id — SERIAL
- user_id — INTEGER
- amount — DECIMAL(10, 2) — NOT NULL
- method — VARCHAR(50) — NOT NULL
- status — VARCHAR(50) — NOT NULL
- created_at — TIMESTAMP
refunds
- id — SERIAL
- payment_id — INTEGER
- refunded_at — TIMESTAMP
users
- id — SERIAL
- username — VARCHAR(255) — NOT NULL
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- role — VARCHAR(50) — NOT NULL
- nickname — VARCHAR(255)
- total_study_time — INTEGER
- subscription_end_date — DATE
videos
- id — SERIAL
- course_id — INTEGER
- title — VARCHAR(255) — NOT NULL
- duration — INTEGER — NOT NULL
- last_watched_position — INTEGER