Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE cliente (
- codigoDeCliente varchar2(10) not null,
- saldo number(4),
- PRIMARY KEY (codigoDeCliente),
- );
- CREATE TABLE direccionesDeEnvio (
- direccionDeEnvio varchar2(50) not null,
- codigoDeCliente varchar2(10) not null,
- PRIMARY KEY (direccionDeEnvio),
- FOREIGN KEY (codigoDeCliente) REFERENCES cliente (codigoDeCliente),
- );
- CREATE TABLE pedido (
- fecha varchar2(11) not null,
- pais varchar2(10) not null,
- provincia varchar2(10) not null,
- localidad varchar2(10) not null,
- calle varchar2(10) not null,
- portal number(4) not null,
- piso number(2) not null,
- codigoDeCliente varchar2(10) not null,
- primary key (fecha),
- foreign key (codigoDeCliente) references cliente (codigoDeCliente)
- );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement