TABLE

TABLE CATEGORY

                            
# Column Name Data Type Description
1 name
2 idCategory
3 description
4 createdAt
5 updatedAt
6 description
7 creation date
8 update date
Utility: Store the product category

TABLE INSTALLATION

Utility: Store the status of the installation
Useful to define is the installation was done

TABLE PRODUCT

                            
# Column Name Data Type Description
1 name String
2 idProduct Int
3 price Float
4 stock Int
5 video String
6 description String
7 createdAt Date
8 updatedAt Date
9 image String
10 idCategory Int
11 specification String
Table Utility: Store the product data

TABLE ORDER

                            
# Column Name Data Type Description
1 idOrder
2 name
3 email
4 phone
5 address
6 postcode
7 comment
8 payment
8 shipping
9 price
10 list_product
11 cart
12 createdAt
13 updatedAt
14 status
Utility: Store the order data

TABLE USER

                            
# Column Name Data Type Description
1 name
2 email
3 password
4 permission
5 createdAt
6 updatedAt
Utility: Store the User data

TABLE SESSION

Utility: Store the session data of user during navigation