Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
---|---|---|---|---|---|---|
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 | 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() |
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | id | 0 | A | No |
Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
---|---|---|---|---|---|---|
id | int(11) | No | ||||
title | varchar(32) | No |
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 | ||||
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 |
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | id | 101524 | A | No | |
idx_tbl_attendance_date | BTREE | No | No | Date | 1046 | A | No | |
idx_tbl_attendance_pin_date | BTREE | No | No | PIN | 409 | A | Yes | |
CHECKTIME | 101524 | A | Yes | |||||
idx_tbl_attendance_checktype | BTREE | No | No | checktype | 8 | A | Yes |
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | id | 9 | A | No | |
idx_tbl_brands_status_title | BTREE | No | No | status | 1 | A | No | |
title | 9 | A | No | |||||
idx_tbl_brands_status | BTREE | No | No | status | 1 | A | No | |
idx_tbl_brands_title | BTREE | No | No | title | 9 | A | No |
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | id | 2103 | A | No | |
idx_tbl_calculations_id_emp | BTREE | No | No | id_emp | 525 | A | Yes | |
idx_tbl_calculations_post_date | BTREE | No | No | post_date | 40 | A | Yes |
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | id | 0 | A | No | |
idx_tbl_cashdetails_date | BTREE | No | No | Date | 0 | A | No |
Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
---|---|---|---|---|---|---|
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_title | BTREE | No | No | title | 5 | A | No |
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 | ||||
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 | 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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | id | 317 | A | No | |
idx_tbl_cus_payments_customer_id | BTREE | No | No | customer_id | 2 | A | No | |
idx_tbl_cus_payments_post_date | BTREE | No | No | post_date | 317 | A | No |
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | id | 1509 | A | No | |
idx_tbl_daily_cash_post_date | BTREE | No | No | post_date | 301 | A | No |
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | demand_id | 0 | A | No |
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | demand_id | 13195 | A | No | |
idx_tbl_demand_record_supplier | BTREE | No | No | supplier | 82 | A | No | |
idx_tbl_demand_record_post_date | BTREE | No | No | post_date | 388 | A | No |
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | id | 272 | A | No | |
idx_tbl_employees_id_emp | BTREE | No | No | id_emp | 272 | A | No | |
idx_tbl_employees_branch | BTREE | No | No | branch | 4 | A | No | |
idx_tbl_employees_post_date | BTREE | No | No | post_date | 136 | A | No |
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 |
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 | 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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | id | 182 | A | No |
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 |
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 | 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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | id | 825 | A | No | |
idx_status | BTREE | No | No | status | 2 | A | No | |
idx_id | BTREE | No | No | id | 825 | A | No | |
idx_tbl_items_status | BTREE | No | No | status | 2 | A | No | |
idx_tbl_items_status_id | BTREE | No | No | status | 2 | A | No | |
id | 825 | A | No | |||||
idx_tbl_items_category_id | BTREE | No | No | category_id | 33 | A | No | |
idx_tbl_items_supplier | BTREE | No | No | supplier | 117 | A | No | |
idx_tbl_items_price | BTREE | No | No | price | 825 | A | No |
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | id | 16 | 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 | 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 |
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 | 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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | id | 0 | A | No |
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() |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | id | 257 | A | No | |
idx_tbl_points_id_emp | BTREE | No | No | id_emp | 257 | A | Yes |
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | id | 3 | A | No | |
idx_tbl_products_category_id | BTREE | No | No | category_id | 3 | A | No | |
idx_tbl_products_brand_id | BTREE | No | No | brand_id | 3 | A | No |
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | id | 3 | A | No |
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | id | 10 | A | No |
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | id_no | 5248 | A | No | |
idx_tbl_purchases_supplier_id | BTREE | No | No | supplier_id | 99 | A | No | |
idx_tbl_purchases_post_date | BTREE | No | No | post_date | 228 | A | No |
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | id | 10100 | A | No | |
idx_tbl_pur_items_supplier_id | BTREE | No | No | supplier_id | 190 | A | No | |
idx_tbl_pur_items_post_date | BTREE | No | No | post_date | 404 | A | No |
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | id | 3923 | A | No |
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | reward_point_id | 0 | A | No |
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | id | 203 | A | No |
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | id | 201 | A | No | |
idx_tbl_sales_items_product_id | BTREE | No | No | product_id | 6 | A | No | |
idx_tbl_sales_items_post_date | BTREE | No | No | post_date | 201 | A | No |
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 |
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 | 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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | id | 4 | A | No |
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() |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | id | 0 | A | No |
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | id | 0 | A | No |
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | id | 419 | A | No |
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | id | 11697 | A | No | |
idx_tbl_stock_dairy_product_id_balance | BTREE | No | No | product_id | 688 | A | No | |
balance_quantity | 11697 | A | No | |||||
balance_cost | 11697 | A | No | |||||
idx_tbl_stock_dairy_product_id | BTREE | No | No | product_id | 688 | A | No | |
idx_tbl_stock_dairy_post_date | BTREE | No | No | post_date | 229 | A | No |
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 | ||||
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | id | 106 | A | No | |
title | BTREE | Yes | No | title | 106 | A | No | |
idx_tbl_suppliers_status_name | BTREE | No | No | status | 2 | A | No | |
name | 106 | A | No | |||||
idx_tbl_suppliers_status | BTREE | No | No | status | 2 | A | No | |
idx_tbl_suppliers_title | BTREE | No | No | title | 106 | A | No |
Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
---|---|---|---|---|---|---|
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 |
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | id | 13894 | A | No | |
idx_tbl_sup_payments_supplier_id | BTREE | No | No | supplier_id | 195 | A | No | |
idx_tbl_sup_payments_post_date | BTREE | No | No | post_date | 448 | A | No |
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | id | 1 | A | No |
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | id | 0 | A | No |
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 |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | id | 0 | A | No |
Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
---|---|---|---|---|---|---|
id (Primary) | int(11) | No | ||||
title | varchar(32) | No |
Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
---|---|---|---|---|---|---|---|---|
PRIMARY | BTREE | Yes | No | id | 53 | A | No | |
idx_tbl_units_title | BTREE | No | No | id | A | No |