Table

types

Description

Attribute type definitions

Column

Format

Description

Definition

Required

Comments

id

integer, primary key

Row identifier

autoincrement

(tick)


co_id

integer, foreign key

CO ID

cos:id

(tick)


attribute

varchar(32)

Attribute this type name applies to


(tick)

Only attributes that support extended types may be used here.

display_name

varchar(64)

Display name for type


(tick)


value

varchar(32)

Database value for type


(tick)

Used for export to provisioners, etc

edupersonaffiliation

varchar(32)

Optional mapping to eduPersonAffiliation

eduPerson


Applies only when attribute is PersonRole.affiliation

status

varchar(2)

Type status

  • A: Active
  • S: Suspended
(tick)

A deleted status cannot exist in any active attribute. A suspended status cannot be added to any new or updated attributes, but may continue to be used by existing active attributes.

  • No labels