Evergreen
HomePrev   Next

Chapter 11. Schema container

Table of Contents

Tables in container
Functions in container

Below are the tables, views and functions for container

Tables in container

biblio_record_entry_bucket

  • id serial PRIMARY KEY
  • owner integer UNIQUE #1 NOT NULL REFERENCES actor.table.usr
  • name text UNIQUE #1 NOT NULL
  • btype text UNIQUE #1 NOT NULL DEFAULT 'misc'::text
  • pub boolean NOT NULL DEFAULT false
  • create_time timestamp with time zone NOT NULL DEFAULT now()
  • description text

Tables referencing via foreign key constraints

biblio_record_entry_bucket_item

  • id serial PRIMARY KEY
  • bucket integer NOT NULL REFERENCES container.table.biblio-record-entry-bucket
  • target_biblio_record_entry bigint NOT NULL REFERENCES biblio.table.record-entry
  • create_time timestamp with time zone NOT NULL DEFAULT now()
  • pos integer

Indexes on biblio_record_entry_bucket_item

  • biblio_record_entry_bucket_item_bucket_idx bucket

Tables referencing via foreign key constraints

biblio_record_entry_bucket_item_note

  • id serial PRIMARY KEY
  • item integer NOT NULL REFERENCES container.table.biblio-record-entry-bucket-item
  • note text NOT NULL

biblio_record_entry_bucket_note

  • id serial PRIMARY KEY
  • bucket integer NOT NULL REFERENCES container.table.biblio-record-entry-bucket
  • note text NOT NULL

biblio_record_entry_bucket_type

  • code text PRIMARY KEY
  • label text UNIQUE NOT NULL

call_number_bucket

  • id serial PRIMARY KEY
  • owner integer UNIQUE #1 NOT NULL REFERENCES actor.table.usr
  • name text UNIQUE #1 NOT NULL
  • btype text UNIQUE #1 NOT NULL DEFAULT 'misc'::text
  • pub boolean NOT NULL DEFAULT false
  • create_time timestamp with time zone NOT NULL DEFAULT now()
  • description text

Tables referencing via foreign key constraints

call_number_bucket_item

  • id serial PRIMARY KEY
  • bucket integer NOT NULL REFERENCES container.table.call-number-bucket
  • target_call_number integer NOT NULL REFERENCES asset.table.call-number
  • create_time timestamp with time zone NOT NULL DEFAULT now()
  • pos integer

Indexes on call_number_bucket_item

  • call_number_bucket_item_bucket_idx bucket

Tables referencing via foreign key constraints

call_number_bucket_item_note

  • id serial PRIMARY KEY
  • item integer NOT NULL REFERENCES container.table.call-number-bucket-item
  • note text NOT NULL

call_number_bucket_note

  • id serial PRIMARY KEY
  • bucket integer NOT NULL REFERENCES container.table.call-number-bucket
  • note text NOT NULL

call_number_bucket_type

  • code text PRIMARY KEY
  • label text UNIQUE NOT NULL

copy_bucket

  • id serial PRIMARY KEY
  • owner integer UNIQUE #1 NOT NULL REFERENCES actor.table.usr
  • name text UNIQUE #1 NOT NULL
  • btype text UNIQUE #1 NOT NULL DEFAULT 'misc'::text
  • pub boolean NOT NULL DEFAULT false
  • create_time timestamp with time zone NOT NULL DEFAULT now()
  • description text

Tables referencing via foreign key constraints

copy_bucket_item

  • id serial PRIMARY KEY
  • bucket integer NOT NULL REFERENCES container.table.copy-bucket
  • target_copy integer NOT NULL REFERENCES asset.table.copy
  • create_time timestamp with time zone NOT NULL DEFAULT now()
  • pos integer

Indexes on copy_bucket_item

  • copy_bucket_item_bucket_idx bucket

Tables referencing via foreign key constraints

copy_bucket_item_note

  • id serial PRIMARY KEY
  • item integer NOT NULL REFERENCES container.table.copy-bucket-item
  • note text NOT NULL

copy_bucket_note

  • id serial PRIMARY KEY
  • bucket integer NOT NULL REFERENCES container.table.copy-bucket
  • note text NOT NULL

copy_bucket_type

  • code text PRIMARY KEY
  • label text UNIQUE NOT NULL

user_bucket

  • id serial PRIMARY KEY
  • owner integer UNIQUE #1 NOT NULL REFERENCES actor.table.usr
  • name text UNIQUE #1 NOT NULL
  • btype text UNIQUE #1 NOT NULL DEFAULT 'misc'::text
  • pub boolean NOT NULL DEFAULT false
  • create_time timestamp with time zone NOT NULL DEFAULT now()
  • description text

Tables referencing via foreign key constraints

user_bucket_item

  • id serial PRIMARY KEY
  • bucket integer NOT NULL REFERENCES container.table.user-bucket
  • target_user integer NOT NULL REFERENCES actor.table.usr
  • create_time timestamp with time zone NOT NULL DEFAULT now()
  • pos integer

Indexes on user_bucket_item

  • user_bucket_item_bucket_idx bucket
  • user_bucket_item_target_user_idx target_user

Tables referencing via foreign key constraints

user_bucket_item_note

  • id serial PRIMARY KEY
  • item integer NOT NULL REFERENCES container.table.user-bucket-item
  • note text NOT NULL

user_bucket_note

  • id serial PRIMARY KEY
  • bucket integer NOT NULL REFERENCES container.table.user-bucket
  • note text NOT NULL

user_bucket_type

  • code text PRIMARY KEY
  • label text UNIQUE NOT NULL
Prev   Next
Functions in config Home Functions in container