FICHAS

Tables

FICHAS

Description

(There is no description for table FICHAS)

Fields

Field	Type	Default
TABLA	CHAR(31)
CAMPO	CHAR(31)
ROTULO	CHAR(31)
EDITOR	CHAR(20)
ORDEN	SMALLINT	0
EDITAR	CHAR(1)	'S'

Triggers

(There are no triggers for table FICHAS)

Indices

Index	Fields	Active	Unique	Order
PK_FICHAS	TABLA, CAMPO			ASC

References

(There are no references for table FICHAS)

Referenced By

(There are no tables referenced by table FICHAS)

Definition

CREATE TABLE FICHAS (
    TABLA   CHAR(31) NOT NULL,
    CAMPO   CHAR(31) NOT NULL,
    ROTULO  CHAR(31) NOT NULL,
    EDITOR  CHAR(20),
    ORDEN   SMALLINT DEFAULT 0,
    EDITAR  CHAR(1) DEFAULT 'S'
);


ALTER TABLE FICHAS ADD CONSTRAINT PK_FICHAS PRIMARY KEY (TABLA, CAMPO);