Shopping Cart Tables

Book_Details Field Name BookId CategoryID Title Author Publisher Edition Price Quantity Description

Data Type number(5), primary key number(5), foreign key varchar2(50) varchar2(30) varchar2(30) varchar2(5) number(7,2) number(3) varchar2(100)

Category_Details Field Name CategoryID CategoryName

Data Type number(5), primary key varchar2(30)

Order_Details Field Name OrderID BookID Quantity

Data Type number(5), foreign key number(5), foreign key number(3)

Temp_Details Field Name BookId CategoryID Title Author Publisher Edition Price Quantity Description

Data Type number(5) number(5) varchar2(50) varchar2(30) varchar2(30) varchar2(5) number(7,2) number(3) varchar2(100)

User_Auth Field Name UserName Password

Data Type varchar2(30), foreign key varchar2(15)

User_Profile Field Name UserName Password FirstName MiddleName LastName Address1 Address2 City State PinCode Email Phone

Data Type varchar2(30), varchar2(15), varchar2(10), varchar2(10) varchar2(10), varchar2(40), varchar2(40) varchar2(20), varchar2(20), varchar2(10), varchar2(25), varchar2(12),

primary key not null not null not null not null not not not not not

null null null null null

Order Table Field Name OrderID UserID TotalAmount OderDate

Data Type number(5), primary key number(5) number(12,2) varchar2(8)

Order_History Field Name OrderID BookID Date

Data Type number(5), foreign key number(5), foreign key varchar2(10)