Skip to content

Uniform Resource Ingest Session PLM Issue Type

Description

Table Definition
CREATE TABLE "ur_ingest_session_plm_issue_type" (
"ur_ingest_session_plm_issue_type_id" VARCHAR PRIMARY KEY NOT NULL,
"avatar_id" TEXT,
"description" TEXT NOT NULL,
"icon_url" TEXT NOT NULL,
"id" TEXT NOT NULL,
"name" TEXT NOT NULL,
"subtask" BOOLEAN NOT NULL,
"url" TEXT NOT NULL,
"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,
UNIQUE("id", "name")
)

Columns

NameTypeDefaultNullableChildrenComment
ur_ingest_session_plm_issue_type_idVARCHARfalseur_ingest_session_plm_acct_project_issue{“isSqlDomainZodDescrMeta”:true,“isVarChar”:true}
avatar_idTEXTtrue
descriptionTEXTfalse
icon_urlTEXTfalse
idTEXTfalse
nameTEXTfalse
subtaskBOOLEANfalse
urlTEXTfalse
elaborationTEXTtrue{“isSqlDomainZodDescrMeta”:true,“isJsonText”:true}
created_atTIMESTAMPTZCURRENT_TIMESTAMPtrue
created_byTEXT’UNKNOWN’true
updated_atTIMESTAMPTZtrue
updated_byTEXTtrue
deleted_atTIMESTAMPTZtrue
deleted_byTEXTtrue
activity_logTEXTtrue{“isSqlDomainZodDescrMeta”:true,“isJsonSqlDomain”:true}

Constraints

NameTypeDefinition
ur_ingest_session_plm_issue_type_idPRIMARY KEYPRIMARY KEY (ur_ingest_session_plm_issue_type_id)
sqlite_autoindex_ur_ingest_session_plm_issue_type_2UNIQUEUNIQUE (id, name)
sqlite_autoindex_ur_ingest_session_plm_issue_type_1PRIMARY KEYPRIMARY KEY (ur_ingest_session_plm_issue_type_id)
-CHECKCHECK(json_valid(elaboration) OR elaboration IS NULL)

Indexes

NameDefinition
idx_ur_ingest_session_plm_issue_type__idCREATE INDEX “idx_ur_ingest_session_plm_issue_type__id” ON “ur_ingest_session_plm_issue_type”(“id”)
sqlite_autoindex_ur_ingest_session_plm_issue_type_2UNIQUE (id, name)
sqlite_autoindex_ur_ingest_session_plm_issue_type_1PRIMARY KEY (ur_ingest_session_plm_issue_type_id)

Relations

er