Files
gupi-osint-board/migrations/037_note_presentation.sql

7 lines
330 B
SQL

ALTER TABLE osint.note_exhibits
ADD COLUMN presentation_kind TEXT NOT NULL DEFAULT 'luggage'
CHECK (presentation_kind IN ('luggage', 'lined_sheet'));
COMMENT ON COLUMN osint.note_exhibits.presentation_kind IS
'Visual presentation of a note exhibit. Notebook tear-outs use lined_sheet; ordinary working notes use luggage.';