P_PPTO

Tables

P_PPTO

Description

PLAN MAESTRO PRESUPUESTO

Fields

Field	Type	Default
CODIGO	CHAR(30)
NOMBRE	CHAR(200)
NIVEL	CHAR(1)	'N'
NOTA	VARCHAR(1000)

Triggers

(There are no triggers for table P_PPTO)

Indices

Index	Fields	Active	Unique	Order
PK_P_PPTO	CODIGO			ASC

References

(There are no references for table P_PPTO)

Referenced By

Table	Foreign Key	Fields	FK Field	Delete Rule	Update Rule
TR_CDP	FK_TR_CDP_2	CODP_PPTO	CODIGO	NO ACTION	CASCADE
TR_PPTO	FK_TR_PPTO_2	CODP_PPTO	CODIGO	NO ACTION	CASCADE
TR_RP	FK_TR_RP_2	CODP_PPTO	CODIGO	NO ACTION	CASCADE

Definition

CREATE TABLE P_PPTO (
    CODIGO  CHAR(30) NOT NULL,
    NOMBRE  CHAR(200) NOT NULL,
    NIVEL   CHAR(1) DEFAULT 'N',
    NOTA    VARCHAR(1000)
);


ALTER TABLE P_PPTO ADD CONSTRAINT PK_P_PPTO PRIMARY KEY (CODIGO);