Tagger Cat's Meta Data Model

List of attributes

Column name	Table	Key	Data type	Unsigned	Not NULL	Autonumber
action	meta_property_constraint		VARCHAR(2048)	No	No	No
action	meta_entity_constraint		VARCHAR(2048)	No	No	No
audit_enabled	meta_entity		CHAR(1)	No	No	No
caption	meta_property		VARCHAR(80)	No	No	No
category_id	meta_entity	FK	INTEGER(11)	Yes	No	No
code_table	meta_property		VARCHAR(128)	No	No	No
comments	meta_property_constraint		VARCHAR(255)	No	No	No
comments	meta_entity_constraint		VARCHAR(255)	No	No	No
ct_code_property	meta_entity		VARCHAR(40)	No	No	No
ct_display_property	meta_entity		VARCHAR(40)	No	No	No
default_edit_page	meta_entity		VARCHAR(128)	No	No	No
default_search_page	meta_entity		VARCHAR(128)	No	No	No
default_value	meta_property		VARCHAR(1024)	No	No	No
delete_data	meta_entity_permission		CHAR(1)	No	Yes	No
delete_data	meta_property_permission		CHAR(1)	No	Yes	No
derivation	meta_property		VARCHAR(1024)	No	No	No
description	meta_entity_category_type		VARCHAR(40)	No	Yes	No
description	meta_entity		VARCHAR(128)	No	No	No
description	user_conf		VARCHAR(120)	No	No	No
effective_from	meta_entity_constraint		DATETIME	No	No	No
effective_from	meta_property_constraint		DATETIME	No	No	No
effective_to	meta_property_constraint		DATETIME	No	No	No
effective_to	meta_entity_constraint		DATETIME	No	No	No
empty_value_policy	meta_property		VARCHAR(40)	No	No	No
enabled	meta_entity_constraint		CHAR(1)	No	No	No
enabled	meta_property_constraint		CHAR(1)	No	No	No
entity_id	meta_entity_ext_property	FK	INTEGER(11)	Yes	Yes	No
entity_id	meta_entity_constraint	FK	INTEGER(11)	Yes	Yes	No
entity_id	meta_entity_permission	FK	INTEGER(11)	Yes	Yes	No
entity_id	meta_property	FK	INTEGER(11)	Yes	Yes	No
expression	meta_property_constraint		VARCHAR(1024)	No	Yes	No
expression	meta_entity_constraint		VARCHAR(1024)	No	Yes	No
field_display_size	meta_property		INTEGER(11)	No	No	No
format	meta_property		VARCHAR(40)	No	No	No
format_key	meta_property		VARCHAR(40)	No	No	No
form_control_type	meta_prop_form_ctrl_type		VARCHAR(40)	No	No	No
form_control_type_id	meta_property	FK	INTEGER(11)	Yes	No	No
full_name	user_conf		VARCHAR(30)	No	No	No
group_id	meta_entity_permission	FK	INTEGER(11)	Yes	Yes	No
group_id	meta_property_permission	FK	INTEGER(11)	Yes	Yes	No
group_id	group_user_xref	FK	INTEGER(11)	Yes	Yes	No
id	meta_property_permission	PK	INTEGER(11)	Yes	Yes	Yes
id	meta_prop_form_ctrl_type	PK	INTEGER(11)	Yes	Yes	Yes
id	meta_property_ext_property	PK	INTEGER(11)	Yes	Yes	Yes
id	meta_property_constraint	PK	INTEGER(11)	Yes	Yes	Yes
id	user_conf	PK	INTEGER(11)	Yes	Yes	Yes
id	meta_property	PK	INTEGER(11)	Yes	Yes	Yes
id	meta_entity_category_type	PK	INTEGER(11)	Yes	Yes	Yes
id	meta_entity_permission	PK	INTEGER(11)	Yes	Yes	Yes
id	meta_entity_ext_property	PK	INTEGER(11)	Yes	Yes	Yes
id	meta_entity_constraint	PK	INTEGER(11)	Yes	Yes	Yes
id	group_user_xref	PK	INTEGER(11)	Yes	Yes	No
id	meta_entity	PK	INTEGER(11)	Yes	Yes	Yes
insert_data	meta_entity_permission		CHAR(1)	No	Yes	No
insert_data	meta_property_permission		CHAR(1)	No	Yes	No
is_code_table	meta_entity		CHAR(1)	No	Yes	No
is_group	user_conf		CHAR(1)	No	Yes	No
layout_by_default	meta_property		CHAR(1)	No	Yes	No
message	meta_entity_constraint		VARCHAR(40)	No	No	No
message	meta_property_constraint		VARCHAR(255)	No	No	No
message_key	meta_entity_constraint		VARCHAR(80)	No	No	No
message_key	meta_property_constraint		VARCHAR(80)	No	No	No
mt_tenant_name	meta_property		VARCHAR(20)	No	No	No
mt_tenant_name	group_user_xref		VARCHAR(20)	No	No	No
mt_tenant_name	user_conf		VARCHAR(20)	No	No	No
mt_tenant_name	meta_entity_permission		VARCHAR(20)	No	No	No
mt_tenant_name	meta_property_permission		VARCHAR(20)	No	No	No
mt_tenant_name	meta_property_ext_property		VARCHAR(20)	No	No	No
mt_tenant_name	meta_entity		VARCHAR(20)	No	No	No
mt_tenant_name	meta_entity_constraint		VARCHAR(20)	No	No	No
mt_tenant_name	meta_property_constraint		VARCHAR(20)	No	No	No
mt_tenant_name	meta_entity_ext_property		VARCHAR(20)	No	No	No
name	user_conf		VARCHAR(15)	No	Yes	No
name	meta_property_constraint		VARCHAR(80)	No	Yes	No
name	meta_entity		VARCHAR(120)	No	Yes	No
name	meta_property_ext_property		VARCHAR(40)	No	Yes	No
name	meta_property		VARCHAR(40)	No	Yes	No
name	meta_entity_constraint		VARCHAR(80)	No	Yes	No
name	meta_entity_ext_property		VARCHAR(40)	No	Yes	No
password	user_conf		VARCHAR(80)	No	No	No
plural_caption	meta_entity		VARCHAR(120)	No	No	No
property_id	meta_property_constraint	FK	INTEGER(11)	Yes	Yes	No
property_id	meta_property_ext_property	FK	INTEGER(11)	Yes	Yes	No
property_id	meta_property_permission	FK	INTEGER(11)	Yes	Yes	No
sequence	meta_property_constraint		DECIMAL(10, 5)	No	No	No
sequence	meta_entity_constraint		DECIMAL(10, 5)	No	No	No
short_name	meta_entity		VARCHAR(40)	No	No	No
singular_caption	meta_entity		VARCHAR(120)	No	No	No
stop_on_error	meta_property_constraint		CHAR(1)	No	No	No
stop_on_error	meta_entity_constraint		CHAR(1)	No	No	No
table_column_caption	meta_property		VARCHAR(40)	No	No	No
table_column_width	meta_property		VARCHAR(20)	No	No	No
tooltip	meta_property		VARCHAR(255)	No	No	No
update_data	meta_property_permission		CHAR(1)	No	Yes	No
update_data	meta_entity_permission		CHAR(1)	No	Yes	No
user_id	group_user_xref	FK	INTEGER(11)	Yes	Yes	No
value	meta_entity_ext_property		VARCHAR(254)	No	Yes	No
value	meta_property_ext_property		VARCHAR(254)	No	Yes	No
view_data	meta_property_permission		CHAR(1)	No	Yes	No
view_data	meta_entity_permission		CHAR(1)	No	Yes	No