aok_knowledge_base_categories_audit


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id CHAR 36 null
parent_id CHAR 36 null
aok_knowledge_base_categories.id Defined in XML R
date_created DATETIME 19 √ NULL
created_by VARCHAR 36 √ NULL
field_name VARCHAR 100 √ NULL
data_type VARCHAR 100 √ NULL
before_value_string VARCHAR 255 √ NULL
after_value_string VARCHAR 255 √ NULL
before_value_text TEXT 65535 √ NULL
after_value_text TEXT 65535 √ NULL

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
idx_aok_knowledge_base_categories_parent_id Performance Asc parent_id

Relationships

Close relationships within degrees of separation