ESQNOMINA

Tables

ESQNOMINA

Description

(There is no description for table ESQNOMINA)

Fields

PK	FK	Field	Domain	Type	NN	Default	Description
		CODIGO		CHAR(5)
		NOMBRE		CHAR(80)

Triggers

(There are no triggers for table ESQNOMINA)

Indices

Index	Fields	Active	Unique	Order
PK_ESQNOMINA	CODIGO			ASC

References

(There are no references for table ESQNOMINA)

Referenced By

Table	Foreign Key	Fields	FK Field	Delete Rule	Update Rule
GRUPONOMINA	FK_GRUPONOMINA_1	CODESQNOMINA	CODIGO	NO ACTION	CASCADE
PERSONAL	FK_PERSONAL_5	CODESQNOMINA	CODIGO	NO ACTION	CASCADE
PLANILLAS	FK_PLANILLAS_2	CODESQNOMINA	CODIGO	NO ACTION	CASCADE

Definition

CREATE TABLE ESQNOMINA (
    CODIGO  CHAR(5) NOT NULL,
    NOMBRE  CHAR(80) NOT NULL
);


ALTER TABLE ESQNOMINA ADD CONSTRAINT PK_ESQNOMINA PRIMARY KEY (CODIGO);