VbzCart/tables/rstk ord line

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 02:02, 8 November 2008 by Woozle (talk | contribs) (→‎SQL: replaced missing comma)
Jump to navigation Jump to search

About

  • Created: 2008-11-07
  • Distribution of restock items to customer orders (planned). This is more of a historical-log kind of record than something which is actually part of the process. (Should we get rid of it at some point?)

SQL

<mysql>CREATE TABLE `rstk_ord_line` (

  `ID_RstkLine`    INT NOT NULL COMMENT "rstk_line.ID which is being used to fulfill the customer's order",
  `ID_OrdLine`     INT NOT NULL COMMENT "ord_lines.ID which is being fulfilled by this restock request line",
  `QtyOrd`         INT NOT NULL COMMENT "Quantity ordered by this customer",
  `Notes`          VARCHAR(255) COMMENT "human-entered notes on this line item",
  PRIMARY KEY(`ID_RstkLine`,`ID_OrdLine`)
)
ENGINE = MYISAM;</mysql>