cafelahore
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 | bigint(20) | No | ||
| designation | text | No | ||
| salary_per_month | decimal(10,0) | No | ||
| post_date | timestamp | No | current_timestamp() |
purchaser_details
| Column | Type | Null | Default | 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 | 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 |
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 | 187236 | A | No | |
| idx_tbl_attendance_date | BTREE | No | No | Date | 1185 | A | No | |
| idx_tbl_attendance_pin_date | BTREE | No | No | PIN | 462 | A | Yes | |
| CHECKTIME | 187236 | 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 | 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 |
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 | 2553 | A | No | |
| idx_tbl_calculations_id_emp | BTREE | No | No | id_emp | 510 | A | Yes | |
| idx_tbl_calculations_post_date | BTREE | No | No | post_date | 46 | 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 | 0 | A | No | |
| idx_tbl_cashdetails_date | BTREE | No | No | Date | 0 | 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_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 | 581 | 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 | 581 | 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 | 2137 | A | No | |
| idx_tbl_daily_cash_post_date | BTREE | No | No | post_date | 534 | 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 | 0 | 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 | 18285 | A | No | |
| idx_tbl_demand_record_supplier | BTREE | No | No | supplier | 86 | A | No | |
| idx_tbl_demand_record_post_date | BTREE | No | No | post_date | 494 | 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 | 300 | A | No | |
| idx_tbl_employees_id_emp | BTREE | No | No | id_emp | 300 | A | No | |
| idx_tbl_employees_branch | BTREE | No | No | branch | 4 | A | No | |
| idx_tbl_employees_post_date | BTREE | No | No | post_date | 300 | 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 | 251 | 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 | 978 | A | No | |
| idx_status | BTREE | No | No | status | 2 | A | No | |
| idx_id | BTREE | No | No | id | 978 | 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 | 978 | A | No | |||||
| idx_tbl_items_category_id | BTREE | No | No | category_id | 32 | A | No | |
| idx_tbl_items_supplier | BTREE | No | No | supplier | 122 | A | No | |
| idx_tbl_items_price | BTREE | No | No | price | 978 | 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 | 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 |
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 | 0 | A | No | |
| idx_tbl_leaves_use_leave_id | BTREE | No | No | Leave_id | 0 | 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 | 1219 | A | No | |
| idx_tbl_points_id_emp | BTREE | No | No | id_emp | 174 | 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 | 4 | A | No | |
| idx_tbl_products_category_id | BTREE | No | No | category_id | 4 | 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 | 11 | 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 | 6722 | 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 | 336 | 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 | 13424 | A | No | |
| idx_tbl_pur_items_supplier_id | BTREE | No | No | supplier_id | 200 | A | No | |
| idx_tbl_pur_items_post_date | BTREE | No | No | post_date | 559 | 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 | 3916 | 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 | 322 | 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 | 282 | 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 | 282 | 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 | |
| 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 | 0 | 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 | |
| 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 | 0 | 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 | 867 | 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 | 15535 | A | No | |
| idx_tbl_stock_dairy_product_id_balance | BTREE | No | No | product_id | 739 | A | No | |
| balance_quantity | 15535 | A | No | |||||
| balance_cost | 15535 | A | No | |||||
| idx_tbl_stock_dairy_product_id | BTREE | No | No | product_id | 739 | A | No | |
| idx_tbl_stock_dairy_post_date | BTREE | No | No | post_date | 330 | 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(200) | No | ||
| ProductTypeCode | varchar(200) | No | ||
| account | varchar(50) | No | ||
| phone | varchar(32) | No | ||
| city_id | int(16) | No | ||
| supcat | int(16) | No | ||
| address | varchar(500) | No | ||
| details | varchar(256) | No | ||
| post_date | date | No | ||
| post_time | time | No | ||
| status | tinyint(4) | No | ||
| last_updated | varchar(36) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 110 | A | No | |
| title | BTREE | Yes | No | title | 110 | A | No | |
| idx_tbl_suppliers_status_name | BTREE | No | No | status | 2 | A | No | |
| name | 110 | A | No | |||||
| idx_tbl_suppliers_status | BTREE | No | No | status | 2 | A | No | |
| idx_tbl_suppliers_title | BTREE | No | No | title | 110 | 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 | 16 | 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 | 17119 | A | No | |
| idx_tbl_sup_payments_supplier_id | BTREE | No | No | supplier_id | 199 | A | No | |
| idx_tbl_sup_payments_post_date | BTREE | No | No | post_date | 590 | 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 |
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 | 0 | 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 | 0 | 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 | 53 | A | No | |
| idx_tbl_units_title | BTREE | No | No | id | A | No |