Column |
MySQL Type |
Oracle Type |
Nullable |
Description |
Version |
DECIMAL |
NUMBER(6,3) |
No |
Numbered version of the warehouse schema that is loaded
|
LoadDate |
DATETIME |
DATE |
No |
Date that this schema was loaded
|
MaxSpecialWID |
BIGINT |
NUMBER |
No |
Maximum value allowed for SpecialWIDTable.PreviousWID / specialWID sequence
|
MaxReservedWID |
BIGINT |
NUMBER |
No |
Maximum value allowed for reserved WIDs (regulard WIDs start above this WID number)
|
Description |
TEXT |
VARCHAR2(4000) |
Yes |
Free-form text as desired by the warehouse maintainers
|