assetslhr
inventory_breakage
| Column | Type | Null | Default | Comments |
|---|---|---|---|---|
| id (Primary) | int(11) | No | ||
| item_name | varchar(255) | Yes | NULL | |
| category | varchar(100) | Yes | NULL | |
| purpose | varchar(255) | Yes | NULL | |
| purchased_from | varchar(255) | Yes | NULL | |
| purchase_link | varchar(255) | Yes | NULL | |
| total_purchased | int(11) | Yes | NULL | |
| unit_price_aed | decimal(10,2) | Yes | NULL | |
| price_aed | decimal(12,2) | Yes | NULL | |
| before_opening | int(11) | No | ||
| quantity_restaurant | int(11) | Yes | NULL | |
| total_breakage | int(11) | Yes | NULL | |
| balance_after_breakage | int(11) | Yes | NULL | |
| storage_place_restaurant | varchar(255) | Yes | NULL | |
| breakage_remarks | varchar(255) | Yes | NULL | |
| quantity_dubai | int(11) | Yes | NULL | |
| storage_place_dubai | varchar(255) | Yes | NULL | |
| quantity_warehouse | int(11) | Yes | NULL | |
| storage_place_warehouse | varchar(255) | Yes | NULL | |
| branch | varchar(50) | Yes | NULL | |
| image_link | varchar(255) | Yes | NULL | |
| invoice_link | varchar(255) | Yes | NULL | |
| post_date | datetime | Yes | current_timestamp() |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 705 | A | No | |
| idx_branch_category_purchased | BTREE | No | No | branch | 4 | A | Yes | |
| category | 35 | A | Yes | |||||
| purchased_from | 35 | A | Yes | |||||
| idx_financial_calc | BTREE | No | No | before_opening | 100 | A | No | |
| quantity_restaurant | 141 | A | Yes | |||||
| unit_price_aed | 141 | A | Yes | |||||
| idx_post_date | BTREE | No | No | post_date | 6 | A | Yes | |
| idx_image_invoice | BTREE | No | No | image_link | 705 | A | Yes | |
| invoice_link | 705 | A | Yes | |||||
| idx_branch_category_date_price | BTREE | No | No | branch | 4 | A | Yes | |
| category | 35 | A | Yes | |||||
| post_date | 37 | A | Yes | |||||
| unit_price_aed | 37 | A | Yes | |||||
| idx_item_name_composite | BTREE | No | No | item_name (50) | 705 | A | Yes | |
| category | 705 | A | Yes | |||||
| purpose | 705 | A | Yes | |||||
| total_purchased | 705 | A | Yes | |||||
| total_breakage | 705 | A | Yes | |||||
| balance_after_breakage | 705 | A | Yes | |||||
| branch | 705 | A | Yes | |||||
| post_date | 705 | A | Yes |
tbl_admin
| Column | Type | Null | Default | Comments |
|---|---|---|---|---|
| id (Primary) | int(11) | No | ||
| user_name | varchar(255) | No | ||
| pword | varchar(255) | No | ||
| branch | varchar(255) | Yes | NULL | |
| varchar(255) | Yes | NULL | ||
| phone | varchar(20) | Yes | NULL | |
| time_stamp | timestamp | No | current_timestamp() | |
| status | int(11) | Yes | NULL | |
| post_date | date | Yes | NULL | |
| post_time | time | Yes | NULL |
Indexes
| Keyname | Type | Unique | Packed | Column | Cardinality | Collation | Null | Comment |
|---|---|---|---|---|---|---|---|---|
| PRIMARY | BTREE | Yes | No | id | 1 | A | No |