create database NAVARRA


USE [NAVARRA]
GO
/****** Object:  Table [dbo].[CatPr]    Script Date: 29-04-2025 22:54:24 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[CatPr](
	[Ano] [smallint] NOT NULL,
	[Empresa] [nvarchar](30) NOT NULL,
	[CCatP] [nvarchar](7) NOT NULL,
	[Descr] [nvarchar](40) NOT NULL,
	[DETEFP] [int] NOT NULL,
 CONSTRAINT [IxCatPr] PRIMARY KEY CLUSTERED 
(
	[Ano] ASC,
	[Empresa] ASC,
	[CCatP] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[Depar]    Script Date: 29-04-2025 22:54:24 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Depar](
	[Ano] [smallint] NOT NULL,
	[Empresa] [nvarchar](30) NOT NULL,
	[CDep] [smallint] NOT NULL,
	[Sigla] [nvarchar](7) NOT NULL,
	[Descr] [nvarchar](20) NOT NULL,
 CONSTRAINT [IxDepar] PRIMARY KEY CLUSTERED 
(
	[Ano] ASC,
	[Empresa] ASC,
	[CDep] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[Estab]    Script Date: 29-04-2025 22:54:24 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Estab](
	[Ano] [smallint] NOT NULL,
	[Empresa] [nvarchar](30) NOT NULL,
	[CEst] [smallint] NOT NULL,
	[Nome] [nvarchar](40) NOT NULL,
	[Morada] [nvarchar](40) NOT NULL,
	[Localidade] [nvarchar](25) NOT NULL,
	[CodPostal] [nvarchar](30) NOT NULL,
	[TelNum] [nvarchar](15) NOT NULL,
	[FaxNum] [nvarchar](15) NOT NULL,
	[Distrito] [nvarchar](20) NOT NULL,
	[Regiao] [nvarchar](1) NOT NULL,
	[Concelho] [nvarchar](20) NOT NULL,
	[Freguesia] [nvarchar](20) NOT NULL,
	[CPais] [smallint] NOT NULL,
	[EMail] [nvarchar](60) NOT NULL,
	[Actividade] [nvarchar](40) NOT NULL,
	[NSegSoc] [nvarchar](12) NOT NULL,
	[NSegSocNew] [nvarchar](11) NOT NULL,
	[CCSS] [smallint] NOT NULL,
	[CEstSgS] [smallint] NOT NULL,
	[CAE] [nvarchar](5) NOT NULL,
	[NSerCA] [int] NOT NULL,
	[FileDir] [nvarchar](100) NOT NULL,
	[CEstRU] [int] NOT NULL,
	[CDMFRU] [nvarchar](6) NOT NULL,
 CONSTRAINT [IxEstab] PRIMARY KEY CLUSTERED 
(
	[Ano] ASC,
	[Empresa] ASC,
	[CEst] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[Funci]    Script Date: 29-04-2025 22:54:24 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Funci](
	[Ano] [smallint] NOT NULL,
	[Empresa] [nvarchar](30) NOT NULL,
	[CFun] [int] NOT NULL,
	[Nome] [nvarchar](60) NULL,
	[Morada] [nvarchar](40) NULL,
	[Localidade] [nvarchar](40) NULL,
	[CodPostal] [nvarchar](40) NULL,
	[CEst] [smallint] NULL,
	[CSec] [smallint] NULL,
	[CDep] [smallint] NULL,
	[Foto] [image] NULL,
	[Contribuinte] [nvarchar](12) NULL,
	[Sexo] [nvarchar](1) NULL,
	[CPais] [smallint] NULL,
	[DtNasc] [datetime] NULL,
	[CCondNum] [nvarchar](15) NULL,
	[CHlit] [smallint] NULL,
	[CProf] [nvarchar](6) NULL,
	[CCatP] [nvarchar](7) NULL,
	[DtAdmis] [datetime] NULL,
	[DtFimContr] [datetime] NULL,
	[TCont] [int] NULL,
	[EDemit] [bit] NULL,
	[DtDemis] [datetime] NULL,
	[CSind] [nvarchar](7) NULL,
 CONSTRAINT [PK_Funci] PRIMARY KEY CLUSTERED 
(
	[Ano] ASC,
	[Empresa] ASC,
	[CFun] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
/****** Object:  Table [dbo].[HLite]    Script Date: 29-04-2025 22:54:24 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[HLite](
	[Ano] [smallint] NOT NULL,
	[Empresa] [nvarchar](30) NOT NULL,
	[CHLit] [smallint] NOT NULL,
	[Sigla] [nvarchar](20) NOT NULL,
	[Descr] [nvarchar](80) NOT NULL,
	[Obs] [nvarchar](max) NOT NULL,
	[EdeMov] [bit] NOT NULL,
	[THLitRU] [tinyint] NOT NULL,
	[CHLitRU] [int] NOT NULL,
	[OSigla] [nvarchar](7) NOT NULL,
 CONSTRAINT [IxHLite] PRIMARY KEY CLUSTERED 
(
	[Ano] ASC,
	[Empresa] ASC,
	[CHLit] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
/****** Object:  Table [dbo].[HsEve]    Script Date: 29-04-2025 22:54:24 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[HsEve](
	[Ano] [smallint] NOT NULL,
	[Empresa] [nvarchar](30) NOT NULL,
	[Data] [datetime] NOT NULL,
	[TEve] [nvarchar](10) NOT NULL,
	[CFun] [int] NOT NULL,
	[Descr] [nvarchar](60) NOT NULL,
	[Qtd1] [real] NOT NULL,
	[Qtd2] [real] NOT NULL,
	[Info1] [nvarchar](20) NOT NULL,
	[Info2] [nvarchar](20) NOT NULL,
	[Obs] [nvarchar](max) NOT NULL,
	[EAg] [bit] NOT NULL,
	[ResAg] [int] NOT NULL,
	[DtRAg] [datetime] NULL,
	[DtLAg] [datetime] NULL,
	[FSitFrq] [tinyint] NOT NULL,
	[FPerRef] [nvarchar](20) NOT NULL,
	[FAreEdu] [smallint] NOT NULL,
	[FModal] [tinyint] NOT NULL,
	[FTipIni] [tinyint] NOT NULL,
	[FTipHor] [tinyint] NOT NULL,
	[FTipEnt] [tinyint] NOT NULL,
	[FTipCer] [tinyint] NOT NULL,
	[FNivQua] [tinyint] NOT NULL,
	[DDtIni] [datetime] NULL,
	[DDtFim] [datetime] NULL,
	[DCPais] [smallint] NOT NULL,
	[COper] [nvarchar](25) NOT NULL,
	[SHSTTipo] [nvarchar](1) NOT NULL,
	[SHSTVarCTab1] [smallint] NOT NULL,
	[SHSTVarCTab2] [nvarchar](15) NOT NULL,
	[SHSTVarStr1] [nvarchar](50) NOT NULL,
	[SHSTVarNum1] [smallint] NOT NULL,
	[SHSTVarBol1] [bit] NOT NULL,
	[DBTS] [datetime] NULL,
 CONSTRAINT [IxHsEve] PRIMARY KEY CLUSTERED 
(
	[Ano] ASC,
	[Empresa] ASC,
	[Data] ASC,
	[TEve] ASC,
	[CFun] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
/****** Object:  Table [dbo].[isi_Empresas]    Script Date: 29-04-2025 22:54:24 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[isi_Empresas](
	[Ano] [smallint] NOT NULL,
	[BD] [nvarchar](30) NOT NULL,
	[Nome] [nvarchar](50) NULL,
 CONSTRAINT [PK_isi_Empresas] PRIMARY KEY CLUSTERED 
(
	[Ano] ASC,
	[BD] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[isi_sistema]    Script Date: 29-04-2025 22:54:24 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[isi_sistema](
	[Numero] [smallint] NOT NULL,
	[VersaoCatalogo] [int] NULL,
	[Logotipo] [image] NULL,
	[versaoEXE] [nvarchar](25) NULL,
 CONSTRAINT [PK_isi_sistema] PRIMARY KEY CLUSTERED 
(
	[Numero] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
/****** Object:  Table [dbo].[isi_Utilizadores]    Script Date: 29-04-2025 22:54:24 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[isi_Utilizadores](
	[CodUtiliz] [nvarchar](10) NOT NULL,
	[Nome] [nvarchar](50) NULL,
	[Nivel] [smallint] NULL,
	[Password] [nvarchar](15) NULL,
	[eMail] [nvarchar](50) NULL,
 CONSTRAINT [PK_isi_Utilizadores_1] PRIMARY KEY CLUSTERED 
(
	[CodUtiliz] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[Profi]    Script Date: 29-04-2025 22:54:24 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Profi](
	[Ano] [smallint] NOT NULL,
	[Empresa] [nvarchar](30) NOT NULL,
	[CProf] [nvarchar](6) NOT NULL,
	[Sigla] [nvarchar](50) NOT NULL,
	[Descr] [nvarchar](255) NOT NULL,
	[Obs] [nvarchar](max) NOT NULL,
	[EdeMov] [bit] NOT NULL,
	[CPP2010] [nvarchar](6) NOT NULL,
	[ODescr] [nvarchar](30) NOT NULL,
 CONSTRAINT [IxProfi] PRIMARY KEY CLUSTERED 
(
	[Ano] ASC,
	[Empresa] ASC,
	[CProf] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
/****** Object:  Table [dbo].[Secca]    Script Date: 29-04-2025 22:54:24 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Secca](
	[Ano] [smallint] NOT NULL,
	[Empresa] [nvarchar](30) NOT NULL,
	[CSec] [smallint] NOT NULL,
	[Sigla] [nvarchar](7) NOT NULL,
	[Descr] [nvarchar](20) NOT NULL,
 CONSTRAINT [IxSecca] PRIMARY KEY CLUSTERED 
(
	[Ano] ASC,
	[Empresa] ASC,
	[CSec] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[Sindi]    Script Date: 29-04-2025 22:54:24 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Sindi](
	[Ano] [smallint] NOT NULL,
	[Empresa] [nvarchar](30) NOT NULL,
	[CSind] [nvarchar](7) NOT NULL,
	[Descr] [nvarchar](40) NOT NULL,
	[ValTx] [money] NOT NULL,
	[ETaxa] [bit] NOT NULL,
 CONSTRAINT [IxSindi] PRIMARY KEY CLUSTERED 
(
	[Ano] ASC,
	[Empresa] ASC,
	[CSind] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[TCont]    Script Date: 29-04-2025 22:54:24 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[TCont](
	[Ano] [smallint] NOT NULL,
	[Empresa] [nvarchar](30) NOT NULL,
	[TCont] [int] NOT NULL,
	[Sigla] [nvarchar](20) NOT NULL,
	[Descr] [nvarchar](80) NOT NULL,
	[Obs] [nvarchar](255) NOT NULL,
	[Termo] [nvarchar](1) NOT NULL,
	[TContRU] [nvarchar](2) NOT NULL,
	[MtCurDur] [bit] NOT NULL,
	[TContSS] [nvarchar](2) NOT NULL,
	[TContFCT] [nvarchar](2) NOT NULL,
 CONSTRAINT [IxTCont] PRIMARY KEY CLUSTERED 
(
	[Ano] ASC,
	[Empresa] ASC,
	[TCont] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[ZPais]    Script Date: 29-04-2025 22:54:25 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[ZPais](
	[Ano] [smallint] NOT NULL,
	[Empresa] [nvarchar](30) NOT NULL,
	[CPais] [smallint] NOT NULL,
	[Descr] [nvarchar](20) NOT NULL,
	[CPaisQP] [smallint] NOT NULL,
	[CPaisISO] [nvarchar](2) NOT NULL,
 CONSTRAINT [IxZPais] PRIMARY KEY CLUSTERED 
(
	[Ano] ASC,
	[Empresa] ASC,
	[CPais] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[CatPr] ADD  CONSTRAINT [DF_CatPr_CCatP]  DEFAULT ('') FOR [CCatP]
GO
ALTER TABLE [dbo].[CatPr] ADD  CONSTRAINT [DF_CatPr_Descr]  DEFAULT ('') FOR [Descr]
GO
ALTER TABLE [dbo].[CatPr] ADD  CONSTRAINT [DF_CatPr_DETEFP]  DEFAULT ((0)) FOR [DETEFP]
GO
ALTER TABLE [dbo].[Depar] ADD  CONSTRAINT [DF_Depar_CDep]  DEFAULT ((0)) FOR [CDep]
GO
ALTER TABLE [dbo].[Depar] ADD  CONSTRAINT [DF_Depar_Sigla]  DEFAULT ('') FOR [Sigla]
GO
ALTER TABLE [dbo].[Depar] ADD  CONSTRAINT [DF_Depar_Descr]  DEFAULT ('') FOR [Descr]
GO
ALTER TABLE [dbo].[Estab] ADD  CONSTRAINT [DF_Estab_CEst]  DEFAULT ((0)) FOR [CEst]
GO
ALTER TABLE [dbo].[Estab] ADD  CONSTRAINT [DF_Estab_Nome]  DEFAULT ('') FOR [Nome]
GO
ALTER TABLE [dbo].[Estab] ADD  CONSTRAINT [DF_Estab_Morada]  DEFAULT ('') FOR [Morada]
GO
ALTER TABLE [dbo].[Estab] ADD  CONSTRAINT [DF_Estab_Localidade]  DEFAULT ('') FOR [Localidade]
GO
ALTER TABLE [dbo].[Estab] ADD  CONSTRAINT [DF_Estab_CodPostal]  DEFAULT ('') FOR [CodPostal]
GO
ALTER TABLE [dbo].[Estab] ADD  CONSTRAINT [DF_Estab_TelNum]  DEFAULT ('') FOR [TelNum]
GO
ALTER TABLE [dbo].[Estab] ADD  CONSTRAINT [DF_Estab_FaxNum]  DEFAULT ('') FOR [FaxNum]
GO
ALTER TABLE [dbo].[Estab] ADD  CONSTRAINT [DF_Estab_Distrito]  DEFAULT ('') FOR [Distrito]
GO
ALTER TABLE [dbo].[Estab] ADD  CONSTRAINT [DF_Estab_Regiao]  DEFAULT ('') FOR [Regiao]
GO
ALTER TABLE [dbo].[Estab] ADD  CONSTRAINT [DF_Estab_Concelho]  DEFAULT ('') FOR [Concelho]
GO
ALTER TABLE [dbo].[Estab] ADD  CONSTRAINT [DF_Estab_Freguesia]  DEFAULT ('') FOR [Freguesia]
GO
ALTER TABLE [dbo].[Estab] ADD  CONSTRAINT [DF_Estab_CPais]  DEFAULT ((0)) FOR [CPais]
GO
ALTER TABLE [dbo].[Estab] ADD  CONSTRAINT [DF_Estab_EMail]  DEFAULT ('') FOR [EMail]
GO
ALTER TABLE [dbo].[Estab] ADD  CONSTRAINT [DF_Estab_Actividade]  DEFAULT ('') FOR [Actividade]
GO
ALTER TABLE [dbo].[Estab] ADD  CONSTRAINT [DF_Estab_NSegSoc]  DEFAULT ('') FOR [NSegSoc]
GO
ALTER TABLE [dbo].[Estab] ADD  CONSTRAINT [DF_Estab_NSegSocNew]  DEFAULT ('') FOR [NSegSocNew]
GO
ALTER TABLE [dbo].[Estab] ADD  CONSTRAINT [DF_Estab_CCSS]  DEFAULT ((0)) FOR [CCSS]
GO
ALTER TABLE [dbo].[Estab] ADD  CONSTRAINT [DF_Estab_CEstSgS]  DEFAULT ((0)) FOR [CEstSgS]
GO
ALTER TABLE [dbo].[Estab] ADD  CONSTRAINT [DF_Estab_CAE]  DEFAULT ('') FOR [CAE]
GO
ALTER TABLE [dbo].[Estab] ADD  CONSTRAINT [DF_Estab_NSerCA]  DEFAULT ((0)) FOR [NSerCA]
GO
ALTER TABLE [dbo].[Estab] ADD  CONSTRAINT [DF_Estab_FileDir]  DEFAULT ('') FOR [FileDir]
GO
ALTER TABLE [dbo].[Estab] ADD  CONSTRAINT [DF_Estab_CEstRU]  DEFAULT ((0)) FOR [CEstRU]
GO
ALTER TABLE [dbo].[Estab] ADD  CONSTRAINT [DF_Estab_CDMFRU]  DEFAULT ('') FOR [CDMFRU]
GO
ALTER TABLE [dbo].[HLite] ADD  CONSTRAINT [DF_HLite_CHLit]  DEFAULT ((0)) FOR [CHLit]
GO
ALTER TABLE [dbo].[HLite] ADD  CONSTRAINT [DF_HLite_Sigla]  DEFAULT ('') FOR [Sigla]
GO
ALTER TABLE [dbo].[HLite] ADD  CONSTRAINT [DF_HLite_Descr]  DEFAULT ('') FOR [Descr]
GO
ALTER TABLE [dbo].[HLite] ADD  CONSTRAINT [DF_HLite_Obs]  DEFAULT ('') FOR [Obs]
GO
ALTER TABLE [dbo].[HLite] ADD  CONSTRAINT [DF_HLite_EdeMov]  DEFAULT ((0)) FOR [EdeMov]
GO
ALTER TABLE [dbo].[HLite] ADD  CONSTRAINT [DF_HLite_THLitRU]  DEFAULT ((0)) FOR [THLitRU]
GO
ALTER TABLE [dbo].[HLite] ADD  CONSTRAINT [DF_HLite_CHLitRU]  DEFAULT ((0)) FOR [CHLitRU]
GO
ALTER TABLE [dbo].[HLite] ADD  CONSTRAINT [DF_HLite_OSigla]  DEFAULT ('') FOR [OSigla]
GO
ALTER TABLE [dbo].[HsEve] ADD  CONSTRAINT [DF_HsEve_TEve]  DEFAULT ('') FOR [TEve]
GO
ALTER TABLE [dbo].[HsEve] ADD  CONSTRAINT [DF_HsEve_CFun]  DEFAULT ((0)) FOR [CFun]
GO
ALTER TABLE [dbo].[HsEve] ADD  CONSTRAINT [DF_HsEve_Descr]  DEFAULT ('') FOR [Descr]
GO
ALTER TABLE [dbo].[HsEve] ADD  CONSTRAINT [DF_HsEve_Qtd1]  DEFAULT ((0)) FOR [Qtd1]
GO
ALTER TABLE [dbo].[HsEve] ADD  CONSTRAINT [DF_HsEve_Qtd2]  DEFAULT ((0)) FOR [Qtd2]
GO
ALTER TABLE [dbo].[HsEve] ADD  CONSTRAINT [DF_HsEve_Info1]  DEFAULT ('') FOR [Info1]
GO
ALTER TABLE [dbo].[HsEve] ADD  CONSTRAINT [DF_HsEve_Info2]  DEFAULT ('') FOR [Info2]
GO
ALTER TABLE [dbo].[HsEve] ADD  CONSTRAINT [DF_HsEve_Obs]  DEFAULT ('') FOR [Obs]
GO
ALTER TABLE [dbo].[HsEve] ADD  CONSTRAINT [DF_HsEve_EAg]  DEFAULT ((0)) FOR [EAg]
GO
ALTER TABLE [dbo].[HsEve] ADD  CONSTRAINT [DF_HsEve_ResAg]  DEFAULT ((0)) FOR [ResAg]
GO
ALTER TABLE [dbo].[HsEve] ADD  CONSTRAINT [DF_HsEve_FSitFrq]  DEFAULT ((0)) FOR [FSitFrq]
GO
ALTER TABLE [dbo].[HsEve] ADD  CONSTRAINT [DF_HsEve_FPerRef]  DEFAULT ('') FOR [FPerRef]
GO
ALTER TABLE [dbo].[HsEve] ADD  CONSTRAINT [DF_HsEve_FAreEdu]  DEFAULT ((0)) FOR [FAreEdu]
GO
ALTER TABLE [dbo].[HsEve] ADD  CONSTRAINT [DF_HsEve_FModal]  DEFAULT ((0)) FOR [FModal]
GO
ALTER TABLE [dbo].[HsEve] ADD  CONSTRAINT [DF_HsEve_FTipIni]  DEFAULT ((0)) FOR [FTipIni]
GO
ALTER TABLE [dbo].[HsEve] ADD  CONSTRAINT [DF_HsEve_FTipHor]  DEFAULT ((0)) FOR [FTipHor]
GO
ALTER TABLE [dbo].[HsEve] ADD  CONSTRAINT [DF_HsEve_FTipEnt]  DEFAULT ((0)) FOR [FTipEnt]
GO
ALTER TABLE [dbo].[HsEve] ADD  CONSTRAINT [DF_HsEve_FTipCer]  DEFAULT ((0)) FOR [FTipCer]
GO
ALTER TABLE [dbo].[HsEve] ADD  CONSTRAINT [DF_HsEve_FNivQua]  DEFAULT ((0)) FOR [FNivQua]
GO
ALTER TABLE [dbo].[HsEve] ADD  CONSTRAINT [DF_HsEve_DCPais]  DEFAULT ((0)) FOR [DCPais]
GO
ALTER TABLE [dbo].[HsEve] ADD  CONSTRAINT [DF_HsEve_COper]  DEFAULT ('') FOR [COper]
GO
ALTER TABLE [dbo].[HsEve] ADD  CONSTRAINT [DF_HsEve_SHSTTipo]  DEFAULT ('') FOR [SHSTTipo]
GO
ALTER TABLE [dbo].[HsEve] ADD  CONSTRAINT [DF_HsEve_SHSTVarCTab1]  DEFAULT ((0)) FOR [SHSTVarCTab1]
GO
ALTER TABLE [dbo].[HsEve] ADD  CONSTRAINT [DF_HsEve_SHSTVarCTab2]  DEFAULT ('') FOR [SHSTVarCTab2]
GO
ALTER TABLE [dbo].[HsEve] ADD  CONSTRAINT [DF_HsEve_SHSTVarSt]  DEFAULT ('') FOR [SHSTVarStr1]
GO
ALTER TABLE [dbo].[HsEve] ADD  CONSTRAINT [DF_HsEve_SHSTVarNu]  DEFAULT ((0)) FOR [SHSTVarNum1]
GO
ALTER TABLE [dbo].[HsEve] ADD  CONSTRAINT [DF_HsEve_SHSTVarBo]  DEFAULT ((0)) FOR [SHSTVarBol1]
GO
ALTER TABLE [dbo].[Profi] ADD  CONSTRAINT [DF_Profi_CProf]  DEFAULT ('') FOR [CProf]
GO
ALTER TABLE [dbo].[Profi] ADD  CONSTRAINT [DF_Profi_Sigla]  DEFAULT ('') FOR [Sigla]
GO
ALTER TABLE [dbo].[Profi] ADD  CONSTRAINT [DF_Profi_Descr]  DEFAULT ('') FOR [Descr]
GO
ALTER TABLE [dbo].[Profi] ADD  CONSTRAINT [DF_Profi_Obs]  DEFAULT ('') FOR [Obs]
GO
ALTER TABLE [dbo].[Profi] ADD  CONSTRAINT [DF_Profi_EdeMov]  DEFAULT ((0)) FOR [EdeMov]
GO
ALTER TABLE [dbo].[Profi] ADD  CONSTRAINT [DF_Profi_CPP2010]  DEFAULT ('') FOR [CPP2010]
GO
ALTER TABLE [dbo].[Profi] ADD  CONSTRAINT [DF_Profi_ODescr]  DEFAULT ('') FOR [ODescr]
GO
ALTER TABLE [dbo].[Secca] ADD  CONSTRAINT [DF_Secca_CSec]  DEFAULT ((0)) FOR [CSec]
GO
ALTER TABLE [dbo].[Secca] ADD  CONSTRAINT [DF_Secca_Sigla]  DEFAULT ('') FOR [Sigla]
GO
ALTER TABLE [dbo].[Secca] ADD  CONSTRAINT [DF_Secca_Descr]  DEFAULT ('') FOR [Descr]
GO
ALTER TABLE [dbo].[Sindi] ADD  CONSTRAINT [DF_Sindi_CSind]  DEFAULT ('') FOR [CSind]
GO
ALTER TABLE [dbo].[Sindi] ADD  CONSTRAINT [DF_Sindi_Descr]  DEFAULT ('') FOR [Descr]
GO
ALTER TABLE [dbo].[Sindi] ADD  CONSTRAINT [DF_Sindi_ValTx]  DEFAULT ((0)) FOR [ValTx]
GO
ALTER TABLE [dbo].[Sindi] ADD  CONSTRAINT [DF_Sindi_ETaxa]  DEFAULT ((0)) FOR [ETaxa]
GO
ALTER TABLE [dbo].[TCont] ADD  CONSTRAINT [DF_TCont_TCont]  DEFAULT ((0)) FOR [TCont]
GO
ALTER TABLE [dbo].[TCont] ADD  CONSTRAINT [DF_TCont_Sigla]  DEFAULT ('') FOR [Sigla]
GO
ALTER TABLE [dbo].[TCont] ADD  CONSTRAINT [DF_TCont_Descr]  DEFAULT ('') FOR [Descr]
GO
ALTER TABLE [dbo].[TCont] ADD  CONSTRAINT [DF_TCont_Obs]  DEFAULT ('') FOR [Obs]
GO
ALTER TABLE [dbo].[TCont] ADD  CONSTRAINT [DF_TCont_Termo]  DEFAULT ('') FOR [Termo]
GO
ALTER TABLE [dbo].[TCont] ADD  CONSTRAINT [DF_TCont_TContRU]  DEFAULT ('') FOR [TContRU]
GO
ALTER TABLE [dbo].[TCont] ADD  CONSTRAINT [DF_TCont_MtCurDur]  DEFAULT ((0)) FOR [MtCurDur]
GO
ALTER TABLE [dbo].[TCont] ADD  CONSTRAINT [DF_TCont_TContRU1]  DEFAULT ('') FOR [TContSS]
GO
ALTER TABLE [dbo].[TCont] ADD  CONSTRAINT [DF_TCont_TContFCT]  DEFAULT ('') FOR [TContFCT]
GO
ALTER TABLE [dbo].[ZPais] ADD  CONSTRAINT [DF_ZPais_CPais]  DEFAULT ((0)) FOR [CPais]
GO
ALTER TABLE [dbo].[ZPais] ADD  CONSTRAINT [DF_ZPais_Descr]  DEFAULT ('') FOR [Descr]
GO
ALTER TABLE [dbo].[ZPais] ADD  CONSTRAINT [DF_ZPais_CPaisQP]  DEFAULT ((0)) FOR [CPaisQP]
GO
ALTER TABLE [dbo].[ZPais] ADD  CONSTRAINT [DF_ZPais_CPaisISO]  DEFAULT ('') FOR [CPaisISO]
GO
ALTER TABLE [dbo].[CatPr]  WITH NOCHECK ADD  CONSTRAINT [CK_CatPr_CCatP] CHECK  ((len([CCatP])>(0)))
GO
ALTER TABLE [dbo].[CatPr] CHECK CONSTRAINT [CK_CatPr_CCatP]
GO
ALTER TABLE [dbo].[Profi]  WITH NOCHECK ADD  CONSTRAINT [CK_Profi_CProf] CHECK  ((len([CProf])>(0)))
GO
ALTER TABLE [dbo].[Profi] CHECK CONSTRAINT [CK_Profi_CProf]
GO
ALTER TABLE [dbo].[Sindi]  WITH NOCHECK ADD  CONSTRAINT [CK_Sindi_CSind] CHECK  ((len([CSind])>(0)))
GO
ALTER TABLE [dbo].[Sindi] CHECK CONSTRAINT [CK_Sindi_CSind]
GO
EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'GepModelo.[CatPr].[CCatP]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CatPr', @level2type=N'COLUMN',@level2name=N'CCatP'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'GepModelo.[CatPr].[Descr]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CatPr', @level2type=N'COLUMN',@level2name=N'Descr'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'GepModelo.[CatPr].[DETEFP]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CatPr', @level2type=N'COLUMN',@level2name=N'DETEFP'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'GepModelo.[CatPr].[IxCatPr]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CatPr', @level2type=N'CONSTRAINT',@level2name=N'IxCatPr'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'GepModelo.[CatPr]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'CatPr'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'GepModelo.[Depar].[CDep]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Depar', @level2type=N'COLUMN',@level2name=N'CDep'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'GepModelo.[Depar].[Sigla]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Depar', @level2type=N'COLUMN',@level2name=N'Sigla'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'GepModelo.[Depar].[Descr]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Depar', @level2type=N'COLUMN',@level2name=N'Descr'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'GepModelo.[Depar].[IxDepar]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Depar', @level2type=N'CONSTRAINT',@level2name=N'IxDepar'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'GepModelo.[Depar]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Depar'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'GepModelo.[Estab].[CEst]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Estab', @level2type=N'COLUMN',@level2name=N'CEst'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'GepModelo.[Estab].[Nome]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Estab', @level2type=N'COLUMN',@level2name=N'Nome'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'GepModelo.[Estab].[Morada]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Estab', @level2type=N'COLUMN',@level2name=N'Morada'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'GepModelo.[Estab].[Localidade]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Estab', @level2type=N'COLUMN',@level2name=N'Localidade'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'GepModelo.[Estab].[CodPostal]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Estab', @level2type=N'COLUMN',@level2name=N'CodPostal'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'GepModelo.[Estab].[TelNum]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Estab', @level2type=N'COLUMN',@level2name=N'TelNum'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'GepModelo.[Estab].[FaxNum]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Estab', @level2type=N'COLUMN',@level2name=N'FaxNum'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'GepModelo.[Estab].[Distrito]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Estab', @level2type=N'COLUMN',@level2name=N'Distrito'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'GepModelo.[Estab].[Regiao]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Estab', @level2type=N'COLUMN',@level2name=N'Regiao'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'GepModelo.[Estab].[Concelho]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Estab', @level2type=N'COLUMN',@level2name=N'Concelho'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'GepModelo.[Estab].[Freguesia]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Estab', @level2type=N'COLUMN',@level2name=N'Freguesia'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'GepModelo.[Estab].[CPais]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Estab', @level2type=N'COLUMN',@level2name=N'CPais'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'GepModelo.[Estab].[EMail]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Estab', @level2type=N'COLUMN',@level2name=N'EMail'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'GepModelo.[Estab].[Actividade]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Estab', @level2type=N'COLUMN',@level2name=N'Actividade'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'GepModelo.[Estab].[NSegSoc]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Estab', @level2type=N'COLUMN',@level2name=N'NSegSoc'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'GepModelo.[Estab].[NSegSocNew]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Estab', @level2type=N'COLUMN',@level2name=N'NSegSocNew'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'GepModelo.[Estab].[CCSS]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Estab', @level2type=N'COLUMN',@level2name=N'CCSS'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'GepModelo.[Estab].[CEstSgS]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Estab', @level2type=N'COLUMN',@level2name=N'CEstSgS'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'GepModelo.[Estab].[CAE]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Estab', @level2type=N'COLUMN',@level2name=N'CAE'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'GepModelo.[Estab].[NSerCA]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Estab', @level2type=N'COLUMN',@level2name=N'NSerCA'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'GepModelo.[Estab].[FileDir]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Estab', @level2type=N'COLUMN',@level2name=N'FileDir'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'GepModelo.[Estab].[CEstRU]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Estab', @level2type=N'COLUMN',@level2name=N'CEstRU'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'GepModelo.[Estab].[IxEstab]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Estab', @level2type=N'CONSTRAINT',@level2name=N'IxEstab'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'GepModelo.[Estab]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Estab'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'GepModelo.[HLite].[CHLit]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'HLite', @level2type=N'COLUMN',@level2name=N'CHLit'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'GepModelo.[HLite].[Sigla]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'HLite', @level2type=N'COLUMN',@level2name=N'Sigla'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'GepModelo.[HLite].[Descr]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'HLite', @level2type=N'COLUMN',@level2name=N'Descr'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'GepModelo.[HLite].[Obs]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'HLite', @level2type=N'COLUMN',@level2name=N'Obs'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'GepModelo.[HLite].[EdeMov]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'HLite', @level2type=N'COLUMN',@level2name=N'EdeMov'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'GepModelo.[HLite].[THLitRU]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'HLite', @level2type=N'COLUMN',@level2name=N'THLitRU'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'GepModelo.[HLite].[CHLitRU]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'HLite', @level2type=N'COLUMN',@level2name=N'CHLitRU'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'GepModelo.[HLite].[OSigla]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'HLite', @level2type=N'COLUMN',@level2name=N'OSigla'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'GepModelo.[HLite].[IxHLite]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'HLite', @level2type=N'CONSTRAINT',@level2name=N'IxHLite'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'GepModelo.[HLite]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'HLite'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'GepModelo.[HsEve].[Data]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'HsEve', @level2type=N'COLUMN',@level2name=N'Data'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'GepModelo.[HsEve].[TEve]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'HsEve', @level2type=N'COLUMN',@level2name=N'TEve'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'GepModelo.[HsEve].[CFun]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'HsEve', @level2type=N'COLUMN',@level2name=N'CFun'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'GepModelo.[HsEve].[Descr]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'HsEve', @level2type=N'COLUMN',@level2name=N'Descr'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'GepModelo.[HsEve].[Qtd1]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'HsEve', @level2type=N'COLUMN',@level2name=N'Qtd1'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'GepModelo.[HsEve].[Qtd2]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'HsEve', @level2type=N'COLUMN',@level2name=N'Qtd2'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'GepModelo.[HsEve].[Info1]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'HsEve', @level2type=N'COLUMN',@level2name=N'Info1'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'GepModelo.[HsEve].[Info2]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'HsEve', @level2type=N'COLUMN',@level2name=N'Info2'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'GepModelo.[HsEve].[Obs]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'HsEve', @level2type=N'COLUMN',@level2name=N'Obs'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'GepModelo.[HsEve].[EAg]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'HsEve', @level2type=N'COLUMN',@level2name=N'EAg'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'GepModelo.[HsEve].[ResAg]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'HsEve', @level2type=N'COLUMN',@level2name=N'ResAg'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'GepModelo.[HsEve].[DtRAg]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'HsEve', @level2type=N'COLUMN',@level2name=N'DtRAg'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'GepModelo.[HsEve].[DtLAg]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'HsEve', @level2type=N'COLUMN',@level2name=N'DtLAg'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'GepModelo.[HsEve].[FSitFrq]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'HsEve', @level2type=N'COLUMN',@level2name=N'FSitFrq'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'GepModelo.[HsEve].[FPerRef]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'HsEve', @level2type=N'COLUMN',@level2name=N'FPerRef'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'GepModelo.[HsEve].[FAreEdu]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'HsEve', @level2type=N'COLUMN',@level2name=N'FAreEdu'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'GepModelo.[HsEve].[FModal]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'HsEve', @level2type=N'COLUMN',@level2name=N'FModal'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'GepModelo.[HsEve].[FTipIni]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'HsEve', @level2type=N'COLUMN',@level2name=N'FTipIni'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'GepModelo.[HsEve].[FTipHor]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'HsEve', @level2type=N'COLUMN',@level2name=N'FTipHor'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'GepModelo.[HsEve].[FTipEnt]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'HsEve', @level2type=N'COLUMN',@level2name=N'FTipEnt'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'GepModelo.[HsEve].[FTipCer]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'HsEve', @level2type=N'COLUMN',@level2name=N'FTipCer'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'GepModelo.[HsEve].[FNivQua]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'HsEve', @level2type=N'COLUMN',@level2name=N'FNivQua'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'GepModelo.[HsEve].[DDtIni]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'HsEve', @level2type=N'COLUMN',@level2name=N'DDtIni'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'GepModelo.[HsEve].[DDtFim]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'HsEve', @level2type=N'COLUMN',@level2name=N'DDtFim'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'GepModelo.[HsEve].[DCPais]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'HsEve', @level2type=N'COLUMN',@level2name=N'DCPais'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'GepModelo.[HsEve].[COper]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'HsEve', @level2type=N'COLUMN',@level2name=N'COper'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'GepModelo.[HsEve].[SHSTTipo]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'HsEve', @level2type=N'COLUMN',@level2name=N'SHSTTipo'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'GepModelo.[HsEve].[SHSTVarCTab1]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'HsEve', @level2type=N'COLUMN',@level2name=N'SHSTVarCTab1'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'GepModelo.[HsEve].[SHSTVarCTab2]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'HsEve', @level2type=N'COLUMN',@level2name=N'SHSTVarCTab2'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'GepModelo.[HsEve].[SHSTVarStr1]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'HsEve', @level2type=N'COLUMN',@level2name=N'SHSTVarStr1'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'GepModelo.[HsEve].[SHSTVarNum1]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'HsEve', @level2type=N'COLUMN',@level2name=N'SHSTVarNum1'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'GepModelo.[HsEve].[SHSTVarBol1]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'HsEve', @level2type=N'COLUMN',@level2name=N'SHSTVarBol1'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'GepModelo.[HsEve].[DBTS]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'HsEve', @level2type=N'COLUMN',@level2name=N'DBTS'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'GepModelo.[HsEve].[IxHsEve]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'HsEve', @level2type=N'CONSTRAINT',@level2name=N'IxHsEve'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'GepModelo.[HsEve]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'HsEve'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'GepModelo.[Profi].[CProf]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Profi', @level2type=N'COLUMN',@level2name=N'CProf'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'GepModelo.[Profi].[Sigla]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Profi', @level2type=N'COLUMN',@level2name=N'Sigla'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'GepModelo.[Profi].[Descr]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Profi', @level2type=N'COLUMN',@level2name=N'Descr'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'GepModelo.[Profi].[Obs]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Profi', @level2type=N'COLUMN',@level2name=N'Obs'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'GepModelo.[Profi].[EdeMov]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Profi', @level2type=N'COLUMN',@level2name=N'EdeMov'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'GepModelo.[Profi].[CPP2010]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Profi', @level2type=N'COLUMN',@level2name=N'CPP2010'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'GepModelo.[Profi].[ODescr]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Profi', @level2type=N'COLUMN',@level2name=N'ODescr'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'GepModelo.[Profi].[IxProfi]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Profi', @level2type=N'CONSTRAINT',@level2name=N'IxProfi'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'GepModelo.[Profi]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Profi'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'GepModelo.[Secca].[CSec]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Secca', @level2type=N'COLUMN',@level2name=N'CSec'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'GepModelo.[Secca].[Sigla]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Secca', @level2type=N'COLUMN',@level2name=N'Sigla'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'GepModelo.[Secca].[Descr]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Secca', @level2type=N'COLUMN',@level2name=N'Descr'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'GepModelo.[Secca].[IxSecca]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Secca', @level2type=N'CONSTRAINT',@level2name=N'IxSecca'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'GepModelo.[Secca]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Secca'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'GepModelo.[Sindi].[CSind]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sindi', @level2type=N'COLUMN',@level2name=N'CSind'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'GepModelo.[Sindi].[Descr]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sindi', @level2type=N'COLUMN',@level2name=N'Descr'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'GepModelo.[Sindi].[ValTx]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sindi', @level2type=N'COLUMN',@level2name=N'ValTx'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'GepModelo.[Sindi].[ETaxa]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sindi', @level2type=N'COLUMN',@level2name=N'ETaxa'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'GepModelo.[Sindi].[IxSindi]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sindi', @level2type=N'CONSTRAINT',@level2name=N'IxSindi'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'GepModelo.[Sindi]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sindi'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'GepModelo.[TCont].[TCont]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TCont', @level2type=N'COLUMN',@level2name=N'TCont'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'GepModelo.[TCont].[Sigla]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TCont', @level2type=N'COLUMN',@level2name=N'Sigla'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'GepModelo.[TCont].[Descr]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TCont', @level2type=N'COLUMN',@level2name=N'Descr'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'GepModelo.[TCont].[Obs]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TCont', @level2type=N'COLUMN',@level2name=N'Obs'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'GepModelo.[TCont].[Termo]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TCont', @level2type=N'COLUMN',@level2name=N'Termo'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'GepModelo.[TCont].[TContRU]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TCont', @level2type=N'COLUMN',@level2name=N'TContRU'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'GepModelo.[TCont].[MtCurDur]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TCont', @level2type=N'COLUMN',@level2name=N'MtCurDur'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'GepModelo.[TCont].[IxTCont]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TCont', @level2type=N'CONSTRAINT',@level2name=N'IxTCont'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'GepModelo.[TCont]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'TCont'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'GepModelo.[ZPais].[CPais]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZPais', @level2type=N'COLUMN',@level2name=N'CPais'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'GepModelo.[ZPais].[Descr]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZPais', @level2type=N'COLUMN',@level2name=N'Descr'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'GepModelo.[ZPais].[CPaisQP]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZPais', @level2type=N'COLUMN',@level2name=N'CPaisQP'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'GepModelo.[ZPais].[CPaisISO]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZPais', @level2type=N'COLUMN',@level2name=N'CPaisISO'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'GepModelo.[ZPais].[IxZPais]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZPais', @level2type=N'CONSTRAINT',@level2name=N'IxZPais'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_SSMA_SOURCE', @value=N'GepModelo.[ZPais]' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ZPais'
GO