Introduction

• Like a namespace (or folder inside a db)
• But all schemas still live inside the same db.
• When create a new db, everything goes into public schema by default

Database =  “project”
Schema   =  “module / folder inside project”
Table    =  “file inside folder”

Practical usage:

• put shared things → public
• auth → auth
• storage → storage
• your app → app_schema, dcai_schema, etc.

To organize multiple apps in same db:

• Create schemas
• And in different schemas, can have same tables name

// app1 = one application module
app1.users
app1.orders

// app2 = another application module
app2.users
app2.payments