kivitendo/sql/Pg-upgrade2/files.sql @ 7b1da9c3
| 2bb452ee | Martin Helmling | -- @tag: files
|
||
-- @description: Tabelle für Files
|
||||
| 23cfb53f | Werner Hahn | -- @depends: release_3_4_1
|
||
| 2bb452ee | Martin Helmling | CREATE TABLE files(
|
||
id SERIAL PRIMARY KEY,
|
||||
object_type TEXT NOT NULL, -- Tabellenname des Moduls z.B. customer, parts ... Fremdschlüssel Zusammen mit object_id
|
||||
object_id INTEGER NOT NULL, -- Fremdschlüssel auf die id der Tabelle aus Spalte object_type
|
||||
| 23cfb53f | Werner Hahn | file_name TEXT NOT NULL,
|
||
file_type TEXT NOT NULL,
|
||||
| 2bb452ee | Martin Helmling | mime_type TEXT NOT NULL,
|
||
| 23cfb53f | Werner Hahn | source TEXT NOT NULL,
|
||
| 2bb452ee | Martin Helmling | backend TEXT,
|
||
| 23cfb53f | Werner Hahn | backend_data TEXT,
|
||
| 2bb452ee | Martin Helmling | title varchar(45),
|
||
| 23cfb53f | Werner Hahn | description TEXT,
|
||
| 2bb452ee | Martin Helmling | itime TIMESTAMP DEFAULT now(),
|
||
mtime TIMESTAMP,
|
||||
CONSTRAINT valid_type CHECK (
|
||||
(object_type = 'credit_note') OR (object_type = 'invoice') OR (object_type = 'sales_order') OR (object_type = 'sales_quotation')
|
||||
OR (object_type = 'sales_delivery_order') OR (object_type = 'request_quotation') OR (object_type = 'purchase_order')
|
||||
| 23cfb53f | Werner Hahn | OR (object_type = 'purchase_delivery_order') OR (object_type = 'purchase_invoice')
|
||
OR (object_type = 'vendor') OR (object_type = 'customer') OR (object_type = 'part') OR (object_type = 'gl_transaction')
|
||||
| 2bb452ee | Martin Helmling | OR (object_type = 'dunning') OR (object_type = 'dunning1') OR (object_type = 'dunning2') OR (object_type = 'dunning3')
|
||
OR (object_type = 'draft') OR (object_type = 'statement'))
|
||||
);
|