CA IDMS/DB SQL Dictionary Reports—QREPORTS › QREPORT 003 -Schema and Table Report › Field Descriptions

Field Descriptions

A description of the fields in QREPORT 003 follows:

SCHEMA NAME

Identifies the name of the schema.

SCHEMA OWNER

Identifies the owner of the schema.

DATE CREATED, BY USER

Identifies the date and time the schema was created, and the user who created it.

DATE LAST UPDATED, BY USER

Identifies the date and time the schema was last updated, and the user who last updated it.

SEGMENT NAME

Name of the segment associated with the default area for relational schemas. For non-SQL schemas, it is the name of the database or segment containing the data that the non-SQL schema defines.

AREA NAME

Name of the default area for relational schemas.

SCHEMA TYPE

The type of schema. Valid values are:

• RELATIONAL
• NON-SQL REFERENCING
• SQL REFERENCING

NON-SQL NODE

Reserved for future use.

REFERENCED NON-SQL SCHEMA

Name of the non-SQL schema.

NON-SQL DICTNAME

Name of the dictionary in which the referenced non-SQL schema is defined.

SCHEMA VERSION

Version number of the non-SQL schema.

REFERENCED SQL SCHEMA

Name of the SQL schema referenced by this schema.

RREFERENCED SQL DICTNAME

Name of the dictionary in which the referenced SQL schema is defined.

TABLE NAME

Name of the table.

TABLE ID

Internal table identifier which identifies the rows of the table within an area.

TABLE TYPE

The type of table. The following are the Valid values:

• Base table
• Function
• Procedure
• Record in a non-SQL defined schema
• Table procedure
• View

CREATED BY

Identifies the user who created the table.

TOTAL LENGTH

The total length of a table row.

NUMBER COLUMNS

Number of columns in the table.

NUMBER INDEXES

Number of indexes on the table.

TIMES REFERENCED

Number of constraints in which the table is the referenced table.

REFERENCES OTHER TABLES

Number of constraints where this table is the referencing table.