Touchstone 2022 Database Reference
tActivityParentXref Table
AIRProject Database : tActivityParentXref Table
Description
System reference table used to associate an activity to the parent activity.
Properties
Creation Date4/4/2022 3:02 AM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows0
Data Space Used0.00 KB
Index Space Used0.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key 

Unique system-generated sequential identifier for the activity record.

For a complete list of records, see tActivity Table.

int4   
Primary Key 

Unique system-generated sequential identifier of the sub-activity's parent record.

For a complete list of records, see tActivity Table.

int4   
Objects that tActivityParentXref depends on
 Database ObjectObject TypeDescriptionDep Level
tActivity tabletActivityTable

Stores information about each activity, including the unique sequential identifiers for analyses and activities.

You can use the information in the table to find analysis results.

1
tAnalysis tabletAnalysisTableStores information about each analysis.2
tDataServer tabletDataServerTableStores information about each data server associated with the project, including the sequential identifier (SID), name, description, connection information, and default MDF and LDF paths for the server.4
tDataSource tabletDataSourceTable

Stores information about the databases registered with the application, for example, the exposure and results databases.

3
tExposureSet tabletExposureSetTableStores exposure set information from each exposure database on the server.4
tProject tabletProjectTableStores information about each project, for example, the project name and status code.2
See Also

Related Objects

AIRProject Database