ㅇㅇ

Tables (7)

Consultation

  • ConsultationID — SERIAL
  • CustomerID — INTEGER
  • TrainerID — INTEGER
  • ConsultationDate — DATE — NOT NULL
  • ConsultationTime — TIME — NOT NULL
  • ConsultationDetails — TEXT
  • ConsultationStatus — VARCHAR(50)
  • In — Progress'

Customer

  • CustomerID — SERIAL
  • Name — VARCHAR(100) — NOT NULL
  • Email — VARCHAR(100) — NOT NULL
  • PhoneNumber — VARCHAR(15)
  • DateOfBirth — DATE
  • Address — TEXT
  • Goal — TEXT
  • HealthStatus — TEXT
  • RegistrationDate — DATE
  • CustomerTier — VARCHAR(50)

Evaluation

  • EvaluationID — SERIAL
  • CustomerID — INTEGER
  • TrainerID — INTEGER
  • SessionID — INTEGER
  • Rating — INTEGER
  • ReviewText — TEXT
  • EvaluationDate — DATE
  • Recommendation — BOOLEAN

HealthCenter

  • HealthCenterID — SERIAL
  • Name — VARCHAR(100) — NOT NULL
  • Location — TEXT — NOT NULL
  • ContactNumber — VARCHAR(15)
  • OperatingHours — TEXT
  • FacilityType — TEXT
  • RegistrationDate — DATE

Payment

  • PaymentID — SERIAL
  • CustomerID — INTEGER
  • TrainerID — INTEGER
  • Amount — DECIMAL(10, 2) — NOT NULL
  • PaymentDate — DATE
  • PaymentMethod — VARCHAR(50)
  • Bank — Transfer'
  • Mobile — Payment'))
  • PaymentStatus — VARCHAR(50)
  • TransactionID — VARCHAR(100)

Trainer

  • TrainerID — SERIAL
  • Name — VARCHAR(100) — NOT NULL
  • Email — VARCHAR(100) — NOT NULL
  • PhoneNumber — VARCHAR(15)
  • Specialization — VARCHAR(100)
  • Experience — INTEGER
  • Certifications — TEXT
  • Availability — TEXT
  • JoinDate — DATE
  • TrainerTier — VARCHAR(50)
  • AverageRating — FLOAT

TrainingSession

  • SessionID — SERIAL
  • TrainerID — INTEGER
  • CustomerID — INTEGER
  • HealthCenterID — INTEGER
  • SessionDate — DATE — NOT NULL
  • SessionTime — TIME — NOT NULL
  • TrainingGoal — TEXT
  • SessionStatus — VARCHAR(50)
  • Feedback — TEXT