... | @@ -75,7 +75,7 @@ TBD |
... | @@ -75,7 +75,7 @@ TBD |
|
|
|
|
|
### Schemas
|
|
### Schemas
|
|
|
|
|
|
# Table User
|
|
##### Table User
|
|
- `id` (uuid, primary key)
|
|
- `id` (uuid, primary key)
|
|
- `email` (text unique, not null)
|
|
- `email` (text unique, not null)
|
|
- `password` (text not null)
|
|
- `password` (text not null)
|
... | @@ -85,13 +85,13 @@ TBD |
... | @@ -85,13 +85,13 @@ TBD |
|
- `profile_picture` (text)
|
|
- `profile_picture` (text)
|
|
- `is_anonymous` (boolean)
|
|
- `is_anonymous` (boolean)
|
|
|
|
|
|
# Table Doctor
|
|
##### Table Doctor
|
|
- `id` (uuid, unique, primary key)
|
|
- `id` (uuid, unique, primary key)
|
|
- `crm` (text unique, not null)
|
|
- `crm` (text unique, not null)
|
|
- `uf` (text not null)
|
|
- `uf` (text not null)
|
|
- `id` (uuid, foreign key referencing User)
|
|
- `id` (uuid, foreign key referencing User)
|
|
|
|
|
|
# Table HealthPlan
|
|
##### Table HealthPlan
|
|
- `id` (uuid, primary key)
|
|
- `id` (uuid, primary key)
|
|
- `name` (text not null)
|
|
- `name` (text not null)
|
|
- `health_plan_image` (text)
|
|
- `health_plan_image` (text)
|
... | | ... | |