PowerDesigner provides default model checks to verify the validity of horizontal partitioning objects.
Check |
Description and Correction |
---|---|
Horizontal partitioning name and code uniqueness |
Horizontal partitioning names and codes must be unique in the model. Manual correction: Modify the duplicate name/code Automatic correction: Appends a number to the duplicate name/code |
Existence of partition |
A horizontal partitioning object cannot be empty, it must contain at least one partition. Manual correction: Delete the horizontal partitioning object or create at least one partition in the horizontal partitioning object property sheet Automatic correction: Deletes empty horizontal partitioning object |
Unavailable target table |
A partition should have a corresponding table. You could delete a table that actually corresponds to a partition, this check verifies that each partition has a corresponding table. Manual correction: Delete the partition with no corresponding table Automatic correction: Deletes the partition with no corresponding table |