Database – Checklist Item To Checklist Entity Map (checklist_item__entity)
Description
This holds the many-to-many mapping information between checklist entities and checklist item entities.
Column | Data Type | Column Info | Value Notes | Other |
entity_id | int(11) | ID of the associated entity | ||
entity_type | char(100) | Type of the associated entity | Entity.Loan | |
checklist_id | int(11) | ID of associated checklist | ||
checklist_item_id | int(11) | ID of associated checklist item | ||
checklist_item_value | tinyint(1) | Value of associated checklist item | 1 - checked, 0 - unchecked | |
deleted | tinyint(1) | Whether or not the entity was deleted | 1 - yes, 0 - no | |
id | int(11) | The id of the entity | ||
last_updated | timestamp | Timestamp of when the entity was last updated | ||
logged_date | timestamp |