Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Column

Format

Description

Definition

Comments

id

integer, primary key

Row identifier

autoincrement


tagvarchar(128)Attribute Tag
Key is a reserved word for MySQL, so this column is called Tag.
valuevarchar(256)Attribute Value 

co_person_role_id

integer, foreign key

CO Person Role Record ID

cm_co_person_roles:id

Only one of co_person_idorg_identity_id, or co_department_id may be specified

org_identity_id

integer, foreign key

Org Identity Record ID

cm_org_identities:id

Only one of co_person_idorg_identity_id, or co_department_id may be specified

co_department_idinteger, foreign keyCO Department Record IDcm_co_departments:idOnly one of co_person_idorg_identity_id, or co_department_id may be specified.
source_ad_hoc_attribute_idinteger, foreign keyIf Pipelines are in use, the Ad Hoc Attribute ID for the Org Identity Ad Hoc Attribute that created this record.cm_ad_hoc_attributes:id