| Column | Type | Actions |
|---|---|---|
| id | int(11) | |
| project_name | varchar(255) | |
| project_description | text | |
| uploaded_by | int(11) | |
| uploaded_by_type | enum('employee','manager') | |
| zip_file_path | varchar(500) | |
| extracted_path | varchar(500) | |
| total_files | int(11) | |
| total_lines | int(11) | |
| analyzed | tinyint(1) | |
| analyzed_at | datetime | |
| status | enum('pending','analyzing','completed','failed') | |
| created_at | datetime |