Table subscription
Push Subscription for the API
Fields
Field |
Description |
Type |
Null |
Key |
Default |
Extra |
id |
Auto incremented image data id |
int unsigned |
NO |
PRI |
NULL |
auto_increment |
application-id |
|
int unsigned |
NO |
|
NULL |
|
uid |
Owner User id |
mediumint unsigned |
NO |
|
NULL |
|
endpoint |
Endpoint URL |
varchar(511) |
YES |
|
NULL |
|
pubkey |
User agent public key |
varchar(127) |
YES |
|
NULL |
|
secret |
Auth secret |
varchar(32) |
YES |
|
NULL |
|
follow |
|
boolean |
YES |
|
NULL |
|
favourite |
|
boolean |
YES |
|
NULL |
|
reblog |
|
boolean |
YES |
|
NULL |
|
mention |
|
boolean |
YES |
|
NULL |
|
poll |
|
boolean |
YES |
|
NULL |
|
follow_request |
|
boolean |
YES |
|
NULL |
|
status |
|
boolean |
YES |
|
NULL |
|
Indexes
Name |
Fields |
PRIMARY |
id |
application-id_uid |
UNIQUE, application-id, uid |
uid_application-id |
uid, application-id |
Foreign Keys
Return to database documentation