Release 10.1A: OpenEdge Development:
Progress Dynamics Repository Reference

> ## gsc_dataset_entity table — gscde

> This table lists the tables that must be deployed with the data set. Each data set must have a designated primary table, in other words, the main table in the data set. The join information between the tables must also be specified.

> The data in this table can be filtered using the `WHERE` clause stored in the `filter_where_clause` field.

> Table 3–3 lists the table’s FLA, fields, and foreign keys.

> Table 3–3: gsc_dataset_entity table information
> Table FLA | Fields (data type) | Foreign keys
> --- | --- | ---
> gscde | dataset_entity_obj (Decimal) deploy_dataset_obj (Decimal) entity_sequence (Integer) entity_mnemonic (Character) primary_entity (Logical) join_entity_mnemonic (Character) join_field_list (Character) filter_where_clause (Character) delete_related_records (Logical) overwrite_records (Logical) keep_own_site_data (Logical) use_relationship (Logical) relationship_obj (Decimal) deletion_action (Character) exclude_field_list (Character) | deploy_dataset_obj entity_mnemonic relationship_obj

> Table 3–4 gives details of the table’s indexes.

> Table 3–4: gsc_dataset_entity index information
> Index name | Elements | Type
> --- | --- | ---
> XPKgsc_dataset_entity | dataset_entity_obj | Primary Unique
> XAK1gsc_dataset_entity | deploy_dataset_obj entity_sequence | Unique
> XIE1gsc_dataset_entity | entity_mnemonic | Nonunique
> XIE3gsc_dataset_entity | deploy_dataset_obj primary_entity entity_mnemonic | Nonunique
> XIE4gsc_dataset_entity | join_entity_mnemonic dataset_entity_obj | Nonunique
> XIE5gsc_dataset_entity | relationship_obj | Nonunique

Copyright © 2005 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095