Service Records
Service Records
| Field | Type | Description |
|---|---|---|
service_record_id đ | INTEGER | Unique identifier for this service record. |
service_contract_id đ | INTEGER | The ID of the service contract this service record belongs to. |
service_referral_id đ | INTEGER | The ID of the service referral this service record belongs to. |
provider_agency_id đ | INTEGER | The ID of the provider agency that provided the service. |
referring_agency_id đ | INTEGER | The ID of the referring agency that referred the service. |
service_date | DATE | The date of the service. |
method_of_engagement | STRING | The method of engagement for the service. |
method_of_engagement_other | STRING | The other method of engagement for the service. |
start_time | TIMESTAMP | The start time of the service. |
end_time | TIMESTAMP | The end time of the service. |
notes | STRING | The notes for the service. |
created_at | TIMESTAMP | The date and time the service record was created. |
updated_at | TIMESTAMP | The date and time the service record was last updated. |
locked_at | TIMESTAMP | The date and time the service record was locked. |
locked_by_id đ | INTEGER | The ID of the user who locked the service record. |
Key Information
Primary Keys
service_record_id- Unique identifier for this service record.
Foreign Keys
service_contract_id- The ID of the service contract this service record belongs to.service_referral_id- The ID of the service referral this service record belongs to.provider_agency_id- The ID of the provider agency that provided the service.referring_agency_id- The ID of the referring agency that referred the service.locked_by_id- The ID of the user who locked the service record.
Updated 2 days ago