VbzCart/docs/tables/rstk ord line: Difference between revisions
Jump to navigation
Jump to search
imported>Woozle (draft) |
imported>Woozle m (→SQL: replaced missing comma) |
||
| Line 7: | Line 7: | ||
`ID_RstkLine` INT NOT NULL COMMENT "rstk_line.ID which is being used to fulfill the customer's order", | `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", | `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" | `QtyOrd` INT NOT NULL COMMENT "Quantity ordered by this customer", | ||
`Notes` VARCHAR(255) COMMENT "human-entered notes on this line item", | `Notes` VARCHAR(255) COMMENT "human-entered notes on this line item", | ||
PRIMARY KEY(`ID_RstkLine`,`ID_OrdLine`) | PRIMARY KEY(`ID_RstkLine`,`ID_OrdLine`) | ||
Revision as of 02:02, 8 November 2008
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
<section begin=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>
<section end=sql />