ie_inventory
Legacy inventory items of a farmer, shown on the Inventory screen.
Table factsheetie_register.db
- Written by
- Inventory screen (
InventoryNewViewModel->IeInventoryRepositoryImpl) - IEInventoryMapper
- Inventory screen (
- Read by
- Inventory screen
- Filled from
Inventory screen; mirrored to agri_db inventoryproduct via BridgeSyncHelper- Sync
- No sync flags. BridgeSyncHelper creates the agri_db inventory rows that sync.
- Source
- app/src/main/java/org/platformcommons/urvi/datasource/database/entity/IeInventory.kt
Columns
| Column | Type | Null | Key | Meaning |
|---|---|---|---|---|
uniqueIdentityKey | INTEGER | No | PK | Local autoincrement key. Autoincrement. |
usableQuantity | REAL | Yes | Quantity entered on the Inventory screen (same value as quantity). | |
usableQuantityUOM | TEXT | Yes | Unit of measure detail (flattened embedded DTO). | |
notes | TEXT | Yes | No description in code. | |
quantity | REAL | Yes | Quantity entered on the Inventory screen, in quantityUOM (default quintal). Includes the fraction stored in inventoryproduct.notes. | |
quantityUOM | TEXT | Yes | Unit of measure detail (flattened embedded DTO). | |
aliasId | TEXT | Yes | Index | Business alias (stable cross-system id). Index: unique. |
parentAliasId | TEXT | Yes | FK → ie.aliasId | aliasId of the parent farmer (legacy ie.aliasId). Link by convention only, no FK constraint. |
id | INTEGER | Yes | Server id. Null or 0 until the row is synced. | |
iE | TEXT | Yes | No description in code. | |
productsku_name | TEXT | Yes | Display name of the product SKU. | |
productsku_id | INTEGER | Yes | Server id of the embedded object. | |
productsku_code | TEXT | Yes | Crop product code of the SKU (product_sku_master.productCode). | |
inventory_owningEnitityId | INTEGER | Yes | Owner farmer id (typo "Enitity"). | |
inventory_owningEntityType | TEXT | Yes | No description in code. | |
inventory_name | TEXT | Yes | No description in code. | |
inventory_id | INTEGER | Yes | Server id of the embedded object. |