🛠️ Database Manager Suite
💻 Run Custom SQL Query
🔍 Table Schema Structure: recovery
| Field Name | Data Type | Null Allowed | Key Index | Default Value | Extra Attributes |
|---|---|---|---|---|---|
| recovery_id | int(11) | NO | 🔑 PRIMARY KEY | NULL | auto_increment |
| username | varchar(100) | NO | - | NULL | |
| received_amount | varchar(100) | NO | - | NULL | |
| receiving_date | datetime | NO | - | NULL | |
| collect_by | varchar(100) | NO | - | NULL | |
| pkg | varchar(150) | NO | - | NULL | |
| given_to_boss | tinyint(1) | YES | - | 0 | |
| grand_total | varchar(150) | NO | - | NULL | |
| remaining_amount | varchar(150) | NO | - | NULL | |
| bill_month | varchar(255) | NO | - | NULL | |
| bill_id | int(11) | NO | - | NULL | |
| total_invoice | varchar(100) | NO | - | NULL | |
| all_grand_total | varchar(255) | NO | - | NULL | |
| expiration | datetime | NO | - | NULL |
📊 Data Preview: recovery (Limit 100)
This table is currently empty.