Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
Caronas
CREATE TABLE MOTORISTAS( id CHAR(8) NOT NULL, nome VARCHAR(60) NOT NULL, num_registro CHAR(12) NOT NULL, med_aval FLOAT NOT NULL, PRIMARY KEY(id)); CREATE TABLE PASSAGEIROS( id CHAR(8) NOT NULL, nome VARCHAR(60) NOT NULL, PRIMARY KEY(id)); CREATE TABLE VIAGENS( motorista_id CHAR(8) NOT NULL, passageiro_id CHAR(8) NOT NULL, data_inicio TIMESTAMP NOT NULL, km_rodados INT, FOREIGN KEY (motorista_id) REFERENCES MOTORISTAS, FOREIGN KEY (passageiro_id) REFERENCES PASSAGEIROS);
run
|
edit
|
history
|
help
0
Allocations Check
tables creation
ERROR
Emp Table
tesing
calendar
comparison and logical
aawrish
QLDT_TUAN 7
subaco