TABLE DESCRIPTION
1.table Name: Login
FIELD DATATYPE DESCRIPTION CONSTRAINTS
Login_id Int(12) Unique id of login Primary key
Username Varchar(20) User name Not null
Password Varchar(20) Password Not null
Usertype Varchar(20) User type Not null
2.Table Name: Staff
FIELD DATATYPE DESCRIPTION CONSTRAINTS
Staff_id Int(12) Unique id of staff Primary key
Login_id Int(12) Unique id of login Foreign key
Name Varchar(20) Name of staff Not null
Age Int(10) Age of staff Not null
Gender Varchar(10) Gender of staff Not null
Phone Int(10) Phone.no of staff Not null
Email Varchar(30) Email of staff Not null
3.Table Name: User
FIELD DATATYPE DESCRIPTION CONSTRAINTS
User_id Int(12) Unique id of user Primary key
Login_id Int(12) Unique id of login Foreign key
Name Varchar(20) Name of user Not null
Phone Int(10) Phone.no of user Not null
Email Varchar(30) Email of user Not null
address Varchar(30) Address of user Not null
4.Table Name: Category
FIELD DATATYPE DESCRIPTION CONSTRAINTS
Cate_id Int(12) Unique id of Primary key
category
Category_name Varchar(20) Name of category Not null
5.Table Name: Product
FIELD DATATYPE DESCRIPTION CONSTRAINTS
Product_id Int(12) Unique id of product Primary key
Category_id Int(12) Category id of Foreign key
product
Pro_name Varchar(20) Name of product Not null
Size Int(12) Size of product Not null
price Int(20) Price of product Not null
6.Table Name: Stock
FIELD DATATYPE DESCRIPTION CONSTRAINTS
Stock_id Int(12) Unique id of stock Primary key
Product_id Int(12) Unique id of product Foreign key
Qty Int(12) Quantity of stock Not null
7.Table Name: Order_master
FIELD DATATYPE DESCRIPTION CONSTRAINTS
Omid Int(12) Unique id of oder Primary key
master
User_id Int(12) Unique id of user Foreign key
Total Int(20) Total price of stock Not null
Date Varchar(10) Date of order Not null
Status Varchar(20) Status of order Not null
8.Table Name: Order_details
FIELD DATATYPE DESCRIPTION CONSTRAINTS
Od_id Int(12) Unique id of order Primary key
details
Omid Int(12) Unique id of order Foreign key
master
Product_id Int(12) Unique id of product Foreign key
Qty Int(12) Quantity of order Not null
Amount Int(20) Amount of order Not null
9.Table Name: Payment
FIELD DATATYPE DESCRIPTION CONSTRAINTS
Payment_id Int(12) Unique id of Primary key
payment
Omid Int(12) Unique id of order Foreign key
master
Amount Int(20) Amount of order Not null
Date Varchar(20) Date of payment Not null
status Varchar(20) Status of payment Not null
10.Table Name: Complaint
FIELD DATATYPE DESCRIPTION CONSTRAINTS
Com_id Int(12) Unique id of Foreign key
complaint
User_id Int(12) Unique id of uer Foreign key
Complaint Varchar(20) Complaint of user Not null
Reply Varchar(20) Replay to user Not null
Date Varchar(20) Date of complaint Not null
11.Table Name: Salary
FIELD DATATYPE DESCRIPTION CONSTRAINTS
Salary_id Int(12) Unique id of salary Primary key
Staff_id Int(12) Unique id of staff Foreign key
Salary Int(20) Salary of staff Not null
Date Varchar(10) Date of salary Not null
Status Varchar(20) Status of Not null
attendance
