Table studip30.oauth_consumer_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
ocr_id int 10  √ 
ocr_usa_id_ref int 10  √  null
ocr_consumer_key varchar 128
ocr_consumer_secret varchar 128
ocr_signature_methods varchar 128 HMAC-SHA1,PLAINTEXT
ocr_server_uri varchar 128
ocr_server_uri_host varchar 128
ocr_server_uri_path varchar 128
ocr_request_token_uri varchar 255
ocr_authorize_uri varchar 255
ocr_access_token_uri varchar 255
ocr_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
ocr_id Primary key Asc PRIMARY
ocr_consumer_key + ocr_usa_id_ref + ocr_server_uri Must be unique Asc/Asc/Asc ocr_consumer_key
ocr_server_uri Performance Asc ocr_server_uri
ocr_server_uri_host + ocr_server_uri_path Performance Asc/Asc ocr_server_uri_host
ocr_usa_id_ref Performance Asc ocr_usa_id_ref