Product table in SQL
By: Prof. Dr. Fazal Rehman | Last updated: February 3, 2024

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

Download the Product table in SQL

Database tables in SQL

Related Posts: