| id |
int(11)
|
|
|
|
| user_id |
int(11)
|
|
|
|
| plan_id |
int(11)
|
|
|
|
| provider |
varchar(32)
|
utf8mb4_general_ci
|
|
|
| provider_ref |
varchar(191)
|
utf8mb4_general_ci
|
|
|
| provider_customer_ref |
varchar(191)
|
utf8mb4_general_ci
|
|
|
| reference_code |
varchar(64)
|
utf8mb4_general_ci
|
|
|
| session_id |
varchar(191)
|
utf8mb4_general_ci
|
|
|
| status |
enum('pending', 'active', 'past_due', 'canceled', 'expired')
|
utf8mb4_general_ci
|
|
|
| current_period_start |
datetime
|
|
|
|
| current_period_end |
datetime
|
|
|
|
| access_until |
datetime
|
|
|
|
| next_charge_at |
datetime
|
|
|
|
| billing_anchor |
datetime
|
|
|
|
| cancel_at_period_end |
tinyint(1)
|
|
|
|
| auto_renew |
tinyint(1)
|
|
|
|
| canceled_at |
datetime
|
|
|
|
| fb_fbp |
varchar(128)
|
utf8mb4_general_ci
|
|
|
| fb_fbc |
varchar(191)
|
utf8mb4_general_ci
|
|
|
| fb_client_ip |
varchar(64)
|
utf8mb4_general_ci
|
|
|
| fb_client_ua |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| fb_subscribe_sent_at |
datetime
|
|
|
|
| created_at |
datetime
|
|
|
|
| updated_at |
datetime
|
|
|
|
| renewal_reminder_sent_at |
datetime
|
|
|
|
