VbzCart/tables/cust names
Jump to navigation
Jump to search
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.
About
- History:
- 2009-07-09 moved to separate wiki page; no design changes
- 2011-11-23 added WhenEnt, WhenUpd
- Notes:
- (2011-11-23) Possibly WhenUpd should be removed and replaced with one or both of:
- WhenCnf (when confirmed) -- stamp whenever a new order is received that contains this email
- WhenEdt (when edited) -- stamp whenever an admin saves the record
- same for cust_phones and cust_emails
- (2011-11-23) Possibly WhenUpd should be removed and replaced with one or both of:
SQL
CREATE TABLE `cust_names` (
`ID` INT NOT NULL AUTO_INCREMENT,
`WhenEnt` DATETIME NOT NULL COMMENT "date when record was first created",
`WhenUpd` DATETIME DEFAULT NULL COMMENT "date when record was last updated",
`ID_Cust` INT COMMENT "core_custs.ID",
`Name` VARCHAR(127) COMMENT "customer's name, for shipping label",
`NameSrch` VARCHAR(127) COMMENT "name with delimiters removed, for matching",
`isActive` BOOL DEFAULT FALSE COMMENT "NO=wrong spelling or name; use for searching",
PRIMARY KEY(`ID`)
)
ENGINE = InnoDB;