test

Tables (9)

cart_items

  • cart_id — INT
  • user_id — INT — NOT NULL
  • lecture_id — INT — NOT NULL
  • added_at — DATETIME

enrollments

  • enrollment_id — INT
  • user_id — INT — NOT NULL
  • lecture_id — INT — NOT NULL
  • status — ENUM('IN_PROGRESS', 'COMPLETED', 'CANCELLED')
  • enrolled_at — DATETIME

lecture_feedback

  • feedback_id — INT
  • user_id — INT — NOT NULL
  • lecture_id — INT — NOT NULL
  • rating — TINYINT — NOT NULL
  • comment — TEXT
  • created_at — DATETIME

lecture_questions

  • question_id — INT
  • user_id — INT — NOT NULL
  • lecture_id — INT — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • content — TEXT — NOT NULL
  • created_at — DATETIME

mentoring_posts

  • post_id — INT
  • mentor_id — INT — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • content — TEXT — NOT NULL
  • is_closed — BOOLEAN
  • created_at — DATETIME

payments

  • payment_id — INT
  • user_id — INT — NOT NULL
  • lecture_id — INT — NOT NULL
  • amount — INT — NOT NULL
  • method — ENUM('CARD', 'BANK_TRANSFER') — NOT NULL
  • status — ENUM('SUCCESS', 'FAILED', 'PENDING')
  • created_at — DATETIME

site_inquiries

  • inquiry_id — INT
  • user_id — INT — NOT NULL
  • category — VARCHAR(50)
  • content — TEXT — NOT NULL
  • status — ENUM('PENDING', 'ANSWERED')
  • created_at — DATETIME

user_profiles

  • profile_id — INT
  • user_id — INT — NOT NULL
  • bio — TEXT
  • skills — VARCHAR(255)
  • profile_image — VARCHAR(255)
  • updated_at — DATETIME

users

  • user_id — INT — User ID
  • email — VARCHAR(100) — NOT NULL — User email
  • password — VARCHAR(255) — NOT NULL — Encrypted password
  • name — VARCHAR(50) — NOT NULL — User name
  • phone — VARCHAR(20) — Phone number
  • user_type — ENUM('STUDENT', 'INSTRUCTOR', 'ADMIN') — NOT NULL — User role
  • is_verified — BOOLEAN — Email verified status
  • created_at — DATETIME — Sign-up date