Table studip30.oauth_consumer_token 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
oct_id int 10  √ 
oct_ocr_id_ref int 10
oct_usa_id_ref int 10
oct_name varchar 64
oct_token varchar 128
oct_token_secret varchar 128
oct_token_type enum 10  √  null
oct_token_ttl datetime 19 9999-12-31 00:00:00
oct_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
oct_id Primary key Asc PRIMARY
oct_ocr_id_ref + oct_token Must be unique Asc/Asc oct_ocr_id_ref
oct_token_ttl Performance Asc oct_token_ttl
oct_usa_id_ref + oct_ocr_id_ref + oct_token_type + oct_name Must be unique Asc/Asc/Asc/Asc oct_usa_id_ref