ur_ingest_session_plm_acct_relationship
| Column |
Type |
PK |
Required |
Default |
| ur_ingest_session_plm_acct_relationship_id |
VARCHAR |
Yes |
Yes |
|
| ur_ingest_session_plm_acct_project_id_prime |
VARCHAR |
No |
Yes |
|
| ur_ingest_session_plm_acct_project_id_related |
TEXT |
No |
Yes |
|
| ur_ingest_session_plm_acct_project_issue_id_prime |
VARCHAR |
No |
Yes |
|
| ur_ingest_session_plm_acct_project_issue_id_related |
TEXT |
No |
Yes |
|
| relationship |
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 |
| ur_ingest_session_plm_acct_project_issue_id_prime |
ur_ingest_session_plm_acct_project_issue_id_prime references ur_ingest_session_plm_acct_project_issue.ur_ingest_session_plm_acct_project_issue_id |
| ur_ingest_session_plm_acct_project_id_prime |
ur_ingest_session_plm_acct_project_id_prime references ur_ingest_session_plm_acct_project.ur_ingest_session_plm_acct_project_id |
Indexes
| Column Name |
Index Name |
| ur_ingest_session_plm_acct_project_id_prime |
idx_ur_ingest_session_plm_acct_relationship__ur_ingest_session_plm_acct_project_id_prime |
| ur_ingest_session_plm_acct_relationship_id |
sqlite_autoindex_ur_ingest_session_plm_acct_relationship_1 |
SQL DDL
CREATE TABLE "ur_ingest_session_plm_acct_relationship" (
"ur_ingest_session_plm_acct_relationship_id" VARCHAR PRIMARY KEY NOT NULL,
"ur_ingest_session_plm_acct_project_id_prime" VARCHAR NOT NULL,
"ur_ingest_session_plm_acct_project_id_related" TEXT NOT NULL,
"ur_ingest_session_plm_acct_project_issue_id_prime" VARCHAR NOT NULL,
"ur_ingest_session_plm_acct_project_issue_id_related" TEXT NOT NULL,
"relationship" 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("ur_ingest_session_plm_acct_project_id_prime") REFERENCES "ur_ingest_session_plm_acct_project"("ur_ingest_session_plm_acct_project_id"),
FOREIGN KEY("ur_ingest_session_plm_acct_project_issue_id_prime") REFERENCES "ur_ingest_session_plm_acct_project_issue"("ur_ingest_session_plm_acct_project_issue_id")
)