· 8 years ago · May 30, 2018, 03:52 PM
1IF NOT EXISTS (
2SELECT schema_name
3FROM information_schema.schemata
4WHERE schema_name = 'CN43' )
5
6BEGIN
7EXEC sp_executesql N'CREATE SCHEMA CN43'
8END
9GO
10
11/****** Object: Table [CN43].[Importacion] Script Date: 23/05/2018 16:03:57 ******/
12SET ANSI_NULLS ON
13GO
14
15SET QUOTED_IDENTIFIER ON
16GO
17
18CREATE TABLE [CN43].[Importacion](
19 [id] [int] IDENTITY(1,1) NOT NULL,
20 [cliente_nombre] [varchar](250) NULL,
21 [cliente_codigo] [varchar](150) NULL,
22 [entidad] [nchar](4) NULL,
23 [oficina] [nchar](4) NULL,
24 [cuenta] [nchar](10) NULL,
25 [fecha_contable] [date] NULL,
26 [fecha_inicial] [date] NULL,
27 [fecha_final] [date] NULL,
28 [saldo_inicial] [float] NULL,
29 [saldo_final] [float] NULL,
30 [divisa] [varchar](150) NULL,
31 [n_debe] [float] NULL,
32 [total_debe] [float] NULL,
33 [n_haber] [float] NULL,
34 [total_haber] [float] NULL,
35 [n_regs] [varchar](150) NULL,
36 [status] [varchar](150) NULL,
37 [message] [varchar](250) NULL,
38 [id_empresa] [int] NULL,
39 [id_cuenta] [int] NULL,
40 CONSTRAINT [PK_Importacion] PRIMARY KEY CLUSTERED
41(
42 [id] ASC
43)WITH (STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
44) ON [PRIMARY]
45GO
46
47/****** Object: Table [CN43].[MovimientosBancarios] Script Date: 23/05/2018 16:01:50 ******/
48SET ANSI_NULLS ON
49GO
50
51SET QUOTED_IDENTIFIER ON
52GO
53
54CREATE TABLE [CN43].[MovimientosBancarios](
55 [id] [int] IDENTITY(1,1) NOT NULL,
56 [codigo_registro] [nchar](2) NULL,
57 [oficina] [nchar](4) NULL,
58 [fecha_operacion] [date] NULL,
59 [fecha_valor] [date] NULL,
60 [concepto_comun] [nchar](2) NULL,
61 [concepto_entidad] [nchar](3) NULL,
62 [importe] [float] NULL,
63 [num_doc] [nchar](10) NULL,
64 [ref1] [varchar](150) NULL,
65 [ref2] [varchar](150) NULL,
66 [datetime_import] [datetime] NULL,
67 [id_empresa] [int] NULL,
68 [id_cuenta] [int] NULL,
69 [Grupo0] [int] NULL,
70 [Grupo1] [int] NULL,
71 [Grupo2] [int] NULL,
72 [Grupo3] [int] NULL,
73 [Grupo4] [int] NULL,
74 [id_importacion] [int] NULL,
75 [cod_insert] [varchar](150) NULL,
76 CONSTRAINT [PK_MovimientosBancarios] PRIMARY KEY CLUSTERED
77(
78 [id] ASC
79)WITH (STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
80) ON [PRIMARY]
81GO
82
83ALTER TABLE [CN43].[MovimientosBancarios] ADD CONSTRAINT [DF_MovimientosBancarios_date_import] DEFAULT (getdate()) FOR [datetime_import]
84GO
85
86ALTER TABLE [CN43].[MovimientosBancarios] WITH CHECK ADD CONSTRAINT [FK_CN43_MB_Grupo0] FOREIGN KEY([Grupo0])
87REFERENCES [CN43].[Grupo0] ([IdGrupo0])
88GO
89
90ALTER TABLE [CN43].[MovimientosBancarios] CHECK CONSTRAINT [FK_CN43_MB_Grupo0]
91GO
92
93ALTER TABLE [CN43].[MovimientosBancarios] WITH CHECK ADD CONSTRAINT [FK_CN43_MB_Grupo1] FOREIGN KEY([Grupo1])
94REFERENCES [CN43].[Grupo1] ([IdGrupo1])
95GO
96
97ALTER TABLE [CN43].[MovimientosBancarios] CHECK CONSTRAINT [FK_CN43_MB_Grupo1]
98GO
99
100/****** Object: Table [CN43].[ConceptosExtra] Script Date: 23/05/2018 16:05:43 ******/
101SET ANSI_NULLS ON
102GO
103
104SET QUOTED_IDENTIFIER ON
105GO
106
107CREATE TABLE [CN43].[ConceptosExtra](
108 [id] [int] IDENTITY(1,1) NOT NULL,
109 [Nombre] [varchar](250) NULL,
110 CONSTRAINT [PK_ConceptosExtra] PRIMARY KEY CLUSTERED
111(
112 [id] ASC
113)WITH (STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
114) ON [PRIMARY]
115GO
116
117
118/****** Object: Table [CN43].[MovimientosBancarios2ConceptosExtra] Script Date: 23/05/2018 16:06:11 ******/
119SET ANSI_NULLS ON
120GO
121
122SET QUOTED_IDENTIFIER ON
123GO
124
125CREATE TABLE [CN43].[MovimientosBancarios2ConceptosExtra](
126 [id] [int] IDENTITY(1,1) NOT NULL,
127 [IdConceptoExtra] [int] NULL,
128 [IdMovimientoBancario] [int] NULL,
129 CONSTRAINT [PK_MovimientosBancarios2ConceptosExtra] PRIMARY KEY CLUSTERED
130(
131 [id] ASC
132)WITH (STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
133) ON [PRIMARY]
134GO
135
136ALTER TABLE [CN43].[MovimientosBancarios2ConceptosExtra] WITH CHECK ADD CONSTRAINT [FK_MovimientosBancarios2ConceptosExtra_ConceptosExtra] FOREIGN KEY([IdConceptoExtra])
137REFERENCES [CN43].[ConceptosExtra] ([id])
138GO
139
140ALTER TABLE [CN43].[MovimientosBancarios2ConceptosExtra] CHECK CONSTRAINT [FK_MovimientosBancarios2ConceptosExtra_ConceptosExtra]
141GO
142
143ALTER TABLE [CN43].[MovimientosBancarios2ConceptosExtra] WITH CHECK ADD CONSTRAINT [FK_MovimientosBancarios2ConceptosExtra_MovimientosBancarios] FOREIGN KEY([IdMovimientoBancario])
144REFERENCES [CN43].[MovimientosBancarios] ([id])
145GO
146
147ALTER TABLE [CN43].[MovimientosBancarios2ConceptosExtra] CHECK CONSTRAINT [FK_MovimientosBancarios2ConceptosExtra_MovimientosBancarios]
148GO
149
150/****** Object: Table [CN43].[Grupo0] Script Date: 23/05/2018 16:06:49 ******/
151SET ANSI_NULLS ON
152GO
153
154SET QUOTED_IDENTIFIER ON
155GO
156
157CREATE TABLE [CN43].[Grupo0](
158 [IdGrupo0] [int] IDENTITY(1,1) NOT NULL,
159 [Grupo0] [varchar](220) NULL,
160 CONSTRAINT [PK_Grupo0] PRIMARY KEY CLUSTERED
161(
162 [IdGrupo0] ASC
163)WITH (STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
164) ON [PRIMARY]
165GO
166
167
168/****** Object: Table [CN43].[Grupo1] Script Date: 23/05/2018 16:07:26 ******/
169SET ANSI_NULLS ON
170GO
171
172SET QUOTED_IDENTIFIER ON
173GO
174
175CREATE TABLE [CN43].[Grupo1](
176 [IdGrupo1] [int] IDENTITY(1,1) NOT NULL,
177 [Grupo1] [varchar](220) NULL,
178 [Grupo0] [int] NULL,
179 CONSTRAINT [PK_Grupo1] PRIMARY KEY CLUSTERED
180(
181 [IdGrupo1] ASC
182)WITH (STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
183) ON [PRIMARY]
184GO
185
186ALTER TABLE [CN43].[Grupo1] WITH CHECK ADD CONSTRAINT [FK_CN43_Grupo1] FOREIGN KEY([Grupo0])
187REFERENCES [CN43].[Grupo0] ([IdGrupo0])
188GO
189
190ALTER TABLE [CN43].[Grupo1] CHECK CONSTRAINT [FK_CN43_Grupo1]
191GO
192
193
194/****** Object: Table [CN43].[Grupo2] Script Date: 23/05/2018 16:07:45 ******/
195SET ANSI_NULLS ON
196GO
197
198SET QUOTED_IDENTIFIER ON
199GO
200
201CREATE TABLE [CN43].[Grupo2](
202 [IdGrupo2] [int] IDENTITY(1,1) NOT NULL,
203 [Grupo2] [varchar](220) NULL,
204 [Grupo1] [int] NULL,
205 CONSTRAINT [PK_Grupo2] PRIMARY KEY CLUSTERED
206(
207 [IdGrupo2] ASC
208)WITH (STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
209) ON [PRIMARY]
210GO
211
212ALTER TABLE [CN43].[Grupo2] WITH CHECK ADD CONSTRAINT [FK_CN43_Grupo2] FOREIGN KEY([Grupo1])
213REFERENCES [CN43].[Grupo1] ([IdGrupo1])
214GO
215
216ALTER TABLE [CN43].[Grupo2] CHECK CONSTRAINT [FK_CN43_Grupo2]
217GO
218
219/****** Object: Table [CN43].[Grupo3] Script Date: 23/05/2018 16:08:10 ******/
220SET ANSI_NULLS ON
221GO
222
223SET QUOTED_IDENTIFIER ON
224GO
225
226CREATE TABLE [CN43].[Grupo3](
227 [IdGrupo3] [int] IDENTITY(1,1) NOT NULL,
228 [Grupo3] [varchar](220) NULL,
229 [Grupo2] [int] NULL,
230 CONSTRAINT [PK_Grupo3] PRIMARY KEY CLUSTERED
231(
232 [IdGrupo3] ASC
233)WITH (STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
234) ON [PRIMARY]
235GO
236
237ALTER TABLE [CN43].[Grupo3] WITH CHECK ADD CONSTRAINT [FK_CN43_Grupo3] FOREIGN KEY([Grupo2])
238REFERENCES [CN43].[Grupo2] ([IdGrupo2])
239GO
240
241ALTER TABLE [CN43].[Grupo3] CHECK CONSTRAINT [FK_CN43_Grupo3]
242GO
243
244
245/****** Object: Table [CN43].[Grupo4] Script Date: 23/05/2018 16:08:27 ******/
246SET ANSI_NULLS ON
247GO
248
249SET QUOTED_IDENTIFIER ON
250GO
251
252CREATE TABLE [CN43].[Grupo4](
253 [IdGrupo4] [int] IDENTITY(1,1) NOT NULL,
254 [Grupo4] [varchar](220) NULL,
255 [Grupo3] [int] NULL,
256 CONSTRAINT [PK_Grupo4] PRIMARY KEY CLUSTERED
257(
258 [IdGrupo4] ASC
259)WITH (STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF) ON [PRIMARY]
260) ON [PRIMARY]
261GO
262
263ALTER TABLE [CN43].[Grupo4] WITH CHECK ADD CONSTRAINT [FK_CN43_Grupo4] FOREIGN KEY([Grupo3])
264REFERENCES [CN43].[Grupo3] ([IdGrupo3])
265GO
266
267ALTER TABLE [CN43].[Grupo4] CHECK CONSTRAINT [FK_CN43_Grupo4]
268GO