Create Oracle Table complete process record in PowerDesigner

This document records how to create a table of Oracle structures in PowerDesigner.

Before reading this article, you need to make DBMS modifications in PowerDesigner, database creation, user creation, and table space creation.

1. Create a table, fill in the Name,code,comment,owner (need to create in advance)

2. Create the corresponding columns in the table

2.1 Edit the primary key, select the primary key, click the Properties button (first button)

2.2 After confirming Name,code,table,primarykey, add sequence, modify Name,code,owner

2.3 To modify the relevant options for sequence

2.4 Ensure that the sequence is defined correctly

3. Create an index, create a name,code, whether it is a unique index

After you select an index, edit the attribute to confirm the name,code,owner.

Select the column information for the index

The parameter definition for the index.

Ensure that the index is defined correctly.

4 Making primary Key edits

Modify Name,code to confirm other content

Select columns for the primary key

Remove the Use index option (depending on the situation)

Ensure that the definitions are correct

5. Delete the automatically added trigger

Confirm that it is normal

6. Modifying parameter information for a table

You can modify it by tapping the magnifying glass.

Determine if the result is normal

7. Verify that the final result is normal

Create Oracle Table complete process record in PowerDesigner