Combine-Language

Tables (4)

lesson_reservations

  • reserve_id — SERIAL
  • lesson_id — INTEGER — Foreign key → lessons.lesson_id — NOT NULL
  • teacher_id — VARCHAR(100) — Foreign key → teachers.user_id — NOT NULL
  • user_id — VARCHAR(100) — Foreign key → users.user_id — NOT NULL
  • reserved_date — DATE — NOT NULL
  • reserved_time — TIME — NOT NULL
  • status — VARCHAR(20)
  • payment_status — BOOLEAN
  • meeting_link — TEXT
  • completed_by_student — BOOLEAN
  • auto_completed — BOOLEAN
  • created_at — TIMESTAMP
  • fee — INTEGER

lessons

  • lesson_id — SERIAL
  • teacher_id — VARCHAR(100) — Foreign key → teachers.user_id — NOT NULL
  • title — VARCHAR(100)
  • description — TEXT
  • created_at — TIMESTAMP
  • available_date — DATE
  • available_time — TIME
  • tag — VARCHAR(100)
  • file_path — TEXT
  • fee — INTEGER

teachers

  • user_id — VARCHAR(100) — Foreign key → users.user_id
  • level — INTEGER
  • approved — BOOLEAN
  • language — VARCHAR(3)

users

  • user_id — VARCHAR(100)
  • password — VARCHAR(255) — NOT NULL
  • teacher — BOOLEAN — NOT NULL
  • created_at — TIMESTAMP