FITMATE
Tables (5)
chats
- chat_id — SERIAL
- sender_id — INT — NOT NULL
- receiver_id — INT — NOT NULL
- message — TEXT
- created_at — TIMESTAMP
class_requests
- request_id — SERIAL
- customer_id — INT — NOT NULL
- name — VARCHAR(255)
- description — TEXT
- exercise_type — VARCHAR(50)
- region — VARCHAR(100)
- trainer_gender — VARCHAR(10)
- class_type — VARCHAR(20)
- time_slot — VARCHAR(20)
- price_min — INT
- price_max — INT
- created_at — TIMESTAMP
classes
- class_id — SERIAL
- trainer_id — INT — NOT NULL
- name — VARCHAR(255) — NOT NULL
- description — TEXT
- class_type — VARCHAR(20)
- time_slot — VARCHAR(20)
- location — VARCHAR(255)
- price_min — INT
- price_max — INT
- capacity — INT
- created_at — TIMESTAMP
reservations
- reservation_id — SERIAL
- class_id — INT — NOT NULL
- customer_id — INT — NOT NULL
- status — VARCHAR(20)
- rating — INT
- created_at — TIMESTAMP
users
- user_id — SERIAL
- name — VARCHAR(100) — NOT NULL
- age — INT
- gender — VARCHAR(10)
- email — VARCHAR(255) — NOT NULL
- phone — VARCHAR(20)
- profile_image — TEXT
- introduction — TEXT
- role — VARCHAR(20)
- experience — TEXT