Guest User

table def

a guest
Jun 4th, 2013
132
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. CREATE TABLE config.record_attr_definition (
  2.     name        TEXT    PRIMARY KEY,
  3.     label       TEXT    NOT NULL, -- I18N
  4.     description TEXT,
  5.     FILTER      BOOL    NOT NULL DEFAULT TRUE,  -- becomes QP filter if true
  6.     sorter      BOOL    NOT NULL DEFAULT FALSE, -- becomes QP sort() axis if true
  7.  
  8. -- For pre-extracted fields. Takes the first occurance, uses naive subfield ordering
  9.     tag         TEXT, -- LIKE format
  10.     sf_list     TEXT, -- pile-o-values, like 'abcd' for a and b and c and d
  11.  
  12. -- This is used for both tag/sf and xpath entries
  13.     joiner      TEXT,
  14.  
  15. -- For xpath-extracted attrs
  16.     xpath       TEXT,
  17.     format      TEXT    REFERENCES config.xml_transform (name) ON DELETE CASCADE DEFERRABLE INITIALLY DEFERRED,
  18.     start_pos   INT,
  19.     string_len  INT,
  20.  
  21. -- For fixed fields
  22.     fixed_field TEXT, -- should exist in config.marc21_ff_pos_map.fixed_field
  23.  
  24. -- For phys-char fields
  25.     phys_char_sf    INT REFERENCES config.marc21_physical_characteristic_subfield_map (id)
  26. );
RAW Paste Data