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