ur_ingest_session_plm_acct_project

Column	Type	PK	Required	Default
ur_ingest_session_plm_acct_project_id	VARCHAR	Yes	Yes
ingest_session_id	VARCHAR	No	Yes
ingest_account_id	VARCHAR	No	Yes
parent_project_id	TEXT	No	No
name	TEXT	No	Yes
description	TEXT	No	No
id	TEXT	No	No
key	TEXT	No	No
elaboration	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
ingest_account_id	ingest_account_id references ur_ingest_session_plm_account.ur_ingest_session_plm_account_id
ingest_session_id	ingest_session_id references ur_ingest_session.ur_ingest_session_id

Indexes

Column Name	Index Name
name	idx_ur_ingest_session_plm_acct_project__name__description
description	idx_ur_ingest_session_plm_acct_project__name__description
name	sqlite_autoindex_ur_ingest_session_plm_acct_project_2
description	sqlite_autoindex_ur_ingest_session_plm_acct_project_2
ur_ingest_session_plm_acct_project_id	sqlite_autoindex_ur_ingest_session_plm_acct_project_1

SQL DDL

CREATE TABLE "ur_ingest_session_plm_acct_project" (
    "ur_ingest_session_plm_acct_project_id" VARCHAR PRIMARY KEY NOT NULL,
    "ingest_session_id" VARCHAR NOT NULL,
    "ingest_account_id" VARCHAR NOT NULL,
    "parent_project_id" TEXT,
    "name" TEXT NOT NULL,
    "description" TEXT,
    "id" TEXT,
    "key" TEXT,
    "elaboration" TEXT CHECK(json_valid(elaboration) OR elaboration IS 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("ingest_session_id") REFERENCES "ur_ingest_session"("ur_ingest_session_id"),
    FOREIGN KEY("ingest_account_id") REFERENCES "ur_ingest_session_plm_account"("ur_ingest_session_plm_account_id"),
    UNIQUE("name", "description")
)