how to make 2 columns in DB as primary key

Priyanka over 8 years ago

how to make 2 columns in DB as primary key .
There is a table with columns , fundid, business effective month, profit, loss and other fields.
I have made fundid as primary key. But I should make fundid and business effective month , both together as primary key . How to do that in CDT ?

Discussion posts and replies are publicly visible

Parents

0 Venu over 8 years ago

@Priyanka,
You can create additional column to save combination values of fundid and business effective month like FUN001_Jan, Make that additional column as PK in your CDT.
From DB side Additional Column should be Unique Key, PK is (fundid and business effective month).

https://forum.appian.com/suite/help/16.3/Database_Schema_Best_Practices.html#composite-keys
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Venu over 8 years ago

@Priyanka,
You can create additional column to save combination values of fundid and business effective month like FUN001_Jan, Make that additional column as PK in your CDT.
From DB side Additional Column should be Unique Key, PK is (fundid and business effective month).

https://forum.appian.com/suite/help/16.3/Database_Schema_Best_Practices.html#composite-keys
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data