Difference between revisions of "Database Table: acctcode promo"

From Dreamwidth Notes
Jump to: navigation, search
m (Robot: Updating: Format)
m (Robot: Updating: Format, definition)
 
(2 intermediate revisions by the same user not shown)
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">
Line 8: Line 8:
 
     active enum('1','0') not null default 1,
 
     active enum('1','0') not null default 1,
 
     suggest_journalid int unsigned,
 
     suggest_journalid int unsigned,
 +
    paid_class varchar(100),
 +
    paid_months tinyint unsigned,
 +
    expiry_date int(10) unsigned not null default 0,
  
 
     PRIMARY KEY ( code )
 
     PRIMARY KEY ( code )

Latest revision as of 16:10, 2 December 2011

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,
    paid_class VARCHAR(100),
    paid_months tinyint UNSIGNED,
    expiry_date INT(10) UNSIGNED NOT NULL DEFAULT 0,
 
    PRIMARY KEY ( code )
)

Relationships

Outgoing

  • Foreign key: suggest_journalid to user.userid