sample
Tables (8)
PT_Assignment (Untitled8)
- assignment_id (Key) — Primary key — NOT NULL
- purchase_id (Key2) — Foreign key → PT_Puchase.purchase_id — NOT NULL
- trainer_id (Key3) — Foreign key → trainer.trainer_id — NOT NULL
- assigned_sessions (Field)
- used_sessions (Field2)
PT_Package (Untitled3)
- package_id (Key) — Primary key — NOT NULL
- name (Field)
- total_session (Field2)
- price_per_session (Field3)
- total_price (Field4)
PT_Puchase (Untitled4)
- purchase_id (Key) — Primary key — NOT NULL
- member_id (Key2) — Foreign key → member.member_id — NOT NULL
- trainer_id (Key3) — Foreign key → trainer.trainer_id — NOT NULL
- package_id (Key4) — Foreign key → PT_Package.package_id — NOT NULL
- purchase_date (Field)
- total_sessions (Field2)
- remaining_sessions (Field3)
- total_price (Field4)
- status (Field5)
PT_session (Untitled5)
- session_id (Key) — Primary key — NOT NULL
- purchase_id (Key2) — Foreign key → PT_Puchase.purchase_id — NOT NULL
- session_date (Field)
- status (Field2)
Refund (Untitled6)
- refund_id (Key) — Primary key — NOT NULL
- purchase_id (Key2) — Foreign key → PT_Puchase.purchase_id — NOT NULL
- refund_date (Field)
- refunded_sessions (Field2)
- refund_amount (Field3)
Trainer_Revenue (Untitled7)
- revenue_id (Key) — Primary key — NOT NULL
- trainer_id (Key2) — Foreign key → trainer.trainer_id — NOT NULL
- year_month (Field2)
- total_revenue (Field3)
- total_sessions (Field4)
member (Untitled)
- member_id (Key) — Primary key — NOT NULL
- name (Field)
- phone (Field2)
- email (Field3)
- date (Field4)
trainer (Untitled2)
- trainer_id (Key) — Primary key — NOT NULL
- name (Field)