Difference between revisions of "Database Table: acctcode request"

From Dreamwidth Notes
Jump to: navigation, search
(Created page with '{{Database Table|name=acctcode_request|table type=global}} Category:Database Tables Needing Description = Definition = <source lang="sql"> CREATE TABLE acctcode_request ( …')
(No difference)

Revision as of 12:28, 27 January 2010

"{{{repo}}}" is not in the list of possible values (dw-free, dw-nonfree) for this property. This is a global table.

Definition

CREATE TABLE acctcode_request (
    reqid   INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
    userid  INT UNSIGNED NOT NULL,
    STATUS ENUM('accepted','rejected', 'outstanding') NOT NULL DEFAULT 'outstanding',
    reason VARCHAR(255),
    timegenerate    INT UNSIGNED NOT NULL,
    timeprocessed   INT UNSIGNED,
 
    INDEX (userid)
)

Relationships

Outgoing

  • Foreign key: userid to user.userid