Table studipjlu_31.api_consumers 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
consumer_id char 32
api_consumer_permissions.consumer_id Implied Constraint R
api_user_permissions.consumer_id Implied Constraint R
consumer_type enum 6 studip
auth_key varchar 64  √  null
auth_secret varchar 64  √  null
active bit 0 0
system bit 0 0
type enum 8  √  website
title varchar 128  √  null
contact varchar 255  √  null
email varchar 255  √  null
url varchar 255  √  null
opengraphdata.url Implied Constraint R
callback varchar 255  √  null
commercial bit 0  √  null
description text 65535  √  null
priority int unsigned 10 0
notes text 65535  √  null
mkdate int unsigned 10
chdate int unsigned 10

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

Indexes:
Column(s) Type Sort Constraint Name
consumer_id Primary key Asc PRIMARY

Close relationships: