VbzCart/tables/cust phones
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
- (2011-11-23) Possibly WhenUpd should be removed and replaced with one or both of:
- REDIRECT Template:l/vc/table and cust_names
SQL
<mysql>CREATE TABLE `cust_phones` (
`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(31) COMMENT "human-assigned name (home, work...)", `Phone` VARCHAR(31) COMMENT "phone number as entered/corrected", `PhoneSrch` VARCHAR(31) COMMENT "Phone number in searchable form (no delimiters, no prefixes)", `Descr` VARCHAR(63) COMMENT "any other notes (best times, etc.)", `isActive` BOOL DEFAULT FALSE, PRIMARY KEY(`ID`)
) ENGINE = MYISAM;</mysql>