🛠️ Database Manager Suite
💻 Run Custom SQL Query
🔍 Table Schema Structure: staff_billing
| Field Name | Data Type | Null Allowed | Key Index | Default Value | Extra Attributes |
|---|---|---|---|---|---|
| staff_bill_id | int(11) | NO | 🔑 PRIMARY KEY | NULL | auto_increment |
| staffname | varchar(255) | NO | - | NULL | |
| staffphone | varchar(255) | NO | - | NULL | |
| staffcity | varchar(255) | NO | - | NULL | |
| staff_salary | varchar(255) | NO | - | NULL | |
| paid_amount | varchar(255) | NO | - | NULL | |
| paid_date | date | NO | - | NULL | |
| paid_month | varchar(255) | NO | - | NULL | |
| remain_amount | varchar(255) | NO | - | NULL | |
| staff_dealer | varchar(255) | NO | - | NULL | |
| pay_status | tinyint(1) | NO | - | NULL | |
| pay1 | varchar(255) | NO | - | NULL | |
| pay2 | varchar(255) | NO | - | NULL | |
| pay3 | varchar(255) | NO | - | NULL | |
| pay4 | varchar(255) | NO | - | NULL | |
| pay5 | varchar(255) | NO | - | NULL | |
| pay6 | varchar(255) | NO | - | NULL | |
| pay7 | varchar(255) | NO | - | NULL | |
| pay8 | varchar(255) | NO | - | NULL | |
| pay9 | varchar(255) | NO | - | NULL | |
| pay10 | varchar(255) | NO | - | NULL | |
| pay11 | varchar(255) | NO | - | NULL | |
| pay12 | varchar(255) | NO | - | NULL | |
| pay13 | varchar(255) | NO | - | NULL | |
| pay14 | varchar(255) | NO | - | NULL | |
| pay15 | varchar(255) | NO | - | NULL | |
| pay16 | varchar(255) | NO | - | NULL | |
| pay17 | varchar(255) | NO | - | NULL | |
| pay18 | varchar(255) | NO | - | NULL | |
| pay19 | varchar(255) | NO | - | NULL | |
| pay20 | varchar(255) | NO | - | NULL | |
| pay21 | varchar(255) | NO | - | NULL | |
| pay22 | varchar(255) | NO | - | NULL | |
| pay23 | varchar(255) | NO | - | NULL | |
| pay24 | varchar(255) | NO | - | NULL | |
| pay25 | varchar(255) | NO | - | NULL | |
| pay26 | varchar(255) | NO | - | NULL | |
| pay27 | varchar(255) | NO | - | NULL | |
| pay28 | varchar(255) | NO | - | NULL | |
| pay29 | varchar(255) | NO | - | NULL | |
| pay30 | varchar(255) | NO | - | NULL | |
| pay31 | varchar(255) | NO | - | NULL | |
| pay_date1 | date | NO | - | NULL | |
| pay_date2 | date | NO | - | NULL | |
| pay_date3 | date | NO | - | NULL | |
| pay_date4 | date | NO | - | NULL | |
| pay_date5 | date | NO | - | NULL | |
| pay_date6 | date | NO | - | NULL | |
| pay_date7 | date | NO | - | NULL | |
| pay_date8 | date | NO | - | NULL | |
| pay_date9 | date | NO | - | NULL | |
| pay_date10 | date | NO | - | NULL | |
| pay_date11 | date | NO | - | NULL | |
| pay_date12 | date | NO | - | NULL | |
| pay_date13 | date | NO | - | NULL | |
| pay_date14 | date | NO | - | NULL | |
| pay_date15 | date | NO | - | NULL | |
| pay_date16 | date | NO | - | NULL | |
| pay_date17 | date | NO | - | NULL | |
| pay_date18 | date | NO | - | NULL | |
| pay_date19 | date | NO | - | NULL | |
| pay_date20 | date | NO | - | NULL | |
| pay_date21 | date | NO | - | NULL | |
| pay_date22 | date | NO | - | NULL | |
| pay_date23 | date | NO | - | NULL | |
| pay_date24 | date | NO | - | NULL | |
| pay_date25 | date | NO | - | NULL | |
| pay_date26 | date | NO | - | NULL | |
| pay_date27 | date | NO | - | NULL | |
| pay_date28 | date | NO | - | NULL | |
| pay_date29 | date | NO | - | NULL | |
| pay_date30 | date | NO | - | NULL | |
| pay_date31 | date | NO | - | NULL | |
| payment_method | varchar(255) | NO | - | NULL | |
| payment_comment | varchar(500) | NO | - | NULL |
📊 Data Preview: staff_billing (Limit 100)
This table is currently empty.