TABLE DESIGN
Table 1: Admin
Primarykey: Admin_id
SI no Field Datatype Constraints Description
1 id Int PRIMARY KEY Admin ID
2 Username Varchar (200) NOT_NULL Admin Name
3 Password Varchar (6) NOT_NULL Password
Table 2: Register
Primary key : Reg_id
SI no Field Datatype Constraints Descripti
on
1 id Int PRIMARY KEY User ID
2 nm Text NOT_NULL User Name
3 mob int NOT_NULL Phone
Number
3 email Varchar (200) NOT_NULL Email ID
4 pw Varchar (6) NOT_NULL Password
5 add Varchar(200) NOT_NULL Address
6 Sts Varchar(100) NOT_NULL Status
Table 3: Login
Primarykey: Login_id
SI no Field Datatype Constraints Description
1 id Int PRIMARY KEY User ID
2 Username Varchar (200) NOT_NULL User Name
3 Password Varchar (6) NOT_NULL Password
Table 4: Product
Primary key : Product_id
SI no Field Datatype Constraints Description
1 id Int PRIMARY KEY Product ID
2 productname Varchar(100) NOT_NULL Product Name
3 category Text NOT_NULL Product
Category
4 productprice Int NOT_NULL Product Price
5 productdescript Varchar(400) NOT_NULL Description
ion
6 Img Varchar(100) NOT_NULL Product Image
Table 5 : Orders
Primarykey :Order_id
SI no Field Datatype Constraints Description
1 id Int PRIMARY KEY Cart ID
2 orderno Int NOT_NULL Order ID
3 dt int NOT_NULL Order Details
4 userid Int NOT_NULL User ID
5 total Int NOT_NULL Order Quantity
6 paidsts Varchar(100) NOT_NULL Payment Status
7 sellid Varchar (50) NOT_NULL Seller ID
Table 6: Cart
Primary key : Cart_id
SI no Field Datatype Constraints Description
1 id Int PRIMARY KEY Order ID
2 pid Int NOT_NULL Product ID
3 uid Varchar(50) NOT_NULL User ID
4 qty Varchar(100) NOT_NULL Quantity
5 sts Varchar(100) NOT_NULL Status
6 rate Varchar(50) NOT_NULL Product Price
7 total Varchar(100) NOT_NULL Total Amount
8 orderno Varchar(100) NOT_NULL Order Number
9 store Int NOT_NULL
Table 2: Agency
Primary key : Agid
SI no Field Datatype Constraints Description
1 agid Int PRIMARY KEY Agency ID
2 name Text NOT_NULL User Name
3 add Text NOT_NULL Address
3 place Text NOT_NULL Place
4 phone Varchar (10) NOT_NULL Phone number
5 email Text NOT_NULL Email
6 pw Text NOT_NULL Password
7 status Int (11) NOT_NULL Status
Table : Bank
Primary key : Bid
SI no Field Datatype Constraints Description
1 bid Int(11) PRIMARY KEY Bank ID
2 bank text NOT_NULL Bank name
3 name Text NOT_NULL User Name
4 acno Text NOT_NULL Account
number
5 ifsc Text NOT_NULL IFSC Code
6 upi Text NOT_NULL UPI ID
7 userid int(11) NOT_NULL User ID
8 status Int (11) NOT_NULL Status
