cafelahore

customer_types

Column Type Null Default Links to Comments Media (MIME) type
type_id (Primary) int(11) No
title varchar(64) No

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNotype_id0ANo
idx_customer_types_type_idBTREENoNotype_id0ANo

designation

Column Type Null Default Links to Comments Media (MIME) type
id bigint(20) No
designation text No
salary_per_month decimal(10,0) No
post_date timestamp No current_timestamp()

purchaser_details

Column Type Null Default Links to Comments Media (MIME) type
id (Primary) int(200) No
post_date date No
other_sources int(200) No
today_bills int(200) No
previous_bill int(200) No

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid0ANo

stock_dairy_types

Column Type Null Default Links to Comments Media (MIME) type
id int(11) No
title varchar(32) No

tbl_admin

Column Type Null Default Links to Comments Media (MIME) type
id int(12) No
type tinyint(4) No
user_name varchar(64) No
pword varchar(100) No
name varchar(100) No
email varchar(64) No
phone varchar(20) No
address varchar(256) No
time_stamp timestamp No current_timestamp()
status tinyint(4) No
post_date datetime No
post_time time No
last_updated varchar(36) No

tbl_attendance

Column Type Null Default Links to Comments Media (MIME) type
id (Primary) int(11) No
Name varchar(50) Yes NULL
PIN int(11) Yes NULL
CHECKTIME varchar(50) Yes NULL
checktype varchar(50) Yes NULL
Date date No

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid101524ANo
idx_tbl_attendance_dateBTREENoNoDate1046ANo
idx_tbl_attendance_pin_dateBTREENoNoPIN409AYes
CHECKTIME101524AYes
idx_tbl_attendance_checktypeBTREENoNochecktype8AYes

tbl_brands

Column Type Null Default Links to Comments Media (MIME) type
id (Primary) int(11) No
title varchar(128) No
post_date date No
post_time time No
status tinyint(4) No
last_updated varchar(36) No

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid9ANo
idx_tbl_brands_status_titleBTREENoNostatus1ANo
title9ANo
idx_tbl_brands_statusBTREENoNostatus1ANo
idx_tbl_brands_titleBTREENoNotitle9ANo

tbl_calculations

Column Type Null Default Links to Comments Media (MIME) type
id (Primary) int(11) No
id_emp varchar(255) Yes NULL
Employee varchar(255) Yes NULL
Designation varchar(255) Yes NULL
Salary varchar(255) Yes NULL
Previous_reserved int(50) No
Worked varchar(255) Yes NULL
Mis_Count varchar(255) Yes NULL
Get_Previous varchar(255) Yes NULL
Annual varchar(255) Yes NULL
public_holidays varchar(255) Yes NULL
Lieu_Avail_In_Month varchar(255) Yes NULL
Payable_Days varchar(255) Yes NULL
cut_days decimal(20,0) No
Now_reserved int(20) No
Total_reserved int(50) No
Bonus varchar(255) Yes NULL
Earned_Bonus varchar(255) Yes NULL
OverTime int(20) No
Advance varchar(255) Yes NULL
Payable varchar(255) Yes NULL
post_date date Yes NULL
branch varchar(50) No
cell varchar(50) Yes NULL
bank_transfer_option varchar(10) No
title_name varchar(50) No
bank_name varchar(200) No
account_number varchar(200) Yes NULL
status int(50) No

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid2103ANo
idx_tbl_calculations_id_empBTREENoNoid_emp525AYes
idx_tbl_calculations_post_dateBTREENoNopost_date40AYes

tbl_cashdetails

Column Type Null Default Links to Comments Media (MIME) type
id (Primary) int(200) No
Date date No
received_amount int(200) No
given_amount int(200) Yes NULL
handover_person varchar(1200) No
remark varchar(12000) No

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid0ANo
idx_tbl_cashdetails_dateBTREENoNoDate0ANo

tbl_cities

Column Type Null Default Links to Comments Media (MIME) type
id (Primary) int(11) No
title varchar(64) No
status tinyint(4) No

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid5ANo
titleBTREEYesNotitle5ANo
idx_tbl_cities_titleBTREENoNotitle5ANo

tbl_customers

Column Type Null Default Links to Comments Media (MIME) type
id (Primary) int(11) No
type_id int(11) No 1
title varchar(128) No
email varchar(64) No
phone varchar(32) No
city_id int(16) No
address varchar(500) No
post_date date No
post_time time No
status tinyint(4) No
last_updated varchar(36) No

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid0ANo
titleBTREEYesNotitle0ANo
idx_tbl_customers_city_idBTREENoNocity_id0ANo
idx_tbl_customers_post_dateBTREENoNopost_date0ANo

