childdailyaudit

Table: childdailyaudit

The childdailyaudit table stores audit logs for child-related records, tracking changes and activities in the system.
It is used for monitoring, troubleshooting, and maintaining a history of operations performed on child data.

---

Columns

Column Name	Data Type	Constraints	Description
Id	int(11)	NOT NULL, AUTO_INCREMENT	Unique identifier for each audit record
ChildId	int(11)	NULL	References the child associated with the audit entry
VaccinationRecordNum	int(11)	NULL	Number of the vaccination record being audited
TableName	varchar(50)	NULL	Name of the table where the change occurred
LogType	smallint(6)	NULL	Type of log entry (e.g., insert, update, delete)
LogDetail	varchar(3500)	NULL	Detailed description of the operation or change
LogTime	datetime	NULL	Timestamp when the audit entry was recorded

---

Indexes

1. PRIMARY - Primary key on Id
2. TableName - Index on TableName
3. LogTime - Index on LogTime

---

Foreign Key Relations

• None

---

Usage Notes

• Tracks all changes or actions related to child records for auditing purposes.
• Data warehouse tables are built using this table.
• LogDetail provides detailed information about the operation performed.
• Helps in debugging, compliance, and monitoring system activity.
• Indexes on TableName and LogTime improve query performance for audit reviews.