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 |
---|---|---|---|---|
CODIGO |
ASC |
References
(There are no references for table SOLICITUDES)
Referenced By
Table | Foreign Key | Fields | FK Field | Delete Rule | Update Rule |
---|---|---|---|---|---|
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);
![]() ![]() ![]() |