User Private Key Table Schema (user_private_key)


Description

access keys used in cookieless scripts - rss, etc.

user_private_key table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
script VARCHAR 128

plugin, module - unique identifier
value VARCHAR 128

private access key value
userid BIGINT 19 null
user.id userprivkey_use2_fk R

owner
instance BIGINT 19 √ null

optional instance id
iprestriction VARCHAR 255 √ null

ip restriction
validuntil BIGINT 19 √ null

timestampt - valid until data
timecreated BIGINT 19 √ null

created timestamp

Table contained -1 rows

user_private_key table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
userprivkey_scrval_ix Performance Asc/Asc script + value
userprivkey_use_ix Performance Asc userid

user_private_key table relationships

Close relationships within degrees of separation