* POS | DbDesigner.net

category
Main Menu (south_indan,Punjabi) 1st phase Specialization (Items)
Table Name Table Comment Main Menu (south_indan,Punjabi) 1st phase Specialization (Items) Cancel Delete Table
	id	integer(30)
	name	varchar(190)
	nick_name	varchar(190)
	desc	varchar(190)
	img	varchar(190)
	company_id	integer
Add field Name Type Size Default Primary Key Allow nulls Unique Auto Increment Foreign Key Ref. Table Ref. Field Cancel

sub_category
Main Menu (Dosha,Pizza,) 2nd phase Specialization (Items)
Table Name Table Comment Main Menu (Dosha,Pizza,) 2nd phase Specialization (Items) Cancel Delete Table
	id	integer(30)
	category_id	integer(30)
	scat_name	integer(190)
	scat_nick_name	integer(190)
	scat_desc	varchar(190)
	scat_img	varchar(190)
	company_id	integer
Add field Name Type Size Default Primary Key Allow nulls Unique Auto Increment Foreign Key Ref. Table Ref. Field Cancel

Item
Main Menu (plain_dhosa, sada_dhosa,chees) 3nd phase Specialization (Items)
Table Name Table Comment Main Menu (plain_dhosa, sada_dhosa,chees) 3nd phase Specialization (Items) Cancel Delete Table
	id	integer(30)
	item_cat_id	integer
	item_name	varchar(190)
	item_price	varchar(190)
	item_stock	varchar(190)
	item_desc	varchar(190)
	item_img	varchar(190)
	company_id	integer
Add field Name Type Size Default Primary Key Allow nulls Unique Auto Increment Foreign Key Ref. Table Ref. Field Cancel

order_detail
Items That are in POS Table like pizza 2qty,20rs = 40rs dosha 10qty 3rs = 30rs OrderNumber Sagar0001 total 70
Table Name Table Comment Items That are in POS Table like pizza 2qty,20rs = 40rs dosha 10qty 3rs = 30rs OrderNumber Sagar0001 total 70 Cancel Delete Table
	id	integer
	table_id	integer
	item_id	integer
	item_qty	decimal
	time	timestamp
	note	varchar(190)
Add field Name Type Size Default Primary Key Allow nulls Unique Auto Increment Foreign Key Ref. Table Ref. Field Cancel

order

Table Name Table Comment Cancel Delete Table
	id	integer
	o_customer_id	integer
	o_order_detail_id	integer(10)
	o_date	timestamp
	o_status	varchar(30)
	o_paid	varchar(30)
	o_amount	decimal
	o_discount	decimal
	o_bill_printed	boolean
	o_type	varchar(40)
Add field Name Type Size Default Primary Key Allow nulls Unique Auto Increment Foreign Key Ref. Table Ref. Field Cancel

customer
Customers Details Customer Database and accounts and future use, offers and discounts
Table Name Table Comment Customers Details Customer Database and accounts and future use, offers and discounts Cancel Delete Table
	id	integer
	c_f_name	varchar(50)
	c_m_name	varchar(50)
	c_l_name	integer(50)
	c_mobile	varchar(30)
	c_mobile1	varchar(30)
	c_address	varchar(190)
	c_address1	varchar(190)
	c_city	varchar(50)
	c_pin_code	varchar(20)
	c_credit_limit	decimal(65)
Add field Name Type Size Default Primary Key Allow nulls Unique Auto Increment Foreign Key Ref. Table Ref. Field Cancel

table
Table Status occupied,HOld,Free Table_type= Take away, Home Delivery or WalkingCustomer
Table Name Table Comment Table Status occupied,HOld,Free Table_type= Take away, Home Delivery or WalkingCustomer Cancel Delete Table
	tbl_id	integer
	tbl_status	varchar(30)
	tbl_part	varchar(30)
	tbl_comment	varchar(190)
Add field Name Type Size Default Primary Key Allow nulls Unique Auto Increment Foreign Key Ref. Table Ref. Field Cancel

employees
Employees Details Name,DOB, Gender(eNum),hireDate,add,city,mobile,img,note
Table Name Table Comment Employees Details Name,DOB, Gender(eNum),hireDate,add,city,mobile,img,note Cancel Delete Table
	e_id	integer
	e_name	varchar(40)
	e_gender	integer
	e_birth_date	timestamp
	e_hire_date	timestamp
	e_position	varchar(40)
	e_add	varchar(190)
	e_mobile	integer(30)
	e_img	varchar(190)
	e_desc	varchar(190)
	e_depa_id	integer
	e_hour_rate	varchar(40)
	e_day_rate	decimal
	e_advance_limit	decimal(190)
