VbzCart/tables/cust addr

from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
< VbzCart‎ | tables
Revision as of 19:35, 9 July 2009 by Woozle (talk | contribs) (moved from "customer tables" page)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

About

  • Fields:
    • Name will at first be set only by us, but later on customers will be able to set it and will be increasingly in charge of it.
    • Search_raw should probably be replaced by a hash at some point, because it's just a value to make it easier to detect when Search needs recalculation
    • State probably needs to be separate fields for as-entered and code-if-known
    • ID_Cust is a new field for the migration; I had this wacky idea that customers might need to share addresses (one customer buys a present for a friend; friend sets up an account and then moves, first friend buys another present but doesn't get the updated address... egh). (Consequently, the [Contacts x Addrs] table in the Access version will be going away too.)
  • History:
    • 2009-07-09 Moved to separate wiki page; no design changes

SQL

<mysql>CREATE TABLE `cust_addrs` (

 `ID`         INT NOT NULL AUTO_INCREMENT,
 `ID_Cust`    INT COMMENT "core_custs.ID",
 `Name`       VARCHAR(31) COMMENT "human-assigned name for this address",
 `WhenAct`    DATETIME COMMENT "date when first active/usable; NULL = always",
 `WhenExp`    DATETIME COMMENT "date when no longer usable; NULL = never",
 `Full`       VARCHAR(255) COMMENT "Full address (street, town, zip, country)",
 `Search`     VARCHAR(255) COMMENT "Full address, normalized for searching",
 `Search_raw` VARCHAR(255) COMMENT "Text used to create Search field",
 `Street`     VARCHAR(127) COMMENT "address within town (street, apt., etc.)",
 `Town`       VARCHAR(63) COMMENT "name of town",
 `State`      VARCHAR(63) COMMENT "state or province name/code",
 `Zip`        VARCHAR(31) COMMENT "zipcode or postal code",
 `Country`    VARCHAR(63) COMMENT "name of country",
 `Extra`      VARCHAR(63) COMMENT "additional instructions to always write on pkg",
 `Descr`      VARCHAR(255) COMMENT "notes on this address",
 PRIMARY KEY(`ID`)

) ENGINE = MYISAM;</mysql>