| Property | View | Edit | Required | Storage Type | Default Value | Nullable |
|---|---|---|---|---|---|---|
| api_key_id | Owner | Owner | Yes | char | No | |
| bof_id | Owner | Owner | No | char | Yes | |
| checkout_date | Everyone | Read Only | No | datetime | No | |
| copyright_checked | Owner | Admin | No | tinyint | 0 | No |
| coupon_id | Everyone | Owner | No | char | Yes | |
| coupon_savings | Everyone | Read Only | No | float | 0 | No |
| crafter_points | Owner | Read Only | No | int | 0 | No |
| date_created | Everyone | Read Only | No | datetime | No | |
| date_updated | Everyone | Read Only | No | datetime | No | |
| defect_reported | Owner | Admin | No | int | 0 | No |
| downloaded | Owner | Admin | No | tinyint | 0 | No |
| generations | Owner | Admin | No | int | 1 | No |
| handling_fee | Owner | Read Only | No | float | 0 | No |
| id | Everyone | Read Only | No | char | No | |
| identity | Everyone | Read Only | No | varchar | Cart | No |
| in_production | Owner | Admin | No | tinyint | 0 | No |
| infinite_hold | Owner | Read Only | No | tinyint | 0 | No |
| insurance_cost | Owner | Read Only | No | float | 0 | No |
| insured | Owner | Owner | No | tinyint | 1 | No |
| ip_address | Owner | Read Only | No | varchar | Yes | |
| name | Everyone | Owner | No | varchar | Yes | |
| notes | Owner | Owner | No | mediumtext | Yes | |
| order_number | Everyone | Read Only | No | int | Yes | |
| original_estimated_ship_date | Everyone | Read Only | No | datetime | No | |
| packing_list | Owner | Read Only | No | mediumblob | Yes | |
| payment_message | Owner | Read Only | No | varchar | Yes | |
| payment_method | Owner | Read Only | No | varchar | Credit Card | Yes |
| payment_status | Owner | Read Only | No | varchar | Yes | |
| payment_transaction_id | Owner | Read Only | No | varchar | Yes | |
| po_number | Everyone | Owner | No | varchar | Yes | |
| production_time | Owner | Read Only | No | integer | Yes | |
| refunded | Owner | Admin | No | tinyint | 0 | No |
| refunded_amount | Owner | Read Only | No | float | 0 | No |
| refunded_to | Owner | Admin | No | varchar | No | |
| ship_date | Everyone | Read Only | No | datetime | No | |
| shipped | Owner | Admin | No | tinyint | 0 | No |
| shipping_address_id | Owner | Owner | No | char | Yes | |
| shipping_cost | Owner | Read Only | No | float | 0 | No |
| shipping_email | Owner | Owner | No | varchar | Yes | |
| shipping_method | Everyone | Owner | No | varchar | USPS Priority Mail | No |
| shipping_notes | Owner | Owner | No | mediumtext | Yes | |
| shop_credit_used | Owner | Read Only | No | float | 0 | No |
| start_production_date | Everyone | Read Only | No | datetime | No | |
| stripe_card_id | Owner | Owner | No | varchar | Yes | |
| taxes | Owner | Read Only | No | float | 0 | No |
| total | Everyone | Read Only | No | float | 0 | No |
| urgent | Owner | Read Only | No | tinyint | 0 | No |
| urgent_fee | Owner | Read Only | No | float | 0 | No |
| use_urgent_token | Owner | Read Only | No | tinyint | 0 | No |
| user_id | Owner | Admin | No | char | Yes |