servicelog
Table: servicelog
The servicelog table stores execution logs and status details for internal or external service calls.
Columns
| Column Name | Data Type | Constraints | Description |
|---|---|---|---|
| serviceLogId | int(11) | NO (PK) | Unique identifier for each service log entry |
| serviceType | varchar(255) | YES | Type or category of the service |
| dateAdded | datetime | YES | Date and time when the log entry was created |
| dateDue | datetime | YES | Scheduled execution or due date of the service |
| dateEdited | datetime | YES | Date and time when the log was last updated |
| description | varchar(255) | YES | Description of the service request or response |
| failureCause | varchar(255) | YES | Reason for failure, if the service execution failed |
| retries | int(11) | YES | Number of retry attempts made for the service |
| serviceUrl | varchar(5555) | YES | Endpoint URL of the service being invoked |
| status | varchar(255) | YES | Current execution status (e.g., SUCCESS, FAILED, PENDING) |
| serviceMethod | varchar(255) | YES | Method used to invoke the service (e.g., GET, POST) |
Indexes
- PRIMARY KEY — Index on
serviceLogId
Foreign Key Relations
- None
Usage Notes
- Used to track service execution attempts and outcomes.
- Helpful for monitoring retries, failures, and service health.
- Commonly used for background jobs, integrations, and scheduled services.
- Supports auditing and debugging of service interactions.