hierarchy table

hierarchy Table (306)

This table contains folders used to group the extra tables in the system.

Name	Description	Type	Nullable
id	The primary key (auto-incremented)	PK	No
domain	Domain seperating the different hierarchy	Int	No
parent_id	Parent table	FK hierarchy	No
name	Name of this hierarchy folder.	String(128)	No
fullname	The full name of this category, i.e. Foo/bar/test.	Clob	Yes
registered	Registered when	UtcDateTime	Yes
registered_associate_id	Registered by whom	FK associate	Yes
updated	Last updated when	UtcDateTime	Yes
updated_associate_id	Last updated by whom	FK associate	Yes
updatedCount	Number of updates made to this record	UShort	Yes

Table	Description
associate	Employees, resources and other users - except for External persons
ej_role	Define access rights, memberships and other properties for role user members
ejscript	ejscript
ejselection	This table stores selections, dynamic groups.
ejuser	This table contains entries for the users of the system.
email_flow	A set of properties related to the email workflow.
external_document	This table stores documents which can be viewed externaly, through the customer module
extra_tables	This table contains entries for the extra tables in the system.
hierarchy	This table contains folders used to group the extra tables in the system.
screen_definition	A configurable screen