Untitled

{
  "tables": [
    {
      "tableName": "rfid_products",
      "description": "Stores product information, including details, categories, and associated files.",
      "fields": [
        {
          "id": "id",
          "label": "Asset Id",
          "type": "IdGeneratorField",
          "description": "Unique identifier for the product in the format PID-??????."
        },
        {
          "id": "product_name",
          "label": "Name",
          "type": "TextField",
          "description": "Name of the product."
        },
        {
          "id": "make",
          "label": "Make",
          "type": "TextField",
          "description": "Manufacturer or brand of the product."
        },
        {
          "id": "model",
          "label": "Model",
          "type": "TextField",
          "description": "Model number or version of the product."
        },
        {
          "id": "year",
          "label": "Year",
          "type": "TextField",
          "description": "Year of manufacture."
        },
        {
          "id": "type",
          "label": "Type",
          "type": "Radio",
          "description": "Specifies if the product is Traceable or Non-Traceable."
        },
        {
          "id": "catalog_id",
          "label": "Product Category",
          "type": "MultiSelectBox",
          "description": "Links to the catalog table for categorizing the product."
        },
        {
          "id": "details",
          "label": "Details",
          "type": "TextArea",
          "description": "Additional details or description of the product."
        },
        {
          "id": "datasheet",
          "label": "Datasheet",
          "type": "FileUpload",
          "description": "Upload product datasheet files."
        },
        {
          "id": "image",
          "label": "Image",
          "type": "FileUpload",
          "description": "Upload product image files."
        }
      ]
    },
    {
      "tableName": "rfid_inventory",
      "description": "Manages the inventory of products, including installation and tracking data.",
      "fields": [
        {
          "id": "id",
          "label": "ID",
          "type": "IdGeneratorField",
          "description": "Unique identifier for inventory records in the format INVID-??????."
        },
        {
          "id": "product_id",
          "label": "Product",
          "type": "MultiSelectBox",
          "description": "References the product being tracked."
        },
        {
          "id": "device_id",
          "label": "Serial No",
          "type": "TextField",
          "description": "Unique serial number of the device."
        },
        {
          "id": "installation_date",
          "label": "Installation Date",
          "type": "DatePicker",
          "description": "Date when the product was installed."
        },
        {
          "id": "additional_notes",
          "label": "Additional Notes",
          "type": "TextField",
          "description": "Any additional information related to the inventory item."
        },
        {
          "id": "batch_id",
          "type": "HiddenField",
          "description": "Batch identifier for grouping inventory items."
        },
        {
          "id": "lat",
          "type": "HiddenField",
          "description": "Latitude of the installation location."
        },
        {
          "id": "lng",
          "type": "HiddenField",
          "description": "Longitude of the installation location."
        },
        {
          "id": "last_maintenance_date",
          "type": "HiddenField",
          "description": "Records the last maintenance date."
        }
      ]
    },
    {
      "tableName": "rfid_catalog",
      "description": "Holds category information for classifying products.",
      "fields": [
        {
          "id": "id",
          "label": "Asset Id",
          "type": "IdGeneratorField",
          "description": "Unique identifier for each catalog entry."
        },
        {
          "id": "name",
          "label": "Name",
          "type": "TextField",
          "description": "Name of the catalog category."
        },
        {
          "id": "level",
          "label": "Level",
          "type": "Radio",
          "description": "Hierarchy level of the catalog item."
        },
        {
          "id": "details",
          "label": "Details",
          "type": "TextArea",
          "description": "Detailed description of the catalog category."
        },
        {
          "id": "parent_id",
          "label": "Parent Category",
          "type": "PopupSelectBox",
          "description": "References the parent category for nested catalog structures."
        }
      ]
    },
    {
      "tableName": "rfid_storage_loc",
      "description": "Manages storage locations for inventory items, including geofencing and hierarchical data.",
      "fields": [
        {
          "id": "id",
          "label": "ID",
          "type": "IdGeneratorField",
          "description": "Unique identifier for the storage location."
        },
        {
          "id": "name",
          "label": "Name",
          "type": "TextField",
          "description": "Name of the storage location."
        },
        {
          "id": "full_address",
          "label": "Address",
          "type": "TextArea",
          "description": "Full address of the storage location."
        },
        {
          "id": "geofencing",
          "label": "Geofencing",
          "type": "Radio",
          "description": "Indicates if geofencing is applied to the location."
        },
        {
          "id": "shape",
          "type": "HiddenField",
          "description": "Geofencing shape data."
        },
        {
          "id": "level",
          "label": "Hierarchy",
          "type": "Radio",
          "description": "Hierarchy level of the storage location."
        },
        {
          "id": "status",
          "label": "Status",
          "type": "Radio",
          "description": "Current status of the location (active/inactive)."
        },
        {
          "id": "lat",
          "type": "HiddenField",
          "description": "Latitude of the storage location."
        },
        {
          "id": "lng",
          "type": "HiddenField",
          "description": "Longitude of the storage location."
        },
        {
          "id": "parent_id",
          "label": "Primary Location",
          "type": "PopupSelectBox",
          "description": "References the primary location for hierarchical structure."
        },
        {
          "id": "assets_count",
          "type": "HiddenField",
          "description": "Total number of assets stored at this location."
        },
        {
          "id": "location_assets_count",
          "type": "MultiMap",
          "description": "Detailed count of assets per sub-location."
        },
        {
          "id": "map_visibility",
          "type": "HiddenField",
          "description": "Controls the visibility of the location on maps."
        },
        {
          "id": "parent_shape",
          "type": "HiddenField",
          "description": "Geofence shape of the parent location."
        },
        {
          "id": "validate_error",
          "label": "Validation Error",
          "type": "TextField",
          "description": "Stores any validation errors for the location."
        },
        {
          "id": "location_map",
          "type": "MultiMap",
          "description": "Visual map data for the location."
        }
      ]
    },
    {
      "tableName": "rfid_project_items",
      "description": "Stores project-specific items, their statuses, and related metadata.",
      "fields": [
        {
          "id": "lat",
          "type": "HiddenField",
          "description": "Latitude of the project item."
        },
        {
          "id": "lng",
          "type": "HiddenField",
          "description": "Longitude of the project item."
        },
        {
          "id": "image",
          "label": "Upload Image",
          "type": "FileUpload",
          "description": "Allows users to upload images for the project item."
        },
        {
          "id": "comments",
          "label": "Comments",
          "type": "TextArea",
          "description": "Any comments related to the project item."
        },
        {
          "id": "condition",
          "label": "Condition",
          "type": "MultiSelectBox",
          "description": "Tracks the condition of the project item."
        },
        {
          "id": "status",
          "label": "Status",
          "type": "MultiSelectBox",
          "description": "Current status of the project item."
        },
        {
          "id": "project_id",
          "label": "Project Id",
          "type": "MultiSelectBox",
          "description": "References the associated project."
        },
        {
          "id": "tag_id",
          "label": "Tag Id",
          "type": "TextField",
          "description": "Tag identifier for the item."
        },
        {
          "id": "product_id",
          "label": "Product Id",
          "type": "MultiSelectBox",
          "description": "Links the project item to a specific product."
        },
        {
          "id": "device_id",
          "label": "Serial No",
          "type": "TextField",
          "description": "Serial number of the project item."
        },
        {
          "id": "additional_notes",
          "label": "Additional Notes",
          "type": "TextField",
          "description": "Any additional notes related to the project item."
        },
        {
          "id": "field_associate",
          "label": "Field Associate",
          "type": "TextField",
          "description": "Name of the field associate responsible for the item."
        },
        {
          "id": "auditor_1",
          "label": "Auditor 1",
          "type": "TextField",
          "description": "First auditor assigned to the project item."
        },
        {
          "id": "auditor_2",
          "label": "Auditor 2",
          "type": "TextField",
          "description": "Second auditor assigned to the project item."
        },
        {
          "id": "location_id",
          "label": "Location Id",
          "type": "MultiSelectBox",
          "description": "References the location where the project item is stored or installed."
        }
      ]
    }
  ]
}