Chapter 12. Schema evergreen

Table of Contents

Tables in evergreen
Functions in evergreen

Below are the tables, views and functions for evergreen

Tables in evergreen

mohawkstudents

  • student_id integer
  • barcode text
  • last_name text
  • first_name text
  • program_number text
  • program_name text
  • email text
  • address_type text
  • street1 text
  • street2 text
  • city text
  • province text
  • country text DEFAULT 'Canada'::text
  • postal_code text
  • phone text
  • profile integer DEFAULT 2
  • ident_type integer DEFAULT 3
  • home_ou integer DEFAULT 101
  • claims_returned_count integer
  • usrname text
  • net_access_level integer DEFAULT 2
  • password text

mohawkstudents2

  • student_id integer
  • barcode text
  • last_name text
  • first_name text
  • program_number text
  • program_name text
  • email text
  • address_type text
  • street1 text
  • street2 text
  • city text
  • province text
  • country text
  • postal_code text
  • phone text
  • profile integer
  • ident_type integer
  • home_ou integer
  • claims_returned_count integer
  • usrname text
  • net_access_level integer
  • password text