VbzCart/tables/data flow

From HTYP, the free directory anyone can edit

[edit] About

• Purpose: Keeps track of data dependencies between tables – which procs update which caches from which sources

[edit] SQL

DROP TABLE IF EXISTS `data_flow`;
 
CREATE TABLE `data_flow` (
    ID_Srce INT NOT NULL COMMENT "data_tables.ID of SOURCE table",
    ID_Dest INT NOT NULL COMMENT "data_tables.ID of DESTINATION table",
    ID_Proc INT NOT NULL COMMENT "data_procs.ID of stored procedure which calculates Dest data from Srce data",
    Notes VARCHAR(255) COMMENT "loose explanatory or descriptive notes",
    PRIMARY KEY (`ID_Srce`,`ID_Dest`,`ID_Proc`)
 ) ENGINE = MYISAM;