cafe
customer_types
| Column | Type | Null | Default | Comments |
|---|---|---|---|---|
| type_id (Primary) | int(11) | No | ||
| title | varchar(64) | No |
Indexes
| 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 |
designation
| 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() |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 0 | A | No |
purchaser_details
| 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 |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 1 | A | No |
stock_dairy_types
| Column | Type | Null | Default | Comments |
|---|---|---|---|---|
| id | int(11) | No | ||
| title | varchar(32) | No |
tbl_admin
| 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 |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 4 | A | No |
tbl_attendance
| 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 |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 143847 | A | No | |
| idx_tbl_attendance_date | BTREE | No | No | Date | 1160 | A | No | |
| idx_tbl_attendance_pin_date | BTREE | No | No | PIN | 499 | A | Yes | |
| CHECKTIME | 143847 | A | Yes | |||||
| idx_tbl_attendance_checktype | BTREE | No | No | checktype | 8 | A | Yes |
tbl_brands
| 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 |
Indexes
| 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 |
tbl_calculations
| 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 |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 2682 | A | No | |
| idx_tbl_calculations_id_emp | BTREE | No | No | id_emp | 536 | A | Yes | |
| idx_tbl_calculations_post_date | BTREE | No | No | post_date | 48 | A | Yes |
tbl_cashdetails
| 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 |
Indexes
| 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 |
tbl_cities
| Column | Type | Null | Default | Comments |
|---|---|---|---|---|
| id (Primary) | int(11) | No | ||
| title | varchar(64) | No | ||
| status | tinyint(4) | No |
Indexes
| 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 |
tbl_customers
| 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 |
Indexes
| 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 | |
| idx_tbl_customers_city_id | BTREE | No | No | city_id | 1 | A | No | |
| idx_tbl_customers_post_date | BTREE | No | No | post_date | 1 | A | No |
tbl_cus_payments
| 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 |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 642 | 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 | 642 | A | No |
tbl_daily_cash
| 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 |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 2925 | A | No | |
| idx_tbl_daily_cash_post_date | BTREE | No | No | post_date | 1462 | A | No |
tbl_daily_closing
| 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 |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | demand_id | 11 | A | No |
tbl_demand_record
| 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 |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | demand_id | 28709 | A | No | |
| idx_tbl_demand_record_supplier | BTREE | No | No | supplier | 84 | A | No | |
| idx_tbl_demand_record_post_date | BTREE | No | No | post_date | 736 | A | No | |
| idx_demandrecord_status_vendor_supplier_brand | BTREE | No | No | status | 4 | A | No | |
| Vendor | 6 | A | No | |||||
| supplier | 122 | A | No | |||||
| brand_id | 211 | A | No |
tbl_employees
| 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 |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 288 | A | No | |
| idx_tbl_employees_id_emp | BTREE | No | No | id_emp | 288 | A | No | |
| idx_tbl_employees_branch | BTREE | No | No | branch | 4 | A | No | |
| idx_tbl_employees_post_date | BTREE | No | No | post_date | 288 | A | No |
tbl_emp_payments
| 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 |
Indexes
| 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 |
tbl_expenses
| 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 |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 872 | A | No |
tbl_exp_categories
| 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 |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 1 | A | No | |
| idx_tbl_exp_categories_title | BTREE | No | No | title | 1 | A | No |
tbl_items
| 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 |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 930 | A | No | |
| idx_status | BTREE | No | No | status | 2 | A | No | |
| idx_id | BTREE | No | No | id | 930 | A | No | |
| idx_status_id | BTREE | No | No | status | 2 | A | No | |
| id | 930 | 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 | 930 | A | No | |||||
| idx_tbl_items_title | BTREE | No | No | title | 930 | A | No | |
| idx_tbl_items_category_id | BTREE | No | No | category_id | 34 | A | No | |
| idx_tbl_items_supplier | BTREE | No | No | supplier | 116 | A | No | |
| idx_tbl_items_price | BTREE | No | No | price | 930 | A | No |
tbl_items_cat
| 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 |
Indexes
| 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 | 1 | A | No | |
| idx_tbl_items_cat_status_title | BTREE | No | No | status | 1 | A | No | |
| title | 17 | A | No | |||||
| idx_tbl_items_cat_title | BTREE | No | No | title | 17 | A | No |
tbl_leaves_use
| 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 |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 1065 | A | No | |
| idx_tbl_leaves_use_leave_id | BTREE | No | No | Leave_id | 1065 | A | No |
tbl_notes
| 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 |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 0 | A | No |
tbl_points
| 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() |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 4873 | A | No | |
| idx_tbl_points_id_emp | BTREE | No | No | id_emp | 406 | A | Yes |
tbl_products
| 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 |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 470 | A | No | |
| idx_tbl_products_category_id | BTREE | No | No | category_id | 8 | A | No | |
| idx_tbl_products_brand_id | BTREE | No | No | brand_id | 2 | A | No |
tbl_products_cat
| 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 |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 3 | A | No |
tbl_purchaser_details
| 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 |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 2052 | A | No |
tbl_purchases
| 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 |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id_no | 14124 | A | No | |
| idx_tbl_purchases_status_supplier_id | BTREE | No | No | status | 1 | A | No | |
| supplier_id | 101 | A | No | |||||
| idx_tbl_purchases_id_cr_dr | BTREE | No | No | id | 14124 | A | No | |
| cr | 14124 | A | No | |||||
| dr | 14124 | A | No | |||||
| idx_tbl_purchases_supplier_id | BTREE | No | No | supplier_id | 101 | A | No | |
| idx_tbl_purchases_post_date | BTREE | No | No | post_date | 672 | A | No | |
| idx_purchases_supplier_id | BTREE | No | No | supplier_id | 101 | A | No |
tbl_pur_items
| 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 |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 28629 | A | No | |
| idx_tbl_pur_items_supplier_id_post_date | BTREE | No | No | supplier_id | 192 | A | No | |
| post_date | 28629 | A | No | |||||
| idx_tbl_pur_items_transport_exp | BTREE | No | No | transport_exp | 622 | A | No | |
| idx_tbl_pur_items_supplier_id | BTREE | No | No | supplier_id | 180 | A | No | |
| idx_tbl_pur_items_post_date | BTREE | No | No | post_date | 1244 | A | No |
tbl_recipe
| 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 |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 5337 | A | No |
tbl_reward_points
| 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 |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | reward_point_id | 0 | A | No |
tbl_sales
| 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 |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 691 | A | No |
tbl_sales_items
| 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 |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 660 | A | No | |
| idx_tbl_sales_items_product_id | BTREE | No | No | product_id | 8 | A | No | |
| idx_tbl_sales_items_post_date | BTREE | No | No | post_date | 660 | A | No |
tbl_sale_services
| 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 |
Indexes
| 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 |
tbl_section_sale
| 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 |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 4 | A | No |
tbl_services
| 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() |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 37 | A | No |
tbl_services_calculations
| 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 |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 531 | A | No |
tbl_staff_leaves
| 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 |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 2528 | A | No |
tbl_stock_dairy
| 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 |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 32660 | A | No | |
| idx_tbl_stock_dairy_product_id_balance | BTREE | No | No | product_id | 907 | A | No | |
| balance_quantity | 32660 | A | No | |||||
| balance_cost | 32660 | A | No | |||||
| idx_tbl_stock_dairy_product_id | BTREE | No | No | product_id | 907 | A | No | |
| idx_tbl_stock_dairy_post_date | BTREE | No | No | post_date | 653 | A | No |
tbl_suppliers
| 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 |
Indexes
| 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 |
tbl_sup_cat
| Column | Type | Null | Default | Comments |
|---|---|---|---|---|
| id (Primary) | int(11) | No | ||
| title | varchar(64) | No | ||
| status | tinyint(4) | No |
Indexes
| 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 |
tbl_sup_payments
| 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 |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 30894 | A | No | |
| idx_tbl_sup_payments_supplier_id_post_date | BTREE | No | No | supplier_id | 193 | A | No | |
| post_date | 30894 | A | No | |||||
| idx_tbl_sup_payments_cr_dr | BTREE | No | No | cr | 10298 | A | No | |
| dr | 15447 | A | No | |||||
| idx_tbl_sup_payments_supplier_id | BTREE | No | No | supplier_id | 193 | A | No | |
| idx_tbl_sup_payments_post_date | BTREE | No | No | post_date | 1235 | A | No |
tbl_tmp_purchases
| 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 |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 1 | A | No |
tbl_tmp_pur_items
| 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 |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 2 | A | No |
tbl_tmp_stock_items
| 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 |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 126 | A | No |
tbl_units
| Column | Type | Null | Default | Comments |
|---|---|---|---|---|
| id (Primary) | int(11) | No | ||
| title | varchar(32) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 63 | A | No | |
| idx_tbl_units_title | BTREE | No | No | id | 63 | A | No |