Supabase
Database
Postgres database from Supabase
Database setup
Secrets
Update all the secrets in the file init.sql.
- JWT_SECRET: provided by Supabase in the Database API section.
- ENDPOINT_URL: you can choose to put the Hookdeck URL or the API Endpoint of the Edge Functions
- SERVER_DEV: Choose the ENV name: dev, staging, prod.
Installation
Go to the Supabase SQL Editor, and execute the SQL files templates.
(micleo-functions/supabase/migrations) Follow the order of the SQL files: init -> crons
(micleo-functions/supabase/migrations) Follow the order of the SQL files: init -> crons
Set variables:
- VUE_APP_SUPABASE_ANON_KEY
- VUE_APP_SUPABASE_URL
- JWT_SECRET
Tables
Organizations (organization_id)
Organizations (organization_id)
- Members
- Roles & permissions
- Subscriptions
- Integrations
- Invoices
Projects (project_id)
Projects (project_id)
- Objects
- Models
- Properties
- Listings
- Folders
- Campaigns
- Templates
- Activities
- Files
- Logs
- Tasks
- Forms
- Workflows
Others
Others
- Admins
- Organizations
- Projects
- Chats
- Stripe tables:
- Products
- Prices