Tables Previous topic Chapter index Next topic

DEPENDENCIAS

 

Description

(There is no description for table DEPENDENCIAS)

 

Fields

PK

FK

Field

Domain

Type

NN

Default

Description

 

CODIGO

 

CHAR(10)

 

 

 

 

NOMBRE

 

CHAR(100)

 

 

 

 

ESTADO

 

CHAR(20)

 

 

 

Triggers

(There are no triggers for table DEPENDENCIAS)

 

Indices

Index

Fields

Active

Unique

Order

PK_DEPENDENCIAS_1

CODIGO

ASC

 

References

(There are no references for table DEPENDENCIAS)

 

Referenced By

Table

Foreign Key

Fields

FK Field

Delete Rule

Update Rule

P_DESARROLLO

FK_P_DESARROLLO_1

CODDEPENDENCIA

CODIGO

NO ACTION

CASCADE

 

Definition

CREATE TABLE DEPENDENCIAS (
    CODIGO  CHAR(10) NOT NULL,
    NOMBRE  CHAR(100) NOT NULL,
    ESTADO  CHAR(20)
);


ALTER TABLE DEPENDENCIAS ADD CONSTRAINT PK_DEPENDENCIAS_1 PRIMARY KEY (CODIGO);

 

     Previous topic Chapter index Next topic