asset

Column Type PK Required Default
asset_id TEXT Yes Yes
organization_id TEXT No Yes
asset_retired_date DATE No No
asset_status_id TEXT No Yes
asset_tag TEXT No Yes
name TEXT No Yes
description TEXT No Yes
asset_type_id TEXT No Yes
asset_workload_category TEXT No Yes
assignment_id TEXT No Yes
barcode_or_rfid_tag TEXT No Yes
installed_date DATE No No
planned_retirement_date DATE No No
purchase_delivery_date DATE No No
purchase_order_date DATE No No
purchase_request_date DATE No No
serial_number TEXT No Yes
tco_amount TEXT No Yes
tco_currency TEXT No Yes
criticality TEXT No No
asymmetric_keys_encryption_enabled TEXT No No
cryptographic_key_encryption_enabled TEXT No No
symmetric_keys_encryption_enabled TEXT No No
created_at TIMESTAMPTZ No No CURRENT_TIMESTAMP
created_by TEXT No No 'UNKNOWN'
updated_at TIMESTAMPTZ No No
updated_by TEXT No No
deleted_at TIMESTAMPTZ No No
deleted_by TEXT No No
activity_log TEXT No No

Foreign Keys

Column Name Foreign Key
assignment_id assignment_id references assignment.assignment_id
asset_type_id asset_type_id references asset_type.asset_type_id
asset_status_id asset_status_id references asset_status.asset_status_id
organization_id organization_id references organization.organization_id

Indexes

Column Name Index Name
asset_id sqlite_autoindex_asset_1

SQL DDL

CREATE TABLE "asset" (
    "asset_id" TEXT PRIMARY KEY NOT NULL,
    "organization_id" TEXT NOT NULL,
    "asset_retired_date" DATE,
    "asset_status_id" TEXT NOT NULL,
    "asset_tag" TEXT NOT NULL,
    "name" TEXT NOT NULL,
    "description" TEXT NOT NULL,
    "asset_type_id" TEXT NOT NULL,
    "asset_workload_category" TEXT NOT NULL,
    "assignment_id" TEXT NOT NULL,
    "barcode_or_rfid_tag" TEXT NOT NULL,
    "installed_date" DATE,
    "planned_retirement_date" DATE,
    "purchase_delivery_date" DATE,
    "purchase_order_date" DATE,
    "purchase_request_date" DATE,
    "serial_number" TEXT NOT NULL,
    "tco_amount" TEXT NOT NULL,
    "tco_currency" TEXT NOT NULL,
    "criticality" TEXT,
    "asymmetric_keys_encryption_enabled" TEXT,
    "cryptographic_key_encryption_enabled" TEXT,
    "symmetric_keys_encryption_enabled" TEXT,
    "created_at" TIMESTAMPTZ DEFAULT CURRENT_TIMESTAMP,
    "created_by" TEXT DEFAULT 'UNKNOWN',
    "updated_at" TIMESTAMPTZ,
    "updated_by" TEXT,
    "deleted_at" TIMESTAMPTZ,
    "deleted_by" TEXT,
    "activity_log" TEXT,
    FOREIGN KEY("organization_id") REFERENCES "organization"("organization_id"),
    FOREIGN KEY("asset_status_id") REFERENCES "asset_status"("asset_status_id"),
    FOREIGN KEY("asset_type_id") REFERENCES "asset_type"("asset_type_id"),
    FOREIGN KEY("assignment_id") REFERENCES "assignment"("assignment_id")
)
;