LIBROS

Tables

LIBROS

Description

(There is no description for table LIBROS)

Fields

PK	FK	Field	Domain	Type	NN	Default	Description
		CODIGO		CHAR(10)
		NOMBRE		CHAR(100)
		NVALOR1		CHAR(20)
		NVALOR2		CHAR(20)
		NVALOR3		CHAR(20)
		NVALOR4		CHAR(20)
		NVALOR5		CHAR(20)
		NVALOR6		CHAR(20)
		NVALOR7		CHAR(20)
		NVALOR8		CHAR(20)
		NVALOR9		CHAR(20)
		NVALOR0		CHAR(20)

Triggers

(There are no triggers for table LIBROS)

Indices

Index	Fields	Active	Unique	Order
PK_LIBROS	CODIGO			ASC

References

(There are no references for table LIBROS)

Referenced By

Table	Foreign Key	Fields	FK Field	Delete Rule	Update Rule
ASIENTOS	FK_ASIENTOS_1	CODLIBRO	CODIGO	NO ACTION	CASCADE

Definition

CREATE TABLE LIBROS (
    CODIGO   CHAR(10) NOT NULL,
    NOMBRE   CHAR(100),
    NVALOR1  CHAR(20),
    NVALOR2  CHAR(20),
    NVALOR3  CHAR(20),
    NVALOR4  CHAR(20),
    NVALOR5  CHAR(20),
    NVALOR6  CHAR(20),
    NVALOR7  CHAR(20),
    NVALOR8  CHAR(20),
    NVALOR9  CHAR(20),
    NVALOR0  CHAR(20)
);


ALTER TABLE LIBROS ADD CONSTRAINT PK_LIBROS PRIMARY KEY (CODIGO);