| Tables |
|
NOTICIAS
| Tables |
|
NOTICIAS
Description
(There is no description for table NOTICIAS)
Fields
PK | FK | Field | Domain | Type | NN | Default | Description |
|---|---|---|---|---|---|---|---|
|
|
CODIGO |
|
INTEGER |
|
|
|
|
|
NOMBRE |
|
CHAR(40) |
|
|
|
|
|
TOPICO |
|
VARCHAR(200) |
|
|
|
|
|
NOTA |
|
BLOB SUB_TYPE 1 SEGMENT SIZE 80 |
|
|
|
|
|
FOTO |
|
CHAR(20) |
|
|
|
|
|
FECHA |
|
TIMESTAMP |
|
|
|
|
|
WEBSITE |
|
CHAR(80) |
|
|
|
|
|
PUBLICAR |
|
CHAR(1) |
|
'N' |
|
Triggers
(There are no triggers for table NOTICIAS)
Indices
Index | Fields | Active | Unique | Order |
|---|---|---|---|---|
CODIGO |
|
|
ASC |
References
(There are no references for table NOTICIAS)
Referenced By
(There are no tables referenced by table NOTICIAS)
Definition
CREATE TABLE NOTICIAS (
CODIGO INTEGER NOT NULL,
NOMBRE CHAR(40) NOT NULL,
TOPICO VARCHAR(200),
NOTA BLOB SUB_TYPE 1 SEGMENT SIZE 80,
FOTO CHAR(20),
FECHA TIMESTAMP,
WEBSITE CHAR(80),
PUBLICAR CHAR(1) DEFAULT 'N'
);
ALTER TABLE NOTICIAS ADD CONSTRAINT PK_NOTICIAS PRIMARY KEY (CODIGO);
|
|
