| subscription_id |
int(11)
|
|
|
|
| order_id |
int(11)
|
|
|
|
| store_id |
int(11)
|
|
|
|
| customer_id |
int(11)
|
|
|
|
| payment_address_id |
int(11)
|
|
|
|
| payment_method |
text
|
utf8mb4_unicode_ci
|
|
|
| shipping_address_id |
int(11)
|
|
|
|
| shipping_method |
text
|
utf8mb4_unicode_ci
|
|
|
| subscription_plan_id |
int(11)
|
|
|
|
| trial_price |
decimal(10,4)
|
|
|
|
| trial_tax |
decimal(10,4)
|
|
|
|
| trial_frequency |
enum('day', 'week', 'semi_month', 'month', 'year')
|
utf8mb4_unicode_ci
|
|
|
| trial_cycle |
smallint(6)
|
|
|
|
| trial_duration |
smallint(6)
|
|
|
|
| trial_remaining |
smallint(6)
|
|
|
|
| trial_status |
tinyint(1)
|
|
|
|
| price |
decimal(10,4)
|
|
|
|
| tax |
decimal(10,4)
|
|
|
|
| frequency |
enum('day', 'week', 'semi_month', 'month', 'year')
|
utf8mb4_unicode_ci
|
|
|
| cycle |
smallint(6)
|
|
|
|
| duration |
smallint(6)
|
|
|
|
| remaining |
smallint(6)
|
|
|
|
| date_next |
datetime
|
|
|
|
| comment |
text
|
utf8mb4_unicode_ci
|
|
|
| subscription_status_id |
int(11)
|
|
|
|
| language |
varchar(5)
|
utf8mb4_unicode_ci
|
|
|
| currency |
varchar(3)
|
utf8mb4_unicode_ci
|
|
|
| date_added |
datetime
|
|
|
|
| date_modified |
datetime
|
|
|
|
