Table descriptions for Inventory Management Module
ims_item_records - stores the records about items such as item manufactured date, item expire date, available inventory, suplier ect…
ims_inventory_records - stores the records about the inventories such as inventory name, avilable resources, inventory space and contact details of the responsible person for the particular inventory.
ims_reorder_level - stores the re-order level of particular items in particular inventories
ims_transfer_item - stores the records about items that have been tranfered from one inventory to another inventory
ims_optimization - A tempory table which stores the predicted amount for a particular item.
ims_relation - deprecated - stores the records about items which are related to other items. (For example a relationship can be found between computer and key board because normally keyboards are useless without a computer)
ims_alternate - deprecated - stores the records about items which can be used instead of another particular items
Table descriptions for Catalog System Module
ct_catalogue - contains the information about catalogs/items
- ct_uuid - a uuid which is the primary key for a catalog/item.
- parentid - contain a uuid of the paren catalog.
- name - name of the catalog/item.
- description - description of the particular catalog/item.
- final_flag - a flag to differentiate catalogs and items.
- keyword - keyword for searching for the catalog/item.
ct_unit_type - contains the information about measurement unit types.
- unit_type_uuid - a uuid which is the primary key for a measurement unit type.
- name - name of the unit type.
- description description of the unit type
ct_unit - contains the information about measurement units.
- unit_type_uuid - unit type id which the particular unit is belong to.
- unit_uuid - a uuid which is the primary key for a measurement unit.
- name - name of the unit.
- base_flag - a flag to differentiate base units and other units.
- multiplier - mltiplier of the unit compared to the base unit.
ct_cat_unit - contains many units for a particular item.
ct_suppliers - contains many suppliers for a particular item.
- supplier - contains a uuid of an organization