ur_ingest_session_plm_acct_project_issue
| Column |
Type |
PK |
Required |
Default |
| ur_ingest_session_plm_acct_project_issue_id |
VARCHAR |
Yes |
Yes |
|
| ingest_session_id |
VARCHAR |
No |
Yes |
|
| ur_ingest_session_plm_acct_project_id |
VARCHAR |
No |
Yes |
|
| uniform_resource_id |
VARCHAR |
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 |
VARCHAR |
No |
Yes |
|
| url |
TEXT |
No |
Yes |
|
| closed_at |
TEXT |
No |
No |
|
| issue_type_id |
VARCHAR |
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 |
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 |
| title |
sqlite_autoindex_ur_ingest_session_plm_acct_project_issue_2 |
| issue_id |
sqlite_autoindex_ur_ingest_session_plm_acct_project_issue_2 |
| state |
sqlite_autoindex_ur_ingest_session_plm_acct_project_issue_2 |
| assigned_to |
sqlite_autoindex_ur_ingest_session_plm_acct_project_issue_2 |
| 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" VARCHAR PRIMARY KEY NOT NULL,
"ingest_session_id" VARCHAR NOT NULL,
"ur_ingest_session_plm_acct_project_id" VARCHAR NOT NULL,
"uniform_resource_id" VARCHAR,
"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" VARCHAR NOT NULL,
"url" TEXT NOT NULL,
"closed_at" TEXT,
"issue_type_id" VARCHAR,
"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 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("ur_ingest_session_plm_acct_project_id") REFERENCES "ur_ingest_session_plm_acct_project"("ur_ingest_session_plm_acct_project_id"),
FOREIGN KEY("uniform_resource_id") REFERENCES "uniform_resource"("uniform_resource_id"),
FOREIGN KEY("user") REFERENCES "ur_ingest_session_plm_user"("ur_ingest_session_plm_user_id"),
FOREIGN KEY("issue_type_id") REFERENCES "ur_ingest_session_plm_issue_type"("ur_ingest_session_plm_issue_type_id"),
UNIQUE("title", "issue_id", "state", "assigned_to")
)