ur_ingest_session_plm_acct_relationship

Column	Type	PK	Required	Default
ur_ingest_session_plm_acct_relationship_id	TEXT	Yes	Yes
ur_ingest_session_plm_acct_project_id_prime	TEXT	No	Yes
ur_ingest_session_plm_acct_project_id_related	TEXT	No	Yes
ur_ingest_session_plm_acct_project_issue_id_prime	TEXT	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` text PRIMARY KEY NOT NULL,
	`ur_ingest_session_plm_acct_project_id_prime` text NOT NULL,
	`ur_ingest_session_plm_acct_project_id_related` text NOT NULL,
	`ur_ingest_session_plm_acct_project_issue_id_prime` text NOT NULL,
	`ur_ingest_session_plm_acct_project_issue_id_related` text NOT NULL,
	`relationship` text,
	`elaboration` 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 (`ur_ingest_session_plm_acct_project_id_prime`) REFERENCES `ur_ingest_session_plm_acct_project`(`ur_ingest_session_plm_acct_project_id`) ON UPDATE no action ON DELETE no action,
	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`) ON UPDATE no action ON DELETE no action
)