PERSONAS

Tables

PERSONAS

Description

(There is no description for table PERSONAS)

Fields

PK	FK	Field	Domain	Type	NN	Default	Description
		CODIGO		CHAR(15)
		NOMBRE		CHAR(100)
		TELEFONO		CHAR(20)
		CELULAR		CHAR(20)
		EMAIL		CHAR(50)

Triggers

(There are no triggers for table PERSONAS)

Indices

Index	Fields	Active	Unique	Order
PK_PERSONAS	CODIGO			ASC

References

(There are no references for table PERSONAS)

Referenced By

Table	Foreign Key	Fields	FK Field	Delete Rule	Update Rule
GIROS	FK_GIROS_2	CODREMITENTE	CODIGO	NO ACTION	CASCADE
GIROS	FK_GIROS_3	CODDESTINATARIO	CODIGO	NO ACTION	CASCADE

Definition

CREATE TABLE PERSONAS (
    CODIGO    CHAR(15) NOT NULL,
    NOMBRE    CHAR(100),
    TELEFONO  CHAR(20),
    CELULAR   CHAR(20),
    EMAIL     CHAR(50)
);


ALTER TABLE PERSONAS ADD CONSTRAINT PK_PERSONAS PRIMARY KEY (CODIGO);