ur_ingest_session_plm_user

Column	Type	PK	Required	Default
ur_ingest_session_plm_user_id	VARCHAR	Yes	Yes
user_id	TEXT	No	Yes
login	TEXT	No	Yes
email	TEXT	No	No
name	TEXT	No	No
url	TEXT	No	Yes
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

No data

Indexes

Column Name	Index Name
user_id	idx_ur_ingest_session_plm_user__user_id__login
login	idx_ur_ingest_session_plm_user__user_id__login
user_id	sqlite_autoindex_ur_ingest_session_plm_user_2
login	sqlite_autoindex_ur_ingest_session_plm_user_2
ur_ingest_session_plm_user_id	sqlite_autoindex_ur_ingest_session_plm_user_1

SQL DDL

CREATE TABLE "ur_ingest_session_plm_user" (
    "ur_ingest_session_plm_user_id" VARCHAR PRIMARY KEY NOT NULL,
    "user_id" TEXT NOT NULL,
    "login" TEXT NOT NULL,
    "email" TEXT,
    "name" TEXT,
    "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("user_id", "login")
)