| id |
int(11)
|
|
|
|
| group_code |
varchar(30)
|
utf8mb4_general_ci
|
|
|
| group_name |
varchar(150)
|
utf8mb4_general_ci
|
|
|
| branch_id |
int(11)
|
|
|
|
| meeting_days |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| meeting_time |
varchar(30)
|
utf8mb4_general_ci
|
|
|
| meeting_location |
varchar(250)
|
utf8mb4_general_ci
|
|
|
| location_gps |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| contact_address |
varchar(250)
|
utf8mb4_general_ci
|
|
|
| treasury_amount |
decimal(12,2)
|
|
|
|
| group_leader_name |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| group_leader_phone |
varchar(30)
|
utf8mb4_general_ci
|
|
|
| group_leader_photo |
varchar(250)
|
utf8mb4_general_ci
|
|
|
| group_leader_signature |
varchar(250)
|
utf8mb4_general_ci
|
|
|
| chairman_name |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| chairman_signature |
varchar(250)
|
utf8mb4_general_ci
|
|
|
| secretary_name |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| secretary_signature |
varchar(250)
|
utf8mb4_general_ci
|
|
|
| treasurer_name |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| treasurer_signature |
varchar(250)
|
utf8mb4_general_ci
|
|
|
| organizer_name |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| organizer_signature |
varchar(250)
|
utf8mb4_general_ci
|
|
|
| group_photo |
varchar(250)
|
utf8mb4_general_ci
|
|
|
| total_members |
int(11)
|
|
|
|
| status |
enum('Active', 'Inactive', 'Suspended')
|
utf8mb4_general_ci
|
|
|
| created_at |
timestamp
|
|
|
|
| updated_at |
timestamp
|
|
|
|