Created
August 13, 2025 16:01
-
-
Save lucasmarcos/7d199ddecd758b12be124f226913a19d to your computer and use it in GitHub Desktop.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| CREATE TABLE salao ( | |
| id TEXT PRIMARY KEY, | |
| nome TEXT | |
| ); | |
| CREATE TABLE usuario ( | |
| id TEXT PRIMARY KEY, | |
| nome TEXT | |
| ); | |
| CREATE TABLE funcionario ( | |
| id TEXT PRIMARY KEY, | |
| usuario TEXT REFERENCES usuario(id) | |
| ); | |
| CREATE TABLE cliente ( | |
| id TEXT PRIMARY KEY, | |
| salao TEXT REFERENCES salao(id), | |
| nome TEXT | |
| ); | |
| CREATE TABLE categoria ( | |
| id TEXT PRIMARY KEY, | |
| salao TEXT REFERENCES salao(id), | |
| nome TEXT | |
| ); | |
| CREATE TABLE servico ( | |
| id TEXT PRIMARY KEY, | |
| salao TEXT REFERENCES salao(id), | |
| categoria TEXT REFERENCES categoria(id) | |
| ); | |
| CREATE TABLE funcionario_servico ( | |
| id TEXT PRIMARY KEY, | |
| funcionario TEXT REFERENCES funcionario(id), | |
| servico TEXT REFERENCES servico(id) | |
| ); | |
| CREATE TABLE agendamento ( | |
| id TEXT PRIMARY KEY, | |
| salao TEXT REFERENCES salao(id), | |
| cliente TEXT REFERENCES cliente(id), | |
| funcionario TEXT REFERENCES funcionario(id), | |
| data TEXT, | |
| inicio TEXT, | |
| duracao TEXT | |
| ); |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment