ㅇㅇ
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