1 | # -*- coding: utf-8 -*- |
---|
2 | # Generated by Django 1.10 on 2017-05-25 12:48 |
---|
3 | from __future__ import unicode_literals |
---|
4 | |
---|
5 | import django.core.validators |
---|
6 | from django.db import migrations, models |
---|
7 | import django.db.models.deletion |
---|
8 | |
---|
9 | |
---|
10 | class Migration(migrations.Migration): |
---|
11 | |
---|
12 | initial = True |
---|
13 | |
---|
14 | dependencies = [ |
---|
15 | ('utils', '0001_initial'), |
---|
16 | ] |
---|
17 | |
---|
18 | operations = [ |
---|
19 | migrations.CreateModel( |
---|
20 | name='Actividad', |
---|
21 | fields=[ |
---|
22 | ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), |
---|
23 | ('descripcion', models.CharField(max_length=128)), |
---|
24 | ('unidad_medida', models.CharField(max_length=10)), |
---|
25 | ('fecha_inicio', models.DateField()), |
---|
26 | ('fecha_culminacion', models.DateField()), |
---|
27 | ('horas_estimadas_ejecucion', models.IntegerField(validators=[django.core.validators.MaxValueValidator(9999999999)])), |
---|
28 | ('costo_estimadao_ejecucion', models.DecimalField(decimal_places=2, max_digits=50)), |
---|
29 | ('peso_actividad', models.IntegerField(validators=[django.core.validators.MaxValueValidator(999)])), |
---|
30 | ('cantidad_estimada_trabajo', models.IntegerField(validators=[django.core.validators.MaxValueValidator(999)])), |
---|
31 | ('activo', models.BooleanField(default=True)), |
---|
32 | ], |
---|
33 | ), |
---|
34 | migrations.CreateModel( |
---|
35 | name='Alcance', |
---|
36 | fields=[ |
---|
37 | ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), |
---|
38 | ('opcion_alcance', models.CharField(max_length=128)), |
---|
39 | ('activo', models.BooleanField(default=True)), |
---|
40 | ], |
---|
41 | ), |
---|
42 | migrations.CreateModel( |
---|
43 | name='AreasEstrategica', |
---|
44 | fields=[ |
---|
45 | ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), |
---|
46 | ('activo', models.BooleanField(default=True)), |
---|
47 | ], |
---|
48 | ), |
---|
49 | migrations.CreateModel( |
---|
50 | name='AvanceActvidad', |
---|
51 | fields=[ |
---|
52 | ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), |
---|
53 | ('horas_invertidas', models.IntegerField(validators=[django.core.validators.MaxValueValidator(999)])), |
---|
54 | ('costo', models.IntegerField(validators=[django.core.validators.MaxValueValidator(9999999999)])), |
---|
55 | ('peso_ejecutado', models.IntegerField(validators=[django.core.validators.MaxValueValidator(999)])), |
---|
56 | ('cantidad_trabajo_realizado', models.IntegerField(validators=[django.core.validators.MaxValueValidator(999)])), |
---|
57 | ('fecha_avance', models.DateTimeField(auto_now_add=True)), |
---|
58 | ('activo', models.BooleanField(default=True)), |
---|
59 | ('fk_actividad', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='proyectos.Actividad')), |
---|
60 | ], |
---|
61 | ), |
---|
62 | migrations.CreateModel( |
---|
63 | name='AvancesProyecto', |
---|
64 | fields=[ |
---|
65 | ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), |
---|
66 | ('avance_subproyecto', models.IntegerField(validators=[django.core.validators.MaxValueValidator(999)])), |
---|
67 | ('avance_proyecto', models.IntegerField(validators=[django.core.validators.MaxValueValidator(999)])), |
---|
68 | ('fecha_avance', models.DateTimeField(auto_now_add=True)), |
---|
69 | ('activo', models.BooleanField(default=True)), |
---|
70 | ], |
---|
71 | ), |
---|
72 | migrations.CreateModel( |
---|
73 | name='CronogramaTarea', |
---|
74 | fields=[ |
---|
75 | ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), |
---|
76 | ('nombre', models.CharField(max_length=128)), |
---|
77 | ('horas_estimadas_tarea', models.IntegerField(validators=[django.core.validators.MaxValueValidator(9999999999)])), |
---|
78 | ('costo_estimado_tarea', models.DecimalField(decimal_places=2, max_digits=50)), |
---|
79 | ('peso_tarea', models.IntegerField(validators=[django.core.validators.MaxValueValidator(999)])), |
---|
80 | ('fin_comiento_tarea', models.BooleanField(default=True)), |
---|
81 | ('comienzo_comienzo_tarea', models.BooleanField(default=False)), |
---|
82 | ('fin_fin_tarea', models.BooleanField(default=False)), |
---|
83 | ('activo', models.BooleanField(default=True)), |
---|
84 | ('fk_actividad', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='proyectos.Actividad')), |
---|
85 | ], |
---|
86 | ), |
---|
87 | migrations.CreateModel( |
---|
88 | name='EstatusActividad', |
---|
89 | fields=[ |
---|
90 | ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), |
---|
91 | ('opcion_actividad', models.CharField(max_length=30)), |
---|
92 | ('activo', models.BooleanField(default=True)), |
---|
93 | ], |
---|
94 | ), |
---|
95 | migrations.CreateModel( |
---|
96 | name='EstatusCosto', |
---|
97 | fields=[ |
---|
98 | ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), |
---|
99 | ('opcion_costo', models.CharField(max_length=30)), |
---|
100 | ('activo', models.BooleanField(default=True)), |
---|
101 | ], |
---|
102 | ), |
---|
103 | migrations.CreateModel( |
---|
104 | name='Indicador', |
---|
105 | fields=[ |
---|
106 | ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), |
---|
107 | ('indicador_avance', models.IntegerField(validators=[django.core.validators.MaxValueValidator(999)])), |
---|
108 | ('indicador_rendimiento_costo', models.IntegerField(validators=[django.core.validators.MaxValueValidator(999)])), |
---|
109 | ('avance_respeto_tiempo', models.IntegerField(validators=[django.core.validators.MaxValueValidator(999)])), |
---|
110 | ('activo', models.BooleanField(default=True)), |
---|
111 | ('fk_avance', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='proyectos.AvanceActvidad')), |
---|
112 | ], |
---|
113 | ), |
---|
114 | migrations.CreateModel( |
---|
115 | name='ObjetivosEstrategico', |
---|
116 | fields=[ |
---|
117 | ('nivel', models.CharField(max_length=10, primary_key=True, serialize=False, verbose_name='nivel')), |
---|
118 | ('objetivo', models.CharField(max_length=800)), |
---|
119 | ], |
---|
120 | ), |
---|
121 | migrations.CreateModel( |
---|
122 | name='ObjetivosGeneral', |
---|
123 | fields=[ |
---|
124 | ('nivel', models.CharField(max_length=13, primary_key=True, serialize=False, verbose_name='nivel')), |
---|
125 | ('objetivo', models.CharField(max_length=2300)), |
---|
126 | ('fk_objetivo_estrategico', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='proyectos.ObjetivosEstrategico', verbose_name='Objetivo Estratégico')), |
---|
127 | ], |
---|
128 | ), |
---|
129 | migrations.CreateModel( |
---|
130 | name='ObjetivosHistorico', |
---|
131 | fields=[ |
---|
132 | ('nivel', models.CharField(max_length=5, primary_key=True, serialize=False, verbose_name='nivel')), |
---|
133 | ('objetivo', models.CharField(max_length=500)), |
---|
134 | ], |
---|
135 | ), |
---|
136 | migrations.CreateModel( |
---|
137 | name='ObjetivosNacional', |
---|
138 | fields=[ |
---|
139 | ('nivel', models.CharField(max_length=5, primary_key=True, serialize=False, verbose_name='nivel')), |
---|
140 | ('objetivo', models.CharField(max_length=500)), |
---|
141 | ('fk_objetivo_historico', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='proyectos.ObjetivosHistorico', verbose_name='Objetivo Historico')), |
---|
142 | ], |
---|
143 | ), |
---|
144 | migrations.CreateModel( |
---|
145 | name='Proyecto', |
---|
146 | fields=[ |
---|
147 | ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), |
---|
148 | ('codigo', models.CharField(max_length=15, unique=True)), |
---|
149 | ('nombre', models.CharField(max_length=128)), |
---|
150 | ('justificacion', models.TextField(blank=True)), |
---|
151 | ('objetivo_general', models.CharField(max_length=128)), |
---|
152 | ('objetivos_especificos', models.CharField(max_length=255)), |
---|
153 | ('monto_proyecto', models.DecimalField(decimal_places=2, max_digits=50)), |
---|
154 | ('fecha_inicio', models.DateField()), |
---|
155 | ('fecha_culminacion', models.DateField()), |
---|
156 | ('activo', models.BooleanField(default=True)), |
---|
157 | ('fk_alcance', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='proyectos.Alcance', verbose_name='Alcance')), |
---|
158 | ], |
---|
159 | ), |
---|
160 | migrations.CreateModel( |
---|
161 | name='Sector', |
---|
162 | fields=[ |
---|
163 | ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), |
---|
164 | ('opcion_sector', models.CharField(max_length=128)), |
---|
165 | ('activo', models.BooleanField(default=True)), |
---|
166 | ], |
---|
167 | ), |
---|
168 | migrations.CreateModel( |
---|
169 | name='SubProyecto', |
---|
170 | fields=[ |
---|
171 | ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), |
---|
172 | ('codigo', models.CharField(max_length=15, unique=True)), |
---|
173 | ('nombre', models.CharField(max_length=128)), |
---|
174 | ('descripcion_bien_servicio', models.TextField(blank=True)), |
---|
175 | ('unidad_medida', models.CharField(max_length=10)), |
---|
176 | ('meta', models.IntegerField(validators=[django.core.validators.MaxValueValidator(999)])), |
---|
177 | ('fecha_inicio', models.DateField()), |
---|
178 | ('fecha_culminacion', models.DateField()), |
---|
179 | ('comunidad', models.CharField(max_length=10)), |
---|
180 | ('monto_subproyecto', models.DecimalField(decimal_places=2, max_digits=50)), |
---|
181 | ('activo', models.BooleanField(default=True)), |
---|
182 | ('fk_proyecto', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='proyectos.Proyecto', verbose_name='Proyecto')), |
---|
183 | ('parroquia', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='utils.Parroquia', verbose_name='Parroquia')), |
---|
184 | ], |
---|
185 | ), |
---|
186 | migrations.CreateModel( |
---|
187 | name='VinculacionPndes', |
---|
188 | fields=[ |
---|
189 | ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), |
---|
190 | ('vinculacion_activa', models.BooleanField(default=True)), |
---|
191 | ('fk_objetivo_generales', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='proyectos.ObjetivosGeneral', verbose_name='Objetivo General')), |
---|
192 | ], |
---|
193 | ), |
---|
194 | migrations.AddField( |
---|
195 | model_name='proyecto', |
---|
196 | name='fk_sector', |
---|
197 | field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='proyectos.Sector', verbose_name='Sector'), |
---|
198 | ), |
---|
199 | migrations.AddField( |
---|
200 | model_name='objetivosestrategico', |
---|
201 | name='fk_objetivo_nacional', |
---|
202 | field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='proyectos.ObjetivosNacional', verbose_name='Objetivo Nacional'), |
---|
203 | ), |
---|
204 | migrations.AddField( |
---|
205 | model_name='avancesproyecto', |
---|
206 | name='fk_proyecto', |
---|
207 | field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='proyectos.Proyecto'), |
---|
208 | ), |
---|
209 | migrations.AddField( |
---|
210 | model_name='avanceactvidad', |
---|
211 | name='fk_estatus_actividad', |
---|
212 | field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='proyectos.EstatusActividad'), |
---|
213 | ), |
---|
214 | migrations.AddField( |
---|
215 | model_name='avanceactvidad', |
---|
216 | name='fk_estatus_costo', |
---|
217 | field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='proyectos.EstatusCosto'), |
---|
218 | ), |
---|
219 | migrations.AddField( |
---|
220 | model_name='areasestrategica', |
---|
221 | name='fk_objetivo_historico', |
---|
222 | field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='proyectos.VinculacionPndes', verbose_name='PNDES'), |
---|
223 | ), |
---|
224 | migrations.AddField( |
---|
225 | model_name='areasestrategica', |
---|
226 | name='fk_proyecto', |
---|
227 | field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='proyectos.Proyecto', verbose_name='Proyecto'), |
---|
228 | ), |
---|
229 | migrations.AddField( |
---|
230 | model_name='actividad', |
---|
231 | name='fk_subproyecto', |
---|
232 | field=models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='proyectos.SubProyecto', verbose_name='Sub-Proyecto'), |
---|
233 | ), |
---|
234 | ] |
---|