Table: DBA . bonus

Employee bonus payments. Used by Powersoft Training only.

Employee id (not yet a foreign key to the employee table).

Date of this bonus payment to this employee.

The amount of the bonus payment.

Table: DBA . call_track

Call Tracking.

Automatically generated id column has default AutoIncrement.

Date of this call.

Name of the caller.

Notes on this call.

Table: DBA . contact

A list of contacts.

Unique Identification number of the contact (not automatically generated).

Last name of the contact.

First name of the contact.

Job role of the contact.

Values:

   Sales                   sa
   Customer support        cs
   Product development     pd
   Administration          ad
   Training                tr
   Documentation           do
   Marketing               ma
   Human resources         hr
   Finance                 fi
   Other                   ot

Street address of the contact.

City where the contact is located.

State where the contact is located; e.g., 'MI', 'TX', 'MA'.

Zip Code where the contact is located (first 5 digits only).

Phone Number of the contact; e.g., '5105551309' displayed as '(510) 555-1309'.

Fax Number of the contact; e.g., '5105554209' displayed as '(510) 555-4209'.

Table: DBA . customer

A list of customers

Unique Identification number of the customer (not automatically generated).

First name of the customer.

Last name of the customer.

Mailing address of the customer.

City where the customer is located.

State where the customer is located.

Zip or postal code where the customer is located. Up to 10 characters may be stored, and the default display format is '#####-####'.

Phone number of the customer; e.g., '5105551309' displayed as '(510) 555-1309'.

Name of the company.

Table: DBA . department

Contains all departments within the company

Unique Identification Code of the department (not automatically generated).

Name of the department.

Employee identification number of the department manager.

This column must either be NULL or contain a valid employee.emp_id value.

Table: DBA . employee

A list of all employees within the company

Identification Number of the employee (not automatically generated).

Identification number of the employee's manager.

No foreign key relationship exists between this column and employee.emp_id.

First name of the employee.

Last name of the employee.

Identification Number for the department where the employee works.

This column must contain a valid department.dept_id value.

Street address of the employee.

City where the employee resides.

State where the employee resides.

Zip Code where the employee resides.

Phone number of the employee.

Status of the employee.

Values:

   Active        A
   Terminated    T
   On Leave      L

Social Security Number of the employee.

Annual salary of the employee.

Date the employee began working.

Date the employee was terminated.

Birth Date of the employee.

Y/N: if the employee has health insurance.

Y/N: if the employee has life insurance.

Y/N: if the employee is entitled to day care insurance.

M or F for Male or Female.

Table: DBA . exam_xref_info

- - -

- - -

- - -

- - -

- - -

- - -

- - -

- - -

- - -

- - -

Table: DBA . exam_xref_list

- - -

- - -

- - -

- - -

Table: DBA . examples

Used for the front-end to the Code Examples

Title of the example

Window that is opened when the example runs

Version of PowerBuilder that the example pertains to

A summary of what the code example does

A technical summary of what the code example is showing

Determines if the example is new for the current release of PowerBuilder

Determines if the code example has been changed, or enhanced, for the current release

Determines what operating systems the example will run on

Determines whether the example will run on desktop or enterprise

Determine if the example has help associated with it in the Help File.

Table: DBA . examples_categories_list

- - -

- - -

Table: DBA . examples_groups

Defines the Code Example topics

Code example topic

Window that opens when code example runs

Table: DBA . examples_previews

- - -

Example window

Screen shot of example

Table: DBA . fin_code

Financial Codes table

Unique financial identification code

Financial Code type

Financial Code description

Table: DBA . fin_data

Financial data

Year financial data applies to

The quarter that the financial data applies to

Financial Identification Code

Dollar amount recorded for year, quarter, and financial code

Table: DBA . ole

- - -

Identification Code

blob column

description of the blob

Table: DBA . printer

- - -

- - -

- - -

- - -

- - -

Table: DBA . product

Products that are sold to customers

Unique Identification Code of the product

Name of the product

Describes what the product is

Measurements of the product.

Values:

   Small
   Medium
   Large
   One size fits all

Color of the product.

Values:

   White
   Black
   Purble
   Orange
   Green
   Blue
   Yellow
   Red

Amount of the product in stock

Unit price per product

.bmp filename that shows what the product looks like

Blob containing a catalog picture of the product in RLE format

Table: DBA . province

- - -

- - -

- - -

Table: DBA . sales_order

Master sales orders table

Unique Identification Number of the sales order

Identification Number of the customer that the sales order is for

Date Ordered

Financial Code

Sales Region.

Values:

   Central
   Eastern
   South
   Western
   Canada

Identification Number of the Sales Representative

Table: DBA . sales_order_items

Contains line items for sales orders

Sales order Identification Number

Line item Identification Number

Product Identification Number

Quantity ordered

Date shipped

Table: DBA . states

The states table contains information about the states of the U.S. (plus the District of Columbia)

State Identification Code

Name of the state

Capital city of the state

Country the state is located in

Table: DBA . terminated_employee

Terminated employees. Used by Powersoft Training only.

- - -

- - -

- - -

- - -

- - -

- - -

- - -

- - -

- - -

- - -

- - -

- - -

- - -

- - -