Chapter 18. Schema public

Table of Contents

Tables in public
Functions in public

Below are the tables, views and functions for public

Tables in public

authdupes

  • id integer
  • heading text

before_1980

  • record bigint
  • ltrim text

billingtest

  • usr integer
  • sum numeric
  • usrname text

circ_mod_count

  • campus text
  • circ_modifier text
  • count bigint

iahs_callnums_titles

  • label text
  • value text

iahs_canada

  • label text
  • value text

items_1980_89

  • record bigint
  • ltrim text

mat_sum

  • usr integer
  • usrname text
  • balance_owed numeric

money_totals

  • balanced owed numeric
  • total owed numeric
  • paid numeric

pg_ts_cfg

  • ts_name text PRIMARY KEY
  • prs_name text NOT NULL
  • locale text

pg_ts_cfgmap

  • ts_name text PRIMARY KEY
  • tok_alias text PRIMARY KEY
  • dict_name text[]

pg_ts_dict

  • dict_name text PRIMARY KEY
  • dict_init regprocedure
  • dict_initoption text
  • dict_lexize regprocedure NOT NULL
  • dict_comment text

pg_ts_parser

  • prs_name text PRIMARY KEY
  • prs_start regprocedure NOT NULL
  • prs_nexttoken regprocedure NOT NULL
  • prs_end regprocedure NOT NULL
  • prs_headline regprocedure NOT NULL
  • prs_lextype regprocedure NOT NULL
  • prs_comment text

pre_1980_items

  • campus text
  • title text
  • call number text
  • year text

record_title

  • record bigint
  • value text

titles_80_to_89

  • campus text
  • title text
  • call number text
  • year text

user_financial_summary

  • usrname text
  • total_owed numeric
  • total_paid numeric
  • balance_owed numeric

weblinks

  • RecordID serial PRIMARY KEY
  • Title text
  • Creator text
  • URL text
  • Access text
  • FullText text
  • Date date
  • DescriptionShort text
  • DescriptionLong text
  • Publisher text
  • NumberOfUsers text
  • Tutorial text
  • SubjectKeywords text
  • SubjectLCSH text
  • SubjectCategories text
  • JointCategory text
  • ResourceTypes text
  • Coverage text
  • CanadianContent text
  • RightsManagement text
  • Notes text
  • DateCreated date
  • DateModified date
  • MohawkOnly text
  • Course text
  • KeySite text
  • ScholarlySite text
  • Cataloguer text
  • EditedBy text