party_relation

Column	Type	PK	Required	Default
party_relation_id	VARCHAR	Yes	Yes
party_id	TEXT	No	Yes
related_party_id	TEXT	No	Yes
relation_type_id	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
relation_type_id	relation_type_id references party_relation_type.party_relation_type_id
related_party_id	related_party_id references party.party_id
party_id	party_id references party.party_id

Indexes

Column Name	Index Name
party_id	party_relation_party_id_related_party_id_relation_type_id_unique
related_party_id	party_relation_party_id_related_party_id_relation_type_id_unique
relation_type_id	party_relation_party_id_related_party_id_relation_type_id_unique
party_id	idx_party_relation__party_id__related_party_id__relation_type_id
related_party_id	idx_party_relation__party_id__related_party_id__relation_type_id
relation_type_id	idx_party_relation__party_id__related_party_id__relation_type_id
party_relation_id	sqlite_autoindex_party_relation_1

SQL DDL

CREATE TABLE `party_relation` (
	`party_relation_id` VARCHAR PRIMARY KEY NOT NULL,
	`party_id` text NOT NULL,
	`related_party_id` text NOT NULL,
	`relation_type_id` 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 (`party_id`) REFERENCES `party`(`party_id`) ON UPDATE no action ON DELETE no action,
	FOREIGN KEY (`related_party_id`) REFERENCES `party`(`party_id`) ON UPDATE no action ON DELETE no action,
	FOREIGN KEY (`relation_type_id`) REFERENCES `party_relation_type`(`party_relation_type_id`) ON UPDATE no action ON DELETE no action,
	CONSTRAINT "elaboration_check_valid_json" CHECK(json_valid("party_relation"."elaboration") OR "party_relation"."elaboration" IS NULL)
)