search

jamesplease / api-pls

Need a backend? Just say please
MIT License
10 stars 1 forks source link

api-pls postgres schema #188

Open jamesplease opened 7 years ago

jamesplease commented 7 years ago

If all of the tables created by api-pls are in a schema, then they wouldn't interfere with existing tables.

Anytime a sync or migration occurs, I can ensure the schema exists via:

CREATE SCHEMA IF NOT EXISTS api_pls

Then, I can create tables in that schema via

CREATE TABLE api_pls.my_table

jamesplease commented 7 years ago

This will also help with #43. Looking at tables one-by-one isn't enough to determine one-to-one relationships, and especially not many-to-many.