Run Code
|
API
|
Code Wall
|
Users
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Blog
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
Please
log in
to post a comment.
testing-2
Project 1
SS mysqlsvr 2014 practice
QLDT DB
Practice
Datos relacional BRYAN
Create Index On Viiew
SQL_leetcode
STACK
Update using a temp table
Please log in to post a comment.