| id |
varchar(64)
|
utf8mb4_general_ci
|
|
|
| full_name |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| phone |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| email |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| membership_type |
varchar(30)
|
utf8mb4_general_ci
|
|
|
| batch_timing |
varchar(20)
|
utf8mb4_general_ci
|
|
|
| start_date |
date
|
|
|
|
| expiry_date |
date
|
|
|
|
| status |
varchar(20)
|
utf8mb4_general_ci
|
|
|
| attendance_count |
int(11)
|
|
|
|
| total_sessions |
int(11)
|
|
|
|
| plan_id |
varchar(64)
|
utf8mb4_general_ci
|
|
|
| plan_name |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| plan_duration |
varchar(20)
|
utf8mb4_general_ci
|
|
|
| batch_id |
varchar(64)
|
utf8mb4_general_ci
|
|
|
| backup_batch_id |
varchar(64)
|
utf8mb4_general_ci
|
|
|
| goals |
text
|
utf8mb4_general_ci
|
|
|
| risk_flags |
longtext
|
utf8mb4_bin
|
|
|
| notes |
text
|
utf8mb4_general_ci
|
|
|
| injuries |
text
|
utf8mb4_general_ci
|
|
|
| is_corporate_gst |
tinyint(1)
|
|
|
|
| created_at |
date
|
|
|
|
| lead_id |
varchar(64)
|
utf8mb4_general_ci
|
|
|
| studio_id |
char(36)
|
utf8mb4_general_ci
|
|
|
| trainer_id |
char(36)
|
utf8mb4_general_ci
|
|
|