tbl_cus_payments

Column Type Null Default Links to Comments Media (MIME) type
id (Primary) int(11) No
customer_id int(11) No
dr decimal(10,2) No
cr decimal(10,2) No
balance decimal(10,2) No
description varchar(500) No
post_date date No
post_time time No
status tinyint(4) No
last_updated varchar(36) No

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid316ANo
idx_tbl_cus_payments_customer_idBTREENoNocustomer_id2ANo
idx_tbl_cus_payments_post_dateBTREENoNopost_date316ANo

tbl_daily_cash

Column Type Null Default Links to Comments Media (MIME) type
id (Primary) int(11) No
description varchar(500) No
dr decimal(10,2) No
cr decimal(10,2) No
balance decimal(10,2) No
month varchar(2) No
year varchar(4) No
post_date date No
post_time time No
status tinyint(4) No
last_updated varchar(36) No

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid1508ANo
idx_tbl_daily_cash_post_dateBTREENoNopost_date301ANo

tbl_daily_closing

Column Type Null Default Links to Comments Media (MIME) type
demand_id (Primary) int(11) No
id int(11) No
supplier varchar(50) No
title varchar(128) No
brand_id int(11) No
unit int(11) No
available decimal(10,0) No
quantity decimal(10,0) Yes NULL
post_date date No
post_time time No
status tinyint(4) No
Vendor varchar(50) No
option varchar(50) No
vendor_note longtext No

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNodemand_id0ANo

tbl_demand_record

Column Type Null Default Links to Comments Media (MIME) type
demand_id (Primary) int(11) No
id int(11) No
supplier varchar(50) No
title varchar(128) No
brand_id int(11) No
unit int(11) No
available decimal(10,0) No
quantity decimal(10,2) Yes NULL
post_date date No
post_time time No
status tinyint(4) No
Vendor varchar(50) No
option varchar(50) No
vendor_note longtext No
DemandDate date No
RecDate date No

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNodemand_id13195ANo
idx_tbl_demand_record_supplierBTREENoNosupplier82ANo
idx_tbl_demand_record_post_dateBTREENoNopost_date388ANo

tbl_employees

Column Type Null Default Links to Comments Media (MIME) type
id (Primary) int(11) No
id_emp int(11) No
name varchar(100) Yes NULL
house varchar(50) Yes NULL
designation varchar(50) Yes NULL
cell varchar(15) Yes NULL
id_card varchar(200) Yes NULL
salary_per_month decimal(10,2) Yes NULL
emergency_contact varchar(15) Yes NULL
date_of_birth date Yes NULL
gender varchar(10) Yes NULL
marital_status varchar(20) Yes NULL
current_address varchar(255) Yes NULL
point varchar(10) Yes NULL
joining_date date Yes NULL
bank_transfer_option varchar(10) Yes NULL
title_name varchar(100) Yes NULL
BeneficiaryBankCode int(11) No
ProductTypeCode varchar(200) No
bank_name varchar(100) Yes NULL
account_number varchar(50) Yes NULL
uniform_info varchar(100) Yes NULL
status varchar(20) Yes NULL
branch varchar(200) No
post_date date No
hous varchar(100) No

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid272ANo
idx_tbl_employees_id_empBTREENoNoid_emp272ANo
idx_tbl_employees_branchBTREENoNobranch4ANo
idx_tbl_employees_post_dateBTREENoNopost_date136ANo

tbl_emp_payments

Column Type Null Default Links to Comments Media (MIME) type
id (Primary) int(11) No
category_id int(11) No
title varchar(128) No
dr decimal(10,2) No
cr decimal(10,2) No
details varchar(500) No
post_date date No
post_time time No
status tinyint(4) No
last_updated varchar(36) No

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid0ANo
idx_tbl_emp_payments_post_dateBTREENoNopost_date0ANo

tbl_expenses

Column Type Null Default Links to Comments Media (MIME) type
id (Primary) int(11) No
category_id int(11) No
title varchar(128) No
dr decimal(10,2) No
locker decimal(10,2) No
owner decimal(10,2) No
hr decimal(10,2) No
given decimal(10,2) No
till decimal(10,2) No
id_emp int(120) No
advance decimal(10,2) No
hand decimal(10,2) No
purchase decimal(10,2) No
tip decimal(10,2) No
details varchar(500) No
post_date date No
post_time time No
status tinyint(4) No
last_updated varchar(36) No

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid181ANo

tbl_exp_categories

