While we recommend that you allow Bracket to build a table for you, here is a guide
for using a table that you’ve created yourself
General requirements
-
A unique identifier (we recommend snake case field names), and our default table generation
creates a field called
bracket_pkey
. -
To be able to insert into postgres, you must have a default value. We recommend using the
builtin function
gen_random_uuid()
. -
In order to leverage the a more efficient polling mechanism where only recently
updated/inserted records are polled, you must include a field that tracks when records were
modified. When Bracket builds a base for you, we create a field called
bracket_last_modified
and add a trigger/function that updates that field’s value whenever the record is updated.