Gift Details

Gift Details

5.2 DATA DICTIONARY

Table Name:    Admin

Description:     This table contains the Admin details.

SR. No	FIELD NAME	DATA TYPE	SIZE	CONSTRAINT	DESCRIPTION
1	Admin_ id	Int	5	Primary key	Admin id
2	Name	varchar	50	Not null	Name
3	Email	varchar	50	Not null	E-mail address
4	Password	Varchar	50	Not null	Password

                

Table Name:    Category

Description:     This table contains the category of product.

SR. No	FIELD NAME	DATA TYPE	SIZE	CONSTRAINT	DESCRIPTION
1	Category_id	int	5	Primary Key	Primary key
2	Name	Varchar	50	Not null	Category name
3	Admin_id	Varchar	50	Not null	Reference of admin

Table Name:    Product

Description:     This table contains details about product which user will shop from “Gift Shop” website.

SR. No	FIELD NAME	DATA TYPE	SIZE	CONSTRAINT	DESCRIPTION
1	Product_id	Int	5	Primary key	Product id
2	Name	Varchar	50	Not null	Product name
3	Photo	varchar	50	Not null	Product image
4	Details	Medium text		Not null	Details
5	Category_id	Int	5	Not null	Reference of category
6	Price	Int	5	Not null	Price

Table Name:    Add_to_cart

Description:     This table contains list of product which customers choose to purchase the product.

SR. No	FIELD NAME	DATA TYPE	SIZE	CONSTRAINT	DESCRIPTION
1	Cart_ id	Int	5	Primary key	Cart id
2	Product_id	Int	5	Not null	Reference product id
3	Register_id	Int	5	Not null	Reference register id
4	Qty	Int	5	Not null	Quantity
5	Total	Int	5	Not null	Total

Table Name:    Register

Description:     This table contains details about register users.

SR. No	FIELD NAME	DATA TYPE	SIZE	CONSTRAINT	DESCRIPTION
1	Register_id	Int	5	Primary key	Product id
2	Name	Varchar	50	Not null	Name
3	Gender	Varchar	10	Not null	Gender
4	E-mail	Varchar	50	Not null	E-mail address
5	Contact	Double	11	Not null	Contact
6	Password	Varchar	50	Not null	Password
7	Birthdate	Date		Not null	Date
8	City	Varchar	50	Not null	City

Table Name:    Order_master

Description:     This table contains Order master types and their prices.

SR. No	FIELD NAME	DATA TYPE	SIZE	CONSTRAINT	DESCRIPTION
1	O_id	Int	5	Primary key	Order id
2	O_date	Date		Not null	Order date
3	Product_id	Int	5	Not null	Ref of  Product id
4	Register_id	Int	5	Not null	Ref of Register id
5	Qty	Int	5	Not null	Qty
6	Total	Int	5	Not null	Total

Table Name:    Feedback

Description:     This table contains information of feedback which is given by customer for the product.

SR. No	FIELD NAME	DATA TYPE	SIZE	CONSTRAINT	DESCRIPTION
1	Feedback_id	Int	5	Primary key	Feedback id
2	Message	varchar	50	Not null	Message
3	Feedback_date	Date		Not null	Feedback date
4	Register_id	Int	5	Not null	Reference Register id
5	Email	Varchar	50	Primary key	E-mail address