jmeeuynz_digitalso
Tables users
| Field | Type | Default | Key | Action |
|---|---|---|---|---|
| id | int | NULL | PRI | |
| username | varchar(255) | NULL | ||
| slug | varchar(255) | NULL | ||
| varchar(255) | name@domain.com | |||
| email_status | tinyint(1) | NULL | ||
| token | varchar(500) | NULL | ||
| password | varchar(255) | NULL | ||
| role_id | smallint | 3 | ||
| balance | bigint | NULL | ||
| number_of_sales | int | NULL | ||
| user_type | varchar(20) | registered | ||
| facebook_id | varchar(255) | NULL | ||
| google_id | varchar(255) | NULL | ||
| vkontakte_id | varchar(255) | NULL | ||
| avatar | varchar(255) | NULL | ||
| cover_image | varchar(255) | NULL | ||
| cover_image_type | varchar(30) | full_width | ||
| banned | tinyint(1) | NULL | MUL | |
| first_name | varchar(100) | NULL | ||
| last_name | varchar(100) | NULL | ||
| about_me | varchar(5000) | NULL | ||
| phone_number | varchar(50) | NULL | ||
| country_id | int | NULL | MUL | |
| state_id | int | NULL | MUL | |
| city_id | int | NULL | MUL | |
| address | varchar(500) | NULL | ||
| zip_code | varchar(50) | NULL | ||
| show_email | tinyint(1) | NULL | ||
| show_phone | tinyint(1) | NULL | ||
| show_location | tinyint(1) | NULL | ||
| social_media_data | text | NULL | ||
| last_seen | timestamp | NULL | ||
| show_rss_feeds | tinyint(1) | NULL | ||
| send_email_new_message | tinyint(1) | NULL | ||
| is_active_shop_request | tinyint(1) | NULL | ||
| shop_request_reject_reason | text | NULL | ||
| shop_request_date | timestamp | NULL | ||
| vendor_documents | varchar(1000) | NULL | ||
| is_membership_plan_expired | tinyint(1) | NULL | MUL | |
| is_used_free_plan | tinyint(1) | NULL | ||
| cash_on_delivery | tinyint(1) | NULL | ||
| is_fixed_vat | tinyint(1) | NULL | ||
| fixed_vat_rate | double | NULL | ||
| vat_rates_data | text | NULL | ||
| vat_rates_data_state | text | NULL | ||
| is_affiliate | tinyint(1) | NULL | ||
| vendor_affiliate_status | tinyint(1) | NULL | ||
| affiliate_commission_rate | double | NULL | ||
| affiliate_discount_rate | double | NULL | ||
| tax_registration_number | varchar(255) | NULL | ||
| vacation_mode | tinyint(1) | NULL | MUL | |
| vacation_message | text | NULL | ||
| commission_debt | bigint | NULL | ||
| account_delete_req | tinyint(1) | NULL | ||
| account_delete_req_date | timestamp | NULL | ||
| created_at | timestamp | CURRENT_TIMESTAMP |