| Field | Type | Null | Key | Default |
|---|---|---|---|---|
| user_id | int | NO | PRI | |
| first_name | varchar(255) | YES | ||
| last_name | varchar(255) | YES | ||
| user_authorize_id | varchar(255) | YES | ||
| app_token | varchar(16) | YES | ||
| user_title | varchar(255) | NO | ||
| user_email | varchar(255) | NO | ||
| user_gender | enum('m','f') | NO | ||
| user_profile | varchar(255) | NO | ||
| user_full_name | varchar(255) | NO | ||
| user_username | varchar(255) | NO | ||
| user_password | varchar(255) | NO | ||
| user_address_1 | varchar(255) | NO | ||
| user_address_2 | varchar(255) | NO | ||
| user_country | varchar(255) | NO | ||
| user_state | varchar(255) | NO | ||
| user_city | varchar(255) | NO | ||
| user_zip | varchar(255) | NO | ||
| user_phone | varchar(255) | NO | ||
| user_avatar | varchar(255) | NO | ||
| user_added | datetime | YES | ||
| user_modified | datetime | NO | 0000-00-00 00:00:00 | |
| user_status | enum('Active','Inactive','Deleted') | NO | Active | |
| user_confirmation | varchar(16) | YES | ||
| oauth_provider | varchar(20) | YES | ||
| oauth_id | varchar(255) | YES | ||
| user_phone_verified | tinyint(1) | YES | 0 | |
| stripe_customer_id | varchar(255) | YES |