public.amc_contracts
iduuidtenant_iduuidcontract_numbercharacter varyingvendor_iduuid?statuscharacter varyingcontract_typecharacter varyingstart_datedateend_datedatecontract_valuenumericvisits_per_yearintegerresponse_hoursintegercovers_partsbooleancovers_labourbooleannotestext?created_byuuid?is_activebooleancreated_attimestamp with time zoneupdated_attimestamp with time zonevendor_nametext?services_coveredtext?sla_response_hoursnumeric?sla_resolution_hoursnumeric?alert_days_before_expiryintegerext_reftext?pm_visit_freq_monthsinteger
| id | tenant_id | contract_number | vendor_id | status | contract_type | start_date | end_date | contract_value | visits_per_year | response_hours | covers_parts | covers_labour | notes | created_by | is_active | created_at | updated_at | vendor_name | services_covered | sla_response_hours | sla_resolution_hours | alert_days_before_expiry | ext_ref | pm_visit_freq_months |
|---|