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