Column Type Null Default Links to Comments Media (MIME) type
id (Primary) int(11) No
title varchar(128) No
post_date date No
post_time time No
status tinyint(4) No
last_updated varchar(36) No

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid0ANo
idx_tbl_exp_categories_titleBTREENoNotitle0ANo

tbl_items

Column Type Null Default Links to Comments Media (MIME) type
id (Primary) int(11) No
category_id int(20) No 1
Mini int(50) No
Max int(200) No
supplier varchar(50) No
title varchar(128) No
updated_Stock decimal(10,2) No
brand_id int(11) No 1
unit int(11) No
price float No
quantity decimal(10,2) No
post_date date No
post_time time No
last_updated varchar(36) No
status tinyint(4) No

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid825ANo
idx_statusBTREENoNostatus2ANo
idx_idBTREENoNoid825ANo
idx_tbl_items_statusBTREENoNostatus2ANo
idx_tbl_items_status_idBTREENoNostatus2ANo
id825ANo
idx_tbl_items_category_idBTREENoNocategory_id33ANo
idx_tbl_items_supplierBTREENoNosupplier117ANo
idx_tbl_items_priceBTREENoNoprice825ANo

tbl_items_cat

Column Type Null Default Links to Comments Media (MIME) type
id (Primary) int(200) No
title varchar(128) No
post_date date No
post_time time No
status tinyint(4) No
last_updated varchar(36) No

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid16ANo
idx_tbl_items_cat_statusBTREENoNostatusANo
idx_tbl_items_cat_status_titleBTREENoNostatusANo
titleANo
idx_tbl_items_cat_titleBTREENoNotitleANo

tbl_leaves_use

Column Type Null Default Links to Comments Media (MIME) type
id (Primary) int(11) No
Leave_id int(64) No
Get_Previous int(20) No
post_date date No
id_emp int(20) No

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid0ANo
idx_tbl_leaves_use_leave_idBTREENoNoLeave_id0ANo

tbl_notes

Column Type Null Default Links to Comments Media (MIME) type
id (Primary) int(11) No
details longtext No
post_date date No
post_time time No
status tinyint(4) No
last_updated varchar(36) No

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid0ANo

tbl_points

Column Type Null Default Links to Comments Media (MIME) type
id (Primary) int(11) No
id_emp int(11) Yes NULL
name varchar(255) Yes NULL
total_tip decimal(10,2) Yes NULL
status varchar(255) Yes NULL
post_date date No
Paid_Date timestamp No current_timestamp()

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid257ANo
idx_tbl_points_id_empBTREENoNoid_emp257AYes

tbl_products

Column Type Null Default Links to Comments Media (MIME) type
id (Primary) int(11) No
category_id int(11) No 1
title varchar(128) No
brand_id int(11) No 1
unit int(11) No
price decimal(10,2) No 0.00
total_order int(200) No
post_date date No
post_time time No
last_updated varchar(36) No
status tinyint(4) No

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid3ANo
idx_tbl_products_category_idBTREENoNocategory_id3ANo
idx_tbl_products_brand_idBTREENoNobrand_id3ANo

tbl_products_cat

Column Type Null Default Links to Comments Media (MIME) type
id (Primary) int(11) No
display_order tinyint(4) No
title varchar(128) No
post_date date No
post_time time No
status tinyint(4) No
last_updated varchar(36) No

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid3ANo

tbl_purchaser_details

Column Type Null Default Links to Comments Media (MIME) type
id (Primary) int(200) No
post_date date No
other_sources int(200) No
today_bills int(200) No
supplier_id int(200) No
previous_bill int(200) No
pending_bills int(200) No
remark varchar(500) No

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid10ANo

tbl_purchases

Column Type Null Default Links to Comments Media (MIME) type
id_no (Primary) int(200) No
id int(200) No
hash varchar(64) No
supplier_id int(11) No
cr decimal(20,0) No
dr decimal(20,0) No
details decimal(20,0) No
transport tinyint(4) No
type varchar(40) No
post_date date No
post_time time No
status tinyint(4) No
Method varchar(200) No
PaidBy varchar(200) No
last_updated varchar(36) No

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid_no5248ANo
idx_tbl_purchases_supplier_idBTREENoNosupplier_id99ANo
idx_tbl_purchases_post_dateBTREENoNopost_date228ANo

tbl_pur_items

