FORMAS

Tables

FORMAS

Description

(There is no description for table FORMAS)

Fields

Field	Type	Default
CODIGO	CHAR(10)
NOMBRE	CHAR(80)
NOTA	CHAR(200)
TABLA	CHAR(31)
NIVEL	SMALLINT
EDITAR	CHAR(1)	'N'
INSERTAR	CHAR(1)	'N'
BORRAR	CHAR(1)	'N'
MODULO	CHAR(10)
FORMATO	BLOB SUB_TYPE 0 SEGMENT SIZE 80
CODGRUPO	CHAR(30)
NATIVO	CHAR(1)	'N'
TABLERO	CHAR(1)	'N'
PRIORIDAD	SMALLINT	1

Triggers

(There are no triggers for table FORMAS)

Indices

Index	Fields	Active	Unique	Order
FK_FORMAS_1	CODGRUPO			ASC
PK_FORMAS	CODIGO			ASC

References

Table	Foreign Key	Fields	FK Field	Delete Rule	Update Rule
GRUPOS	FK_FORMAS_1	CODGRUPO	CODIGO	NO ACTION	CASCADE

Referenced By

(There are no tables referenced by table FORMAS)

Definition

CREATE TABLE FORMAS (
    CODIGO     CHAR(10) NOT NULL,
    NOMBRE     CHAR(80) NOT NULL,
    NOTA       CHAR(200),
    TABLA      CHAR(31),
    NIVEL      SMALLINT,
    EDITAR     CHAR(1) DEFAULT 'N',
    INSERTAR   CHAR(1) DEFAULT 'N',
    BORRAR     CHAR(1) DEFAULT 'N',
    MODULO     CHAR(10),
    FORMATO    BLOB SUB_TYPE 0 SEGMENT SIZE 80,
    CODGRUPO   CHAR(30),
    NATIVO     CHAR(1) DEFAULT 'N',
    TABLERO    CHAR(1) DEFAULT 'N',
    PRIORIDAD  SMALLINT DEFAULT 1
);


ALTER TABLE FORMAS ADD CONSTRAINT PK_FORMAS PRIMARY KEY (CODIGO);
ALTER TABLE FORMAS ADD CONSTRAINT FK_FORMAS_1 FOREIGN KEY (CODGRUPO) REFERENCES GRUPOS (CODIGO) ON UPDATE CASCADE;