asset_boundary

Column Type PK Required Default
asset_boundary_id TEXT Yes Yes
asset_id TEXT No Yes
boundary_id 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
boundary_id boundary_id references boundary.boundary_id
asset_id asset_id references asset.asset_id

Indexes

Column Name Index Name
asset_boundary_id sqlite_autoindex_asset_boundary_1

SQL DDL

CREATE TABLE "asset_boundary" (
    "asset_boundary_id" TEXT PRIMARY KEY NOT NULL,
    "asset_id" TEXT NOT NULL,
    "boundary_id" 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("boundary_id") REFERENCES "boundary"("boundary_id")
)
;