17 lines
663 B
SQL
17 lines
663 B
SQL
|
-- Create documentFieldExtractionVersions table for version tracking
|
||
|
|
CREATE TABLE documentFieldExtractionVersions (
|
||
|
|
id uuid PRIMARY KEY DEFAULT uuid_generate_v7(),
|
||
|
|
fieldExtractionId uuid NOT NULL,
|
||
|
|
version bigint NOT NULL,
|
||
|
|
createdBy varchar(255) NOT NULL,
|
||
|
|
createdAt timestamp NOT NULL DEFAULT NOW(),
|
||
|
|
|
||
|
|
FOREIGN KEY (fieldExtractionId) REFERENCES documentFieldExtractions(id)
|
||
|
|
);
|
||
|
|
|
||
|
|
-- Indexes for version queries
|
||
|
|
CREATE INDEX idx_documentfieldextractionversions_fieldextractionid
|
||
|
|
ON documentFieldExtractionVersions(fieldExtractionId);
|
||
|
|
CREATE INDEX idx_documentfieldextractionversions_version
|
||
|
|
ON documentFieldExtractionVersions(version);
|