cotept

Tables (7)

Booking

  • id — SERIAL
  • scheduleId — INTEGER — NOT NULL
  • menteeId — INTEGER — NOT NULL
  • bookingDate — TIMESTAMP — NOT NULL

Cancellation

  • id — SERIAL
  • bookingId — INTEGER — NOT NULL
  • cancellationDate — TIMESTAMP — NOT NULL
  • reason — TEXT — NOT NULL

Mentee

  • id — SERIAL
  • userId — INTEGER — NOT NULL
  • preferences — TEXT — NOT NULL

Mentor

  • id — SERIAL
  • userId — INTEGER — NOT NULL
  • bio — TEXT — NOT NULL
  • expertise — TEXT — NOT NULL

Payment

  • id — SERIAL
  • bookingId — INTEGER — NOT NULL
  • amount — NUMERIC(10, 2) — NOT NULL
  • paymentDate — TIMESTAMP — NOT NULL

Schedule

  • id — SERIAL
  • mentorId — INTEGER — NOT NULL
  • date — TIMESTAMP — NOT NULL
  • startTime — TIMESTAMP — NOT NULL
  • endTime — TIMESTAMP — NOT NULL
  • available — BOOLEAN — NOT NULL

User

  • id — SERIAL
  • name — VARCHAR(255) — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • role — VARCHAR(255) — NOT NULL