warehouse
page_permissions
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| 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 | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id (Primary) | int(11) | No | ||||
| bill_date | date | No |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 0 | A | No |
tbl_admin
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| 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 | 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 | 0 | A | No |
tmp_supplier_demand
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| 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 | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| 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 | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| 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 | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| 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 | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| 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 | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| 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 | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| 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 | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| 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 | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| 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 | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| 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 | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| id (Primary) | int(20) | No | ||||
| title | varchar(500) | 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 | 251 | A | No | |
| title | BTREE | No | No | title | 251 | A | No |
warehouseitemsunites
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| 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 | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| 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 | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| 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 | 0 | A | No |
warehouseproductscategories
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| 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 | 0 | A | No |
warehouseproductsrecipe
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| 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 | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| 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 | 0 | A | No |
warehousepurchaserclosing
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| 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 | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| 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 | 12 | A | No |
warehousestockin
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| 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 | 17 | A | No |
warehousestockout
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| 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 | 41 | A | No |
warehousesuppliers
| Column | Type | Null | Default | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| 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 | Links to | Comments | Media (MIME) type |
|---|---|---|---|---|---|---|
| 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 |