ALTER TABLE UNIDADES ADD UNI_CFE VARCHAR(20)
GO
CREATE TABLE TIPOSRF ( 
TIP_COD VARCHAR(10) NOT NULL,
TIP_DES VARCHAR(250) NOT NULL
 CONSTRAINT PK_TIPOSRF PRIMARY KEY CLUSTERED (TIP_COD),
 CONSTRAINT CK_TIPOSRFTIP_COD CHECK ((len([TIP_COD])>(0))),
 CONSTRAINT CK_TIPOSRFTIP_DES CHECK ((len([TIP_DES])>(0))))
GO
CREATE TABLE NIT_RESFISCAL ( 
TRF_ID INT IDENTITY ( 1,1 ) NOT NULL,
TRF_NIT VARCHAR(11) NOT NULL,
TRF_COD VARCHAR(10) NOT NULL,
TRF_INA BIT DEFAULT ((0)) NOT NULL
 CONSTRAINT PK_NIT_RESFISCAL PRIMARY KEY CLUSTERED (TRF_ID),
 CONSTRAINT CK_NIT_RESFISCALTRF_COD CHECK ((len([TRF_COD])>(0))),
 CONSTRAINT CK_NIT_RESFISCALTRF_NIT CHECK ((len([TRF_NIT])>(0))))
GO
