Versions Compared

Old Version 23

changes.mady.by.user Benn Oshrin

Saved on

compared with

New Version 24

changes.mady.by.user Benn Oshrin

Saved on

Key

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

...

Column

Format

Description

Definition

Comments

id

integer, primary key

Row identifier

autoincrement

 

statusvarchar(2)Org Identity status
  • RM: Removed
  • SY: Synced
Added in v1.1.0. Currently intended primarily for org identities synced from an org identity source.

affiliation

varchar(8)  

Broad affiliation to source organization

eduPerson person

 

title

varchar(128)

Title at source organization

X.520 via RFC 4519 person

 

o

varchar(128)

Source organization

X.520 via RFC 4519 person

 

ou

varchar(128)

Departmental affiliation at source organization

X.520 via RFC 4519 person

 

organization_id

integer, foreign key

Source organization via known organizations

cm_organizations:id

Unused column removed in v1.1.0

co_id

integer, foreign key

If pool_org_identities is false in the CMP Enrollment Configuration, the CO in which this Org Identity is available

cm_cos:id