User Properties
| Property | View | Edit | Required | Storage Type | Default Value | Nullable |
|---|
| admin | Owner | Admin | No | tinyint | 0 | No |
| approved_for_invoice | Owner | Admin | No | tinyint | 0 | No |
| avatar_id | Owner | Owner | No | char | | Yes |
| billing_cycle_per | Owner | Admin | No | varchar | order | No |
| bio | Everyone | Owner | No | mediumtext | | Yes |
| can_use_facebook_beacon | Owner | Owner | No | tinyint | 1 | No |
| can_use_google_analytics | Owner | Owner | No | tinyint | 1 | No |
| can_use_helpscout_beacon | Owner | Owner | No | tinyint | 1 | No |
| can_use_kiss_metrics | Owner | Owner | No | tinyint | 1 | No |
| can_use_pinterest_beacon | Owner | Owner | No | tinyint | 1 | No |
| concierge_manager | Owner | Admin | No | tinyint | 0 | No |
| copyright_violator | Owner | Admin | No | tinyint | 0 | No |
| crafter_points | Owner | Read Only | No | int | 0 | No |
| curator | Owner | Admin | No | tinyint | 0 | No |
| date_created | Everyone | Read Only | No | datetime | | No |
| date_updated | Everyone | Read Only | No | datetime | | No |
| default_address_id | Owner | Owner | No | char | | Yes |
| default_designer_id | Owner | Owner | No | char | | Yes |
| developer | Owner | Owner | No | tinyint | 0 | No |
| email | Owner | Owner | Yes | varchar | | Yes |
| email_diagnostics | Owner | Read Only | No | mediumblob | | Yes |
| exclude_gore | Owner | Owner | No | tinyint | 1 | No |
| exclude_nudity | Owner | Owner | No | tinyint | 1 | No |
| exclude_profanity | Owner | Owner | No | tinyint | 1 | No |
| exclude_sexuality | Owner | Owner | No | tinyint | 1 | No |
| exclude_substance_abuse | Owner | Owner | No | tinyint | 1 | No |
| facebook_token | Owner | Admin | No | varchar | | Yes |
| facebook_uid | Owner | Admin | No | bigint | | Yes |
| gift_cert_manager | Owner | Admin | No | tinyint | 0 | No |
| history_of_issues | Owner | Admin | No | tinyint | 0 | No |
| how_you_found_us | Owner | Owner | No | varchar | | No |
| id | Everyone | Read Only | No | char | | No |
| inventory_manager | Owner | Admin | No | tinyint | 0 | No |
| laboratory_manager | Owner | Admin | No | tinyint | 0 | No |
| last_ip | Owner | Read Only | No | varchar | | Yes |
| last_login | Owner | Read Only | No | datetime | | No |
| looney_labs | Owner | Admin | No | tinyint | 0 | No |
| maintenance_manager | Owner | Admin | No | tinyint | 0 | No |
| no_email | Owner | Owner | No | tinyint | 0 | No |
| no_pm | Everyone | Owner | No | tinyint | 0 | No |
| no_reminders | Everyone | Owner | No | tinyint | 0 | No |
| no_updates | Everyone | Owner | No | tinyint | 0 | No |
| order_manager | Owner | Admin | No | tinyint | 0 | No |
| payout_owed | Owner | Read Only | No | float | 0 | No |
| payout_threshold | Owner | Owner | No | float | 5 | No |
| payout_via | Owner | Owner | No | varchar | shop_credit | No |
| paypal_email | Owner | Owner | No | varchar | | Yes |
| perfectionist | Owner | Admin | No | tinyint | 0 | No |
| permanently_deactivated | Owner | Admin | No | tinyint | 0 | No |
| product_manager | Owner | Admin | No | tinyint | 0 | No |
| production_manager | Owner | Admin | No | tinyint | 0 | No |
| publisher | Owner | Admin | No | tinyint | 0 | No |
| publishing_manager | Owner | Admin | No | tinyint | 0 | No |
| real_name | Owner | Owner | No | varchar | | Yes |
| retailer | Owner | Admin | No | tinyint | 0 | No |
| root_folder_id | Owner | Read Only | No | char | | Yes |
| sanity_tester | Owner | Admin | No | tinyint | 0 | No |
| shipping_victim | Owner | Admin | No | tinyint | 0 | No |
| shop_credit | Owner | Read Only | No | float | 0 | No |
| staff_manager | Owner | Admin | No | tinyint | 0 | No |
| stats_manager | Owner | Admin | No | tinyint | 0 | No |
| stripe_customer_id | Owner | Owner | No | varchar | | Yes |
| urgent_tokens | Everyone | Owner | No | int | 0 | No |
| use_as_display_name | Owner | Owner | No | varchar | username | Yes |
| user_manager | Owner | Admin | No | tinyint | 0 | No |
| username | Owner | Owner | Yes | varchar | | No |
| vip | Owner | Admin | No | tinyint | 0 | No |
| wants_newsletter | Owner | Owner | No | tinyint | 1 | No |