Product table in SQL

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
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

  1. Student table in SQL
  2. Employee table in SQL
  3. Product table in SQL