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)