Chapter 16. Schema offline

Table of Contents

Tables in offline
script
session

Below are the tables, views and functions for offline

Tables in offline

script

  • id serial PRIMARY KEY
  • session text NOT NULL
  • requestor integer NOT NULL
  • create_time integer NOT NULL
  • workstation text NOT NULL
  • logfile text NOT NULL
  • time_delta integer NOT NULL
  • count integer NOT NULL

Indexes on script

  • offline_script_pkey id
  • offline_script_session session
  • offline_script_ws workstation

session

  • key text PRIMARY KEY
  • org integer NOT NULL
  • description text
  • creator integer NOT NULL
  • create_time integer NOT NULL
  • in_process integer NOT NULL
  • start_time integer
  • end_time integer
  • num_complete integer NOT NULL

Indexes on session

  • offline_session_creation create_time
  • offline_session_org org
  • offline_session_pkey key