[Backend] Define Asset Entity with Full Property Set

[yusuftomilola]

The Asset entity is the core data model for the platform. It needs a rich set of fields covering identification, classification, financial data, condition tracking, and blockchain anchoring.

Required Fields

Field	Type	Notes
id	UUID PK	Auto-generated
assetId	string unique	Human-readable (e.g. AST-1001)
name	string	Required
description	text nullable
category	ManyToOne → Category
department	ManyToOne → Department
assignedTo	ManyToOne → User nullable
serialNumber	string nullable
purchaseDate	date nullable
purchasePrice	decimal(15,2) nullable
currentValue	decimal(15,2) nullable
warrantyExpiration	date nullable
status	enum: ACTIVE, ASSIGNED, MAINTENANCE, RETIRED
condition	enum: NEW, GOOD, FAIR, POOR
location	string nullable
manufacturer	string nullable
model	string nullable
barcode	string nullable
qrCode	string nullable
tags	simple-array nullable
imageUrls	simple-array nullable
customFields	jsonb nullable
notes	text nullable
stellarAssetId	string nullable	SHA-256 of UUID
stellarTxHash	string nullable
stellarStatus	enum: NOT_REGISTERED, PENDING, CONFIRMED, FAILED
createdBy	ManyToOne → User
updatedBy	ManyToOne → User
createdAt, updatedAt	timestamps

Acceptance Criteria

• Entity created with all fields and correct TypeORM decorators
• Relations use @ManyToOne with @JoinColumn
• Enums defined in a shared enums.ts file

[drips-wave]

This issue has been added to the Stellar Wave Program and is worth 200 Points.

🧑‍💻 Interested in contributing? Apply to work on this issue on Drips Wave, earn points, and receive rewards.

Warning

Only applications submitted via the apply link above will be considered. Please do not apply by commenting on the issue or opening a PR directly.

🤠 Repo maintainers: You can manage this issue's Points and Complexity on your Maintainer Dashboard here. Please keep an eye on applications and respond quickly 💙

ℹ️ Learn more about Drips Wave

[AbdulmujibOladayo]

@AbdulmujibOladayo has applied to work on this issue as part of the Stellar Wave Program's 2nd wave.

I am a fullstack software developer with multiple years experience in the industry. I can deliver on this issue in a few hours.

ℹ️ Repo Maintainers: To accept this application, review their application or assign @AbdulmujibOladayo to this issue.

[drips-wave]

Congratulations, @AbdulmujibOladayo! 🎉 Your application was accepted by the repo's maintainers, and the issue is due on February 26, 2026.

🧑‍💻 @AbdulmujibOladayo: Please resolve the issue such that the repo's maintainers have enough time to review your contribution before the due date. You'll earn Points for completing the issue on-time, which will make you eligible for a share of the Stellar Wave Program's reward pool.

Warning

When opening a PR, please link it to this issue to ensure it gets tracked accurately. Points are issued when this issue is marked as completed by the maintainer.

🤠 Repo maintainers: Please keep an eye on the contributor's progress and review their work before the due date. You can manage this issue, including adjusting its complexity and points, here.

🌊 Happy Wave 🌊

[drips-wave]

This issue has been completed by @AbdulmujibOladayo as part of the Stellar Wave Program's 2nd Wave 🥳

😎 @AbdulmujibOladayo: You earned 200 Points for completing this issue! After the current Wave ends, you'll be eligible for a percentage of the Wave's reward pool based on the percentage of total points you've earned. Learn more here. You can also Leave a review to share your experience working on this issue.

🧑‍💻 Repo maintainers: How'd the contributor do? Leave a review to share your experience working with them.