Database Table: acctcode_promo

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