14 lines
560 B
SQL
14 lines
560 B
SQL
CREATE TABLE IF NOT EXISTS documents
|
|
(
|
|
id SERIAL PRIMARY KEY,
|
|
name TEXT NOT NULL,
|
|
id_file UUID UNIQUE NOT NULL,
|
|
fingerprint TEXT UNIQUE NOT NULL,
|
|
created_at TIMESTAMP WITHOUT TIME ZONE NOT NULL DEFAULT now(),
|
|
updated_at TIMESTAMP WITHOUT TIME ZONE NOT NULL DEFAULT now(),
|
|
deleted_at TIMESTAMP WITHOUT TIME ZONE
|
|
);
|
|
|
|
-- Crea un indice su deleted_at per il supporto soft delete
|
|
CREATE INDEX IF NOT EXISTS idx_documents_deleted_at ON documents (deleted_at);
|