Ventricci / AcAgendamentos

AC Agendamentos
https://ac-agendamentos.vercel.app
0 stars 0 forks source link

Criar e Hospedar Banco de Dados #2

Open Ventricci opened 4 months ago

Ventricci commented 4 months ago

Criar banco de dados postgres em https://www.elephantsql.com/. O banco de dados deve conter os seguintes elementos:

create type schedulingService as enum ('Manutenção', 'Instalação', 'Orçamento'); create type schedulingCity as enum ('São José dos Campos', 'Taubaté', 'Tremembé', 'Guaratinguetá', 'Jacareí', 'Cruzeiro');

create table Technician( id serial primary key not null, email varchar(80) not null, password varchar(80) not null, token varchar(80) );

create table Scheduling( id serial primary key not null, service schedulingService not null, dateTime timestamp not null, address varchar(120) not null, number int not null, distric varchar(80) not null, city schedulingCity not null, client varchar(80) not null, phone varchar(15) not null, email varchar(80), observation text );

Ventricci commented 4 months ago

Server: silly.db.elephantsql.com User & Database: ygnusbbu Pass: LBpwubEfCQvVoKdOQbr9B9GBJibRIdLf