1 | # -*- coding: utf-8 -*- |
---|
2 | # Generated by Django 1.10 on 2017-06-02 17:32 |
---|
3 | from __future__ import unicode_literals |
---|
4 | |
---|
5 | from django.conf import settings |
---|
6 | import django.core.validators |
---|
7 | from django.db import migrations, models |
---|
8 | import django.db.models.deletion |
---|
9 | |
---|
10 | |
---|
11 | class Migration(migrations.Migration): |
---|
12 | |
---|
13 | initial = True |
---|
14 | |
---|
15 | dependencies = [ |
---|
16 | ('utils', '0001_initial'), |
---|
17 | migrations.swappable_dependency(settings.AUTH_USER_MODEL), |
---|
18 | ] |
---|
19 | |
---|
20 | operations = [ |
---|
21 | migrations.CreateModel( |
---|
22 | name='Actividad', |
---|
23 | fields=[ |
---|
24 | ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), |
---|
25 | ('descripcion', models.CharField(max_length=128)), |
---|
26 | ('unidad_medida', models.CharField(max_length=10)), |
---|
27 | ('fecha_inicio', models.DateField()), |
---|
28 | ('fecha_culminacion', models.DateField()), |
---|
29 | ('horas_estimadas_ejecucion', models.IntegerField(validators=[django.core.validators.MaxValueValidator(9999999999)])), |
---|
30 | ('costo_estimadao_ejecucion', models.DecimalField(decimal_places=2, max_digits=50)), |
---|
31 | ('peso_actividad', models.IntegerField(validators=[django.core.validators.MaxValueValidator(999)])), |
---|
32 | ('cantidad_estimada_trabajo', models.IntegerField(validators=[django.core.validators.MaxValueValidator(999)])), |
---|
33 | ('activo', models.BooleanField(default=True)), |
---|
34 | ], |
---|
35 | ), |
---|
36 | migrations.CreateModel( |
---|
37 | name='Alcance', |
---|
38 | fields=[ |
---|
39 | ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), |
---|
40 | ('opcion_alcance', models.CharField(max_length=128)), |
---|
41 | ('activo', models.BooleanField(default=True)), |
---|
42 | ], |
---|
43 | ), |
---|
44 | migrations.CreateModel( |
---|
45 | name='AreasEstrategica', |
---|
46 | fields=[ |
---|
47 | ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), |
---|
48 | ('activo', models.BooleanField(default=True)), |
---|
49 | ], |
---|
50 | ), |
---|
51 | migrations.CreateModel( |
---|
52 | name='AvanceActvidad', |
---|
53 | fields=[ |
---|
54 | ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), |
---|
55 | ('horas_invertidas', models.IntegerField(validators=[django.core.validators.MaxValueValidator(999)])), |
---|
56 | ('costo', models.IntegerField(validators=[django.core.validators.MaxValueValidator(9999999999)])), |
---|
57 | ('peso_ejecutado', models.IntegerField(validators=[django.core.validators.MaxValueValidator(999)])), |
---|
58 | ('cantidad_trabajo_realizado', models.IntegerField(validators=[django.core.validators.MaxValueValidator(999)])), |
---|
59 | ('fecha_avance', models.DateTimeField(auto_now_add=True)), |
---|
60 | ('activo', models.BooleanField(default=True)), |
---|
61 | ('fk_actividad', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='proyectos.Actividad')), |
---|
62 | ], |
---|
63 | ), |
---|
64 | migrations.CreateModel( |
---|
65 | name='AvancesProyecto', |
---|
66 | fields=[ |
---|
67 | ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), |
---|
68 | ('avance_subproyecto', models.IntegerField(validators=[django.core.validators.MaxValueValidator(999)])), |
---|
69 | ('avance_proyecto', models.IntegerField(validators=[django.core.validators.MaxValueValidator(999)])), |
---|
70 | ('fecha_avance', models.DateTimeField(auto_now_add=True)), |
---|
71 | ('activo', models.BooleanField(default=True)), |
---|
72 | ], |
---|
73 | ), |
---|
74 | migrations.CreateModel( |
---|
75 | name='CronogramaTarea', |
---|
76 | fields=[ |
---|
77 | ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), |
---|
78 | ('nombre', models.CharField(max_length=128)), |
---|
79 | ('horas_estimadas_tarea', models.IntegerField(validators=[django.core.validators.MaxValueValidator(9999999999)])), |
---|
80 | ('costo_estimado_tarea', models.DecimalField(decimal_places=2, max_digits=50)), |
---|
81 | ('peso_tarea', models.IntegerField(validators=[django.core.validators.MaxValueValidator(999)])), |
---|
82 | ('fin_comiento_tarea', models.BooleanField(default=True)), |
---|
83 | ('comienzo_comienzo_tarea', models.BooleanField(default=False)), |
---|
84 | ('fin_fin_tarea', models.BooleanField(default=False)), |
---|
85 | ('activo', models.BooleanField(default=True)), |
---|
86 | ('fk_actividad', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='proyectos.Actividad')), |
---|
87 | ], |
---|
88 | ), |
---|
89 | migrations.CreateModel( |
---|
90 | name='EstatusActividad', |
---|
91 | fields=[ |
---|
92 | ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), |
---|
93 | ('opcion_actividad', models.CharField(max_length=30)), |
---|
94 | ('activo', models.BooleanField(default=True)), |
---|
95 | ], |
---|
96 | ), |
---|
97 | migrations.CreateModel( |
---|
98 | name='EstatusCosto', |
---|
99 | fields=[ |
---|
100 | ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), |
---|
101 | ('opcion_costo', models.CharField(max_length=30)), |
---|
102 | ('activo', models.BooleanField(default=True)), |
---|
103 | ], |
---|
104 | ), |
---|
105 | migrations.CreateModel( |
---|
106 | name='Indicador', |
---|
107 | fields=[ |
---|
108 | ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), |
---|
109 | ('indicador_avance', models.IntegerField(validators=[django.core.validators.MaxValueValidator(999)])), |
---|
110 | ('indicador_rendimiento_costo', models.IntegerField(validators=[django.core.validators.MaxValueValidator(999)])), |
---|
111 | ('avance_respeto_tiempo', models.IntegerField(validators=[django.core.validators.MaxValueValidator(999)])), |
---|
112 | ('activo', models.BooleanField(default=True)), |
---|
113 | ('fk_avance', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='proyectos.AvanceActvidad')), |
---|
114 | ], |
---|
115 | ), |
---|
116 | migrations.CreateModel( |
---|
117 | name='Localizacion', |
---|
118 | fields=[ |
---|
119 | ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), |
---|
120 | ('estado', models.ForeignKey(null=True, on_delete=django.db.models.deletion.CASCADE, to='utils.Estado')), |
---|
121 | ], |
---|
122 | options={ |
---|
123 | 'verbose_name': 'Localizacion', |
---|
124 | 'verbose_name_plural': 'Localizaciones', |
---|
125 | 'ordering': ('estado', 'municipio', 'parroquia'), |
---|
126 | }, |
---|
127 | ), |
---|
128 | migrations.CreateModel( |
---|
129 | name='ObjetivosEspecificosProy', |
---|
130 | fields=[ |
---|
131 | ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), |
---|
132 | ('objetivos_especificos', models.CharField(max_length=255)), |
---|
133 | ], |
---|
134 | options={ |
---|
135 | 'verbose_name': 'Objetivo Especifico', |
---|
136 | 'verbose_name_plural': 'Objetivos Especificos', |
---|
137 | 'ordering': ('objetivos_especificos',), |
---|
138 | }, |
---|
139 | ), |
---|
140 | migrations.CreateModel( |
---|
141 | name='ObjetivosEstrategico', |
---|
142 | fields=[ |
---|
143 | ('nivel', models.CharField(max_length=10, primary_key=True, serialize=False, verbose_name='nivel')), |
---|
144 | ('objetivo', models.CharField(max_length=800)), |
---|
145 | ], |
---|
146 | ), |
---|
147 | migrations.CreateModel( |
---|
148 | name='ObjetivosGeneral', |
---|
149 | fields=[ |
---|
150 | ('nivel', models.CharField(max_length=13, primary_key=True, serialize=False, verbose_name='nivel')), |
---|
151 | ('objetivo', models.CharField(max_length=2300)), |
---|
152 | ('fk_objetivo_estrategico', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='proyectos.ObjetivosEstrategico', verbose_name='Objetivo Estratégico')), |
---|
153 | ], |
---|
154 | ), |
---|
155 | migrations.CreateModel( |
---|
156 | name='ObjetivosHistorico', |
---|
157 | fields=[ |
---|
158 | ('nivel', models.CharField(max_length=5, primary_key=True, serialize=False, verbose_name='nivel')), |
---|
159 | ('objetivo', models.CharField(max_length=500)), |
---|
160 | ], |
---|
161 | ), |
---|
162 | migrations.CreateModel( |
---|
163 | name='ObjetivosNacional', |
---|
164 | fields=[ |
---|
165 | ('nivel', models.CharField(max_length=5, primary_key=True, serialize=False, verbose_name='nivel')), |
---|
166 | ('objetivo', models.CharField(max_length=500)), |
---|
167 | ('fk_objetivo_historico', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='proyectos.ObjetivosHistorico', verbose_name='Objetivo Historico')), |
---|
168 | ], |
---|
169 | ), |
---|
170 | migrations.CreateModel( |
---|
171 | name='Proyecto', |
---|
172 | fields=[ |
---|
173 | ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), |
---|
174 | ('codigo', models.CharField(max_length=15, unique=True)), |
---|
175 | ('nombre', models.CharField(max_length=128)), |
---|
176 | ('descripcion', models.TextField(blank=True)), |
---|
177 | ('objetivo_general', models.CharField(max_length=128)), |
---|
178 | ('justificacion', models.TextField(blank=True)), |
---|
179 | ('fecha_inicio', models.DateField()), |
---|
180 | ('fecha_culminacion', models.DateField()), |
---|
181 | ('plurianual', models.BooleanField(default=True)), |
---|
182 | ('monto_anho_anterior', models.DecimalField(decimal_places=2, max_digits=50, null=True)), |
---|
183 | ('monto_anho_proximo', models.DecimalField(decimal_places=2, max_digits=50, null=True)), |
---|
184 | ('monto_total', models.DecimalField(decimal_places=2, max_digits=50, null=True)), |
---|
185 | ('poan', models.BooleanField(default=True)), |
---|
186 | ('localidad', models.CharField(choices=[(1, 'Estado'), (2, 'Municipio'), (3, 'Parroquia')], max_length=1)), |
---|
187 | ('activo', models.BooleanField(default=True)), |
---|
188 | ], |
---|
189 | options={ |
---|
190 | 'verbose_name': 'Proyecto', |
---|
191 | 'verbose_name_plural': 'Proyectos', |
---|
192 | 'ordering': ('nombre',), |
---|
193 | }, |
---|
194 | ), |
---|
195 | migrations.CreateModel( |
---|
196 | name='ResponsableGerente', |
---|
197 | fields=[ |
---|
198 | ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), |
---|
199 | ('cedula', models.CharField(max_length=12, unique=True, verbose_name='Documento de identidad')), |
---|
200 | ('nombres', models.CharField(max_length=128)), |
---|
201 | ('apellidos', models.CharField(max_length=128)), |
---|
202 | ('correo', models.EmailField(max_length=75)), |
---|
203 | ('numero_telefono', models.CharField(max_length=11)), |
---|
204 | ('fk_documento', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='utils.TipoDocumento')), |
---|
205 | ('fk_proyecto', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='proyectos.Proyecto')), |
---|
206 | ], |
---|
207 | options={ |
---|
208 | 'verbose_name': 'Responsable Gerente', |
---|
209 | 'verbose_name_plural': 'Responsables Gerentes', |
---|
210 | 'ordering': ('cedula',), |
---|
211 | }, |
---|
212 | ), |
---|
213 | migrations.CreateModel( |
---|
214 | name='ResponsableTecnico', |
---|
215 | fields=[ |
---|
216 | ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), |
---|
217 | ('cedula', models.CharField(max_length=12, unique=True, verbose_name='Documento de identidad')), |
---|
218 | ('nombres', models.CharField(max_length=128)), |
---|
219 | ('apellidos', models.CharField(max_length=128)), |
---|
220 | ('correo', models.EmailField(max_length=75)), |
---|
221 | ('numero_telefono', models.CharField(max_length=11)), |
---|
222 | ('fk_documento', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='utils.TipoDocumento')), |
---|
223 | ('fk_proyecto', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='proyectos.Proyecto')), |
---|
224 | ], |
---|
225 | options={ |
---|
226 | 'verbose_name': 'Responsable Tecnico', |
---|
227 | 'verbose_name_plural': 'Responsables Tecnicos', |
---|
228 | 'ordering': ('cedula',), |
---|
229 | }, |
---|
230 | ), |
---|
231 | migrations.CreateModel( |
---|
232 | name='Sector', |
---|
233 | fields=[ |
---|
234 | ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), |
---|
235 | ('opcion_sector', models.CharField(max_length=128)), |
---|
236 | ('activo', models.BooleanField(default=True)), |
---|
237 | ], |
---|
238 | ), |
---|
239 | migrations.CreateModel( |
---|
240 | name='SubProyecto', |
---|
241 | fields=[ |
---|
242 | ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), |
---|
243 | ('codigo', models.CharField(max_length=15, unique=True)), |
---|
244 | ('nombre', models.CharField(max_length=128)), |
---|
245 | ('descripcion_bien_servicio', models.TextField(blank=True)), |
---|
246 | ('unidad_medida', models.CharField(max_length=10)), |
---|
247 | ('meta', models.IntegerField(validators=[django.core.validators.MaxValueValidator(999)])), |
---|
248 | ('fecha_inicio', models.DateField()), |
---|
249 | ('fecha_culminacion', models.DateField()), |
---|
250 | ('comunidad', models.CharField(max_length=10)), |
---|
251 | ('monto_subproyecto', models.DecimalField(decimal_places=2, max_digits=50)), |
---|
252 | ('activo', models.BooleanField(default=True)), |
---|
253 | ('fk_proyecto', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='proyectos.Proyecto', verbose_name='Proyecto')), |
---|
254 | ('parroquia', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='utils.Parroquia', verbose_name='Parroquia')), |
---|
255 | ], |
---|
256 | ), |
---|
257 | migrations.CreateModel( |
---|
258 | name='TipoProyecto', |
---|
259 | fields=[ |
---|
260 | ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), |
---|
261 | ('tipo_proyecto', models.CharField(max_length=97)), |
---|
262 | ('descripcion', models.TextField()), |
---|
263 | ], |
---|
264 | options={ |
---|
265 | 'verbose_name': 'Tipo de Proyecto', |
---|
266 | 'verbose_name_plural': 'Tipos de Proyectos', |
---|
267 | 'ordering': ('tipo_proyecto',), |
---|
268 | }, |
---|
269 | ), |
---|
270 | migrations.CreateModel( |
---|
271 | name='VinculacionPndes', |
---|
272 | fields=[ |
---|
273 | ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), |
---|
274 | ('vinculacion_activa', models.BooleanField(default=True)), |
---|
275 | ('fk_objetivo_generales', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='proyectos.ObjetivosGeneral', verbose_name='Objetivo General')), |
---|
276 | ], |
---|
277 | ), |
---|
278 | migrations.AddField( |
---|
279 | model_name='proyecto', |
---|
280 | name='fk_tipo', |
---|
281 | field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='proyectos.TipoProyecto', verbose_name='Tipo de Proyecto'), |
---|
282 | ), |
---|
283 | migrations.AddField( |
---|
284 | model_name='proyecto', |
---|
285 | name='fk_user', |
---|
286 | field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to=settings.AUTH_USER_MODEL), |
---|
287 | ), |
---|
288 | migrations.AddField( |
---|
289 | model_name='objetivosestrategico', |
---|
290 | name='fk_objetivo_nacional', |
---|
291 | field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='proyectos.ObjetivosNacional', verbose_name='Objetivo Nacional'), |
---|
292 | ), |
---|
293 | migrations.AddField( |
---|
294 | model_name='objetivosespecificosproy', |
---|
295 | name='fk_proyecto', |
---|
296 | field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='proyectos.Proyecto'), |
---|
297 | ), |
---|
298 | migrations.AddField( |
---|
299 | model_name='localizacion', |
---|
300 | name='fk_proyecto', |
---|
301 | field=models.OneToOneField(on_delete=django.db.models.deletion.CASCADE, to='proyectos.Proyecto'), |
---|
302 | ), |
---|
303 | migrations.AddField( |
---|
304 | model_name='localizacion', |
---|
305 | name='municipio', |
---|
306 | field=models.ForeignKey(null=True, on_delete=django.db.models.deletion.CASCADE, to='utils.Municipio'), |
---|
307 | ), |
---|
308 | migrations.AddField( |
---|
309 | model_name='localizacion', |
---|
310 | name='parroquia', |
---|
311 | field=models.ForeignKey(null=True, on_delete=django.db.models.deletion.CASCADE, to='utils.Parroquia'), |
---|
312 | ), |
---|
313 | migrations.AddField( |
---|
314 | model_name='avancesproyecto', |
---|
315 | name='fk_proyecto', |
---|
316 | field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='proyectos.Proyecto'), |
---|
317 | ), |
---|
318 | migrations.AddField( |
---|
319 | model_name='avanceactvidad', |
---|
320 | name='fk_estatus_actividad', |
---|
321 | field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='proyectos.EstatusActividad'), |
---|
322 | ), |
---|
323 | migrations.AddField( |
---|
324 | model_name='avanceactvidad', |
---|
325 | name='fk_estatus_costo', |
---|
326 | field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='proyectos.EstatusCosto'), |
---|
327 | ), |
---|
328 | migrations.AddField( |
---|
329 | model_name='areasestrategica', |
---|
330 | name='fk_objetivo_historico', |
---|
331 | field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='proyectos.VinculacionPndes', verbose_name='PNDES'), |
---|
332 | ), |
---|
333 | migrations.AddField( |
---|
334 | model_name='areasestrategica', |
---|
335 | name='fk_proyecto', |
---|
336 | field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='proyectos.Proyecto', verbose_name='Proyecto'), |
---|
337 | ), |
---|
338 | migrations.AddField( |
---|
339 | model_name='actividad', |
---|
340 | name='fk_subproyecto', |
---|
341 | field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='proyectos.SubProyecto', verbose_name='Sub-Proyecto'), |
---|
342 | ), |
---|
343 | ] |
---|