Page tree

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

 

co_id

integer, foreign key

CO Record ID

cm_cos:id

 

cou_idinteger, foreign keyCOU Record IDcm_cous:id 
namevarchar(256)Name  

description

varchar(256)

Description

  

co_group_id

integer, foreign key

CO Group ID

cm_co_groups:id

If set, access to this service is controlled by the specified group, though the application is ultimately responsible for enforcement

service_url

varchar(256)

Service URL

 

A clickable link that directs the user to the service

service_labelvarchar(1024)Protocol specific identifier or label of the service, eg SAML Entity ID or OIDC Client ID Added v3.1.0

contact_email

varchar(128)

Email Address of contact responsible for this Service

RFC 5322 Address

 

entitlement_uri

varchar(256)

Entitlement URI associated with this Service

eduPerson entitlement

For authorization purposes, eg: ldap attribute population

visibilityvarchar(2)Visibility of this Service
  • CA: CO Admin
  • CG: CO Group Member (of the specified co_group_id)
  • CP: CO Person
  • P: Unauthenticated (Public)
In particular for use generating a user-visible list of Services

status

varchar(2)

Status

  • A: Active
  • S: Suspended