Database – Customer Status Entity (customer_status_entity)
This holds categories for different statuses a customer can be in. This allows categorization of various customers.
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 | ||
slug | varchar(255) | Status slug | ||
created | timestamp | Timestamp of when the entity was created | ||
lastUpdated | timestamp | Timestamp of when the entity was last updated | ||
active | tinyint(4) | Whether or not the entity is active | 1 - yes, 0 - no | |
deleted | tinyint(4) | Whether or not the entity was deleted | 1 - yes, 0 - no |