| id |
int(11)
|
|
|
|
| client_id |
int(11)
|
|
|
|
| m1_nar |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| year |
int(11)
|
|
|
|
| status |
varchar(50)
|
utf8mb4_general_ci
|
|
|
| amount |
decimal(10,2)
|
|
|
|
| discount_pct |
decimal(5,2)
|
|
|
|
| rpac_opt_in |
tinyint(1)
|
|
|
|
| rpac_amount |
decimal(10,2)
|
|
|
|
| final_amount |
decimal(10,2)
|
|
|
|
| paid_at |
datetime
|
|
|
|
| created_at |
datetime
|
|
|
|
| notes |
text
|
utf8mb4_general_ci
|
|
|
| membership_group |
varchar(20)
|
utf8mb4_general_ci
|
|
|
| membership_description |
varchar(500)
|
utf8mb4_general_ci
|
|
|
| custom_membership_amount |
decimal(10,2)
|
|
|
|
| voluntary_contribution |
decimal(10,2)
|
|
|
|
| emeritus_evidence_url |
varchar(500)
|
utf8mb4_general_ci
|
|
|
| include_mid |
tinyint(1)
|
|
|
|
| include_pr |
tinyint(1)
|
|
|
|
| include_nar |
tinyint(1)
|
|
|
|
| payment_plan_enabled |
tinyint(1)
|
|
|
|
| payment_plan_started_at |
date
|
|
|
|
| payment_plan_due_date |
date
|
|
|
|
| payment_plan_regulatory_deadline |
date
|
|
|
|
| payment_plan_penalty_pct |
decimal(5,2)
|
|
|
|
| payment_plan_penalty_amount |
decimal(10,2)
|
|
|
|
| payment_plan_total |
decimal(10,2)
|
|
|
|
| payment_plan_balance |
decimal(10,2)
|
|
|
|
| payment_plan_status |
varchar(30)
|
utf8mb4_general_ci
|
|
|
| membership_type_flags |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| board_secondary_amount |
decimal(10,2)
|
|
|
|