Payroll schema using supabase (postgresql) + nodeJs
Using the supabase API reference to make queries (Link) a simple normalized relational database is used to store event records like vacations, day offs, etc.
the sql/ folder contain the CREATE TABLE code for the schema
A supabase project must be created (Link), then, to store the supabase Url and anon Key, a .js file namded "supabaseUrlKey" with the next data structure:
module.exports = {
supabaseUrl: "",
supabaseAnonKey: ""
}