Dean
/
Bookdata-tools
mirror of https://github.com/BoiseState/bookdata-tools


  
1

	
2

	
3

	
4

	
5

	
6

	
7

	
8

	
9

	
10

	
11

	
12

	
13

	
14

	
15

	
16

	
17

	
18

	
19

	
20

	
21

	
22

	
23

	
24

	
25

	
26

	
27

	
28

	
29

	
30

	
31

	
32

	
33

	
34

	
35

	
36

	
37

	
38

	
39

	
40

	
            --- #dep common-schema
--- #table locmds.book_marc_field
--- #table locmds.name_marc_field

CREATE SCHEMA IF NOT EXISTS locmds;

DROP TABLE IF EXISTS locmds.book_marc_field CASCADE;
CREATE TABLE locmds.book_marc_field (
  rec_id INTEGER NOT NULL,
  fld_no INTEGER NOT NULL,
  tag VARCHAR NOT NULL,
  ind1 VARCHAR,
  ind2 VARCHAR,
  sf_code VARCHAR,
  contents VARCHAR
);

DROP VIEW IF EXISTS locmds.book_raw_isbn CASCADE;
CREATE VIEW locmds.book_raw_isbn
AS SELECT rec_id, trim(contents) AS isbn_text
   FROM locmds.book_marc_field
   WHERE tag = '020' AND sf_code = 'a';

DROP TABLE IF EXISTS locmds.book_extracted_isbn CASCADE;
CREATE TABLE locmds.book_extracted_isbn (
  rec_id INTEGER NOT NULL,
  isbn VARCHAR NOT NULL,
  isbn_tag VARCHAR
);

DROP TABLE IF EXISTS locmds.name_marc_field CASCADE;
CREATE TABLE locmds.name_marc_field (
  rec_id INTEGER NOT NULL,
  fld_no INTEGER NOT NULL,
  tag VARCHAR NOT NULL,
  ind1 VARCHAR,
  ind2 VARCHAR,
  sf_code VARCHAR,
  contents VARCHAR
);