Untitled
unknown
plain_text
2 months ago
10 kB
4
Indexable
{ "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." } ] } ] }
Editor is loading...
Leave a Comment