The data dictionary is a collection of tables that define the structure of data used in the system.
This table defines the data dictionaries available in the system.
CREATE TABLE `def_data_dictionary` (
`DictionaryCode` char(255) NOT NULL,
`Package` char(50) NOT NULL,
PRIMARY KEY (`DictionaryCode`,`Package`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
This table defines the fields within each data dictionary.
CREATE TABLE `def_data_dictionary_field` (
`DictionaryCode` char(255) NOT NULL,
`Package` char(255) NOT NULL,
`FieldName` char(255) NOT NULL,
`Description` char(255) NOT NULL,
`OpType` char(255) DEFAULT NULL,
`DataType` char(255) DEFAULT NULL,
`Values` text DEFAULT NULL,
`LeftMargin` float DEFAULT NULL,
`RightMargin` float DEFAULT NULL,
PRIMARY KEY (`DictionaryCode`,`Package`,`FieldName`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
cythonize -3 -a -i ObjDataDictionary.py
Compiling /home/axion/projects/axion/factory.core/ObjDataDictionary.py because it changed..[1/1] Cythonizing /home/axion/projects/axion/factory.core/ObjDataDictionary.py
Updated : 2025-09-10