Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| id | CHAR | 36 | null |
|
|
|||
| location_business_line_id | CHAR | 36 | null |
|
|
|||
| client_id | CHAR | 36 | null |
|
|
|||
| case_id | CHAR | 36 | null |
|
|
|||
| rendering_user_id | CHAR | 36 | null |
|
|
|||
| week_start_date | DATE | 10 | null |
|
|
|||
| week_end_date | DATE | 10 | null |
|
|
|||
| status | VARCHAR | 30 | INCOMPLETE |
|
|
|||
| provider_signature_data | TEXT | 65535 | √ | null |
|
|
||
| provider_signed_at | DATETIME | 19 | √ | null |
|
|
||
| provider_signed_by | CHAR | 36 | √ | null |
|
|
||
| total_hours | DECIMAL | 10,2 | 0.00 |
|
|
|||
| notes | TEXT | 65535 | √ | null |
|
|
||
| created_at | DATETIME | 19 | CURRENT_TIMESTAMP |
|
|
|||
| updated_at | DATETIME | 19 | √ | null |
|
|
||
| created_by | VARCHAR | 255 | √ | null |
|
|
||
| updated_by | VARCHAR | 255 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | id |
| idx_service_logs_case | Performance | Asc | case_id |
| idx_service_logs_client | Performance | Asc | client_id |
| idx_service_logs_location | Performance | Asc | location_business_line_id |
| idx_service_logs_provider | Performance | Asc | rendering_user_id |
| idx_service_logs_status | Performance | Asc | status |
| idx_service_logs_week | Performance | Asc | week_start_date |
| uk_service_log_unique | Must be unique | Asc/Asc/Asc/Asc | location_business_line_id + client_id + rendering_user_id + week_start_date |