what is broadlog id primary sequenec

[Shruti1]

what is differnevcet between primaru and primary key sequence in adibe

pleqse help me to und what is the usage of defjnj h pk sequence in adobe schema

i want to underatand in layman langauage

[Marcel_Szimonisz]

Hello @Shruti1,

primary key is unique record identifier and primary key sequence is function how that key is generated. Take a look at following atricle:

https://experienceleague.adobe.com/docs/campaign-classic/using/configuring-campaign-classic/schema-r...

You can create your own or use ones adobe campaign has already added. 

Definition:
In SQL, a sequence is a database object that generates a sequence of numeric values. It is often used to generate unique identifiers for rows in a table. Sequences are typically used to provide a unique number for primary keys or other columns that require unique values.

In adobe campaign when you reach the end of the sequence the sequence reset from the begining. When this happens usually we set update the sequence to start from negative number.
https://experienceleague.adobe.com/docs/campaign-classic/using/monitoring-campaign-classic/database-...

Marcel Szimonsiz

[Shruti1]

we are using sql data base ...please help me to know how can we put sequnece in negative values

this is much needed ar this moment

we are havjng show stopper issue because of this??

please please help me with any doc or steps if you have

how can we put sequnqce in negative numbers

i need conplete process asap

[Sukrity_Wadhwa · Accepted solution]

Hi @Shruti1,

This has been answered in another query thread authored by you: https://experienceleaguecommunities.adobe.com/t5/adobe-campaign-classic-questions/broadlog-id-primar...

Kindly refer here for the solution.