graph

Column Type PK Required Default
graph_id TEXT Yes Yes
graph_nature_id TEXT No Yes
name TEXT No Yes
description 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
graph_nature_id graph_nature_id references graph_nature.graph_nature_id

Indexes

Column Name Index Name
graph_id sqlite_autoindex_graph_1

SQL DDL

CREATE TABLE "graph" (
    "graph_id" TEXT PRIMARY KEY NOT NULL,
    "graph_nature_id" TEXT NOT NULL,
    "name" TEXT NOT NULL,
    "description" 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("graph_nature_id") REFERENCES "graph_nature"("graph_nature_id")
)
;