Versions Compared

Old Version 25

changes.mady.by.user Benn Oshrin

Saved on

compared with

New Version 26

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 v1v2.10.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 


valid_from

datetime

Org Identity is considered valid from this time

If null, valid any time through valid_through

Added in v1v2.10.0

valid_through

datetime

Org Identity is considered valid through (but not past) this time

If null, valid any time from valid_from

Added in v1v2.10.0

organization_id

integer, foreign key

Source organization via known organizations

cm_organizations:id

Unused column removed in v1v2.10.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