assets
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 | 513 | A | No | |
| idx_inventory_breakage | BTREE | No | No | item_name (50) | 34 | A | Yes | |
| category | 39 | A | Yes | |||||
| purpose | 256 | A | Yes | |||||
| total_purchased | 513 | A | Yes | |||||
| total_breakage | 513 | A | Yes | |||||
| balance_after_breakage | 513 | A | Yes | |||||
| branch | 513 | A | Yes | |||||
| post_date | 513 | A | Yes | |||||
| idx_composite_query | BTREE | No | No | branch | 6 | A | Yes | |
| category | 14 | A | Yes | |||||
| purchased_from | 51 | A | Yes | |||||
| unit_price_aed | 256 | A | Yes | |||||
| idx_post_date | BTREE | No | No | post_date | 4 | 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 |