User`s guide

9030971 E17

C-1

Appendix C

Data Structure of SQL Tables

Provides SQL (Ingres, Sybase, Oracle, and Microsoft SQL Server) format speciﬁcations for

SPECTRUM data types using sample data.

The various SQL export options let you export SPECTRUM data to SQL

tables. These tables are created in the database you specify in the Database

Name ﬁeld in the SPECTRUM Data Export main window. The tables in this

appendix contain the SQL format structure and sample data for the following

exported data types:

• Associations

• Attributes

• Events

• Extended Attributes

• Model Type Hierarchy

• Model Types

• Models

• Relations

• Rules

• Statistics

NOTE

The columns described in this appendix do not have default values. Unless

otherwise noted, these columns do not allow nulls.