Unique Entries

[Krondor]

Hi,

I've got a question.
I want to generate tables like this with powerdesigner:

create table TEST_TABLE
(
COL_1 integer not null,
COL_2 integer not null,
COL_3 integer not null,
COL_4 ...
...
primary key (COL_1),
unique (COL_2, COL_3)
);

Now I don't know how to create the unique-statement.
Is it possible to create unique attributes already in the ConceptualDataModels?
I've got PowerDesigner 12.0.0.1700.

 

[rbarlow55]

You have to create an identifier for those attribute you want to be unique. Each table should have at least 1 identifier which is the PK but can also have others on different columns which creates a unique constraint when the physical model is generated.