Entity Constant
An Entity constant is a value that is not expected to change over time. Entity Constants are linked to specific Entitys and are used to provide extra pieces of metadata for data handling purposes.
Definition
Name
Type
Nullable
Description
entity_constant_id
integer
NO
System generated unique identifier.
entity_id
integer
NO
System generated unique identifier of the entity.
name
character varying
NO
Name of the constant. See acceptable values within the constraint_entity_constant_name table.
value
character varying
NO
Value of the constant.
insert_date
timestamp with time zone
NO
UTC timestamp when the record was inserted into the table.
update_date
timestamp with time zone
YES
UTC timestamp when the record was updated into the table.
migration_insert_id
integer
YES
System generated unique identifier of the migration this record was inserted by.
migration_update_id
integer
YES
System generated unique identifier of the migration this record was updated by.
Constraints
Type
Columns
FOREIGN KEY
entity_id
FOREIGN KEY
name
PRIMARY KEY
entity_constant_id
UNIQUE
entity_id, name
Acceptable Values
Column
Values
name
See full list of values here .