Fitness CRM

Tables (5)

ATTENDANCE

  • attendance_uuid — CHAR(32) — Primary key — NOT NULL
  • membership_uuid — CHAR(32) — Foreign key → MEMBERSHIP.membership_uuid — NOT NULL
  • attendance_no — VARCHAR(20) — NOT NULL
  • checkin_at — TIMESTAMP — NOT NULL
  • checkout_at — TIMESTAMP
  • attendance_status — VARCHAR(20) — NOT NULL
  • failure_reason — VARCHAR(255)
  • created_by — VARCHAR(50) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • last_changed_by — VARCHAR(50) — NOT NULL
  • last_changed_at — TIMESTAMP — NOT NULL
  • local_last_changed_at — TIMESTAMP — NOT NULL

MEMBER

  • member_uuid — CHAR(32) — Primary key — NOT NULL
  • member_no — VARCHAR(20) — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • phone — VARCHAR(20) — NOT NULL
  • email — VARCHAR(100)
  • birth_date — DATE
  • gender — VARCHAR(10)
  • status — VARCHAR(20) — NOT NULL
  • created_by — VARCHAR(50) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • last_changed_by — VARCHAR(50) — NOT NULL
  • last_changed_at — TIMESTAMP — NOT NULL
  • local_last_changed_at — TIMESTAMP — NOT NULL

MEMBERSHIP

  • membership_uuid — CHAR(32) — Primary key — NOT NULL
  • member_uuid — CHAR(32) — Foreign key → MEMBER.member_uuid — NOT NULL
  • product_uuid — CHAR(32) — Foreign key → PRODUCT.product_uuid — NOT NULL
  • membership_no — VARCHAR(20) — NOT NULL
  • start_date — DATE
  • end_date — DATE
  • total_count — INTEGER
  • used_count — INTEGER — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • created_by — VARCHAR(50) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • last_changed_by — VARCHAR(50) — NOT NULL
  • last_changed_at — TIMESTAMP — NOT NULL
  • local_last_changed_at — TIMESTAMP — NOT NULL

PAYMENT

  • payment_uuid — CHAR(32) — Primary key — NOT NULL
  • membership_uuid — CHAR(32) — Foreign key → MEMBERSHIP.membership_uuid — NOT NULL
  • payment_no — VARCHAR(20) — NOT NULL
  • payment_type — VARCHAR(20) — NOT NULL
  • amount — DECIMAL(15,2) — NOT NULL
  • currency_code — CHAR(3) — NOT NULL
  • payment_date — DATE
  • payment_status — VARCHAR(20) — NOT NULL
  • refund_amount — DECIMAL(15,2)
  • refund_date — DATE
  • created_by — VARCHAR(50) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • last_changed_by — VARCHAR(50) — NOT NULL
  • last_changed_at — TIMESTAMP — NOT NULL
  • local_last_changed_at — TIMESTAMP — NOT NULL

PRODUCT

  • product_uuid — CHAR(32) — Primary key — NOT NULL
  • product_no — VARCHAR(20) — NOT NULL
  • product_name — VARCHAR(100) — NOT NULL
  • product_type — VARCHAR(20) — NOT NULL
  • price — DECIMAL(15,2) — NOT NULL
  • currency_code — CHAR(3) — NOT NULL
  • duration_days — INTEGER
  • total_count — INTEGER
  • status — VARCHAR(20) — NOT NULL
  • created_by — VARCHAR(50) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • last_changed_by — VARCHAR(50) — NOT NULL
  • last_changed_at — TIMESTAMP — NOT NULL
  • local_last_changed_at — TIMESTAMP — NOT NULL