app.certified_payroll_projects
TablaSeguridad a nivel de fila activa
The WH-347 header of a project covered by the Davis-Bacon and Related Acts.
Clave primaria: id
| Columna | Tipo | Admite nulos | Descripción |
|---|---|---|---|
| id | uuid | No | Primary key, UUID v7. |
| org_id | uuid | No | Owning org, derived from app.projects on insert; never accepted from the caller and never changed.Hace referencia a app.organizations.id |
| project_id | uuid | No | Project covered.Hace referencia a app.projects.id |
| contract_number | text | No | Project No. or Contract No. |
| wage_determinations | text | No | Wage Determination No.: every wage determination and revision number that applies, as written on the form. |
| contractor_role | text | No | Prime contractor or Subcontractor, as the form's check boxes ask. |
| business_name | text | No | Prime contractor's or subcontractor's legal business name. |
| business_address | text | No | Prime contractor's or subcontractor's business address. |
| project_location | text | No | Project location: the full address, or at least the county and state. |
| deleted_at | timestamp with time zone | Sí | Soft delete time. A row with deleted_at set is ignored by every access helper. |
| created_at | timestamp with time zone | No | When the row was inserted. Set by the database. |
| created_by | uuid | Sí | Person who inserted the row, or null for a platform process. Set by the database.Hace referencia a app.people.id |
| updated_at | timestamp with time zone | No | When the row last changed. Set by the database. |
| updated_by | uuid | Sí | Person who last changed the row, or null for a platform process. Set by the database.Hace referencia a app.people.id |