ur_ingest_session_plm_acct_project_issue

Column	Type	PK	Required	Default
ur_ingest_session_plm_acct_project_issue_id	TEXT	Yes	Yes
ingest_session_id	TEXT	No	Yes
ur_ingest_session_plm_acct_project_id	TEXT	No	Yes
uniform_resource_id	TEXT	No	No
issue_id	TEXT	No	Yes
issue_number	INTEGER	No	No
parent_issue_id	TEXT	No	No
title	TEXT	No	Yes
body	TEXT	No	No
body_text	TEXT	No	No
body_html	TEXT	No	No
state	TEXT	No	Yes
assigned_to	TEXT	No	No
user	TEXT	No	Yes
url	TEXT	No	Yes
closed_at	TEXT	No	No
issue_type_id	TEXT	No	No
time_estimate	INTEGER	No	No
aggregate_time_estimate	INTEGER	No	No
time_original_estimate	INTEGER	No	No
time_spent	INTEGER	No	No
aggregate_time_spent	INTEGER	No	No
aggregate_time_original_estimate	INTEGER	No	No
workratio	INTEGER	No	No
current_progress	INTEGER	No	No
total_progress	INTEGER	No	No
resolution_name	TEXT	No	No
resolution_date	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
issue_type_id	issue_type_id references ur_ingest_session_plm_issue_type.ur_ingest_session_plm_issue_type_id
user	user references ur_ingest_session_plm_user.ur_ingest_session_plm_user_id
uniform_resource_id	uniform_resource_id references uniform_resource.uniform_resource_id
ur_ingest_session_plm_acct_project_id	ur_ingest_session_plm_acct_project_id references ur_ingest_session_plm_acct_project.ur_ingest_session_plm_acct_project_id
ingest_session_id	ingest_session_id references ur_ingest_session.ur_ingest_session_id

Indexes

Column Name	Index Name
title	ur_ingest_session_plm_acct_project_issue_title_issue_id_state_assigned_to_unique
issue_id	ur_ingest_session_plm_acct_project_issue_title_issue_id_state_assigned_to_unique
state	ur_ingest_session_plm_acct_project_issue_title_issue_id_state_assigned_to_unique
assigned_to	ur_ingest_session_plm_acct_project_issue_title_issue_id_state_assigned_to_unique
title	idx_ur_ingest_session_plm_acct_project_issue__title__issue_id__state__assigned_to
issue_id	idx_ur_ingest_session_plm_acct_project_issue__title__issue_id__state__assigned_to
state	idx_ur_ingest_session_plm_acct_project_issue__title__issue_id__state__assigned_to
assigned_to	idx_ur_ingest_session_plm_acct_project_issue__title__issue_id__state__assigned_to
ur_ingest_session_plm_acct_project_issue_id	sqlite_autoindex_ur_ingest_session_plm_acct_project_issue_1

SQL DDL

CREATE TABLE `ur_ingest_session_plm_acct_project_issue` (
	`ur_ingest_session_plm_acct_project_issue_id` text PRIMARY KEY NOT NULL,
	`ingest_session_id` text NOT NULL,
	`ur_ingest_session_plm_acct_project_id` text NOT NULL,
	`uniform_resource_id` text,
	`issue_id` text NOT NULL,
	`issue_number` integer,
	`parent_issue_id` text,
	`title` text NOT NULL,
	`body` text,
	`body_text` text,
	`body_html` text,
	`state` text NOT NULL,
	`assigned_to` text,
	`user` text NOT NULL,
	`url` text NOT NULL,
	`closed_at` text,
	`issue_type_id` text,
	`time_estimate` integer,
	`aggregate_time_estimate` integer,
	`time_original_estimate` integer,
	`time_spent` integer,
	`aggregate_time_spent` integer,
	`aggregate_time_original_estimate` integer,
	`workratio` integer,
	`current_progress` integer,
	`total_progress` integer,
	`resolution_name` text,
	`resolution_date` 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 (`ingest_session_id`) REFERENCES `ur_ingest_session`(`ur_ingest_session_id`) ON UPDATE no action ON DELETE no action,
	FOREIGN KEY (`ur_ingest_session_plm_acct_project_id`) REFERENCES `ur_ingest_session_plm_acct_project`(`ur_ingest_session_plm_acct_project_id`) ON UPDATE no action ON DELETE no action,
	FOREIGN KEY (`uniform_resource_id`) REFERENCES `uniform_resource`(`uniform_resource_id`) ON UPDATE no action ON DELETE no action,
	FOREIGN KEY (`user`) REFERENCES `ur_ingest_session_plm_user`(`ur_ingest_session_plm_user_id`) ON UPDATE no action ON DELETE no action,
	FOREIGN KEY (`issue_type_id`) REFERENCES `ur_ingest_session_plm_issue_type`(`ur_ingest_session_plm_issue_type_id`) ON UPDATE no action ON DELETE no action
)