SQL Server 2005 (script produced trought management studio):

table SGTALIQDATA:

USE [SGT]

GO

/****** Object: Table [dbo].[SGTALIQDATA] Script Date: 08/14/2009 13:59:52 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo].[SGTALIQDATA](

[CODLIQ] [int] NOT NULL,

[ANONOTAS] [int] NULL,

[ESTANCIA] [varchar](5) NULL,

[DATAEMISSAO] [datetime] NOT NULL,

[NUMDU] [varchar](20) NOT NULL,

[DATAEXPIRACAO] [datetime] NOT NULL,

[CODCTBIRREG] [int] NULL,

[NOMEFICH] [varchar](20) NULL,

[DUORIGINAL] [varchar](20) NULL,

[TIPOID] [int] NOT NULL CONSTRAINT [DF_SGTALIQDATA_TIPOID] DEFAULT (1),

[CODCR] [int] NULL,

[NUMLIVRE] [varchar](20) NULL,

[DUORIGINAL2] [varchar](20) NULL,

[SEPARADO] [varchar](20) NULL,

[CODDESP] [int] NULL,

[CODAREASERVICO] [int] NULL,

CONSTRAINT [IX_SGTALIQDATA] UNIQUE CLUSTERED

(

[CODLIQ] DESC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

) ON [PRIMARY]

GO

SET ANSI_PADDING OFF

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Armazena o nº da nota que originou a liquidação adicional' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SGTALIQDATA', @level2type=N'COLUMN',@level2name=N'DUORIGINAL'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ID utilizada na importacao do fich. 1=NIF, 2=RGC' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SGTALIQDATA', @level2type=N'COLUMN',@level2name=N'TIPOID'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Armazena o nº da nota que originou a liquidação oficiosa (não adicional)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SGTALIQDATA', @level2type=N'COLUMN',@level2name=N'DUORIGINAL2'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Número do separado de bagagem' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SGTALIQDATA', @level2type=N'COLUMN',@level2name=N'SEPARADO'

GO

ALTER TABLE [dbo].[SGTALIQDATA] WITH CHECK ADD CONSTRAINT [FK_SGTALIQDATA_AREASERVICO] FOREIGN KEY([CODAREASERVICO])

REFERENCES [dbo].[AREASERVICO] ([CODAREASERVICO])

GO

ALTER TABLE [dbo].[SGTALIQDATA] CHECK CONSTRAINT [FK_SGTALIQDATA_AREASERVICO]

GO

ALTER TABLE [dbo].[SGTALIQDATA] WITH NOCHECK ADD CONSTRAINT [FK_SGTALIQDATA_DESPACHANTES] FOREIGN KEY([CODDESP])

REFERENCES [dbo].[DESPACHANTES] ([codDesp])

GO

ALTER TABLE [dbo].[SGTALIQDATA] CHECK CONSTRAINT [FK_SGTALIQDATA_DESPACHANTES]

table Liquidacao:

/****** Object: Table [dbo].[LIQUIDACAO] Script Date: 08/14/2009 14:02:22 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo].[LIQUIDACAO](

[CODLIQ] [int] IDENTITY(1,1) NOT NULL,

[NUMLIQ] [varchar](50) NOT NULL,

[LANCLIQ] [int] NOT NULL,

[DATALIQ] [datetime] NOT NULL,

[HORALIQ] [datetime] NOT NULL,

[VALORTRIB] [float] NOT NULL,

[CODCTB] [int] NOT NULL,

[CODRF] [int] NULL,

[CODFUNC] [int] NULL,

[DATALIQANUL] [datetime] NULL,

[HORALIQANUL] [datetime] NULL,

[CODARF] [int] NULL,

[CODAFUNC] [int] NULL,

[DIASJUROS] [float] NULL,

[TAXAMENSALJUROS] [float] NULL,

[CODIMP] [int] NULL,

[ANOLIQ] [varchar](50) NOT NULL,

[DESCPERIODO] [varchar](50) NOT NULL,

[CODPERIODO] [int] NULL,

[CODTLIQ1] [int] NULL,

[CODTLIQ2] [int] NULL,

[TXTRIB] [float] NULL,

[IMPTRIB] [float] NOT NULL,

[VALORJUROS] [float] NULL,

[JUROSPAGAR] [float] NULL,

[MULTAID] [char](50) NULL,

[MULTAVALOR] [float] NULL,

[CUSTAID] [char](50) NULL,

[CUSTAVALOR] [float] NULL,

[IMPCOB] [float] NULL CONSTRAINT [DF__LIQUIDACA__IMPCO__48CFD27E] DEFAULT (0),

[IMPPAGAR] [float] NULL CONSTRAINT [DF__LIQUIDACA__IMPPA__49C3F6B7] DEFAULT (0),

[CODDAR] [int] NULL,

[CODNOTIFICA] [int] NULL,

[CODCR] [int] NULL,

[CODTPAG] [int] NULL,

[PAGEFECT] [float] NOT NULL CONSTRAINT [DF__LIQUIDACA__PAGEF__4AB81AF0] DEFAULT (0),

[CODDLIORIG] [int] NULL,

[TIPODLI] [float] NOT NULL,

[CODCRORIG] [int] NULL,

[CODANULA] [int] NULL,

CONSTRAINT [PK__LIQUIDACAO__46E78A0C] PRIMARY KEY CLUSTERED

(

[CODLIQ] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY],

CONSTRAINT [AK_LIQUIDACAO_LANCLIQ] UNIQUE NONCLUSTERED

(

[LANCLIQ] ASC,

[DATALIQ] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY],

CONSTRAINT [AK_LIQUIDACAO_NUMLIQ] UNIQUE NONCLUSTERED

(

[NUMLIQ] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

) ON [PRIMARY]

GO

SET ANSI_PADDING OFF

GO

ALTER TABLE [dbo].[LIQUIDACAO] WITH NOCHECK ADD CONSTRAINT [FK__LIQUIDACA__CODAF__3864608B] FOREIGN KEY([CODAFUNC])

REFERENCES [dbo].[FUNCIONARIO] ([CODFUNC])

GO

ALTER TABLE [dbo].[LIQUIDACAO] CHECK CONSTRAINT [FK__LIQUIDACA__CODAF__3864608B]

GO

ALTER TABLE [dbo].[LIQUIDACAO] WITH NOCHECK ADD CONSTRAINT [FK__LIQUIDACA__CODCR__32AB8735] FOREIGN KEY([CODCR])

REFERENCES [dbo].[CRELAXE] ([CODCR])

GO

ALTER TABLE [dbo].[LIQUIDACAO] CHECK CONSTRAINT [FK__LIQUIDACA__CODCR__32AB8735]

GO

ALTER TABLE [dbo].[LIQUIDACAO] WITH NOCHECK ADD CONSTRAINT [FK__LIQUIDACA__CODCR__339FAB6E] FOREIGN KEY([CODCRORIG])

REFERENCES [dbo].[CRELAXE] ([CODCR])

GO

ALTER TABLE [dbo].[LIQUIDACAO] CHECK CONSTRAINT [FK__LIQUIDACA__CODCR__339FAB6E]

GO

ALTER TABLE [dbo].[LIQUIDACAO] WITH NOCHECK ADD CONSTRAINT [FK__LIQUIDACA__CODDL__489AC854] FOREIGN KEY([CODDLIORIG])

REFERENCES [dbo].[LIQUIDACAO] ([CODLIQ])

GO

ALTER TABLE [dbo].[LIQUIDACAO] CHECK CONSTRAINT [FK__LIQUIDACA__CODDL__489AC854]

GO

ALTER TABLE [dbo].[LIQUIDACAO] WITH NOCHECK ADD CONSTRAINT [FK__LIQUIDACA__CODFU__395884C4] FOREIGN KEY([CODFUNC])

REFERENCES [dbo].[FUNCIONARIO] ([CODFUNC])

GO

ALTER TABLE [dbo].[LIQUIDACAO] CHECK CONSTRAINT [FK__LIQUIDACA__CODFU__395884C4]

GO

ALTER TABLE [dbo].[LIQUIDACAO] WITH NOCHECK ADD CONSTRAINT [FK__LIQUIDACA__CODIM__40F9A68C] FOREIGN KEY([CODIMP])

REFERENCES [dbo].[IMPOSTO] ([CODIMP])

GO

ALTER TABLE [dbo].[LIQUIDACAO] CHECK CONSTRAINT [FK__LIQUIDACA__CODIM__40F9A68C]

GO

ALTER TABLE [dbo].[LIQUIDACAO] WITH NOCHECK ADD CONSTRAINT [FK__LIQUIDACA__CODNO__4E53A1AA] FOREIGN KEY([CODNOTIFICA])

REFERENCES [dbo].[NOTIFICACAO] ([CODNOTIFICA])

GO

ALTER TABLE [dbo].[LIQUIDACAO] CHECK CONSTRAINT [FK__LIQUIDACA__CODNO__4E53A1AA]

GO

ALTER TABLE [dbo].[LIQUIDACAO] WITH NOCHECK ADD CONSTRAINT [FK__LIQUIDACA__CODPE__51300E55] FOREIGN KEY([CODPERIODO])

REFERENCES [dbo].[PERIODICIDADE] ([CODPERIODO])

GO

ALTER TABLE [dbo].[LIQUIDACAO] CHECK CONSTRAINT [FK__LIQUIDACA__CODPE__51300E55]

GO

ALTER TABLE [dbo].[LIQUIDACAO] WITH NOCHECK ADD CONSTRAINT [FK__LIQUIDACA__CODTL__531856C7] FOREIGN KEY([CODTLIQ2])

REFERENCES [dbo].[TLIQUIDACAO] ([CODTLIQ])

GO

ALTER TABLE [dbo].[LIQUIDACAO] CHECK CONSTRAINT [FK__LIQUIDACA__CODTL__531856C7]

GO

ALTER TABLE [dbo].[LIQUIDACAO] WITH NOCHECK ADD CONSTRAINT [FK__LIQUIDACA__CODTP__55F4C372] FOREIGN KEY([CODTPAG])

REFERENCES [dbo].[TPAGAMENTO] ([CODTPAG])

GO

ALTER TABLE [dbo].[LIQUIDACAO] CHECK CONSTRAINT [FK__LIQUIDACA__CODTP__55F4C372]

GO

ALTER TABLE [dbo].[LIQUIDACAO] WITH NOCHECK ADD CONSTRAINT [CK__LIQUIDACA__CODTL__47DBAE45] CHECK (([CODTLIQ1] = 1 or [CODTLIQ1] = 0))

GO

ALTER TABLE [dbo].[LIQUIDACAO] CHECK CONSTRAINT [CK__LIQUIDACA__CODTL__47DBAE45]

GO

ALTER TABLE [dbo].[LIQUIDACAO] WITH NOCHECK ADD CONSTRAINT [CK__LIQUIDACA__PAGEF__4BAC3F29] CHECK (([PAGEFECT] = 1 or [PAGEFECT] = 0))

GO

ALTER TABLE [dbo].[LIQUIDACAO] CHECK CONSTRAINT [CK__LIQUIDACA__PAGEF__4BAC3F29]

GO

ALTER TABLE [dbo].[LIQUIDACAO] WITH NOCHECK ADD CONSTRAINT [CK__LIQUIDACA__TIPOD__4CA06362] CHECK (([TIPODLI] = 1 or [TIPODLI] = 0))

GO

ALTER TABLE [dbo].[LIQUIDACAO] CHECK CONSTRAINT [CK__LIQUIDACA__TIPOD__4CA06362]

Script SQL Server 2000 (trought management studio):

table SGTALIQDATA:

USE [SGT]

GO

/****** Object: Table [dbo].[SGTALIQDATA] Script Date: 08/14/2009 14:07:44 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo].[SGTALIQDATA](

[CODLIQ] [int] NOT NULL,

[ANONOTAS] [int] NULL,

[ESTANCIA] [varchar](5) NULL,

[DATAEMISSAO] [datetime] NOT NULL,

[NUMDU] [varchar](20) NOT NULL,

[DATAEXPIRACAO] [datetime] NOT NULL,

[CODCTBIRREG] [int] NULL,

[NOMEFICH] [varchar](20) NULL,

[DUORIGINAL] [varchar](20) NULL,

[TIPOID] [int] NOT NULL CONSTRAINT [DF_SGTALIQDATA_TIPOID] DEFAULT (1),

[CODCR] [int] NULL,

[NUMLIVRE] [varchar](20) NULL,

[DUORIGINAL2] [varchar](20) NULL,

[SEPARADO] [varchar](20) NULL,

[CODDESP] [int] NULL,

[CODAREASERVICO] [int] NULL,

CONSTRAINT [IX_SGTALIQDATA] UNIQUE CLUSTERED

(

[CODLIQ] DESC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

) ON [PRIMARY]

GO

SET ANSI_PADDING OFF

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Armazena o nº da nota que originou a liquidação adicional' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SGTALIQDATA', @level2type=N'COLUMN',@level2name=N'DUORIGINAL'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ID utilizada na importacao do fich. 1=NIF, 2=RGC' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SGTALIQDATA', @level2type=N'COLUMN',@level2name=N'TIPOID'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Armazena o nº da nota que originou a liquidação oficiosa (não adicional)' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SGTALIQDATA', @level2type=N'COLUMN',@level2name=N'DUORIGINAL2'

GO

EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Número do separado de bagagem' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'SGTALIQDATA', @level2type=N'COLUMN',@level2name=N'SEPARADO'

GO

ALTER TABLE [dbo].[SGTALIQDATA] WITH CHECK ADD CONSTRAINT [FK_SGTALIQDATA_AREASERVICO] FOREIGN KEY([CODAREASERVICO])

REFERENCES [dbo].[AREASERVICO] ([CODAREASERVICO])

GO

ALTER TABLE [dbo].[SGTALIQDATA] CHECK CONSTRAINT [FK_SGTALIQDATA_AREASERVICO]

GO

ALTER TABLE [dbo].[SGTALIQDATA] WITH NOCHECK ADD CONSTRAINT [FK_SGTALIQDATA_DESPACHANTES] FOREIGN KEY([CODDESP])

REFERENCES [dbo].[DESPACHANTES] ([codDesp])

GO

ALTER TABLE [dbo].[SGTALIQDATA] CHECK CONSTRAINT [FK_SGTALIQDATA_DESPACHANTES]

table liquidacao:

USE [SGT]

GO

/****** Object: Table [dbo].[LIQUIDACAO] Script Date: 08/14/2009 14:08:44 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo].[LIQUIDACAO](

[CODLIQ] [int] IDENTITY(1,1) NOT NULL,

[NUMLIQ] [varchar](50) NOT NULL,

[LANCLIQ] [int] NOT NULL,

[DATALIQ] [datetime] NOT NULL,

[HORALIQ] [datetime] NOT NULL,

[VALORTRIB] [float] NOT NULL,

[CODCTB] [int] NOT NULL,

[CODRF] [int] NULL,

[CODFUNC] [int] NULL,

[DATALIQANUL] [datetime] NULL,

[HORALIQANUL] [datetime] NULL,

[CODARF] [int] NULL,

[CODAFUNC] [int] NULL,

[DIASJUROS] [float] NULL,

[TAXAMENSALJUROS] [float] NULL,

[CODIMP] [int] NULL,

[ANOLIQ] [varchar](50) NOT NULL,

[DESCPERIODO] [varchar](50) NOT NULL,

[CODPERIODO] [int] NULL,

[CODTLIQ1] [int] NULL,

[CODTLIQ2] [int] NULL,

[TXTRIB] [float] NULL,

[IMPTRIB] [float] NOT NULL,

[VALORJUROS] [float] NULL,

[JUROSPAGAR] [float] NULL,

[MULTAID] [char](50) NULL,

[MULTAVALOR] [float] NULL,

[CUSTAID] [char](50) NULL,

[CUSTAVALOR] [float] NULL,

[IMPCOB] [float] NULL CONSTRAINT [DF__LIQUIDACA__IMPCO__48CFD27E] DEFAULT (0),

[IMPPAGAR] [float] NULL CONSTRAINT [DF__LIQUIDACA__IMPPA__49C3F6B7] DEFAULT (0),

[CODDAR] [int] NULL,

[CODNOTIFICA] [int] NULL,

[CODCR] [int] NULL,

[CODTPAG] [int] NULL,

[PAGEFECT] [float] NOT NULL CONSTRAINT [DF__LIQUIDACA__PAGEF__4AB81AF0] DEFAULT (0),

[CODDLIORIG] [int] NULL,

[TIPODLI] [float] NOT NULL,

[CODCRORIG] [int] NULL,

[CODANULA] [int] NULL,

CONSTRAINT [PK__LIQUIDACAO__46E78A0C] PRIMARY KEY CLUSTERED

(

[CODLIQ] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY],

CONSTRAINT [AK_LIQUIDACAO_LANCLIQ] UNIQUE NONCLUSTERED

(

[LANCLIQ] ASC,

[DATALIQ] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY],

CONSTRAINT [AK_LIQUIDACAO_NUMLIQ] UNIQUE NONCLUSTERED

(

[NUMLIQ] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

) ON [PRIMARY]

GO

SET ANSI_PADDING OFF

GO

ALTER TABLE [dbo].[LIQUIDACAO] WITH NOCHECK ADD CONSTRAINT [FK__LIQUIDACA__CODAF__3864608B] FOREIGN KEY([CODAFUNC])

REFERENCES [dbo].[FUNCIONARIO] ([CODFUNC])

GO

ALTER TABLE [dbo].[LIQUIDACAO] CHECK CONSTRAINT [FK__LIQUIDACA__CODAF__3864608B]

GO

ALTER TABLE [dbo].[LIQUIDACAO] WITH NOCHECK ADD CONSTRAINT [FK__LIQUIDACA__CODCR__32AB8735] FOREIGN KEY([CODCR])

REFERENCES [dbo].[CRELAXE] ([CODCR])

GO

ALTER TABLE [dbo].[LIQUIDACAO] CHECK CONSTRAINT [FK__LIQUIDACA__CODCR__32AB8735]

GO

ALTER TABLE [dbo].[LIQUIDACAO] WITH NOCHECK ADD CONSTRAINT [FK__LIQUIDACA__CODCR__339FAB6E] FOREIGN KEY([CODCRORIG])

REFERENCES [dbo].[CRELAXE] ([CODCR])

GO

ALTER TABLE [dbo].[LIQUIDACAO] CHECK CONSTRAINT [FK__LIQUIDACA__CODCR__339FAB6E]

GO

ALTER TABLE [dbo].[LIQUIDACAO] WITH NOCHECK ADD CONSTRAINT [FK__LIQUIDACA__CODDL__489AC854] FOREIGN KEY([CODDLIORIG])

REFERENCES [dbo].[LIQUIDACAO] ([CODLIQ])

GO

ALTER TABLE [dbo].[LIQUIDACAO] CHECK CONSTRAINT [FK__LIQUIDACA__CODDL__489AC854]

GO

ALTER TABLE [dbo].[LIQUIDACAO] WITH NOCHECK ADD CONSTRAINT [FK__LIQUIDACA__CODFU__395884C4] FOREIGN KEY([CODFUNC])

REFERENCES [dbo].[FUNCIONARIO] ([CODFUNC])

GO

ALTER TABLE [dbo].[LIQUIDACAO] CHECK CONSTRAINT [FK__LIQUIDACA__CODFU__395884C4]

GO

ALTER TABLE [dbo].[LIQUIDACAO] WITH NOCHECK ADD CONSTRAINT [FK__LIQUIDACA__CODIM__40F9A68C] FOREIGN KEY([CODIMP])

REFERENCES [dbo].[IMPOSTO] ([CODIMP])

GO

ALTER TABLE [dbo].[LIQUIDACAO] CHECK CONSTRAINT [FK__LIQUIDACA__CODIM__40F9A68C]

GO

ALTER TABLE [dbo].[LIQUIDACAO] WITH NOCHECK ADD CONSTRAINT [FK__LIQUIDACA__CODNO__4E53A1AA] FOREIGN KEY([CODNOTIFICA])

REFERENCES [dbo].[NOTIFICACAO] ([CODNOTIFICA])

GO

ALTER TABLE [dbo].[LIQUIDACAO] CHECK CONSTRAINT [FK__LIQUIDACA__CODNO__4E53A1AA]

GO

ALTER TABLE [dbo].[LIQUIDACAO] WITH NOCHECK ADD CONSTRAINT [FK__LIQUIDACA__CODPE__51300E55] FOREIGN KEY([CODPERIODO])

REFERENCES [dbo].[PERIODICIDADE] ([CODPERIODO])

GO

ALTER TABLE [dbo].[LIQUIDACAO] CHECK CONSTRAINT [FK__LIQUIDACA__CODPE__51300E55]

GO

ALTER TABLE [dbo].[LIQUIDACAO] WITH NOCHECK ADD CONSTRAINT [FK__LIQUIDACA__CODTL__531856C7] FOREIGN KEY([CODTLIQ2])

REFERENCES [dbo].[TLIQUIDACAO] ([CODTLIQ])

GO

ALTER TABLE [dbo].[LIQUIDACAO] CHECK CONSTRAINT [FK__LIQUIDACA__CODTL__531856C7]

GO

ALTER TABLE [dbo].[LIQUIDACAO] WITH NOCHECK ADD CONSTRAINT [FK__LIQUIDACA__CODTP__55F4C372] FOREIGN KEY([CODTPAG])

REFERENCES [dbo].[TPAGAMENTO] ([CODTPAG])

GO

ALTER TABLE [dbo].[LIQUIDACAO] CHECK CONSTRAINT [FK__LIQUIDACA__CODTP__55F4C372]

GO

ALTER TABLE [dbo].[LIQUIDACAO] WITH NOCHECK ADD CONSTRAINT [CK__LIQUIDACA__CODTL__47DBAE45] CHECK (([CODTLIQ1] = 1 or [CODTLIQ1] = 0))

GO

ALTER TABLE [dbo].[LIQUIDACAO] CHECK CONSTRAINT [CK__LIQUIDACA__CODTL__47DBAE45]

GO

ALTER TABLE [dbo].[LIQUIDACAO] WITH NOCHECK ADD CONSTRAINT [CK__LIQUIDACA__PAGEF__4BAC3F29] CHECK (([PAGEFECT] = 1 or [PAGEFECT] = 0))

GO

ALTER TABLE [dbo].[LIQUIDACAO] CHECK CONSTRAINT [CK__LIQUIDACA__PAGEF__4BAC3F29]

GO

ALTER TABLE [dbo].[LIQUIDACAO] WITH NOCHECK ADD CONSTRAINT [CK__LIQUIDACA__TIPOD__4CA06362] CHECK (([TIPODLI] = 1 or [TIPODLI] = 0))

GO

ALTER TABLE [dbo].[LIQUIDACAO] CHECK CONSTRAINT [CK__LIQUIDACA__TIPOD__4CA06362]

thank you