5 lines
358 B
SQL
5 lines
358 B
SQL
|
-- Evidence IDs identify the historical source, while KB IDs identify a version.
|
||
|
|
-- Preserve those IDs in independent personal, review and published knowledge bases.
|
||
|
|
ALTER TABLE native_graph_records DROP CONSTRAINT IF EXISTS native_graph_records_pkey;
|
||
|
|
ALTER TABLE native_graph_records ADD PRIMARY KEY (tenant_id, knowledge_base_id, source_table, legacy_id);
|