| id |
int(11)
|
|
|
|
| foreman_id |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| breakdown_id |
int(11)
|
|
|
|
| pr_number |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| print_count |
int(11)
|
|
|
|
| source |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| total_groups |
int(11)
|
|
|
|
| project_name |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| job_number |
varchar(100)
|
utf8mb4_unicode_ci
|
|
|
| customer |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| project_owner |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| location |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| required_date |
date
|
|
|
|
| installation_date |
date
|
|
|
|
| receiver_name |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| foreman_name |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| printed_by |
varchar(50)
|
utf8mb4_unicode_ci
|
|
|
| printed_by_name |
varchar(255)
|
utf8mb4_unicode_ci
|
|
|
| items_snapshot |
longtext
|
utf8mb4_unicode_ci
|
|
|
| document_refs |
longtext
|
utf8mb4_unicode_ci
|
|
|
| created_at |
timestamp
|
|
|
|