is it possible we will create an auto increment field in wp data table ?

if yes then please let me know how 

thanks

i am not talking about create table manually, let me put in this way if i want to show wp_posts table and show serial number with each row then what i need to do ? 

I'm with usman on this ... I'd like to created a Serial_ID for each row so that it may be the number referenced in a separate table using the following (https://wpdatatables.com/documentation/front-end-editing/configuring-table-relations-foreign-key/).

I'm not sure if it is possible, but I'd like to create Column 1 that has Serial IDs (goes up by 1 each new entry), and Column 2 has Country Name. Then, in my main table I'd like to use the Country table as a foreign key where it selects the Serial_ID but SHOWS the Country Name in the main table. 

The purpose would be so that if I want to change the spelling or the like of a Country Name, it does not create an error within the main table as the Serial_ID is referenced and not the text.

Is this possible?

This would also apply to boolean reference tables. Ie. 2 entries in the table. Col 1 has entries 0 and 1; Col 2 has text reference for what those 2 options correspond to. And then you could choose the text option in a main table but it would enter the boolean integer in the actual database.

Is this possible?

Does the WPDT foreign key use the integer of the automatically created wpdt row ID as the reference? (I think that is what is happening in the tutorial.)

If that is the case, could I use that to achieve my serial id goal with the countries linked table? (As in, when I link the foreign key table, even though I select a country name, the table row number is what is entered into the main table?)