Product Attribute Management
Button
*Back
*Refresh
*Add Attribute
*Delete
*Export - PDF, CSV, Excel, Docs
Product Attribute UI
(First Page)
- Search filter by attribute label
Add product attribute
Delete attribute
Export - PDF, CSV, Excel, Docs
Approve product attribute
(Second Page)
- Update save form
- Insert Attribute information
DB Table Attribute
| Column | Data Type | Comment |
|---|---|---|
| attribute_id | BIGINT default | |
| create_by | VARCHAR(50) | |
| create_time | TIMESTAMP | |
| update_by | VARCHAR(50) | |
| update_time | TIMESTAMP | |
| rec_state | INTEGER | |
| attribute_type | VARCHAR(50) | |
| attribute | VARCHAR(50) | |
| description | VARCHAR(1000) | |
| parent_attribute | VARCHAR(50) |
DB Table - Attribute Type
| Column | Data Type | Comment |
|---|---|---|
| type_id | BIGINT default | |
| create_by | VARCHAR(50) | |
| create_time | TIMESTAMP | |
| update_by | VARCHAR(50) | |
| update_time | TIMESTAMP | |
| rec_state | INTEGER | |
| attribute_type | VARCHAR(50) | |
| description | VARCHAR(1000) | |
| parent_attribute_type | VARCHAR(50) | |
| field_type | VARCHAR(50) | |
| editor_type | VARCHAR(50) | |
| editor_label | VARCHAR(1000) | |
| default_value | VARCHAR(1000) | |
| is_required | VARCHAR(1000) | |
| is_user_defined | BOOLEAN default false | |
| is_visible | BOOLEAN default false | |
| is_searchable | BOOLEAN default false | |
| is_filterable | BOOLEAN default false | |
| position _order | INTEGER default 0 |