• If you are citizen of an European Union member nation, you may not use this service unless you are at least 16 years old.

  • You already know Dokkio is an AI-powered assistant to organize & manage your digital files & messages. Very soon, Dokkio will support Outlook as well as One Drive. Check it out today!

View
 

ImplementationNotes

Page history last edited by Leah Culver 15 years, 11 months ago

Implementation Notes

 

Pownce Database Tables

Contact: leah@pownce.com

Probably not the optimal design for these tables, but hey, here they are.

 

Request Token / Access Token

We have 2 different tables but they look identical.

 

id int(11) NO PRI NULL auto_increment
key varchar(32) NO UNI
secret varchar(32) NO
consumer_application_id int(11) NO MUL
user_id int(11) NO MUL
creation_date datetime NO

 

Consumer Application

 

id int(11) NO PRI NULL auto_increment
user_id int(11) NO MUL
key varchar(255) NO UNI
secret varchar(255) NO
consumer_type varchar(8) NO
callback_url varchar(255) YES NULL
status varchar(8) NO
status_reason varchar(255) YES NULL
ranking int(10) unsigned NO
is_featured tinyint(1) NO
name varchar(255) NO
developer_email varchar(75) NO
help_email varchar(75) NO
url varchar(255) NO
description longtext NO
photo_display_name varchar(255) YES NULL
orig_photo_key varchar(200) NO
large_photo_key varchar(200) NO
tos_accepted tinyint(1) NO
registration_date datetime NO
num_requests int(11) NO
last_request_date datetime NO

Comments (0)

You don't have permission to comment on this page.