Column Type Null Default Links to Comments Media (MIME) type
id (Primary) int(11) No
type tinyint(4) No
transport_type tinyint(4) No
bill_id int(11) No
category_id int(11) No
brand_id int(11) No
product_id int(11) No
unit int(11) No
supplier_id int(11) No
quantity decimal(10,3) No
supplier_cost decimal(10,2) No
transport_exp decimal(10,2) No
labor_exp decimal(10,2) No
unit_cost decimal(10,2) No
total_cost decimal(10,2) No
details varchar(500) No
purchase_date date No
post_date date No
post_time time No
status tinyint(4) No
remark varchar(500) No

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid10100ANo
idx_tbl_pur_items_supplier_idBTREENoNosupplier_id190ANo
idx_tbl_pur_items_post_dateBTREENoNopost_date404ANo

tbl_recipe

Column Type Null Default Links to Comments Media (MIME) type
id (Primary) int(16) No
product_id int(16) No
item_id int(16) No
item_qty float No
marge_product_id int(200) No

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid3923ANo

tbl_reward_points

Column Type Null Default Links to Comments Media (MIME) type
reward_point_id (Primary) int(11) No
customer_id int(11) No
sale_id int(11) No
amount_in decimal(10,2) No
amount_out decimal(10,2) No
post_date date No
post_time time No

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoreward_point_id0ANo

tbl_sales

Column Type Null Default Links to Comments Media (MIME) type
id (Primary) int(11) No
kot_no varchar(16) No
type tinyint(4) No
type_id int(11) Yes NULL
hash varchar(128) No
customer_id int(11) No
service_id int(16) No
grand_total int(16) No
amount_received decimal(10,2) No
total_amount decimal(10,2) No
tax_amount int(16) No
discount_percent decimal(10,2) No
discount decimal(10,2) No
delivery_charges decimal(10,2) No
service_charges_percent decimal(10,2) No
service_charges decimal(10,2) No
reward_discount decimal(10,2) No
details varchar(256) No
post_date date No
post_time time No
status tinyint(4) No
last_updated varchar(36) No

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid202ANo

tbl_sales_items

Column Type Null Default Links to Comments Media (MIME) type
id (Primary) int(11) No
type tinyint(4) No
customer_id int(11) No
service_id int(16) No
order_id int(11) No
category_id int(11) No
brand_id int(11) No
product_id int(11) No
unit_cost decimal(10,2) No
sale_price decimal(10,2) No
total_cost decimal(10,2) No
total_sale_price decimal(10,2) No
quantity_sold decimal(10,3) No
post_date date No
post_time time No
last_updated varchar(36) No
order_status int(11) No
status tinyint(4) No
kitchen_print tinyint(1) No 0
details varchar(1000) No

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid200ANo
idx_tbl_sales_items_product_idBTREENoNoproduct_id6ANo
idx_tbl_sales_items_post_dateBTREENoNopost_date200ANo

tbl_sale_services

Column Type Null Default Links to Comments Media (MIME) type
id (Primary) int(11) No
title varchar(128) No
post_date date No
post_time time No
status tinyint(4) No
last_updated varchar(36) No

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid1ANo
titleBTREEYesNotitle1ANo

tbl_section_sale

Column Type Null Default Links to Comments Media (MIME) type
id (Primary) int(200) No
section_id int(200) Yes NULL
section varchar(200) Yes NULL
amount int(200) Yes NULL
post_date date No

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid4ANo

tbl_services

Column Type Null Default Links to Comments Media (MIME) type
id (Primary) int(11) No
name varchar(255) Yes NULL
id_card bigint(20) Yes NULL
dob date Yes NULL
designation varchar(255) Yes NULL
salary decimal(10,2) Yes NULL
gender enum('Male', 'Female', 'Other') Yes NULL
cell varchar(15) Yes NULL
emergency varchar(15) Yes NULL
address text Yes NULL
joining_date date Yes NULL
Transfer_Option varchar(15) No
bank_name varchar(255) Yes NULL
account varchar(255) Yes NULL
title varchar(255) Yes NULL
status enum('Active', 'Inactive') Yes NULL
post_date timestamp No current_timestamp()

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid0ANo

tbl_services_calculations

Column Type Null Default Links to Comments Media (MIME) type
id (Primary) int(11) No
id_ser varchar(200) No
name varchar(255) Yes NULL
id_card bigint(20) Yes NULL
dob date Yes NULL
designation varchar(255) Yes NULL
salary decimal(10,2) Yes NULL
gender enum('Male', 'Female', 'Other') Yes NULL
cell varchar(15) Yes NULL
emergency varchar(15) Yes NULL
address text Yes NULL
joining_date date Yes NULL
Transfer_Option varchar(15) Yes NULL
bank_name varchar(255) Yes NULL
account varchar(255) Yes NULL
title varchar(255) Yes NULL
status enum('Active', 'Inactive') Yes NULL
post_date timestamp No current_timestamp()
action int(50) No

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid0ANo

