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

Navigation
QR Code
QR Code sql:inventory (generated for current page)