Column | Type | Null | Default | Comments |
---|---|---|---|---|
type_id (Primary) | int(11) | No | ||
title | varchar(64) | No |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | type_id | 0 | A | No | |
idx_customer_types_type_id | BTREE | No | No | type_id | 0 | A | No |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
id (Primary) | bigint(20) | No | ||
designation | text | No | ||
salary_per_month | decimal(10,0) | No | ||
post_date | timestamp | No | current_timestamp() |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | id | 0 | A | No |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
id (Primary) | int(200) | No | ||
post_date | date | No | ||
other_sources | int(200) | No | ||
today_bills | int(200) | No | ||
previous_bill | int(200) | No |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | id | 0 | A | No |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
id | int(11) | No | ||
title | varchar(32) | No |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
id (Primary) | int(12) | No | ||
type | tinyint(4) | No | ||
user_name | varchar(64) | No | ||
pword | varchar(100) | No | ||
name | varchar(100) | No | ||
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | id | 4 | A | No |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | id | 0 | A | No | |
idx_tbl_attendance_date | BTREE | No | No | Date | 0 | A | No | |
idx_tbl_attendance_pin_date | BTREE | No | No | PIN | 0 | A | Yes | |
CHECKTIME | 0 | A | Yes | |||||
idx_tbl_attendance_checktype | BTREE | No | No | checktype | 0 | A | Yes |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | id | 11 | A | No | |
idx_tbl_brands_status_title | BTREE | No | No | status | A | No | ||
title | A | No | ||||||
idx_tbl_brands_status | BTREE | No | No | status | A | No | ||
idx_tbl_brands_title | BTREE | No | No | title | A | No |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | id | 0 | A | No | |
idx_tbl_calculations_id_emp | BTREE | No | No | id_emp | 0 | A | Yes | |
idx_tbl_calculations_post_date | BTREE | No | No | post_date | 0 | A | Yes |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | id | 9 | A | No | |
idx_tbl_cashdetails_date | BTREE | No | No | Date | 9 | A | No |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
id (Primary) | int(11) | No | ||
title | varchar(64) | No | ||
status | tinyint(4) | No |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | id | 5 | A | No | |
title | BTREE | Yes | No | title | 5 | A | No | |
idx_tbl_cities_status_title | BTREE | No | No | status | 2 | A | No | |
title | 5 | A | No | |||||
idx_tbl_cities_title | BTREE | No | No | title | 5 | A | No |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
id (Primary) | int(11) | No | ||
type_id | int(11) | No | 1 | |
title | varchar(128) | No | ||
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | id | 0 | A | No | |
title | BTREE | Yes | No | title | 0 | A | No | |
idx_tbl_customers_city_id | BTREE | No | No | city_id | 0 | A | No | |
idx_tbl_customers_post_date | BTREE | No | No | post_date | 0 | A | No |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | id | 0 | A | No | |
idx_tbl_cus_payments_customer_id | BTREE | No | No | customer_id | 0 | A | No | |
idx_tbl_cus_payments_post_date | BTREE | No | No | post_date | 0 | A | No |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | id | 2916 | A | No | |
idx_tbl_daily_cash_post_date | BTREE | No | No | post_date | 1458 | A | No |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | demand_id | 0 | A | No |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | demand_id | 0 | A | No | |
idx_tbl_demand_record_supplier | BTREE | No | No | supplier | 0 | A | No | |
idx_tbl_demand_record_post_date | BTREE | No | No | post_date | 0 | A | No | |
idx_demandrecord_status_vendor_supplier_brand | BTREE | No | No | status | 0 | A | No | |
Vendor | 0 | A | No | |||||
supplier | 0 | A | No | |||||
brand_id | 0 | A | No |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | id | 286 | A | No | |
idx_tbl_employees_id_emp | BTREE | No | No | id_emp | 286 | A | No | |
idx_tbl_employees_branch | BTREE | No | No | branch | 4 | A | No | |
idx_tbl_employees_post_date | BTREE | No | No | post_date | 286 | A | No |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | id | 0 | A | No | |
idx_tbl_emp_payments_post_date | BTREE | No | No | post_date | 0 | A | No |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | id | 0 | A | No |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | id | 0 | A | No | |
idx_tbl_exp_categories_title | BTREE | No | No | title | 0 | A | No |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | id | 0 | A | No | |
idx_status | BTREE | No | No | status | 0 | A | No | |
idx_id | BTREE | No | No | id | 0 | A | No | |
idx_status_id | BTREE | No | No | status | 0 | A | No | |
id | 0 | A | No | |||||
idx_tbl_items_status | BTREE | No | No | status | 0 | A | No | |
idx_tbl_items_status_id | BTREE | No | No | status | 0 | A | No | |
id | 0 | A | No | |||||
idx_tbl_items_title | BTREE | No | No | title | 0 | A | No | |
idx_tbl_items_category_id | BTREE | No | No | category_id | 0 | A | No | |
idx_tbl_items_supplier | BTREE | No | No | supplier | 0 | A | No | |
idx_tbl_items_price | BTREE | No | No | price | 0 | A | No |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | id | 17 | A | No | |
idx_tbl_items_cat_status | BTREE | No | No | status | A | No | ||
idx_tbl_items_cat_status_title | BTREE | No | No | status | A | No | ||
title | A | No | ||||||
idx_tbl_items_cat_title | BTREE | No | No | title | A | No |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
id (Primary) | int(11) | No | ||
Leave_id | int(64) | No | ||
Get_Previous | int(20) | No | ||
post_date | date | No | ||
id_emp | int(20) | No |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | id | 0 | A | No | |
idx_tbl_leaves_use_leave_id | BTREE | No | No | Leave_id | 0 | A | No |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | id | 0 | A | No |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
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() |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | id | 0 | A | No | |
idx_tbl_points_id_emp | BTREE | No | No | id_emp | 0 | A | Yes |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | id | 0 | A | No | |
idx_tbl_products_category_id | BTREE | No | No | category_id | 0 | A | No | |
idx_tbl_products_brand_id | BTREE | No | No | brand_id | 0 | A | No |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | id | 2 | A | No |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | id | 0 | A | No |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | id_no | 0 | A | No | |
idx_tbl_purchases_status_supplier_id | BTREE | No | No | status | A | No | ||
supplier_id | A | No | ||||||
idx_tbl_purchases_id_cr_dr | BTREE | No | No | id | A | No | ||
cr | A | No | ||||||
dr | A | No | ||||||
idx_tbl_purchases_supplier_id | BTREE | No | No | supplier_id | A | No | ||
idx_tbl_purchases_post_date | BTREE | No | No | post_date | A | No | ||
idx_purchases_supplier_id | BTREE | No | No | supplier_id | A | No |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | id | 0 | A | No | |
idx_tbl_pur_items_supplier_id_post_date | BTREE | No | No | supplier_id | 0 | A | No | |
post_date | 0 | A | No | |||||
idx_tbl_pur_items_transport_exp | BTREE | No | No | transport_exp | 0 | A | No | |
idx_tbl_pur_items_supplier_id | BTREE | No | No | supplier_id | 0 | A | No | |
idx_tbl_pur_items_post_date | BTREE | No | No | post_date | 0 | A | No |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | id | 0 | A | No |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | reward_point_id | 0 | A | No |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | id | 0 | A | No |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | id | 0 | A | No | |
idx_tbl_sales_items_product_id | BTREE | No | No | product_id | 0 | A | No | |
idx_tbl_sales_items_post_date | BTREE | No | No | post_date | 0 | A | No |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | id | 1 | A | No | |
title | BTREE | Yes | No | title | 1 | A | No |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | id | 4 | A | No |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
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 | |
branch | varchar(50) | No | ||
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() |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | id | 0 | A | No |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
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 | |
branch | varchar(50) | 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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | id | 0 | A | No |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | id | 0 | A | No |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | id | 0 | A | No | |
idx_tbl_stock_dairy_product_id_balance | BTREE | No | No | product_id | A | No | ||
balance_quantity | A | No | ||||||
balance_cost | A | No | ||||||
idx_tbl_stock_dairy_product_id | BTREE | No | No | product_id | A | No | ||
idx_tbl_stock_dairy_post_date | BTREE | No | No | post_date | A | No |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
id (Primary) | int(11) | No | ||
title | varchar(128) | No | ||
name | varchar(64) | No | ||
FbrName | text | No | ||
NTN | int(200) | No | ||
varchar(64) | No | |||
BeneficiaryBankCode | int(22) | 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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | id | 103 | A | No | |
title | BTREE | Yes | No | title | 103 | A | No | |
idx_tbl_suppliers_status_name | BTREE | No | No | status | 2 | A | No | |
name | 103 | A | No | |||||
idx_tbl_suppliers_status_id | BTREE | No | No | status | 2 | A | No | |
id | 103 | A | No | |||||
idx_tbl_suppliers_status | BTREE | No | No | status | 2 | A | No | |
idx_tbl_suppliers_title | BTREE | No | No | title | 103 | A | No |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
id (Primary) | int(11) | No | ||
title | varchar(64) | No | ||
status | tinyint(4) | No |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | id | 14 | A | No | |
idx_tbl_sup_cat_status_title | BTREE | No | No | status | 2 | A | No | |
title | 14 | A | No |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | id | 0 | A | No | |
idx_tbl_sup_payments_supplier_id_post_date | BTREE | No | No | supplier_id | 0 | A | No | |
post_date | 0 | A | No | |||||
idx_tbl_sup_payments_cr_dr | BTREE | No | No | cr | 0 | A | No | |
dr | 0 | A | No | |||||
idx_tbl_sup_payments_supplier_id | BTREE | No | No | supplier_id | 0 | A | No | |
idx_tbl_sup_payments_post_date | BTREE | No | No | post_date | 0 | A | No |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
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 | ||
remark | varchar(500) | No |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | id | 1 | A | No |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | id | 0 | A | No |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | id | 0 | A | No |
Column | Type | Null | Default | Comments |
---|---|---|---|---|
id (Primary) | int(11) | No | ||
title | varchar(32) | No |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | id | 60 | A | No | |
idx_tbl_units_title | BTREE | No | No | id | A | No |