warehouselhr
page_permissions
| Column | Type | Null | Default | Comments |
|---|---|---|---|---|
| id (Primary) | int(11) | No | ||
| user_id | int(11) | No | ||
| page | varchar(255) | No | ||
| can_access | tinyint(1) | No | 0 |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 22 | A | No |
set_date
| Column | Type | Null | Default | Comments |
|---|---|---|---|---|
| id (Primary) | int(11) | No | ||
| bill_date | date | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 1 | A | 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 | current_timestamp() | |
| post_time | time | No | current_timestamp() | |
| last_updated | varchar(36) | No | current_timestamp() |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 4 | 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 | 1 | A | No |
tmp_supplier_demand
| Column | Type | Null | Default | Comments |
|---|---|---|---|---|
| id (Primary) | int(11) | No | ||
| item_id | int(11) | No | ||
| unit_id | int(11) | No | ||
| cat_id | int(11) | No | ||
| qty | decimal(10,2) | No | ||
| note | varchar(500) | No | ||
| supplier_id | int(11) | No | ||
| cell | bigint(20) | No | ||
| cr | int(11) | No | ||
| status | tinyint(4) | No | ||
| post_date | date | Yes | curdate() |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 0 | A | No |
tmp_warehousepay
| Column | Type | Null | Default | Comments |
|---|---|---|---|---|
| id (Primary) | int(20) | No | ||
| invoice | int(11) | No | ||
| items_amount | int(11) | No | ||
| gst | int(11) | No | ||
| delivery_charges | decimal(10,2) | No | ||
| total_cost | decimal(10,2) | No | ||
| return_cost | decimal(10,2) | No | ||
| payable | int(11) | No | ||
| paid | int(11) | No | ||
| balance | int(11) | No | ||
| pay | int(11) | No | ||
| demand_supplier_id | int(11) | No | ||
| purchased_supplier_id | int(11) | No | ||
| payment_method_id | int(11) | No | ||
| post_date | date | No | current_timestamp() | |
| post_time | time | No | current_timestamp() | |
| bill_date | date | No | ||
| paid_date | date | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 0 | A | No |
tmp_warehousepurchased
| Column | Type | Null | Default | Comments |
|---|---|---|---|---|
| id (Primary) | int(11) | No | ||
| invoice | int(11) | No | ||
| items_amount | int(11) | No | ||
| gst | int(11) | No | ||
| delivery_charges | decimal(10,2) | No | ||
| total_cost | decimal(10,2) | No | ||
| return_cost | decimal(10,2) | No | ||
| payable | int(11) | No | ||
| paid | int(11) | No | ||
| balance | int(11) | No | ||
| demand_supplier_id | int(11) | No | ||
| purchased_supplier_id | int(11) | No | ||
| payment_method_id | int(11) | No | ||
| Logo | blob | No | ||
| post_date | date | No | current_timestamp() | |
| post_time | time | No | current_timestamp() | |
| bill_date | date | No | ||
| paid_date | date | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 0 | A | No |
tmp_warehousepurchaserclosing
| Column | Type | Null | Default | Comments |
|---|---|---|---|---|
| id (Primary) | int(20) | No | ||
| invoice | int(11) | No | ||
| items_amount | int(11) | No | ||
| gst | int(11) | No | ||
| delivery_charges | decimal(10,2) | No | ||
| total_cost | decimal(10,2) | No | ||
| return_cost | int(11) | No | ||
| total_cash | int(11) | No | ||
| paid_exp | int(11) | No | ||
| payable | int(11) | No | ||
| paid | int(11) | No | ||
| balance | int(11) | No | ||
| pay | int(11) | No | ||
| pending_bills | int(50) | No | ||
| demand_supplier_id | int(11) | No | ||
| purchased_supplier_id | int(11) | No | ||
| payment_method_id | int(11) | No | ||
| remarks | varchar(300) | No | ||
| post_date | date | No | current_timestamp() | |
| post_time | time | No | current_timestamp() | |
| bill_date | date | No | ||
| paid_date | date | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 0 | A | No |
tmp_warehousereceive
| Column | Type | Null | Default | Comments |
|---|---|---|---|---|
| id (Primary) | int(20) | No | ||
| invoice | int(11) | No | ||
| items_amount | int(11) | No | ||
| gst | int(11) | No | ||
| delivery_charges | decimal(10,2) | No | ||
| total_cost | decimal(10,2) | No | ||
| return_cost | decimal(10,2) | No | ||
| payable | int(11) | No | ||
| paid | int(11) | No | ||
| balance | int(11) | No | ||
| pay | int(11) | No | ||
| branch_id | int(11) | No | ||
| payment_method_id | int(11) | No | ||
| post_date | date | No | current_timestamp() | |
| post_time | time | No | current_timestamp() | |
| bill_date | date | No | ||
| paid_date | date | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 0 | A | No |
tmp_warehousesell
| Column | Type | Null | Default | Comments |
|---|---|---|---|---|
| id (Primary) | int(20) | No | ||
| invoice | int(11) | No | ||
| items_amount | int(11) | No | ||
| gst | int(11) | No | ||
| delivery_charges | decimal(10,2) | No | ||
| total_cost | decimal(10,2) | No | ||
| return_cost | decimal(10,2) | No | ||
| payable | int(11) | No | ||
| paid | int(11) | No | ||
| balance | int(11) | No | ||
| branch_id | int(11) | No | ||
| payment_method_id | int(11) | No | ||
| post_date | date | No | current_timestamp() | |
| post_time | time | No | current_timestamp() | |
| bill_date | date | No | ||
| paid_date | date | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 0 | A | No |
tmp_warehousestockin
| Column | Type | Null | Default | Comments |
|---|---|---|---|---|
| id (Primary) | int(200) | No | ||
| invoice | int(11) | No | ||
| item_id | int(11) | No | ||
| pack_qty | decimal(11,2) | No | ||
| total_pack | decimal(11,2) | No | ||
| qty | decimal(11,3) | No | ||
| unit_cost | decimal(10,2) | No | ||
| total_cost | decimal(10,2) | No | ||
| return_qty | decimal(11,2) | No | ||
| return_cost | decimal(10,2) | No | ||
| wastage | decimal(11,2) | No | ||
| unit_id | int(11) | No | ||
| cat_id | int(11) | No | ||
| post_date | date | No | current_timestamp() | |
| stockin_date | date | No | ||
| paid_date | date | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 0 | A | No |
tmp_warehousestockout
| Column | Type | Null | Default | Comments |
|---|---|---|---|---|
| id (Primary) | int(200) | No | ||
| invoice | int(11) | No | ||
| item_id | int(11) | No | ||
| pack_qty | decimal(11,3) | No | ||
| total_pack | decimal(11,2) | No | ||
| qty | decimal(11,3) | No | ||
| unit_cost | decimal(10,2) | No | ||
| total_cost | decimal(10,2) | No | ||
| return_qty | decimal(11,2) | No | ||
| branch_id | int(11) | No | ||
| merge_recipe_id | int(11) | No | ||
| unit_id | int(11) | No | ||
| cat_id | int(11) | No | ||
| post_date | date | No | current_timestamp() | |
| stockin_date | date | No | ||
| paid_date | date | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 0 | A | No |
warehousebank
| Column | Type | Null | Default | Comments |
|---|---|---|---|---|
| id (Primary) | int(11) | No | ||
| title | text | No | ||
| post_date | datetime | No | current_timestamp() |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 23 | A | No |
warehousebranches
| Column | Type | Null | Default | Comments |
|---|---|---|---|---|
| id (Primary) | int(11) | No | ||
| title | text | No | ||
| address | text | No | ||
| post_date | datetime | No | current_timestamp() |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 3 | A | No |
warehouseitems
| Column | Type | Null | Default | Comments |
|---|---|---|---|---|
| id (Primary) | int(20) | No | ||
| title | varchar(200) | No | ||
| unit_id | int(11) | No | ||
| mini | int(11) | No | ||
| new_order | int(11) | No | ||
| opening_stock | decimal(11,3) | No | ||
| balance_stock | decimal(11,3) | No | ||
| unit_cost | decimal(10,3) | No | ||
| supplier_id | int(11) | No | ||
| suppliers_cat_id | int(11) | No | ||
| post_date | timestamp | No | current_timestamp() | |
| Remark | varchar(500) | No | ||
| image_path | blob | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 113 | A | No | |
| title | BTREE | No | No | title | 113 | A | No |
warehouseitemsunites
| Column | Type | Null | Default | Comments |
|---|---|---|---|---|
| id (Primary) | int(11) | No | ||
| title | text | No | ||
| post_date | datetime | No | current_timestamp() |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 4 | A | No |
warehousepaymentmethod
| Column | Type | Null | Default | Comments |
|---|---|---|---|---|
| id (Primary) | int(11) | No | ||
| title | text | No | ||
| post_date | datetime | No | current_timestamp() |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 4 | A | No |
warehouseproducts
| Column | Type | Null | Default | Comments |
|---|---|---|---|---|
| id (Primary) | int(11) | No | ||
| title | text | No | ||
| p_categories | int(10) | No | ||
| total_order | int(10) | No | ||
| sell_price | int(11) | No | ||
| post_date | datetime | No | current_timestamp() |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 1 | A | No |
warehouseproductscategories
| Column | Type | Null | Default | Comments |
|---|---|---|---|---|
| id (Primary) | int(11) | No | ||
| title | text | No | ||
| post_date | datetime | No | current_timestamp() |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 1 | A | No |
warehouseproductsrecipe
| Column | Type | Null | Default | Comments |
|---|---|---|---|---|
| id (Primary) | int(11) | No | ||
| recipe_id | int(11) | No | ||
| item_id | int(11) | No | ||
| item_qty | decimal(11,3) | No | ||
| merge_recipe_id | int(11) | No | ||
| procedure_notes | text | No | ||
| post_date | date | No | current_timestamp() |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 0 | A | No |
warehousepurchased
| Column | Type | Null | Default | Comments |
|---|---|---|---|---|
| id (Primary) | int(20) | No | ||
| invoice | int(11) | No | ||
| items_amount | int(11) | No | ||
| gst | int(11) | No | ||
| delivery_charges | decimal(10,2) | No | ||
| total_cost | decimal(10,2) | No | ||
| return_cost | decimal(10,2) | No | ||
| payable | int(11) | No | ||
| paid | int(11) | No | ||
| balance | int(11) | No | ||
| demand_supplier_id | int(11) | No | ||
| purchased_supplier_id | int(11) | No | ||
| payment_method_id | int(11) | No | ||
| Logo | blob | No | ||
| post_date | date | No | current_timestamp() | |
| post_time | time | No | current_timestamp() | |
| bill_date | date | No | ||
| paid_date | date | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 7 | A | No |
warehousepurchaserclosing
| Column | Type | Null | Default | Comments |
|---|---|---|---|---|
| id (Primary) | int(20) | No | ||
| invoice | int(11) | No | ||
| items_amount | int(11) | No | ||
| gst | int(11) | No | ||
| delivery_charges | decimal(10,2) | No | ||
| total_cost | decimal(10,2) | No | ||
| return_cost | decimal(10,2) | No | ||
| total_cash | int(11) | No | ||
| paid_exp | int(11) | No | ||
| payable | int(11) | No | ||
| paid | int(11) | No | ||
| balance | int(11) | No | ||
| pay | int(11) | No | ||
| pending_bills | int(50) | No | ||
| demand_supplier_id | int(11) | No | ||
| purchased_supplier_id | int(11) | No | ||
| payment_method_id | int(11) | No | ||
| remarks | varchar(300) | No | ||
| post_date | date | No | current_timestamp() | |
| post_time | time | No | current_timestamp() | |
| bill_date | date | No | ||
| paid_date | date | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 0 | A | No |
warehousesell
| Column | Type | Null | Default | Comments |
|---|---|---|---|---|
| id (Primary) | int(20) | No | ||
| invoice | int(11) | No | ||
| items_amount | int(11) | No | ||
| gst | int(11) | No | ||
| delivery_charges | decimal(10,2) | No | ||
| total_cost | decimal(10,2) | No | ||
| return_cost | decimal(10,2) | No | ||
| payable | int(11) | No | ||
| paid | int(11) | No | ||
| balance | int(11) | No | ||
| branch_id | int(11) | No | ||
| payment_method_id | int(11) | No | ||
| post_date | date | No | current_timestamp() | |
| post_time | time | No | current_timestamp() | |
| bill_date | date | No | ||
| paid_date | date | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 16 | A | No |
warehousestockin
| Column | Type | Null | Default | Comments |
|---|---|---|---|---|
| id (Primary) | int(20) | No | ||
| invoice | int(11) | No | ||
| item_id | int(11) | No | ||
| qty | decimal(11,2) | No | ||
| unit_cost | decimal(10,2) | No | ||
| total_cost | decimal(10,2) | No | ||
| return_qty | decimal(11,2) | No | ||
| return_cost | decimal(10,2) | No | ||
| wastage | decimal(11,2) | No | ||
| unit_id | int(11) | No | ||
| cat_id | int(11) | No | ||
| post_date | date | No | current_timestamp() | |
| stockin_date | date | No | ||
| paid_date | date | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 116 | A | No |
warehousestockout
| Column | Type | Null | Default | Comments |
|---|---|---|---|---|
| id (Primary) | int(20) | No | ||
| invoice | int(11) | No | ||
| item_id | int(11) | No | ||
| qty | decimal(11,2) | No | ||
| total_pack | decimal(11,2) | No | ||
| unit_cost | decimal(10,2) | No | ||
| total_cost | decimal(10,2) | No | ||
| return_qty | decimal(11,2) | No | ||
| return_cost | decimal(10,2) | No | ||
| branch_id | int(11) | No | ||
| unit_id | int(11) | No | ||
| cat_id | int(11) | No | ||
| merge_recipe_id | int(11) | No | ||
| post_date | date | No | current_timestamp() | |
| stockin_date | date | No | ||
| paid_date | date | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 151 | A | No |
warehousesuppliers
| Column | Type | Null | Default | Comments |
|---|---|---|---|---|
| id (Primary) | int(11) | No | ||
| title | varchar(255) | No | ||
| supplier_cat_id | int(11) | No | ||
| c_limit | int(200) | No | ||
| fbr_name | varchar(255) | No | ||
| ntn | int(11) | No | ||
| bank_id | int(11) | No | ||
| bank_title_name | varchar(255) | No | ||
| account_number | varchar(20) | No | ||
| phone_number | bigint(20) | No | ||
| address | varchar(235) | No | ||
| post_date | datetime | No | current_timestamp() |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 24 | A | No | |
| title | BTREE | No | No | title | 24 | A | No | |
| title_2 | BTREE | No | No | title | 24 | A | No |
warehousesupplierscategories
| Column | Type | Null | Default | Comments |
|---|---|---|---|---|
| id (Primary) | int(11) | No | ||
| title | text | No | ||
| status | varchar(11) | No | ||
| post_date | datetime | No | current_timestamp() |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 16 | A | No |