asset_service_status

Column Type PK Required Default
asset_service_status_id TEXT Yes Yes
code TEXT No Yes
value 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

No data

Indexes

Column Name Index Name
code sqlite_autoindex_asset_service_status_2
asset_service_status_id sqlite_autoindex_asset_service_status_1

SQL DDL

CREATE TABLE "asset_service_status" (
    "asset_service_status_id" TEXT PRIMARY KEY NOT NULL,
    "code" TEXT /* UNIQUE COLUMN */ NOT NULL,
    "value" 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,
    UNIQUE("code")
)
;