Table studip30.oauth_server_registry Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
osr_id int 10  √ 
osr_usa_id_ref int 10  √  null
osr_consumer_key varchar 64
osr_consumer_secret varchar 64
osr_enabled bit 0 1
osr_status varchar 16
osr_requester_name varchar 64
osr_requester_email varchar 64
osr_callback_uri varchar 255
osr_application_uri varchar 255
osr_application_title varchar 80
osr_application_descr text 65535
osr_application_notes text 65535
osr_application_type varchar 20
osr_application_commercial bit 0 0
osr_issue_date datetime 19
osr_timestamp timestamp 19 CURRENT_TIMESTAMP

Table contained 0 rows at Do Aug 02 15:05 GMT+01:00 2018

Indexes:
Column(s) Type Sort Constraint Name
osr_id Primary key Asc PRIMARY
osr_consumer_key Must be unique Asc osr_consumer_key
osr_usa_id_ref Performance Asc osr_usa_id_ref