Add field Name Type Size Default Primary Key Allow nulls Unique Auto Increment Foreign Key Ref. Table Ref. Field Cancel

department

Table Name Table Comment Cancel Delete Table
	depa_id	integer
	depa_name	varchar(40)
	depa_desc	varchar(190)
Add field Name Type Size Default Primary Key Allow nulls Unique Auto Increment Foreign Key Ref. Table Ref. Field Cancel

salary
working_days + Bonus - leave - Advance + Advance_received = Total payable Salary
Table Name Table Comment working_days + Bonus - leave - Advance + Advance_received = Total payable Salary Cancel Delete Table
	sal_id	integer
	sal_e_id	integer
	sal_from_date	timestamp
	sal_to_date	timestamp
	sal_paid	boolean
Add field Name Type Size Default Primary Key Allow nulls Unique Auto Increment Foreign Key Ref. Table Ref. Field Cancel

e_leave
Raja
Table Name Table Comment Raja Cancel Delete Table
	leave_id	integer
	leave_e_id	integer
	leave_from_date	timestamp
	leave_to_date	timestamp
	leave_reason	varchar(190)
	leave_total_days	integer
	leave_deduction	decimal(190)
Add field Name Type Size Default Primary Key Allow nulls Unique Auto Increment Foreign Key Ref. Table Ref. Field Cancel

shift
Shift id Shift Type, shift_start, shift_end, Shift time, Shift Desc
Table Name Table Comment Shift id Shift Type, shift_start, shift_end, Shift time, Shift Desc Cancel Delete Table
Add field Name Type Size Default Primary Key Allow nulls Unique Auto Increment Foreign Key Ref. Table Ref. Field Cancel

advance
Upad,date,rs,reason,return,return date, Advance return Date is Not null then advance return received
Table Name Table Comment Upad,date,rs,reason,return,return date, Advance return Date is Not null then advance return received Cancel Delete Table
	adv_id	integer
	adv_e_id	integer
	adv_rs	decimal(190)
	adv_date	timestamp
	adv_reason	decimal(190)
	adv_received	boolean
	adv_received_date	timestamp
Add field Name Type Size Default Primary Key Allow nulls Unique Auto Increment Foreign Key Ref. Table Ref. Field Cancel

bonus
Bonus Given by Manager or any occasion, Month of Bonus given
Table Name Table Comment Bonus Given by Manager or any occasion, Month of Bonus given Cancel Delete Table
	bns_id	integer
	bns_rs	decimal(190)
	bns_e_id	integer
	bns_month	varchar(40)
	bns_desc	varchar(190)
Add field Name Type Size Default Primary Key Allow nulls Unique Auto Increment Foreign Key Ref. Table Ref. Field Cancel

payment_method
Cash,Payple,Paytm,Debit \|\| Create crd, CardProvider (icic_visa,HDFC,Etc)
Table Name Table Comment Cash,Payple,Paytm,Debit \|\| Create crd, CardProvider (icic_visa,HDFC,Etc) Cancel Delete Table
	id	integer
	payment_type	varchar(190)
Add field Name Type Size Default Primary Key Allow nulls Unique Auto Increment Foreign Key Ref. Table Ref. Field Cancel

transition
Payment Details Customer id, Oder id , Payment Method FK Table id
Table Name Table Comment Payment Details Customer id, Oder id , Payment Method FK Table id Cancel Delete Table
	id	integer
	payment_method_id	integer
	order_id	integer
	amount	decimal(100)
	transition_date	timestamp
Add field Name Type Size Default Primary Key Allow nulls Unique Auto Increment Foreign Key Ref. Table Ref. Field Cancel

credit_master
CustoemrId, Order_id Paid, Pending, Total Amount,
Table Name Table Comment CustoemrId, Order_id Paid, Pending, Total Amount, Cancel Delete Table
	id	integer
	customer_id	integer
	order_id	integer
	paid_amout	decimal
	payment_date	timestamp
	transition_id	integer
	diff_amount	decimal(50)
Add field Name Type Size Default Primary Key Allow nulls Unique Auto Increment Foreign Key Ref. Table Ref. Field Cancel

company
Branch, Location Company_type = same Location or somewhare Else
Table Name Table Comment Branch, Location Company_type = same Location or somewhare Else Cancel Delete Table
	id	integer
	company_name	varchar(190)
	company_type	varchar(190)
Add field Name Type Size Default Primary Key Allow nulls Unique Auto Increment Foreign Key Ref. Table Ref. Field Cancel