(
CODARTICULO NUMBER (6,2) NOT NULL ,
NOMBRE_ARTICULO VARCHAR2 (6 CHAR) NOT NULL ,
VALOR_ARTICULO NUMBER (4,2) NOT NULL
) ;
ALTER TABLE ARTICULOS ADD CONSTRAINT ARTICULOS_PK PRIMARY KEY ( CODARTICULO ) ;
CREATE TABLE CLIENTES
(
CODCLIENTE NUMBER (4,2) NOT NULL ,
NOMCLIENTE VARCHAR2 (3 CHAR) NOT NULL ,
TELCLIENTE NUMBER (4,2) NOT NULL
) ;
ALTER TABLE CLIENTES ADD CONSTRAINT CLIENTES_PK PRIMARY KEY ( CODCLIENTE ) ;
CREATE TABLE COMPRAS
(
ARTICULOS_CODARTICULO NUMBER (6,2) NOT NULL ,
PROVEEDORES_CODPROVEEDOR NUMBER (4,2) NOT NULL ,
CANTIDADCOMPRAS NUMBER (6) NOT NULL
) ;
ALTER TABLE COMPRAS ADD CONSTRAINT COMPRAS_PK PRIMARY KEY ( ARTICULOS_CODARTICULO, PROVEEDORES_CODPROVEEDOR ) ;
CREATE TABLE PROVEEDORES
(
CODPROVEEDOR NUMBER (4,2) NOT NULL ,
NOMPROVEDORES VARCHAR2
-- ERROR: VARCHAR2 size not specified
NOT NULL ,
TELPROVEEDOR NUMBER (4,2) NOT NULL ,
DIRPROVEEDOR VARCHAR2 (3 CHAR) NOT NULL
) ;
ALTER TABLE PROVEEDORES ADD CONSTRAINT PROVEEDORES_PK PRIMARY KEY ( CODPROVEEDOR ) ;
CREATE TABLE VENTAS
(
ARTICULOS_CODARTICULO NUMBER (6,2) NOT NULL ,
CLIENTES_CODCLIENTE NUMBER (4,2) NOT NULL ,
CANTIDADVENTAS NUMBER (6) NOT NULL
) ;
ALTER TABLE VENTAS ADD CONSTRAINT VENTAS_PK PRIMARY KEY ( ARTICULOS_CODARTICULO, CLIENTES_CODCLIENTE ) ;
ALTER TABLE COMPRAS ADD CONSTRAINT FK_ASS_1 FOREIGN KEY ( ARTICULOS_CODARTICULO ) REFERENCES ARTICULOS ( CODARTICULO ) ;
ALTER TABLE COMPRAS ADD CONSTRAINT FK_ASS_2 FOREIGN KEY ( PROVEEDORES_CODPROVEEDOR ) REFERENCES PROVEEDORES ( CODPROVEEDOR ) ;
ALTER TABLE VENTAS ADD CONSTRAINT FK_ASS_3 FOREIGN KEY ( ARTICULOS_CODARTICULO ) REFERENCES ARTICULOS ( CODARTICULO ) ;
ALTER TABLE VENTAS ADD CONSTRAINT FK_ASS_4 FOREIGN KEY ( CLIENTES_CODCLIENTE ) REFERENCES CLIENTES ( CODCLIENTE ) ;
-- Informe de Resumen de Oracle SQL Developer Data Modeler:
--
-- CREATE TABLE 5
-- CREATE INDEX 0
-- ALTER TABLE 9
-- CREATE VIEW 0
-- ALTER VIEW 0
-- CREATE PACKAGE 0
-- CREATE PACKAGE BODY 0
-- CREATE PROCEDURE 0
-- CREATE FUNCTION 0
-- CREATE TRIGGER 0
-- ALTER TRIGGER 0
-- CREATE COLLECTION TYPE 0
-- CREATE STRUCTURED TYPE 0
-- CREATE STRUCTURED TYPE BODY 0
-- CREATE CLUSTER 0
-- CREATE CONTEXT 0
-- CREATE DATABASE 0
-- CREATE DIMENSION 0
-- CREATE DIRECTORY 0
-- CREATE DISK GROUP 0
-- CREATE ROLE 0
-- CREATE ROLLBACK SEGMENT 0
-- CREATE SEQUENCE 0
-- CREATE MATERIALIZED VIEW 0
-- CREATE SYNONYM 0
-- CREATE TABLESPACE 0
-- CREATE USER 0
--
-- DROP TABLESPACE 0
-- DROP DATABASE 0
--
-- REDACTION POLICY 0
--
-- ORDS DROP SCHEMA 0
-- ORDS ENABLE SCHEMA 0
-- ORDS ENABLE OBJECT 0
--
-- ERRORS 1
-- WARNINGS 0