tbl_staff_leaves

Column Type Null Default Links to Comments Media (MIME) type
id (Primary) int(11) No
id_emp int(11) Yes NULL
name varchar(255) Yes NULL
bonus decimal(10,2) Yes NULL
public int(11) Yes NULL
mis_count int(120) Yes NULL
reserved int(120) Yes NULL
OverTime int(50) No
annual int(120) Yes NULL
details varchar(120) Yes NULL
post_date date No
status tinyint(4) No
update_date date No

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid419ANo

tbl_stock_dairy

Column Type Null Default Links to Comments Media (MIME) type
id (Primary) int(11) No
type tinyint(4) No
product_id int(11) No
in_id int(11) No
out_id int(11) No
in_quantity decimal(10,3) No
in_cost decimal(10,2) No
out_quantity decimal(10,3) No
out_cost decimal(10,2) No
balance_quantity decimal(10,3) No
balance_cost decimal(10,2) No
post_date date No
post_time time No
status tinyint(4) No
description varchar(1000) No
last_updated varchar(36) No

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid11697ANo
idx_tbl_stock_dairy_product_id_balanceBTREENoNoproduct_id688ANo
balance_quantity11697ANo
balance_cost11697ANo
idx_tbl_stock_dairy_product_idBTREENoNoproduct_id688ANo
idx_tbl_stock_dairy_post_dateBTREENoNopost_date229ANo

tbl_suppliers

Column Type Null Default Links to Comments Media (MIME) type
id (Primary) int(11) No
title varchar(128) No
name varchar(64) No
FbrName text No
NTN int(200) No
email varchar(64) No
BeneficiaryBankCode int(200) No
ProductTypeCode varchar(200) No
account varchar(50) No
phone varchar(32) No
city_id int(16) No
supcat int(16) No
address varchar(500) No
details varchar(256) No
post_date date No
post_time time No
status tinyint(4) No
last_updated varchar(36) No

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid106ANo
titleBTREEYesNotitle106ANo
idx_tbl_suppliers_status_nameBTREENoNostatus2ANo
name106ANo
idx_tbl_suppliers_statusBTREENoNostatus2ANo
idx_tbl_suppliers_titleBTREENoNotitle106ANo

tbl_sup_cat

Column Type Null Default Links to Comments Media (MIME) type
id (Primary) int(11) No
title varchar(64) No
status tinyint(4) No

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid14ANo

tbl_sup_payments

Column Type Null Default Links to Comments Media (MIME) type
id (Primary) int(11) No
bill_id int(200) No
supplier_id int(11) No
dr decimal(10,2) No
cr decimal(10,2) No
balance decimal(10,2) No
description varchar(500) No
Method varchar(200) No
PaidBy varchar(200) No
post_date date No
post_time time No
status tinyint(4) No
last_updated varchar(36) No

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid13894ANo
idx_tbl_sup_payments_supplier_idBTREENoNosupplier_id195ANo
idx_tbl_sup_payments_post_dateBTREENoNopost_date448ANo

tbl_tmp_purchases

Column Type Null Default Links to Comments Media (MIME) type
id (Primary) int(11) No
post_date date No
post_time time No
hash varchar(64) No
supplier_id int(11) No
cr decimal(20,0) No
dr decimal(20,0) No
details decimal(20,0) No
transport decimal(20,0) No
type varchar(20) No
Method varchar(200) No
PaidBy varchar(200) No
time_stamp timestamp No current_timestamp()
status tinyint(4) No
last_updated varchar(36) No

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid1ANo

tbl_tmp_pur_items

Column Type Null Default Links to Comments Media (MIME) type
id (Primary) int(11) No
bill_id int(11) No
product_id int(11) No
supplier_cost decimal(10,2) No
transport_cost decimal(10,2) No
labor_cost decimal(10,2) No
quantity decimal(10,3) No
status tinyint(4) No
Method int(200) No
PaidBy int(200) No
remark varchar(500) No

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid0ANo

tbl_tmp_stock_items

Column Type Null Default Links to Comments Media (MIME) type
id (Primary) int(11) No
product_id int(11) No
Item varchar(200) No
quantity decimal(10,3) No
date date No
status tinyint(4) No

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid0ANo

tbl_units

Column Type Null Default Links to Comments Media (MIME) type
id (Primary) int(11) No
title varchar(32) No

Indexes

No index defined!
KeynameTypeUniquePackedColumnCardinalityCollationNullComment
PRIMARYBTREEYesNoid53ANo
idx_tbl_units_titleBTREENoNoidANo