Why do I need an ID column?

Details on why an ID column is required in Supabase for two-way sync

To enable two-way sync between Supabase and your other apps, Whalesync needs a way to uniquely identify each record in your Supabase database.

If your table already has a unique primary key, Whalesync will use it.

If not, Whalesync will automatically add a whalesync_postgres_id column to ensure each record can be tracked reliably.

What the automatically added "whalesync_postgres_id" column looks like in Supabase

Alternatively, if you'd prefer to add your unique ID field manually, you can follow these steps:

Adding default values to primary keys