Database – Checklist item Entity (checklist_item_entity)
Updated 3 months ago
This holds the information for items on a checklist. These are the items that can be marked as checked or unchecked.
Column | Data Type | Column Info | Value Notes | Other |
id | int(11) | The id of the entity | ||
title | varchar(255) | The name/title of the entity instance | ||
description | varchar(255) | The description of the entity instance | ||
checklist_id | int(11) | ID of associated checklist | ||
display_order | int(11) | Sort order used when displaying on the UI | ||
created | timestamp | Timestamp of when the entity was created | ||
lastUpdated | timestamp | Timestamp of when the entity was last updated | ||
active | tinyint(1) | Whether or not the entity is active | 1 - yes, 0 - no | |
deleted | tinyint(1) | Whether or not the entity was deleted | 1 - yes, 0 - no |