asset_service

Column Type PK Required Default
asset_service_id TEXT Yes Yes
asset_id TEXT No Yes
asset_service_type_id TEXT No Yes
name TEXT No Yes
description TEXT No Yes
asset_service_status_id TEXT No Yes
port TEXT No Yes
experimental_version TEXT No Yes
production_version TEXT No Yes
latest_vendor_version TEXT No Yes
resource_utilization TEXT No Yes
log_file TEXT No Yes
url TEXT No Yes
vendor_link TEXT No Yes
installation_date DATE No No
criticality TEXT No Yes
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
asset_service_status_id asset_service_status_id references asset_service_status.asset_service_status_id
asset_service_type_id asset_service_type_id references asset_service_type.asset_service_type_id
asset_id asset_id references asset.asset_id

Indexes

Column Name Index Name
asset_service_id sqlite_autoindex_asset_service_1

SQL DDL

CREATE TABLE "asset_service" (
    "asset_service_id" TEXT PRIMARY KEY NOT NULL,
    "asset_id" TEXT NOT NULL,
    "asset_service_type_id" TEXT NOT NULL,
    "name" TEXT NOT NULL,
    "description" TEXT NOT NULL,
    "asset_service_status_id" TEXT NOT NULL,
    "port" TEXT NOT NULL,
    "experimental_version" TEXT NOT NULL,
    "production_version" TEXT NOT NULL,
    "latest_vendor_version" TEXT NOT NULL,
    "resource_utilization" TEXT NOT NULL,
    "log_file" TEXT NOT NULL,
    "url" TEXT NOT NULL,
    "vendor_link" TEXT NOT NULL,
    "installation_date" DATE,
    "criticality" TEXT NOT NULL,
    "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("asset_id") REFERENCES "asset"("asset_id"),
    FOREIGN KEY("asset_service_type_id") REFERENCES "asset_service_type"("asset_service_type_id"),
    FOREIGN KEY("asset_service_status_id") REFERENCES "asset_service_status"("asset_service_status_id")
)
;