Tables Previous topic Chapter index Next topic

SOLICITUDES

 

Description

MAESTRO DE SOLICITUDES

 

Fields

PK

FK

Field

Domain

Type

NN

Default

Description

 

CODIGO

 

CHAR(20)

 

 

 

 

NOMBRE

 

CHAR(100)

 

 

 

 

NOTA

 

VARCHAR(1000)

 

 

 

 

FECHA

 

DATE

 

 

 

Triggers

(There are no triggers for table SOLICITUDES)

 

Indices

Index

Fields

Active

Unique

Order

PK_SOLICITUDES

CODIGO

ASC

 

References

(There are no references for table SOLICITUDES)

 

Referenced By

Table

Foreign Key

Fields

FK Field

Delete Rule

Update Rule

CDP

FK_CDP_1

CODSOLICITUD

CODIGO

NO ACTION

CASCADE

 

Definition

CREATE TABLE SOLICITUDES (
    CODIGO  CHAR(20) NOT NULL,
    NOMBRE  CHAR(100) NOT NULL,
    NOTA    VARCHAR(1000),
    FECHA   DATE
);


ALTER TABLE SOLICITUDES ADD CONSTRAINT PK_SOLICITUDES PRIMARY KEY (CODIGO);

 

     Previous topic Chapter index Next topic