DEPLOYMENT_PROJECTIONS

Contains information about projections created and dropped during the design. Each row contains information about a different projection. Database Designer populates this table after the design is deployed.

Column Name Column Type Description
deployment_id INTEGER Unique ID that Database Designer assigned to the deployment.

deployment_projection_id

INTEGER Unique ID that Database Designer assigned to the output projection.
design_name VARCHAR Name of the design being deployed.
deployment_projection_name VARCHAR

Name that Database Designer assigned to the projection.
anchor_table_schema VARCHAR

Name of the schema that contains the table the projection is based on.
anchor_table_name VARCHAR

Name of the table the projection is based on.
deployment_operation VARCHAR

Action being taken on the projection, for example, add or drop.
deployment_projection_type VARCHAR

Indicates whether Database Designer has proposed new projections for this design (DBD) or is using the existing catalog design (CATALOG). The REENCODED suffix indicates that the projection sort order and segmentation are the same, but the projection columns have new encodings:

  • DBD
  • CATALOG
  • DBD_REENCODED
  • CATALOG_REENCODED
deploy_weight INTEGER

Weight of this projection in creating the design. This field is always 0 for projections that have been dropped.
estimated_size_on_disk INTEGER Approximate size of the projection on disk, in MB.