GlobalSight database schema

From Globalsight
Jump to navigation Jump to search
Developers
Go to: Getting Started Guide
Footer-logo.gif
System requirements

Installing GlobalSight
3rd party comps: Windows | Ubuntu
GlobalSight: Windows | Ubuntu
Desktop Icon

Setting up GlobalSight
Running GlobalSight Behind an Apache Reverse Proxy

Developing GlobalSight
GlobalSight Architecture
Getting the Code
Building and Deploying GlobalSight
GlobalSight Developer’s Guide
Setting up the Development Environment
Debugging GlobalSight
Designing the GlobalSight Adapters
GlobalSight Web Services API
Using the GlobalSight Web Services API Test Tool
Using the GlobalSight CVS Connector
Connecting to a CVS with the GlobalSight Desktop Icon

Upgrading GlobalSight
Comparing GlobalSight with WorldServer

The following section is meant to document the database schema and the table contents. Tables are listed alphabetically, comments are listed after the column names.

COST_BY_WORD_COUNT
   COST_ID -> FK; points to the COST table
COST
  COSTABLE_OBJECT_TYPE: "J", "W", and "T" are Job, Workflow, and Task. (This part is actually controlled by Hibernate, so this info is in the HBM file envoy/src/java/com/globalsight/persistence/hibernate/xml/Cost.hbm.xml)
  RATE_TYPE: "E" and "R" are "Expense" and "Revenue", respectively. (cf. -- envoy/src/java/com/globalsight/everest/costing/Cost.java)