Skip to content
Snippets Groups Projects
structure.sql 62.2 KiB
Newer Older
  • Learn to ignore specific revisions
  • Damien's avatar
    Damien committed
    filename CHARACTER VARYING(256) NOT NULL,
    
    Damien's avatar
    Damien committed
    fingerprint CHARACTER VARYING(256) NOT NULL,
    
    Damien's avatar
    Damien committed
    CONSTRAINT acknowledgment_receipts_pkey PRIMARY KEY (id)
    )
    WITH (OIDS=FALSE);
    
    
    CREATE TABLE custom_fields
    (
      id serial NOT NULL,
      label character varying(256) NOT NULL,
      type character varying(256) NOT NULL,
      values jsonb,
      CONSTRAINT custom_fields_pkey PRIMARY KEY (id),
      CONSTRAINT custom_fields_unique_key UNIQUE (label)
    )
    WITH (OIDS=FALSE);