Tables Previous topic Chapter index Next topic

CARGOS

 

Description

(There is no description for table CARGOS)

 

Fields

PK

FK

Field

Domain

Type

NN

Default

Description

 

CODIGO

 

CHAR(5)

 

 

 

 

NOMBRE

 

CHAR(80)

 

 

 

Triggers

(There are no triggers for table CARGOS)

 

Indices

Index

Fields

Active

Unique

Order

PK_CARGOS

CODIGO

ASC

 

References

(There are no references for table CARGOS)

 

Referenced By

Table

Foreign Key

Fields

FK Field

Delete Rule

Update Rule

ASISTENTES

FK_ASISTENTES_7

CODCARGO

CODIGO

NO ACTION

CASCADE

CONTACTOS

FK_CONTACTOS_2

CODCARGO

CODIGO

NO ACTION

CASCADE

PERSONAL

FK_PERSONAL_1

CODCARGO

CODIGO

NO ACTION

CASCADE

 

Definition

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


ALTER TABLE CARGOS ADD CONSTRAINT PK_CARGOS PRIMARY KEY (CODIGO);

 

     Previous topic Chapter index Next topic