Difference between revisions of "Database Table: acctcode promo"

From Dreamwidth Notes
Jump to: navigation, search
m (Robot: Updating: Format)
m (Robot: Updating: Format)
Line 1: Line 1:
{{Database Table|name=acctcode_promo|table type=global|repo=dw-free|need desc=1}}
+
{{Database Table|name=acctcode_promo|table type=global|need desc=1|repo=dw-free}}
 
= Definition =
 
= Definition =
 
<source lang="sql">
 
<source lang="sql">

Revision as of 11:40, 7 September 2010

This is a global table.

Definition

CREATE TABLE acctcode_promo (
    code VARCHAR(20) NOT NULL,
    max_count INT(10) UNSIGNED NOT NULL DEFAULT 0,
    current_count INT(10) UNSIGNED NOT NULL DEFAULT 0,
    active enum('1','0') NOT NULL DEFAULT 1,
    suggest_journalid INT UNSIGNED,
 
    PRIMARY KEY ( code )
)

Relationships

Outgoing

  • Foreign key: suggest_journalid to user.userid