Category Management
Button
*Add Category
*Back
*Refesh
*Delete
*Export - PDF, CSV, Excel, DOCS
Category UI
(First Page) UI of Category Listing + Tree List
- Search category name and status
- update status (Approve)
- Delete category
- Add new category
(Second Page) UI Category Form
- Insert category info
- upload image
- update save form
DB Table Category
| Column | Data Type | Comment |
|---|---|---|
| category_id | BIGINT | Category idetifier number |
| create_by | VARCHAR(50) | Category created by a person |
| create_time | TIMESTAMP | Time create category |
| update_by | VARCHAR(50) | A person update category |
| update_time | TIMESTAMP | Update time of category |
| rec_state | INTEGER | Count status to prevent concurrency conflict |
| category | VARCHAR(50) | Product category |
| description | VARCHAR(1000) | Description of category |
| parent_category | BIGINT | First layer of categoy |
| state | VARCHAR(50) | Category state (A-Active, S-Suspend) |
| url_path | VARCHAR(1000) | Path of category |
| image_path | VARCHAR(1000) | Image path of category |
| meta_keywords | VARCHAR(1000) | Specific type of meta tag |
| meta_description | VARCHAR(1000) | Description of meta tag |
| meta_title | VARCHAR(1000) | Title of meta tag |
| name | VARCHAR(1000) | Category name |
| show_in_menu | BOOLEAN default false | Disply mode in menu |
| sort_order | INTEGER default 0 | Sorting out category |