| MONTH |
| PK | YEAR_ID | SMALLINT |
class cMONTH {
cNumber m_YEAR_ID;
cNumber m_MONTH_ID;
cString m_MONTH_NAME;
}; |
| PK | MONTH_ID | DECIMAL (6,0) |
| | MONTH_NAME | VARCHAR (20) |
| REGION |
| PK | REGION_ID | SMALLINT |
class cREGION {
cNumber m_REGION_ID;
cString m_REGION_NAME;
}; |
| | REGION_NAME | VARCHAR (30) |
| SALE |
| PK | PRODUCT_ID | INTEGER |
class cSALE {
cNumber m_PRODUCT_ID;
cUnknown m_STORE_ID;
cNumber m_YEAR_ID;
cNumber m_MONTH_ID;
cNumber m_PCS;
cUnknown m_PRICE;
cUnknown m_REVENUE;
cNumber m_FLAG;
cNumber m_REGION_ID;
}; |
| PK | STORE_ID | TCustNo |
| PK | YEAR_ID | SMALLINT |
| PK | MONTH_ID | DECIMAL (6,0) |
| | PCS | INTEGER |
| | PRICE | TPrice |
| | REVENUE | TPrice |
| | FLAG | SMALLINT |
| | REGION_ID | SMALLINT |
| STORE |
| PK | STORE_ID | TCustNo |
class cSTORE {
cUnknown m_STORE_ID;
cNumber m_REGION_ID;
cString m_STORE_NAME;
cString m_ADDRESS;
}; |
| NN | REGION_ID | SMALLINT |
| | STORE_NAME | VARCHAR (30) |
| | ADDRESS | VARCHAR (30) |
| YEAR |
| PK | YEAR_ID | SMALLINT |
class cYEAR {
cNumber m_YEAR_ID;
cString m_YEAR_NAME;
}; |
| | YEAR_NAME | VARCHAR (10) |
| CATEGORY |
| PK | CATEGORY_ID | SMALLINT |
class cCATEGORY {
cNumber m_CATEGORY_ID;
cString m_CATEGORY_NAME;
}; |
| | CATEGORY_NAME | VARCHAR (30) |
| PRODUCT |
| PK | PRODUCT_ID | INTEGER |
class cPRODUCT {
cNumber m_PRODUCT_ID;
cNumber m_CATEGORY_ID;
cString m_PRODUCT_NAME;
}; |
| NN | CATEGORY_ID | SMALLINT |
| | PRODUCT_NAME | VARCHAR (30) |