Difference between revisions of "Database Table: acctcode promo"

From Dreamwidth Notes
Jump to: navigation, search
m (Robot: Updating: Format)
m (Robot: Updating: Format, definition)
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,
  
 
     PRIMARY KEY ( code )
 
     PRIMARY KEY ( code )

Revision as of 21:15, 15 October 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,
    paid_class VARCHAR(100),
    paid_months tinyint UNSIGNED,
 
    PRIMARY KEY ( code )
)

Relationships

Outgoing

  • Foreign key: suggest_journalid to user.userid