| Column | Type | Actions |
|---|---|---|
| team_id | int(10) unsigned | |
| Team_name | varchar(120) | |
| month | tinyint(2) | |
| year | smallint(4) | |
| member_type | enum('employee','manager') | |
| person_id | int(10) unsigned | |
| member_name | varchar(120) | |
| project_id | int(11) | |
| project_number | varchar(20) | |
| payment_received | decimal(12,2) | |
| tip_amount | decimal(12,2) | |
| total_amount | decimal(13,2) | |
| payment_method | varchar(100) | |
| tip_payment_method | varchar(255) | |
| project_date | timestamp |