cafelahore
customer_types
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| 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 | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id | bigint(20) | No | ||||
| designation | text | No | ||||
| salary_per_month | decimal(10,0) | No | ||||
| post_date | timestamp | No | current_timestamp() |
purchaser_details
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id (Primary) | int(200) | No | ||||
| post_date | date | No | ||||
| other_sources | int(200) | No | ||||
| today_bills | int(200) | No | ||||
| previous_bill | int(200) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 0 | A | No |
stock_dairy_types
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id | int(11) | No | ||||
| title | varchar(32) | No |
tbl_admin
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id | int(12) | No | ||||
| type | tinyint(4) | No | ||||
| user_name | varchar(64) | No | ||||
| pword | varchar(100) | No | ||||
| name | varchar(100) | No | ||||
| varchar(64) | No | |||||
| phone | varchar(20) | No | ||||
| address | varchar(256) | No | ||||
| time_stamp | timestamp | No | current_timestamp() | |||
| status | tinyint(4) | No | ||||
| post_date | datetime | No | ||||
| post_time | time | No | ||||
| last_updated | varchar(36) | No |
tbl_attendance
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id (Primary) | int(11) | No | ||||
| Name | varchar(50) | Yes | NULL | |||
| PIN | int(11) | Yes | NULL | |||
| CHECKTIME | varchar(50) | Yes | NULL | |||
| checktype | varchar(50) | Yes | NULL | |||
| Date | date | No |
Indexes
| 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 |
tbl_brands
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id (Primary) | int(11) | No | ||||
| title | varchar(128) | No | ||||
| post_date | date | No | ||||
| post_time | time | No | ||||
| status | tinyint(4) | No | ||||
| last_updated | varchar(36) | No |
Indexes
| 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 | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id (Primary) | int(11) | No | ||||
| id_emp | varchar(255) | Yes | NULL | |||
| Employee | varchar(255) | Yes | NULL | |||
| Designation | varchar(255) | Yes | NULL | |||
| Salary | varchar(255) | Yes | NULL | |||
| Previous_reserved | int(50) | No | ||||
| Worked | varchar(255) | Yes | NULL | |||
| Mis_Count | varchar(255) | Yes | NULL | |||
| Get_Previous | varchar(255) | Yes | NULL | |||
| Annual | varchar(255) | Yes | NULL | |||
| public_holidays | varchar(255) | Yes | NULL | |||
| Lieu_Avail_In_Month | varchar(255) | Yes | NULL | |||
| Payable_Days | varchar(255) | Yes | NULL | |||
| cut_days | decimal(20,0) | No | ||||
| Now_reserved | int(20) | No | ||||
| Total_reserved | int(50) | No | ||||
| Bonus | varchar(255) | Yes | NULL | |||
| Earned_Bonus | varchar(255) | Yes | NULL | |||
| OverTime | int(20) | No | ||||
| Advance | varchar(255) | Yes | NULL | |||
| Payable | varchar(255) | Yes | NULL | |||
| post_date | date | Yes | NULL | |||
| branch | varchar(50) | No | ||||
| cell | varchar(50) | Yes | NULL | |||
| bank_transfer_option | varchar(10) | No | ||||
| title_name | varchar(50) | No | ||||
| bank_name | varchar(200) | No | ||||
| account_number | varchar(200) | Yes | NULL | |||
| status | int(50) | No |
Indexes
| 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 |
tbl_cashdetails
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id (Primary) | int(200) | No | ||||
| Date | date | No | ||||
| received_amount | int(200) | No | ||||
| given_amount | int(200) | Yes | NULL | |||
| handover_person | varchar(1200) | No | ||||
| remark | varchar(12000) | No |
Indexes
| 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 | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| 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 | 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 |
Indexes
| 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 |
tbl_cus_payments
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id (Primary) | int(11) | No | ||||
| customer_id | int(11) | No | ||||
| dr | decimal(10,2) | No | ||||
| cr | decimal(10,2) | No | ||||
| balance | decimal(10,2) | No | ||||
| description | varchar(500) | No | ||||
| post_date | date | No | ||||
| post_time | time | No | ||||
| status | tinyint(4) | No | ||||
| last_updated | varchar(36) | No |
Indexes
| 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 |
tbl_daily_cash
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id (Primary) | int(11) | No | ||||
| description | varchar(500) | No | ||||
| dr | decimal(10,2) | No | ||||
| cr | decimal(10,2) | No | ||||
| balance | decimal(10,2) | No | ||||
| month | varchar(2) | No | ||||
| year | varchar(4) | No | ||||
| post_date | date | No | ||||
| post_time | time | No | ||||
| status | tinyint(4) | No | ||||
| last_updated | varchar(36) | No |
Indexes
| 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 |
tbl_daily_closing
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| demand_id (Primary) | int(11) | No | ||||
| id | int(11) | No | ||||
| supplier | varchar(50) | No | ||||
| title | varchar(128) | No | ||||
| brand_id | int(11) | No | ||||
| unit | int(11) | No | ||||
| available | decimal(10,0) | No | ||||
| quantity | decimal(10,0) | Yes | NULL | |||
| post_date | date | No | ||||
| post_time | time | No | ||||
| status | tinyint(4) | No | ||||
| Vendor | varchar(50) | No | ||||
| option | varchar(50) | No | ||||
| vendor_note | longtext | No |
Indexes
| 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 | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| demand_id (Primary) | int(11) | No | ||||
| id | int(11) | No | ||||
| supplier | varchar(50) | No | ||||
| title | varchar(128) | No | ||||
| brand_id | int(11) | No | ||||
| unit | int(11) | No | ||||
| available | decimal(10,0) | No | ||||
| quantity | decimal(10,2) | Yes | NULL | |||
| post_date | date | No | ||||
| post_time | time | No | ||||
| status | tinyint(4) | No | ||||
| Vendor | varchar(50) | No | ||||
| option | varchar(50) | No | ||||
| vendor_note | longtext | No | ||||
| DemandDate | date | No | ||||
| RecDate | date | No |
Indexes
| 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 |
tbl_employees
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id (Primary) | int(11) | No | ||||
| id_emp | int(11) | No | ||||
| name | varchar(100) | Yes | NULL | |||
| house | varchar(50) | Yes | NULL | |||
| designation | varchar(50) | Yes | NULL | |||
| cell | varchar(15) | Yes | NULL | |||
| id_card | varchar(200) | Yes | NULL | |||
| salary_per_month | decimal(10,2) | Yes | NULL | |||
| emergency_contact | varchar(15) | Yes | NULL | |||
| date_of_birth | date | Yes | NULL | |||
| gender | varchar(10) | Yes | NULL | |||
| marital_status | varchar(20) | Yes | NULL | |||
| current_address | varchar(255) | Yes | NULL | |||
| point | varchar(10) | Yes | NULL | |||
| joining_date | date | Yes | NULL | |||
| bank_transfer_option | varchar(10) | Yes | NULL | |||
| title_name | varchar(100) | Yes | NULL | |||
| BeneficiaryBankCode | int(11) | No | ||||
| ProductTypeCode | varchar(200) | No | ||||
| bank_name | varchar(100) | Yes | NULL | |||
| account_number | varchar(50) | Yes | NULL | |||
| uniform_info | varchar(100) | Yes | NULL | |||
| status | varchar(20) | Yes | NULL | |||
| branch | varchar(200) | No | ||||
| post_date | date | No | ||||
| hous | varchar(100) | No |
Indexes
| 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 |
tbl_emp_payments
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id (Primary) | int(11) | No | ||||
| category_id | int(11) | No | ||||
| title | varchar(128) | No | ||||
| dr | decimal(10,2) | No | ||||
| cr | decimal(10,2) | No | ||||
| details | varchar(500) | No | ||||
| post_date | date | No | ||||
| post_time | time | No | ||||
| status | tinyint(4) | No | ||||
| last_updated | varchar(36) | No |
Indexes
| 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 | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id (Primary) | int(11) | No | ||||
| category_id | int(11) | No | ||||
| title | varchar(128) | No | ||||
| dr | decimal(10,2) | No | ||||
| locker | decimal(10,2) | No | ||||
| owner | decimal(10,2) | No | ||||
| hr | decimal(10,2) | No | ||||
| given | decimal(10,2) | No | ||||
| till | decimal(10,2) | No | ||||
| id_emp | int(120) | No | ||||
| advance | decimal(10,2) | No | ||||
| hand | decimal(10,2) | No | ||||
| purchase | decimal(10,2) | No | ||||
| tip | decimal(10,2) | No | ||||
| details | varchar(500) | No | ||||
| post_date | date | No | ||||
| post_time | time | No | ||||
| status | tinyint(4) | No | ||||
| last_updated | varchar(36) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 182 | A | No |
tbl_exp_categories
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id (Primary) | int(11) | No | ||||
| title | varchar(128) | No | ||||
| post_date | date | No | ||||
| post_time | time | No | ||||
| status | tinyint(4) | No | ||||
| last_updated | varchar(36) | No |
Indexes
| 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 |
tbl_items
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id (Primary) | int(11) | No | ||||
| category_id | int(20) | No | 1 | |||
| Mini | int(50) | No | ||||
| Max | int(200) | No | ||||
| supplier | varchar(50) | No | ||||
| title | varchar(128) | No | ||||
| updated_Stock | decimal(10,2) | No | ||||
| brand_id | int(11) | No | 1 | |||
| unit | int(11) | No | ||||
| price | float | No | ||||
| quantity | decimal(10,2) | No | ||||
| post_date | date | No | ||||
| post_time | time | No | ||||
| last_updated | varchar(36) | No | ||||
| status | tinyint(4) | No |
Indexes
| 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 |
tbl_items_cat
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id (Primary) | int(200) | No | ||||
| title | varchar(128) | No | ||||
| post_date | date | No | ||||
| post_time | time | No | ||||
| status | tinyint(4) | No | ||||
| last_updated | varchar(36) | No |
Indexes
| 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 | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id (Primary) | int(11) | No | ||||
| Leave_id | int(64) | No | ||||
| Get_Previous | int(20) | No | ||||
| post_date | date | No | ||||
| id_emp | int(20) | No |
Indexes
| 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 | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id (Primary) | int(11) | No | ||||
| details | longtext | No | ||||
| post_date | date | No | ||||
| post_time | time | No | ||||
| status | tinyint(4) | No | ||||
| last_updated | varchar(36) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 0 | A | No |
tbl_points
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id (Primary) | int(11) | No | ||||
| id_emp | int(11) | Yes | NULL | |||
| name | varchar(255) | Yes | NULL | |||
| total_tip | decimal(10,2) | Yes | NULL | |||
| status | varchar(255) | Yes | NULL | |||
| post_date | date | No | ||||
| Paid_Date | timestamp | No | current_timestamp() |
Indexes
| 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 |
tbl_products
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id (Primary) | int(11) | No | ||||
| category_id | int(11) | No | 1 | |||
| title | varchar(128) | No | ||||
| brand_id | int(11) | No | 1 | |||
| unit | int(11) | No | ||||
| price | decimal(10,2) | No | 0.00 | |||
| total_order | int(200) | No | ||||
| post_date | date | No | ||||
| post_time | time | No | ||||
| last_updated | varchar(36) | No | ||||
| status | tinyint(4) | No |
Indexes
| 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 |
tbl_products_cat
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id (Primary) | int(11) | No | ||||
| display_order | tinyint(4) | No | ||||
| title | varchar(128) | No | ||||
| post_date | date | No | ||||
| post_time | time | No | ||||
| status | tinyint(4) | No | ||||
| last_updated | varchar(36) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 3 | A | No |
tbl_purchaser_details
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id (Primary) | int(200) | No | ||||
| post_date | date | No | ||||
| other_sources | int(200) | No | ||||
| today_bills | int(200) | No | ||||
| supplier_id | int(200) | No | ||||
| previous_bill | int(200) | No | ||||
| pending_bills | int(200) | No | ||||
| remark | varchar(500) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 10 | A | No |
tbl_purchases
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id_no (Primary) | int(200) | No | ||||
| id | int(200) | No | ||||
| hash | varchar(64) | No | ||||
| supplier_id | int(11) | No | ||||
| cr | decimal(20,0) | No | ||||
| dr | decimal(20,0) | No | ||||
| details | decimal(20,0) | No | ||||
| transport | tinyint(4) | No | ||||
| type | varchar(40) | No | ||||
| post_date | date | No | ||||
| post_time | time | No | ||||
| status | tinyint(4) | No | ||||
| Method | varchar(200) | No | ||||
| PaidBy | varchar(200) | No | ||||
| last_updated | varchar(36) | No |
Indexes
| 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 |
tbl_pur_items
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id (Primary) | int(11) | No | ||||
| type | tinyint(4) | No | ||||
| transport_type | tinyint(4) | No | ||||
| bill_id | int(11) | No | ||||
| category_id | int(11) | No | ||||
| brand_id | int(11) | No | ||||
| product_id | int(11) | No | ||||
| unit | int(11) | No | ||||
| supplier_id | int(11) | No | ||||
| quantity | decimal(10,3) | No | ||||
| supplier_cost | decimal(10,2) | No | ||||
| transport_exp | decimal(10,2) | No | ||||
| labor_exp | decimal(10,2) | No | ||||
| unit_cost | decimal(10,2) | No | ||||
| total_cost | decimal(10,2) | No | ||||
| details | varchar(500) | No | ||||
| purchase_date | date | No | ||||
| post_date | date | No | ||||
| post_time | time | No | ||||
| status | tinyint(4) | No | ||||
| remark | varchar(500) | No |
Indexes
| 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 |
tbl_recipe
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id (Primary) | int(16) | No | ||||
| product_id | int(16) | No | ||||
| item_id | int(16) | No | ||||
| item_qty | float | No | ||||
| marge_product_id | int(200) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 3923 | A | No |
tbl_reward_points
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| reward_point_id (Primary) | int(11) | No | ||||
| customer_id | int(11) | No | ||||
| sale_id | int(11) | No | ||||
| amount_in | decimal(10,2) | No | ||||
| amount_out | decimal(10,2) | No | ||||
| post_date | date | No | ||||
| post_time | time | No |
Indexes
| 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 | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id (Primary) | int(11) | No | ||||
| kot_no | varchar(16) | No | ||||
| type | tinyint(4) | No | ||||
| type_id | int(11) | Yes | NULL | |||
| hash | varchar(128) | No | ||||
| customer_id | int(11) | No | ||||
| service_id | int(16) | No | ||||
| grand_total | int(16) | No | ||||
| amount_received | decimal(10,2) | No | ||||
| total_amount | decimal(10,2) | No | ||||
| tax_amount | int(16) | No | ||||
| discount_percent | decimal(10,2) | No | ||||
| discount | decimal(10,2) | No | ||||
| delivery_charges | decimal(10,2) | No | ||||
| service_charges_percent | decimal(10,2) | No | ||||
| service_charges | decimal(10,2) | No | ||||
| reward_discount | decimal(10,2) | No | ||||
| details | varchar(256) | No | ||||
| post_date | date | No | ||||
| post_time | time | No | ||||
| status | tinyint(4) | No | ||||
| last_updated | varchar(36) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 203 | A | No |
tbl_sales_items
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id (Primary) | int(11) | No | ||||
| type | tinyint(4) | No | ||||
| customer_id | int(11) | No | ||||
| service_id | int(16) | No | ||||
| order_id | int(11) | No | ||||
| category_id | int(11) | No | ||||
| brand_id | int(11) | No | ||||
| product_id | int(11) | No | ||||
| unit_cost | decimal(10,2) | No | ||||
| sale_price | decimal(10,2) | No | ||||
| total_cost | decimal(10,2) | No | ||||
| total_sale_price | decimal(10,2) | No | ||||
| quantity_sold | decimal(10,3) | No | ||||
| post_date | date | No | ||||
| post_time | time | No | ||||
| last_updated | varchar(36) | No | ||||
| order_status | int(11) | No | ||||
| status | tinyint(4) | No | ||||
| kitchen_print | tinyint(1) | No | 0 | |||
| details | varchar(1000) | No |
Indexes
| 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 |
tbl_sale_services
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id (Primary) | int(11) | No | ||||
| title | varchar(128) | No | ||||
| post_date | date | No | ||||
| post_time | time | No | ||||
| status | tinyint(4) | No | ||||
| last_updated | varchar(36) | No |
Indexes
| 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 | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id (Primary) | int(200) | No | ||||
| section_id | int(200) | Yes | NULL | |||
| section | varchar(200) | Yes | NULL | |||
| amount | int(200) | Yes | NULL | |||
| post_date | date | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 4 | A | No |
tbl_services
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id (Primary) | int(11) | No | ||||
| name | varchar(255) | Yes | NULL | |||
| id_card | bigint(20) | Yes | NULL | |||
| dob | date | Yes | NULL | |||
| designation | varchar(255) | Yes | NULL | |||
| salary | decimal(10,2) | Yes | NULL | |||
| gender | enum('Male', 'Female', 'Other') | Yes | NULL | |||
| cell | varchar(15) | Yes | NULL | |||
| emergency | varchar(15) | Yes | NULL | |||
| address | text | Yes | NULL | |||
| joining_date | date | Yes | NULL | |||
| Transfer_Option | varchar(15) | No | ||||
| bank_name | varchar(255) | Yes | NULL | |||
| account | varchar(255) | Yes | NULL | |||
| title | varchar(255) | Yes | NULL | |||
| status | enum('Active', 'Inactive') | Yes | NULL | |||
| post_date | timestamp | No | current_timestamp() |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 0 | A | No |
tbl_services_calculations
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id (Primary) | int(11) | No | ||||
| id_ser | varchar(200) | No | ||||
| name | varchar(255) | Yes | NULL | |||
| id_card | bigint(20) | Yes | NULL | |||
| dob | date | Yes | NULL | |||
| designation | varchar(255) | Yes | NULL | |||
| salary | decimal(10,2) | Yes | NULL | |||
| gender | enum('Male', 'Female', 'Other') | Yes | NULL | |||
| cell | varchar(15) | Yes | NULL | |||
| emergency | varchar(15) | Yes | NULL | |||
| address | text | Yes | NULL | |||
| joining_date | date | Yes | NULL | |||
| Transfer_Option | varchar(15) | Yes | NULL | |||
| bank_name | varchar(255) | Yes | NULL | |||
| account | varchar(255) | Yes | NULL | |||
| title | varchar(255) | Yes | NULL | |||
| status | enum('Active', 'Inactive') | Yes | NULL | |||
| post_date | timestamp | No | current_timestamp() | |||
| action | int(50) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 0 | A | No |
tbl_staff_leaves
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id (Primary) | int(11) | No | ||||
| id_emp | int(11) | Yes | NULL | |||
| name | varchar(255) | Yes | NULL | |||
| bonus | decimal(10,2) | Yes | NULL | |||
| public | int(11) | Yes | NULL | |||
| mis_count | int(120) | Yes | NULL | |||
| reserved | int(120) | Yes | NULL | |||
| OverTime | int(50) | No | ||||
| annual | int(120) | Yes | NULL | |||
| details | varchar(120) | Yes | NULL | |||
| post_date | date | No | ||||
| status | tinyint(4) | No | ||||
| update_date | date | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 419 | A | No |
tbl_stock_dairy
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id (Primary) | int(11) | No | ||||
| type | tinyint(4) | No | ||||
| product_id | int(11) | No | ||||
| in_id | int(11) | No | ||||
| out_id | int(11) | No | ||||
| in_quantity | decimal(10,3) | No | ||||
| in_cost | decimal(10,2) | No | ||||
| out_quantity | decimal(10,3) | No | ||||
| out_cost | decimal(10,2) | No | ||||
| balance_quantity | decimal(10,3) | No | ||||
| balance_cost | decimal(10,2) | No | ||||
| post_date | date | No | ||||
| post_time | time | No | ||||
| status | tinyint(4) | No | ||||
| description | varchar(1000) | No | ||||
| last_updated | varchar(36) | No |
Indexes
| 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 |
tbl_suppliers
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id (Primary) | int(11) | No | ||||
| title | varchar(128) | No | ||||
| name | varchar(64) | No | ||||
| FbrName | text | No | ||||
| NTN | int(200) | No | ||||
| 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 | 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 |
tbl_sup_cat
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id (Primary) | int(11) | No | ||||
| title | varchar(64) | No | ||||
| status | tinyint(4) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 14 | A | No |
tbl_sup_payments
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id (Primary) | int(11) | No | ||||
| bill_id | int(200) | No | ||||
| supplier_id | int(11) | No | ||||
| dr | decimal(10,2) | No | ||||
| cr | decimal(10,2) | No | ||||
| balance | decimal(10,2) | No | ||||
| description | varchar(500) | No | ||||
| Method | varchar(200) | No | ||||
| PaidBy | varchar(200) | No | ||||
| post_date | date | No | ||||
| post_time | time | No | ||||
| status | tinyint(4) | No | ||||
| last_updated | varchar(36) | No |
Indexes
| 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 |
tbl_tmp_purchases
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id (Primary) | int(11) | No | ||||
| post_date | date | No | ||||
| post_time | time | No | ||||
| hash | varchar(64) | No | ||||
| supplier_id | int(11) | No | ||||
| cr | decimal(20,0) | No | ||||
| dr | decimal(20,0) | No | ||||
| details | decimal(20,0) | No | ||||
| transport | decimal(20,0) | No | ||||
| type | varchar(20) | No | ||||
| Method | varchar(200) | No | ||||
| PaidBy | varchar(200) | No | ||||
| time_stamp | timestamp | No | current_timestamp() | |||
| status | tinyint(4) | No | ||||
| last_updated | varchar(36) | No |
Indexes
| 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 | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id (Primary) | int(11) | No | ||||
| bill_id | int(11) | No | ||||
| product_id | int(11) | No | ||||
| supplier_cost | decimal(10,2) | No | ||||
| transport_cost | decimal(10,2) | No | ||||
| labor_cost | decimal(10,2) | No | ||||
| quantity | decimal(10,3) | No | ||||
| status | tinyint(4) | No | ||||
| Method | int(200) | No | ||||
| PaidBy | int(200) | No | ||||
| remark | varchar(500) | No |
Indexes
| 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 | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id (Primary) | int(11) | No | ||||
| product_id | int(11) | No | ||||
| Item | varchar(200) | No | ||||
| quantity | decimal(10,3) | No | ||||
| date | date | No | ||||
| status | tinyint(4) | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 0 | A | No |
tbl_units
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| 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 |