Online ordering and inventory system

4.10 Data Dictionary

A data dictionary is a collection of descriptions of the data objects or items in a data model for the benefit of programmers and others who need to refer to them or the dictionary of data is at a time the pillar of work and the result of research and analysis of data. It is just like a depicted picture of the entire work. This dictionary of data defines all categories of data or data types, brief the all essential information about the software is included.

Table 2: Data dictionary

TABLE	FIELD	DESCRIPTION	TYPE	CONSTRAINTS
CUSTOMER	CustomerId	Identification of the customer	Varchar(15)	Primary key
	InvoiceId	Identification of the invoice	Int	Foreign key
	Username	Name of the customer	Varchar(14)	Not null
	Email	E-mail using	Varchar(15)	Not null
	Password	Customer password	Varchar(15)	Not null
	Phone	Phone of customer	Varchar(10)	Not null
	Regdate	Date of registration	Date	Null
	Adress	Adress of customer	Varchar(15)	Null
PRODUCT	ProductId	Identification of product	Varchar(10)	Primary Key
	Prodcategory	Category of product	Varchar(15)	Not null
	Prodname	Name of product	Varchar(15)	Not null
	Productdescription	Description of product	Varchar(15)	Null
	Price	Price of product	Varchar(15)	Not null
	Image	Image of product	Varchar(15)	Null
INVOICE	InvoiceId	Identification of invoice	Varchar(15)	Primary Key
	ProductId	Identification of the product	Varchar(15)	Foreign Key
	Quantity	Quantity of product	Varchar(15)	Not null
	Date	Time of writing an invoice	Date	Not null
	Unitprice	Price of product	Varchar(15)	Not null
	Pricetotal	Amount of product	Varchar(15)	Not null
ORDER	OrderId	Identification of order	Varchar(15)	Primary Key
	ProductId	Identification of the product	Varchar(15)	Foreign Key
	Orderdate	Date of order	Date	Not null
	Customername	Name of customer	Varchar(15)	Not null
	Quantity	Quantity	Int	Not null
	Productname	Name of product	Varchar(15)	Not null
	Companyname	Name of company	Varchar(15)	Not null
	Deliverydate	Date of delivery product	Date	Not null
STOCK	Codestock	Identification of stock	Varchar(15)	Primary Key
	ProductId	Identification of product	Varchar(20)	Foreign Key
	Regdate	Date of registration	Date	Not null
	Quantity	Quantity	Int	null
DELIVERY	DeliveryId	Identification of delivery	Varchar(15)	Not null
	Product	Product	Varchar(15)	null
	Quantity	Quantity of product	Int	Null
	Customer	Description of product	Varchar(15)	Null
	Datereceivable	Date of receivable	Date	Null
AUTORIZED STAFF	Id	Identification of product	Varchar(15)	Null
	Name	Name of authorized staff	Varchar(15)	Null
	Address	Address of person	Varchar(15)	null
	Companyname	Name of company	Varchar(15)	null
MAKE	Customerid	Identification of customer	Int	Not null
	Orderid	Identification of order	Int	Not null
	Product	product	Varchar(15)	null
PAY	Customerid	Identification of customer	Varchar(15)	Not null
	Invoiceid	Identification of invoice	Varchar(15)	Not null
	Prodid	product	Int	Not null
HAS	Stockid	Stock	Int	Not null
	Productid	Product	Int	Not null
	Productname	Name of product	Varchar(15)	Not null
CONTAINS	Orderid	Identification of order	Int	Not null
	Deliveryid	Delivery	Int	Not null
	Date	Date	Date	Not null