| id |
char(36)
|
utf8mb4_general_ci
|
|
|
| name |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| date_entered |
datetime
|
|
|
|
| date_modified |
datetime
|
|
|
|
| modified_user_id |
char(36)
|
utf8mb4_general_ci
|
|
|
| created_by |
char(36)
|
utf8mb4_general_ci
|
|
|
| description |
text
|
utf8mb4_general_ci
|
|
|
| deleted |
tinyint(1)
|
|
|
|
| assigned_user_id |
char(36)
|
utf8mb4_general_ci
|
|
|
| maincode |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| part_number |
varchar(25)
|
utf8mb4_general_ci
|
|
|
| category |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| type |
varchar(100)
|
utf8mb4_general_ci
|
|
|
| cost |
decimal(26,6)
|
|
|
|
| cost_usdollar |
decimal(26,6)
|
|
|
|
| currency_id |
char(36)
|
utf8mb4_general_ci
|
|
|
| price |
decimal(26,6)
|
|
|
|
| price_usdollar |
decimal(26,6)
|
|
|
|
| url |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| contact_id |
char(36)
|
utf8mb4_general_ci
|
|
|
| product_image |
varchar(255)
|
utf8mb4_general_ci
|
|
|
| aos_product_category_id |
char(36)
|
utf8mb4_general_ci
|
|
|
