api_consumers

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
consumer_id CHAR 32
api_consumer_permissions.consumer_id Implied ConstraintR
consumer_type enum('http', 'studip', 'oauth') 6 studip
auth_key VARCHAR 64 √ null
auth_secret VARCHAR 64 √ null
active BIT 1 0
system BIT 1 0
type enum('website', 'mobile', 'desktop') 7 √ website
title VARCHAR 128 √ null
contact VARCHAR 255 √ null
email VARCHAR 255 √ null
url VARCHAR 255 √ null
callback VARCHAR 255 √ null
commercial BIT 1 √ null
description TEXT 65535 √ null
priority INT UNSIGNED 10 0
notes TEXT 65535 √ null
mkdate INT UNSIGNED 10 null
chdate INT UNSIGNED 10 null

Indexes

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

Relationships

Close relationships within degrees of separation