Database / Land & assets

ie_asset

Legacy copy of farmer assets (land, livestock) used by land lists and geofencing.

Table factsheetie_register.db

Written by

FarmerAssetsMapper (copy of agri_db farmerassets)
IeAssetRepositoryImpl

Read by

Land lists (fetchAuthenticatedAssetNames)
PortfolioBinderAdapter (is land disabled)
GeofencingViewModel
CompactBlockImp
IePortfolioRepositoryImpl

Filled from

Copied from agri_db farmerassets

Sync

No sync flags.

Source

app/src/main/java/org/platformcommons/urvi/datasource/database/entity/IeAsset.kt

Columns

Column	Type	Null	Key	Meaning
`uniqueIdentityKey`	INTEGER	No	PK	Local autoincrement key. Autoincrement.
`assetName`	TEXT	Yes		Generated unique asset name (farmer alias, land name, farmer name, category labels, index, time); sent as the asset code.
`assetSubCategory`	TEXT	Yes		Label of assetSubCategoryCode (first server label).
`assetSubCategoryCode`	TEXT	Yes		Reference data code.
`notes`	TEXT	Yes		Free-text description typed on the add/edit asset form.
`assetCost`	TEXT	Yes		No description in code.
`assetCategory`	TEXT	Yes		Label of assetCategoryCode (first server label).
`assetCategoryCode`	TEXT	Yes		Reference data code.
`yearOfPurchase`	TEXT	Yes		No description in code.
`aliasId`	TEXT	Yes	Index	Business alias (stable cross-system id). Index: unique.
`assetFunctionality`	TEXT	Yes		Label of assetFunctionalityCode (first server label).
`quality`	TEXT	Yes		Quality code of the asset from the server.
`assetFunctionalityCode`	TEXT	Yes		Reference data code.
`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		Owner farmer server id (= farmerassets.owningEntityId).
`name`	TEXT	Yes		Land name (asset spec asset.spec.land.name).
`surveyNumber`	TEXT	Yes		Survey number of the land (asset spec asset.spec.land.survey_number).
`accountNumber`	TEXT	Yes		Account (khata) number of the land (asset spec asset.spec.land.account_number).
`landHolderTypeOwner`	INTEGER	No		1 = owner.
`authenticated`	INTEGER	Yes		Verified land flag.
`assetChecksum`	TEXT	Yes		Content hash of a land asset. Links this row to the land before the land has a server id.
`leasedFromOwningEntityId`	TEXT	Yes		Farmer id of the owner the land is leased from (leased-in land).
`leasedToOwningEntityId`	TEXT	Yes		Farmer id the owned land is leased to.
`isLeased`	INTEGER	Yes		1 if the land is leased (from the server).
`leaseStatus`	TEXT	Yes		Lease state. New leased-in land starts as ASSET_LEASED_STATUS.PENDING.
`leaseType`	TEXT	Yes		Lease direction. New leased-in land uses ASSET_LEASED_TYPE.INCOMING.
`leasedFromAssetId`	TEXT	Yes		Server id of the owner's land this leased-in land comes from.
`leasedFromWorknodeCode`	TEXT	Yes		Code of the SHG (or VO when no SHG was chosen) used to pick the lessor farmer.
`leasedFromWorknodeType`	TEXT	Yes		Type of node used to pick the lessor farmer: "SHG" when an SHG was chosen, else "VO".
`isActive`	INTEGER	No		Soft-delete flag.
`inactiveReason`	TEXT	Yes		Reason given when the row was deactivated.
`inactiveAt`	INTEGER	Yes		When the row was deactivated (epoch millis).
`createdAt`	TEXT	Yes		Created time from the server.
`lastModifiedAt`	TEXT	Yes		Last modified time from the server.
`appCreatedAt`	TEXT	Yes		Created on device (epoch millis). Type differs between tables (TEXT vs INTEGER).
`appLastModifiedAt`	TEXT	Yes		Last modified on device (epoch millis).
`createdByApp`	INTEGER	Yes		Audit: app that created/last changed the row.
`lastModifiedByApp`	INTEGER	Yes		Audit: app that created/last changed the row.
`createdFromDevice`	TEXT	Yes		Audit: device id that created/last changed the row.
`lastUpdatedFromDevice`	TEXT	Yes		Audit: device id that created/last changed the row.
`geoFencingFileName`	TEXT	Yes		File name of the geofence polygon (KML/GeoJSON).
`geoFencingCreatedOn`	TEXT	Yes		When the geofence was captured.
`geoFencingFilePath`	TEXT	Yes		Local path of the polygon file under filesDir/geofencing/.
`geoFencingId`	INTEGER	Yes		Server attachment id of the geofence file.
`allocatedquantity_id`	INTEGER	Yes		Server id of the embedded object.
`allocatedquantity_value`	TEXT	Yes		Numeric quantity value (flattened embedded quantity).
`allocatedquantity_uomCode`	TEXT	Yes		Unit of measure detail (flattened embedded DTO).
`totalquantity_id`	INTEGER	Yes		Server id of the embedded object.
`totalquantity_value`	TEXT	Yes		Numeric quantity value (flattened embedded quantity).
`totalquantity_uomCode`	TEXT	Yes		Unit of measure detail (flattened embedded DTO).

Notes

fetchAuthenticatedAssetNames: active, authenticated assets of a category for a farmer.