Skip to content
Database t4tutorials
Table structure for table brands
| Column |
Type |
Null |
Default |
| id |
int(30) |
No |
|
| name |
varchar(250) |
No |
|
| description |
text |
Yes |
NULL |
| status |
tinyint(1) |
No |
1 |
Table structure for table cart
| Column |
Type |
Null |
Default |
| id |
int(30) |
No |
|
| client_id |
int(30) |
No |
|
| inventory_id |
int(30) |
No |
|
| price |
double |
No |
|
| quantity |
int(30) |
No |
|
| date_created |
datetime |
No |
current_timestamp() |
Product-table-in-SQL
Table structure for table categories
| Column |
Type |
Null |
Default |
| id |
int(30) |
No |
|
| category |
varchar(250) |
No |
|
| status |
tinyint(1) |
No |
1 |
| delete_flag |
tinyint(1) |
No |
0 |
Table structure for table clients
| Column |
Type |
Null |
Default |
| id |
int(30) |
No |
|
| firstname |
varchar(250) |
No |
|
| gender |
varchar(20) |
No |
|
| contact |
varchar(15) |
No |
|
| email |
varchar(250) |
No |
|
| password |
text |
No |
|
Table structure for table inventory
| Column |
Type |
Null |
Default |
| id |
int(30) |
No |
|
| product_id |
int(30) |
No |
|
| quantity |
double |
No |
|
| price |
float |
No |
|
Dumping data for table inventory
| 1 |
1 |
10 |
155 |
| 2 |
1 |
5 |
200 |
| 3 |
1 |
10 |
1055.58 |
| 4 |
3 |
25 |
250 |
| 5 |
3 |
25 |
300 |
| 6 |
4 |
100 |
350 |
Table structure for table orders
| Column |
Type |
Null |
Default |
| id |
int(30) |
No |
|
| ref_code |
varchar(100) |
No |
|
| client_id |
int(30) |
No |
|
| delivery_address |
text |
No |
|
| payment_method |
varchar(100) |
No |
|
| amount |
double |
No |
|
| status |
tinyint(2) |
No |
0 |
| paid |
tinyint(1) |
No |
0 |
Table structure for table order_list
| Column |
Type |
Null |
Default |
| id |
int(30) |
No |
|
| order_id |
int(30) |
No |
|
| inventory_id |
int(30) |
No |
|
| quantity |
int(30) |
No |
|
| price |
double |
No |
|
| total |
double |
No |
|
Table structure for table products
| Column |
Type |
Null |
Default |
| id |
int(30) |
No |
|
| brand_id |
int(30) |
No |
|
| category_id |
int(30) |
No |
|
| name |
varchar(250) |
No |
|
| status |
tinyint(1) |
No |
1 |
Table structure for table sales
| Column |
Type |
Null |
Default |
| id |
int(30) |
No |
|
| order_id |
int(30) |
No |
|
| amount |
double |
No |
|
| date_created |
datetime |
No |
current_timestamp() |
Table structure for table users
| Column |
Type |
Null |
Default |
| id |
int(50) |
No |
|
| name |
varchar(250) |
No |
|
| username |
text |
No |
|
| password |
text |
No |
|
Database tables in SQL
- Student table in SQL
- Employee table in SQL
- Product table in SQL
