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