ur_ingest_session

Column	Type	PK	Required	Default
ur_ingest_session_id	TEXT	Yes	Yes
device_id	TEXT	No	Yes
behavior_id	TEXT	No	No
behavior_json	TEXT	No	No
ingest_started_at	TIMESTAMPTZ	No	Yes
ingest_finished_at	TIMESTAMPTZ	No	No
session_agent	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

Column Name	Foreign Key
behavior_id	behavior_id references behavior.behavior_id
device_id	device_id references device.device_id

Indexes

Column Name	Index Name
device_id	ur_ingest_session_device_id_created_at_unique
created_at	ur_ingest_session_device_id_created_at_unique
ur_ingest_session_id	sqlite_autoindex_ur_ingest_session_1

SQL DDL

CREATE TABLE `ur_ingest_session` (
	`ur_ingest_session_id` text PRIMARY KEY NOT NULL,
	`device_id` text NOT NULL,
	`behavior_id` text,
	`behavior_json` text,
	`ingest_started_at` TIMESTAMPTZ NOT NULL,
	`ingest_finished_at` TIMESTAMPTZ,
	`session_agent` text NOT NULL,
	`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 (`device_id`) REFERENCES `device`(`device_id`) ON UPDATE no action ON DELETE no action,
	FOREIGN KEY (`behavior_id`) REFERENCES `behavior`(`behavior_id`) ON UPDATE no action ON DELETE no action,
	CONSTRAINT "behavior_json_check_valid_json" CHECK(json_valid("ur_ingest_session"."behavior_json") OR "ur_ingest_session"."behavior_json" IS NULL),
	CONSTRAINT "session_agent_check_valid_json" CHECK(json_valid("ur_ingest_session"."session_agent") OR "ur_ingest_session"."session_agent" IS NULL),
	CONSTRAINT "elaboration_check_valid_json" CHECK(json_valid("ur_ingest_session"."elaboration") OR "ur_ingest_session"."elaboration" IS NULL)
)