Specs: schema.yml

File schema.yml, 84.8 KB (added by David, 12 years ago)

Esquema a la fecha

Line 
1CA_ACCESO:
2 connection: doctrine
3 tableName: CA_ACCESO
4 columns:
5 id_acceso:
6 type: integer(8)
7 fixed: false
8 unsigned: false
9 primary: true
10 cod_func:
11 notnull: true
12 type: string(32)
13 fixed: false
14 unsigned: false
15 primary: false
16 es_funcion:
17 notnull: true
18 type: integer(1)
19 fixed: false
20 unsigned: false
21 primary: false
22 rotulo:
23 notnull: true
24 type: string(128)
25 fixed: false
26 unsigned: false
27 primary: false
28 id_modulo:
29 notnull: true
30 type: integer(8)
31 fixed: false
32 unsigned: false
33 primary: false
34 estado:
35 notnull: true
36 type: integer(1)
37 fixed: false
38 unsigned: false
39 primary: false
40 relations:
41 CA_MODULO:
42 local: id_modulo
43 foreign: id_modulo
44 type: one
45 CA_PERFIL_ACCESO:
46 local: id_acceso
47 foreign: id_acceso
48 type: many
49 CA_ACCESO_ACCESO:
50 local: id_acceso
51 foreign: id_acceso_padre
52 type: many
53 CA_ACCESO_ACCESO_2:
54 class: CA_ACCESO_ACCESO
55 local: id_acceso
56 foreign: id_acceso_hijo
57 type: many
58CA_ACCESO_ACCESO:
59 connection: doctrine
60 tableName: CA_ACCESO_ACCESO
61 columns:
62 id_acceso_padre:
63 type: integer(8)
64 fixed: false
65 unsigned: false
66 primary: true
67 id_acceso_hijo:
68 type: integer(8)
69 fixed: false
70 unsigned: false
71 primary: true
72 orden:
73 notnull: false
74 type: integer(8)
75 fixed: false
76 unsigned: false
77 primary: false
78 relations:
79 CA_ACCESO:
80 local: id_acceso_padre
81 foreign: id_acceso
82 type: one
83 CA_ACCESO_2:
84 class: CA_ACCESO
85 local: id_acceso_hijo
86 foreign: id_acceso
87 type: one
88CA_ANUAL_ETAPA:
89 connection: doctrine
90 tableName: CA_ANUAL_ETAPA
91 columns:
92 id_anual_etapa:
93 type: integer(8)
94 fixed: false
95 unsigned: false
96 primary: true
97 id_titulo_etapa:
98 notnull: true
99 type: integer(8)
100 fixed: false
101 unsigned: false
102 primary: false
103 id_titulo:
104 notnull: true
105 type: integer(8)
106 fixed: false
107 unsigned: false
108 primary: false
109 anualidad:
110 notnull: false
111 type: integer(8)
112 fixed: false
113 unsigned: false
114 default: '0 '
115 primary: false
116 fecha_inicio:
117 notnull: false
118 type: timestamp(7)
119 fixed: false
120 unsigned: false
121 primary: false
122 fecha_fin:
123 notnull: false
124 type: timestamp(7)
125 fixed: false
126 unsigned: false
127 primary: false
128 estado:
129 notnull: true
130 type: integer(1)
131 fixed: false
132 unsigned: false
133 default: "0\n "
134 primary: false
135 liquidado:
136 notnull: true
137 type: integer(1)
138 fixed: false
139 unsigned: false
140 default: '0 '
141 primary: false
142 impreso:
143 notnull: true
144 type: integer(1)
145 fixed: false
146 unsigned: false
147 default: '0 '
148 primary: false
149 relations:
150 CA_TITULO_ETAPA:
151 local: id_titulo_etapa
152 foreign: id_titulo_etapa
153 type: one
154 CA_DET_LIQ_CANON:
155 local: id_anual_etapa
156 foreign: id_anual_etapa
157 type: many
158CA_CON_RECIBO:
159 connection: doctrine
160 tableName: CA_CON_RECIBO
161 columns:
162 vigencia:
163 type: integer(8)
164 fixed: false
165 unsigned: false
166 primary: true
167 num_recibo_actual:
168 notnull: true
169 type: integer(8)
170 fixed: false
171 unsigned: false
172 default: "NULL\n "
173 primary: false
174CA_DET_LIQ_CANON:
175 connection: doctrine
176 tableName: CA_DET_LIQ_CANON
177 columns:
178 id_det_liq_canon:
179 type: integer(8)
180 fixed: false
181 unsigned: false
182 primary: true
183 vigencia:
184 type: integer(8)
185 fixed: false
186 unsigned: false
187 primary: true
188 id_liq_canon:
189 notnull: true
190 type: integer(8)
191 fixed: false
192 unsigned: false
193 primary: false
194 id_titulo:
195 notnull: true
196 type: integer(8)
197 fixed: false
198 unsigned: false
199 primary: false
200 id_etapa:
201 notnull: true
202 type: integer(8)
203 fixed: false
204 unsigned: false
205 primary: false
206 id_anual_etapa:
207 notnull: true
208 type: integer(8)
209 fixed: false
210 unsigned: false
211 primary: false
212 id_usuario_aprueba:
213 notnull: false
214 type: integer(8)
215 fixed: false
216 unsigned: false
217 primary: false
218 id_smdlv:
219 notnull: true
220 type: integer(8)
221 fixed: false
222 unsigned: false
223 primary: false
224 id_usuario_anula:
225 notnull: false
226 type: integer(8)
227 fixed: false
228 unsigned: false
229 primary: false
230 area:
231 notnull: false
232 type: integer(8)
233 fixed: false
234 unsigned: false
235 primary: false
236 anualidad:
237 notnull: false
238 type: integer(8)
239 fixed: false
240 unsigned: false
241 primary: false
242 valor:
243 notnull: true
244 type: decimal(18)
245 fixed: false
246 unsigned: false
247 default: '0'
248 primary: false
249 fecha_aprueba:
250 notnull: false
251 type: timestamp(7)
252 fixed: false
253 unsigned: false
254 primary: false
255 fecha_anula:
256 notnull: false
257 type: timestamp(7)
258 fixed: false
259 unsigned: false
260 primary: false
261 aprobado:
262 notnull: true
263 type: integer(1)
264 fixed: false
265 unsigned: false
266 default: '0 '
267 primary: false
268 anulado:
269 notnull: true
270 type: integer(1)
271 fixed: false
272 unsigned: false
273 default: '0'
274 primary: false
275 motivo_anu:
276 notnull: false
277 type: string(256)
278 fixed: false
279 unsigned: false
280 primary: false
281 relations:
282 CA_ANUAL_ETAPA:
283 local: id_anual_etapa
284 foreign: id_anual_etapa
285 type: one
286 CA_ETAPA:
287 local: id_etapa
288 foreign: id_etapa
289 type: one
290 CA_LIQ_CANON:
291 local: vigencia
292 foreign: id_liq_canon
293 type: one
294 CA_LIQ_CANON_4:
295 class: CA_LIQ_CANON
296 local: id_liq_canon
297 foreign: id_liq_canon
298 type: one
299 CA_LIQ_CANON_5:
300 class: CA_LIQ_CANON
301 local: vigencia
302 foreign: vigencia
303 type: one
304 CA_LIQ_CANON_6:
305 class: CA_LIQ_CANON
306 local: id_liq_canon
307 foreign: vigencia
308 type: one
309 CA_SMDLV:
310 local: id_smdlv
311 foreign: id_smdlv
312 type: one
313 CA_USUARIO:
314 local: id_usuario_aprueba
315 foreign: id_usuario
316 type: one
317 CA_USUARIO_9:
318 class: CA_USUARIO
319 local: id_usuario_anula
320 foreign: id_usuario
321 type: one
322 RMN_TITULO:
323 local: id_titulo
324 foreign: id_titulo
325 type: one
326 CA_RECIBO:
327 local: id_det_liq_canon
328 foreign: id_det_liq_canon
329 type: many
330 CA_RECIBO_2:
331 class: CA_RECIBO
332 local: id_det_liq_canon
333 foreign: vig_liq
334 type: many
335 CA_RECIBO_3:
336 class: CA_RECIBO
337 local: vigencia
338 foreign: id_det_liq_canon
339 type: many
340 CA_RECIBO_4:
341 class: CA_RECIBO
342 local: vigencia
343 foreign: vig_liq
344 type: many
345CA_DET_LIQ_CANON_MV:
346 connection: doctrine
347 tableName: CA_DET_LIQ_CANON_MV
348 columns:
349 id:
350 type: integer(8)
351 autoincrement: true
352 primary: true
353 id_det_liq_canon:
354 notnull: true
355 type: integer(8)
356 fixed: false
357 unsigned: false
358 primary: false
359 vigencia:
360 notnull: true
361 type: integer(8)
362 fixed: false
363 unsigned: false
364 primary: false
365 id_liq_canon:
366 notnull: true
367 type: integer(8)
368 fixed: false
369 unsigned: false
370 primary: false
371 id_titulo:
372 notnull: true
373 type: integer(8)
374 fixed: false
375 unsigned: false
376 primary: false
377 id_etapa:
378 notnull: true
379 type: integer(8)
380 fixed: false
381 unsigned: false
382 primary: false
383 id_anual_etapa:
384 notnull: true
385 type: integer(8)
386 fixed: false
387 unsigned: false
388 primary: false
389 id_usuario_aprueba:
390 notnull: false
391 type: integer(8)
392 fixed: false
393 unsigned: false
394 primary: false
395 id_smdlv:
396 notnull: true
397 type: integer(8)
398 fixed: false
399 unsigned: false
400 primary: false
401 id_usuario_anula:
402 notnull: false
403 type: integer(8)
404 fixed: false
405 unsigned: false
406 primary: false
407 area:
408 notnull: false
409 type: integer(8)
410 fixed: false
411 unsigned: false
412 primary: false
413 anualidad:
414 notnull: false
415 type: integer(8)
416 fixed: false
417 unsigned: false
418 primary: false
419 valor:
420 notnull: true
421 type: decimal(18)
422 fixed: false
423 unsigned: false
424 primary: false
425 fecha_aprueba:
426 notnull: false
427 type: timestamp(7)
428 fixed: false
429 unsigned: false
430 primary: false
431 fecha_anula:
432 notnull: false
433 type: timestamp(7)
434 fixed: false
435 unsigned: false
436 primary: false
437 aprobado:
438 notnull: true
439 type: integer(1)
440 fixed: false
441 unsigned: false
442 primary: false
443 anulado:
444 notnull: true
445 type: integer(1)
446 fixed: false
447 unsigned: false
448 primary: false
449 motivo_anu:
450 notnull: false
451 type: string(256)
452 fixed: false
453 unsigned: false
454 primary: false
455 fecha:
456 notnull: true
457 type: timestamp(7)
458 fixed: false
459 unsigned: false
460 primary: false
461 estado:
462 notnull: true
463 type: integer(1)
464 fixed: false
465 unsigned: false
466 primary: false
467 motivo_anu_liq:
468 notnull: false
469 type: string(256)
470 fixed: false
471 unsigned: false
472 primary: false
473 fecha_anula_liq:
474 notnull: false
475 type: timestamp(7)
476 fixed: false
477 unsigned: false
478 primary: false
479 id_usuario_anula_liq:
480 notnull: false
481 type: integer(8)
482 fixed: false
483 unsigned: false
484 primary: false
485 automatico:
486 notnull: true
487 type: integer(8)
488 fixed: false
489 unsigned: false
490 primary: false
491 anulado_liq:
492 notnull: true
493 type: integer(8)
494 fixed: false
495 unsigned: false
496 primary: false
497 valor_dia:
498 notnull: true
499 type: decimal(18)
500 fixed: false
501 unsigned: false
502 primary: false
503 valor_mensual:
504 notnull: true
505 type: decimal(18)
506 fixed: false
507 unsigned: false
508 primary: false
509 fecha_ini:
510 notnull: true
511 type: timestamp(7)
512 fixed: false
513 unsigned: false
514 primary: false
515 fecha_fin:
516 notnull: true
517 type: timestamp(7)
518 fixed: false
519 unsigned: false
520 primary: false
521 vigencia_salmin:
522 notnull: true
523 type: integer(8)
524 fixed: false
525 unsigned: false
526 primary: false
527 nombre:
528 notnull: true
529 type: string(128)
530 fixed: false
531 unsigned: false
532 primary: false
533 descripcion:
534 notnull: false
535 type: string(256)
536 fixed: false
537 unsigned: false
538 primary: false
539 id_titulo_etapa:
540 notnull: true
541 type: integer(8)
542 fixed: false
543 unsigned: false
544 primary: false
545 id_titulo_anueta:
546 notnull: true
547 type: integer(8)
548 fixed: false
549 unsigned: false
550 primary: false
551 anualidad_anueta:
552 notnull: false
553 type: integer(8)
554 fixed: false
555 unsigned: false
556 primary: false
557 fecha_inicio:
558 notnull: false
559 type: timestamp(7)
560 fixed: false
561 unsigned: false
562 primary: false
563 fecha_cumple:
564 notnull: false
565 type: timestamp(7)
566 fixed: false
567 unsigned: false
568 primary: false
569 estado_anueta:
570 notnull: true
571 type: integer(1)
572 fixed: false
573 unsigned: false
574 primary: false
575CA_ETAPA:
576 connection: doctrine
577 tableName: CA_ETAPA
578 columns:
579 id_etapa:
580 type: integer(8)
581 fixed: false
582 unsigned: false
583 primary: true
584 nombre:
585 notnull: true
586 type: string(128)
587 fixed: false
588 unsigned: false
589 primary: false
590 descripcion:
591 notnull: false
592 type: string(256)
593 fixed: false
594 unsigned: false
595 primary: false
596 relations:
597 CA_TITULO_ETAPA:
598 local: id_etapa
599 foreign: id_etapa
600 type: many
601 CA_FORMULA:
602 local: id_etapa
603 foreign: id_etapa
604 type: many
605 CA_ETAPA_MODALIDAD:
606 local: id_etapa
607 foreign: id_etapa
608 type: many
609 CA_DET_LIQ_CANON:
610 local: id_etapa
611 foreign: id_etapa
612 type: many
613CA_ETAPA_MODALIDAD:
614 connection: doctrine
615 tableName: CA_ETAPA_MODALIDAD
616 columns:
617 id_modalidad:
618 type: integer(8)
619 fixed: false
620 unsigned: false
621 primary: true
622 id_etapa:
623 type: integer(8)
624 fixed: false
625 unsigned: false
626 primary: true
627 anual_defecto:
628 notnull: true
629 type: integer(8)
630 fixed: false
631 unsigned: false
632 default: '0 '
633 primary: false
634 anual_max:
635 notnull: false
636 type: integer(8)
637 fixed: false
638 unsigned: false
639 default: '0 '
640 primary: false
641 orden:
642 notnull: false
643 type: integer(8)
644 fixed: false
645 unsigned: false
646 default: '0 '
647 primary: false
648 relations:
649 CA_ETAPA:
650 local: id_etapa
651 foreign: id_etapa
652 type: one
653 RMN_MODALIDAD:
654 local: id_modalidad
655 foreign: id_modalidad
656 type: one
657CA_FORMULA:
658 connection: doctrine
659 tableName: CA_FORMULA
660 columns:
661 id_formula:
662 type: integer(8)
663 fixed: false
664 unsigned: false
665 primary: true
666 id_norma:
667 notnull: true
668 type: integer(8)
669 fixed: false
670 unsigned: false
671 primary: false
672 id_etapa:
673 notnull: true
674 type: integer(8)
675 fixed: false
676 unsigned: false
677 primary: false
678 formula:
679 notnull: true
680 type: string(1024)
681 fixed: false
682 unsigned: false
683 primary: false
684 relations:
685 CA_ETAPA:
686 local: id_etapa
687 foreign: id_etapa
688 type: one
689 CA_NORMA_CANON:
690 local: id_norma
691 foreign: id_norma
692 type: one
693CA_LIQ_CANON:
694 connection: doctrine
695 tableName: CA_LIQ_CANON
696 columns:
697 id_liq_canon:
698 type: integer(8)
699 fixed: false
700 unsigned: false
701 primary: true
702 vigencia:
703 type: integer(8)
704 fixed: false
705 unsigned: false
706 primary: true
707 fecha:
708 notnull: true
709 type: timestamp(7)
710 fixed: false
711 unsigned: false
712 primary: false
713 estado:
714 notnull: true
715 type: integer(1)
716 fixed: false
717 unsigned: false
718 default: '1 '
719 primary: false
720 motivo_anu:
721 notnull: false
722 type: string(256)
723 fixed: false
724 unsigned: false
725 primary: false
726 fecha_anula:
727 notnull: false
728 type: timestamp(7)
729 fixed: false
730 unsigned: false
731 primary: false
732 id_usuario_anula:
733 notnull: false
734 type: integer(8)
735 fixed: false
736 unsigned: false
737 primary: false
738 automatico:
739 notnull: true
740 type: integer(8)
741 fixed: false
742 unsigned: false
743 default: '0'
744 primary: false
745 anulado:
746 notnull: true
747 type: integer(8)
748 fixed: false
749 unsigned: false
750 default: '0 '
751 primary: false
752 motivo_cierre:
753 notnull: false
754 type: string(256)
755 fixed: false
756 unsigned: false
757 primary: false
758 fecha_cierre:
759 notnull: false
760 type: timestamp(7)
761 fixed: false
762 unsigned: false
763 primary: false
764 id_usuario_cierre:
765 notnull: false
766 type: integer(8)
767 fixed: false
768 unsigned: false
769 primary: false
770 id_competencia:
771 notnull: false
772 type: integer(8)
773 fixed: false
774 unsigned: false
775 primary: false
776 relations:
777 CA_USUARIO:
778 local: id_usuario_cierre
779 foreign: id_usuario
780 type: one
781 RMN_COMPETENCIA:
782 local: id_competencia
783 foreign: id_competencia
784 type: one
785 CA_USUARIO_3:
786 class: CA_USUARIO
787 local: id_usuario_anula
788 foreign: id_usuario
789 type: one
790 CA_DET_LIQ_CANON:
791 local: id_liq_canon
792 foreign: vigencia
793 type: many
794 CA_DET_LIQ_CANON_4:
795 class: CA_DET_LIQ_CANON
796 local: id_liq_canon
797 foreign: id_liq_canon
798 type: many
799 CA_DET_LIQ_CANON_5:
800 class: CA_DET_LIQ_CANON
801 local: vigencia
802 foreign: vigencia
803 type: many
804 CA_DET_LIQ_CANON_6:
805 class: CA_DET_LIQ_CANON
806 local: vigencia
807 foreign: id_liq_canon
808 type: many
809CA_LOG:
810 connection: doctrine
811 tableName: CA_LOG
812 columns:
813 id_log:
814 type: integer(8)
815 fixed: false
816 unsigned: false
817 primary: true
818 id_tabla:
819 notnull: false
820 type: integer(8)
821 fixed: false
822 unsigned: false
823 primary: false
824 id_anho:
825 notnull: false
826 type: integer(8)
827 fixed: false
828 unsigned: false
829 primary: false
830 vigencia:
831 notnull: true
832 type: integer(8)
833 fixed: false
834 unsigned: false
835 primary: false
836 id_mae_bd:
837 notnull: false
838 type: integer(8)
839 fixed: false
840 unsigned: false
841 primary: false
842 periodo:
843 notnull: true
844 type: integer(8)
845 fixed: false
846 unsigned: false
847 primary: false
848 id_ope_bd:
849 notnull: true
850 type: integer(8)
851 fixed: false
852 unsigned: false
853 primary: false
854 fecha_log:
855 notnull: true
856 type: timestamp(7)
857 fixed: false
858 unsigned: false
859 primary: false
860 id_mae_ter:
861 notnull: false
862 type: integer(8)
863 fixed: false
864 unsigned: false
865 primary: false
866 usuario:
867 notnull: true
868 type: string(128)
869 fixed: false
870 unsigned: false
871 primary: false
872 id_usuario:
873 notnull: true
874 type: integer(8)
875 fixed: false
876 unsigned: false
877 primary: false
878 comando:
879 notnull: true
880 type: string(128)
881 fixed: false
882 unsigned: false
883 primary: false
884 cod_func:
885 notnull: true
886 type: string(128)
887 fixed: false
888 unsigned: false
889 primary: false
890 observacion:
891 notnull: false
892 type: string(512)
893 fixed: false
894 unsigned: false
895 primary: false
896 id_punto_venta:
897 notnull: false
898 type: integer(8)
899 fixed: false
900 unsigned: false
901 primary: false
902 relations:
903 CA_MAE_BD:
904 local: id_mae_bd
905 foreign: id_mae_bd
906 type: one
907 CA_OPE_BD:
908 local: id_ope_bd
909 foreign: id_ope_bd
910 type: one
911 CA_USUARIO:
912 local: id_usuario
913 foreign: id_usuario
914 type: one
915CA_LOG_MV:
916 connection: doctrine
917 tableName: CA_LOG_MV
918 columns:
919 id:
920 type: integer(8)
921 autoincrement: true
922 primary: true
923 id_log:
924 notnull: true
925 type: integer(8)
926 fixed: false
927 unsigned: false
928 primary: false
929 id_tabla:
930 notnull: false
931 type: integer(8)
932 fixed: false
933 unsigned: false
934 primary: false
935 vigencia:
936 notnull: true
937 type: integer(8)
938 fixed: false
939 unsigned: false
940 primary: false
941 periodo:
942 notnull: true
943 type: integer(8)
944 fixed: false
945 unsigned: false
946 primary: false
947 fecha_log:
948 notnull: true
949 type: timestamp(7)
950 fixed: false
951 unsigned: false
952 primary: false
953 id_ope_bd:
954 notnull: true
955 type: integer(8)
956 fixed: false
957 unsigned: false
958 primary: false
959 id_mae_bd:
960 notnull: false
961 type: integer(8)
962 fixed: false
963 unsigned: false
964 primary: false
965 id_usuario:
966 notnull: true
967 type: integer(8)
968 fixed: false
969 unsigned: false
970 primary: false
971 cod_func:
972 notnull: true
973 type: string(128)
974 fixed: false
975 unsigned: false
976 primary: false
977 observacion:
978 notnull: false
979 type: string(512)
980 fixed: false
981 unsigned: false
982 primary: false
983 des_ope_bd:
984 notnull: true
985 type: string(128)
986 fixed: false
987 unsigned: false
988 primary: false
989 username:
990 notnull: true
991 type: string(64)
992 fixed: false
993 unsigned: false
994 primary: false
995 estado:
996 notnull: true
997 type: integer(1)
998 fixed: false
999 unsigned: false
1000 primary: false
1001CA_MAE_BD:
1002 connection: doctrine
1003 tableName: CA_MAE_BD
1004 columns:
1005 id_mae_bd:
1006 type: integer(8)
1007 fixed: false
1008 unsigned: false
1009 primary: true
1010 des_mae_bd:
1011 notnull: true
1012 type: string(128)
1013 fixed: false
1014 unsigned: false
1015 primary: false
1016 relations:
1017 CA_LOG:
1018 local: id_mae_bd
1019 foreign: id_mae_bd
1020 type: many
1021CA_MODALIDAD_NORMA:
1022 connection: doctrine
1023 tableName: CA_MODALIDAD_NORMA
1024 columns:
1025 id_modalidad:
1026 type: integer(8)
1027 fixed: false
1028 unsigned: false
1029 primary: true
1030 id_norma:
1031 type: integer(8)
1032 fixed: false
1033 unsigned: false
1034 primary: true
1035 estado:
1036 notnull: true
1037 type: integer(1)
1038 fixed: false
1039 unsigned: false
1040 default: "0\n "
1041 primary: false
1042 relations:
1043 CA_NORMA_CANON:
1044 local: id_norma
1045 foreign: id_norma
1046 type: one
1047 RMN_MODALIDAD:
1048 local: id_modalidad
1049 foreign: id_modalidad
1050 type: one
1051CA_MODULO:
1052 connection: doctrine
1053 tableName: CA_MODULO
1054 columns:
1055 id_modulo:
1056 type: integer(8)
1057 fixed: false
1058 unsigned: false
1059 primary: true
1060 descripcion:
1061 notnull: true
1062 type: string(256)
1063 fixed: false
1064 unsigned: false
1065 primary: false
1066 desc_corta:
1067 notnull: true
1068 type: string(64)
1069 fixed: false
1070 unsigned: false
1071 primary: false
1072 nombre:
1073 notnull: true
1074 type: string(128)
1075 fixed: false
1076 unsigned: false
1077 primary: false
1078 relations:
1079 CA_PERFIL:
1080 local: id_modulo
1081 foreign: id_modulo
1082 type: many
1083 CA_ACCESO:
1084 local: id_modulo
1085 foreign: id_modulo
1086 type: many
1087CA_NORMA_CANON:
1088 connection: doctrine
1089 tableName: CA_NORMA_CANON
1090 columns:
1091 id_norma:
1092 type: integer(8)
1093 fixed: false
1094 unsigned: false
1095 primary: true
1096 descripcion:
1097 notnull: true
1098 type: string(256)
1099 fixed: false
1100 unsigned: false
1101 primary: false
1102 fecha_vigencia:
1103 notnull: true
1104 type: timestamp(7)
1105 fixed: false
1106 unsigned: false
1107 primary: false
1108 estado:
1109 notnull: true
1110 type: integer(1)
1111 fixed: false
1112 unsigned: false
1113 default: "0\n "
1114 primary: false
1115 relations:
1116 CA_TITULO_NORMA:
1117 local: id_norma
1118 foreign: id_norma
1119 type: many
1120 CA_MODALIDAD_NORMA:
1121 local: id_norma
1122 foreign: id_norma
1123 type: many
1124 CA_FORMULA:
1125 local: id_norma
1126 foreign: id_norma
1127 type: many
1128CA_NOVEDAD:
1129 connection: doctrine
1130 tableName: CA_NOVEDAD
1131 columns:
1132 id_novedad:
1133 type: integer(8)
1134 fixed: false
1135 unsigned: false
1136 primary: true
1137 id_titulo:
1138 notnull: true
1139 type: integer(8)
1140 fixed: false
1141 unsigned: false
1142 primary: false
1143 id_tipo_novedad:
1144 notnull: true
1145 type: integer(8)
1146 fixed: false
1147 unsigned: false
1148 primary: false
1149 fecha_registro:
1150 notnull: true
1151 type: timestamp(7)
1152 fixed: false
1153 unsigned: false
1154 primary: false
1155 id_anotacion:
1156 notnull: false
1157 type: integer(8)
1158 fixed: false
1159 unsigned: false
1160 primary: false
1161 id_tipo_anotacion:
1162 notnull: false
1163 type: integer(8)
1164 fixed: false
1165 unsigned: false
1166 primary: false
1167 doc_soporte:
1168 notnull: false
1169 type: string(128)
1170 fixed: false
1171 unsigned: false
1172 primary: false
1173 fecha_doc_sop:
1174 notnull: false
1175 type: timestamp(7)
1176 fixed: false
1177 unsigned: false
1178 primary: false
1179 id_tipo_doc:
1180 notnull: false
1181 type: integer(8)
1182 fixed: false
1183 unsigned: false
1184 primary: false
1185 observaciones:
1186 notnull: false
1187 type: string(512)
1188 fixed: false
1189 unsigned: false
1190 primary: false
1191 aprobada:
1192 notnull: true
1193 type: integer(1)
1194 fixed: false
1195 unsigned: false
1196 default: '0 '
1197 primary: false
1198 relations:
1199 CA_TIPO_NOVEDAD:
1200 local: id_tipo_novedad
1201 foreign: id_tipo_novedad
1202 type: one
1203 RMN_ANOTACION:
1204 local: id_anotacion
1205 foreign: id_anotacion
1206 type: one
1207 RMN_TIPO_ANOTACION:
1208 local: id_tipo_anotacion
1209 foreign: id_tipo_anotacion
1210 type: one
1211 RMN_TITULO:
1212 local: id_titulo
1213 foreign: id_titulo
1214 type: one
1215 CA_TIPO_DOC:
1216 local: id_tipo_doc
1217 foreign: id_tipo_doc
1218 type: one
1219 IN_TITULO_COMPETENCIA:
1220 local: id_novedad
1221 foreign: id_novedad
1222 type: many
1223 IN_TITULO_AREA:
1224 local: id_novedad
1225 foreign: id_novedad
1226 type: many
1227 CA_TITULO_NORMA:
1228 local: id_novedad
1229 foreign: id_novedad
1230 type: many
1231 CA_TITULO_ETAPA:
1232 local: id_novedad
1233 foreign: id_novedad
1234 type: many
1235 RMN_TITULO_PERSONA:
1236 local: id_novedad
1237 foreign: id_novedad
1238 type: many
1239 RMN_TITULO_MODALIDAD:
1240 local: id_novedad
1241 foreign: id_novedad
1242 type: many
1243CA_NOVEDAD_MV:
1244 connection: doctrine
1245 tableName: CA_NOVEDAD_MV
1246 columns:
1247 id:
1248 type: integer(8)
1249 autoincrement: true
1250 primary: true
1251 id_novedad:
1252 notnull: true
1253 type: integer(8)
1254 fixed: false
1255 unsigned: false
1256 primary: false
1257 id_titulo:
1258 notnull: true
1259 type: integer(8)
1260 fixed: false
1261 unsigned: false
1262 primary: false
1263 id_tipo_novedad:
1264 notnull: true
1265 type: integer(8)
1266 fixed: false
1267 unsigned: false
1268 primary: false
1269 fecha_registro:
1270 notnull: true
1271 type: timestamp(7)
1272 fixed: false
1273 unsigned: false
1274 primary: false
1275 id_anotacion:
1276 notnull: false
1277 type: integer(8)
1278 fixed: false
1279 unsigned: false
1280 primary: false
1281 id_tipo_anotacion:
1282 notnull: false
1283 type: integer(8)
1284 fixed: false
1285 unsigned: false
1286 primary: false
1287 doc_soporte:
1288 notnull: false
1289 type: string(128)
1290 fixed: false
1291 unsigned: false
1292 primary: false
1293 fecha_doc_sop:
1294 notnull: false
1295 type: timestamp(7)
1296 fixed: false
1297 unsigned: false
1298 primary: false
1299 id_tipo_doc:
1300 notnull: false
1301 type: integer(8)
1302 fixed: false
1303 unsigned: false
1304 primary: false
1305 observaciones:
1306 notnull: false
1307 type: string(512)
1308 fixed: false
1309 unsigned: false
1310 primary: false
1311 aprobada:
1312 notnull: true
1313 type: integer(1)
1314 fixed: false
1315 unsigned: false
1316 primary: false
1317 nombre:
1318 notnull: true
1319 type: string(64)
1320 fixed: false
1321 unsigned: false
1322 primary: false
1323 descripcion:
1324 notnull: false
1325 type: string(256)
1326 fixed: false
1327 unsigned: false
1328 primary: false
1329 usa_anotacion:
1330 notnull: true
1331 type: integer(1)
1332 fixed: false
1333 unsigned: false
1334 primary: false
1335CA_OPE_BD:
1336 connection: doctrine
1337 tableName: CA_OPE_BD
1338 columns:
1339 id_ope_bd:
1340 type: integer(8)
1341 fixed: false
1342 unsigned: false
1343 primary: true
1344 des_ope_bd:
1345 notnull: true
1346 type: string(128)
1347 fixed: false
1348 unsigned: false
1349 primary: false
1350 relations:
1351 CA_LOG:
1352 local: id_ope_bd
1353 foreign: id_ope_bd
1354 type: many
1355CA_PERFIL:
1356 connection: doctrine
1357 tableName: CA_PERFIL
1358 columns:
1359 id_perfil:
1360 type: integer(8)
1361 fixed: false
1362 unsigned: false
1363 primary: true
1364 nombre:
1365 notnull: true
1366 type: string(64)
1367 fixed: false
1368 unsigned: false
1369 primary: false
1370 descripcion:
1371 notnull: true
1372 type: string(128)
1373 fixed: false
1374 unsigned: false
1375 primary: false
1376 id_modulo:
1377 notnull: true
1378 type: integer(8)
1379 fixed: false
1380 unsigned: false
1381 primary: false
1382 estado:
1383 notnull: true
1384 type: integer(1)
1385 fixed: false
1386 unsigned: false
1387 primary: false
1388 relations:
1389 CA_MODULO:
1390 local: id_modulo
1391 foreign: id_modulo
1392 type: one
1393 CA_USUARIO_PERFIL:
1394 local: id_perfil
1395 foreign: id_perfil
1396 type: many
1397 CA_PERFIL_ACCESO:
1398 local: id_perfil
1399 foreign: id_perfil
1400 type: many
1401CA_PERFIL_ACCESO:
1402 connection: doctrine
1403 tableName: CA_PERFIL_ACCESO
1404 columns:
1405 id_perfil:
1406 type: integer(8)
1407 fixed: false
1408 unsigned: false
1409 primary: true
1410 id_acceso:
1411 type: integer(8)
1412 fixed: false
1413 unsigned: false
1414 primary: true
1415 relations:
1416 CA_ACCESO:
1417 local: id_acceso
1418 foreign: id_acceso
1419 type: one
1420 CA_PERFIL:
1421 local: id_perfil
1422 foreign: id_perfil
1423 type: one
1424CA_PREG_SEGURIDAD:
1425 connection: doctrine
1426 tableName: CA_PREG_SEGURIDAD
1427 columns:
1428 id_preg_seguridad:
1429 type: integer(8)
1430 fixed: false
1431 unsigned: false
1432 primary: true
1433 id_usuario:
1434 notnull: true
1435 type: integer(8)
1436 fixed: false
1437 unsigned: false
1438 primary: false
1439 texto_preg:
1440 notnull: true
1441 type: string(128)
1442 fixed: false
1443 unsigned: false
1444 primary: false
1445 resp_preg:
1446 notnull: true
1447 type: string(128)
1448 fixed: false
1449 unsigned: false
1450 primary: false
1451 relations:
1452 CA_USUARIO:
1453 local: id_usuario
1454 foreign: id_usuario
1455 type: one
1456CA_RECIBO:
1457 connection: doctrine
1458 tableName: CA_RECIBO
1459 columns:
1460 id_recibo:
1461 type: integer(8)
1462 fixed: false
1463 unsigned: false
1464 primary: true
1465 vigencia:
1466 type: integer(8)
1467 fixed: false
1468 unsigned: false
1469 primary: true
1470 id_det_liq_canon:
1471 notnull: true
1472 type: integer(8)
1473 fixed: false
1474 unsigned: false
1475 primary: false
1476 vig_liq:
1477 notnull: true
1478 type: integer(8)
1479 fixed: false
1480 unsigned: false
1481 primary: false
1482 num_recibo:
1483 notnull: false
1484 type: integer(8)
1485 fixed: false
1486 unsigned: false
1487 primary: false
1488 fecha_exped_rec:
1489 notnull: false
1490 type: timestamp(7)
1491 fixed: false
1492 unsigned: false
1493 primary: false
1494 fecha_vence_rec:
1495 notnull: false
1496 type: timestamp(7)
1497 fixed: false
1498 unsigned: false
1499 primary: false
1500 fecha_pago_oportuno:
1501 notnull: false
1502 type: timestamp(7)
1503 fixed: false
1504 unsigned: false
1505 primary: false
1506 fecha_anula:
1507 notnull: false
1508 type: timestamp(7)
1509 fixed: false
1510 unsigned: false
1511 primary: false
1512 pago:
1513 notnull: true
1514 type: integer(1)
1515 fixed: false
1516 unsigned: false
1517 default: '0'
1518 primary: false
1519 id_usuario_anula:
1520 notnull: false
1521 type: integer(8)
1522 fixed: false
1523 unsigned: false
1524 primary: false
1525 anulado:
1526 notnull: true
1527 type: integer(1)
1528 fixed: false
1529 unsigned: false
1530 default: "0\n "
1531 primary: false
1532 relations:
1533 CA_DET_LIQ_CANON:
1534 local: id_det_liq_canon
1535 foreign: id_det_liq_canon
1536 type: one
1537 CA_DET_LIQ_CANON_2:
1538 class: CA_DET_LIQ_CANON
1539 local: vig_liq
1540 foreign: id_det_liq_canon
1541 type: one
1542 CA_DET_LIQ_CANON_3:
1543 class: CA_DET_LIQ_CANON
1544 local: id_det_liq_canon
1545 foreign: vigencia
1546 type: one
1547 CA_DET_LIQ_CANON_4:
1548 class: CA_DET_LIQ_CANON
1549 local: vig_liq
1550 foreign: vigencia
1551 type: one
1552 CA_USUARIO:
1553 local: id_usuario_anula
1554 foreign: id_usuario
1555 type: one
1556CA_SMDLV:
1557 connection: doctrine
1558 tableName: CA_SMDLV
1559 columns:
1560 id_smdlv:
1561 type: integer(8)
1562 fixed: false
1563 unsigned: false
1564 primary: true
1565 valor_dia:
1566 notnull: true
1567 type: decimal(18)
1568 fixed: false
1569 unsigned: false
1570 default: '0'
1571 primary: false
1572 valor_mensual:
1573 notnull: true
1574 type: decimal(18)
1575 fixed: false
1576 unsigned: false
1577 default: '0'
1578 primary: false
1579 fecha_ini:
1580 notnull: true
1581 type: timestamp(7)
1582 fixed: false
1583 unsigned: false
1584 primary: false
1585 fecha_fin:
1586 notnull: true
1587 type: timestamp(7)
1588 fixed: false
1589 unsigned: false
1590 primary: false
1591 vigencia:
1592 notnull: true
1593 type: integer(8)
1594 fixed: false
1595 unsigned: false
1596 primary: false
1597 relations:
1598 CA_DET_LIQ_CANON:
1599 local: id_smdlv
1600 foreign: id_smdlv
1601 type: many
1602CA_TABLE_VIG_SEQ:
1603 connection: doctrine
1604 tableName: CA_TABLE_VIG_SEQ
1605 columns:
1606 id_vigencia:
1607 type: integer(8)
1608 fixed: false
1609 unsigned: false
1610 primary: true
1611 nom_entidad:
1612 type: string(50)
1613 fixed: false
1614 unsigned: false
1615 primary: true
1616 seq:
1617 notnull: true
1618 type: integer(8)
1619 fixed: false
1620 unsigned: false
1621 default: "0\n "
1622 primary: false
1623CA_TIPO_DOC:
1624 connection: doctrine
1625 tableName: CA_TIPO_DOC
1626 columns:
1627 id_tipo_doc:
1628 type: integer(8)
1629 fixed: false
1630 unsigned: false
1631 primary: true
1632 nombre:
1633 notnull: true
1634 type: string(64)
1635 fixed: false
1636 unsigned: false
1637 primary: false
1638 descripcion:
1639 notnull: false
1640 type: string(256)
1641 fixed: false
1642 unsigned: false
1643 primary: false
1644 relations:
1645 CA_NOVEDAD:
1646 local: id_tipo_doc
1647 foreign: id_tipo_doc
1648 type: many
1649CA_TIPO_NOVEDAD:
1650 connection: doctrine
1651 tableName: CA_TIPO_NOVEDAD
1652 columns:
1653 id_tipo_novedad:
1654 type: integer(8)
1655 fixed: false
1656 unsigned: false
1657 primary: true
1658 descripcion:
1659 notnull: false
1660 type: string(256)
1661 fixed: false
1662 unsigned: false
1663 primary: false
1664 nombre:
1665 notnull: true
1666 type: string(64)
1667 fixed: false
1668 unsigned: false
1669 primary: false
1670 desc_corta:
1671 notnull: true
1672 type: string(2)
1673 fixed: false
1674 unsigned: false
1675 primary: false
1676 estado:
1677 notnull: true
1678 type: integer(1)
1679 fixed: false
1680 unsigned: false
1681 default: "0\n "
1682 primary: false
1683 usa_anotacion:
1684 notnull: true
1685 type: integer(1)
1686 fixed: false
1687 unsigned: false
1688 default: "0\n "
1689 primary: false
1690 relations:
1691 CA_NOVEDAD:
1692 local: id_tipo_novedad
1693 foreign: id_tipo_novedad
1694 type: many
1695CA_TITULO_ETAPA:
1696 connection: doctrine
1697 tableName: CA_TITULO_ETAPA
1698 columns:
1699 id_titulo_etapa:
1700 type: integer(8)
1701 fixed: false
1702 unsigned: false
1703 primary: true
1704 id_titulo:
1705 notnull: true
1706 type: integer(8)
1707 fixed: false
1708 unsigned: false
1709 primary: false
1710 id_etapa:
1711 notnull: true
1712 type: integer(8)
1713 fixed: false
1714 unsigned: false
1715 primary: false
1716 id_novedad:
1717 notnull: false
1718 type: integer(8)
1719 fixed: false
1720 unsigned: false
1721 primary: false
1722 fecha_inicio:
1723 notnull: false
1724 type: timestamp(7)
1725 fixed: false
1726 unsigned: false
1727 primary: false
1728 fecha_fin:
1729 notnull: false
1730 type: timestamp(7)
1731 fixed: false
1732 unsigned: false
1733 primary: false
1734 fecha_inscripcion:
1735 notnull: false
1736 type: timestamp(7)
1737 fixed: false
1738 unsigned: false
1739 primary: false
1740 anualidades:
1741 notnull: false
1742 type: integer(8)
1743 fixed: false
1744 unsigned: false
1745 primary: false
1746 estado:
1747 notnull: true
1748 type: integer(1)
1749 fixed: false
1750 unsigned: false
1751 default: '0'
1752 primary: false
1753 actual:
1754 notnull: true
1755 type: integer(1)
1756 fixed: false
1757 unsigned: false
1758 default: "0\n "
1759 primary: false
1760 relations:
1761 CA_ETAPA:
1762 local: id_etapa
1763 foreign: id_etapa
1764 type: one
1765 CA_NOVEDAD:
1766 local: id_novedad
1767 foreign: id_novedad
1768 type: one
1769 RMN_TITULO:
1770 local: id_titulo
1771 foreign: id_titulo
1772 type: one
1773 CA_ANUAL_ETAPA:
1774 local: id_titulo_etapa
1775 foreign: id_titulo_etapa
1776 type: many
1777CA_TITULO_ETAPA_MV:
1778 connection: doctrine
1779 tableName: CA_TITULO_ETAPA_MV
1780 columns:
1781 id:
1782 type: integer(8)
1783 autoincrement: true
1784 primary: true
1785 id_titulo_etapa:
1786 notnull: true
1787 type: integer(8)
1788 fixed: false
1789 unsigned: false
1790 primary: false
1791 id_titulo:
1792 notnull: true
1793 type: integer(8)
1794 fixed: false
1795 unsigned: false
1796 primary: false
1797 id_etapa:
1798 notnull: true
1799 type: integer(8)
1800 fixed: false
1801 unsigned: false
1802 primary: false
1803 id_novedad:
1804 notnull: false
1805 type: integer(8)
1806 fixed: false
1807 unsigned: false
1808 primary: false
1809 fecha_inicio:
1810 notnull: false
1811 type: timestamp(7)
1812 fixed: false
1813 unsigned: false
1814 primary: false
1815 fecha_fin:
1816 notnull: false
1817 type: timestamp(7)
1818 fixed: false
1819 unsigned: false
1820 primary: false
1821 fecha_inscripcion:
1822 notnull: false
1823 type: timestamp(7)
1824 fixed: false
1825 unsigned: false
1826 primary: false
1827 anualidades:
1828 notnull: false
1829 type: integer(8)
1830 fixed: false
1831 unsigned: false
1832 primary: false
1833 estado:
1834 notnull: true
1835 type: integer(1)
1836 fixed: false
1837 unsigned: false
1838 primary: false
1839 actual:
1840 notnull: true
1841 type: integer(1)
1842 fixed: false
1843 unsigned: false
1844 primary: false
1845 nombre:
1846 notnull: true
1847 type: string(128)
1848 fixed: false
1849 unsigned: false
1850 primary: false
1851 descripcion:
1852 notnull: false
1853 type: string(256)
1854 fixed: false
1855 unsigned: false
1856 primary: false
1857CA_TITULO_NORMA:
1858 connection: doctrine
1859 tableName: CA_TITULO_NORMA
1860 columns:
1861 id_titulo_norma:
1862 type: integer(8)
1863 fixed: false
1864 unsigned: false
1865 primary: true
1866 id_titulo:
1867 notnull: true
1868 type: integer(8)
1869 fixed: false
1870 unsigned: false
1871 primary: false
1872 id_norma:
1873 notnull: true
1874 type: integer(8)
1875 fixed: false
1876 unsigned: false
1877 primary: false
1878 fecha_inscripcion:
1879 notnull: false
1880 type: timestamp(7)
1881 fixed: false
1882 unsigned: false
1883 primary: false
1884 id_novedad:
1885 notnull: false
1886 type: integer(8)
1887 fixed: false
1888 unsigned: false
1889 primary: false
1890 actual:
1891 notnull: true
1892 type: integer(1)
1893 fixed: false
1894 unsigned: false
1895 default: "0\n "
1896 primary: false
1897 relations:
1898 CA_NORMA_CANON:
1899 local: id_norma
1900 foreign: id_norma
1901 type: one
1902 CA_NOVEDAD:
1903 local: id_novedad
1904 foreign: id_novedad
1905 type: one
1906 RMN_TITULO:
1907 local: id_titulo
1908 foreign: id_titulo
1909 type: one
1910CA_TITULO_NORMA_MV:
1911 connection: doctrine
1912 tableName: CA_TITULO_NORMA_MV
1913 columns:
1914 id:
1915 type: integer(8)
1916 autoincrement: true
1917 primary: true
1918 id_titulo_norma:
1919 notnull: true
1920 type: integer(8)
1921 fixed: false
1922 unsigned: false
1923 primary: false
1924 id_titulo:
1925 notnull: true
1926 type: integer(8)
1927 fixed: false
1928 unsigned: false
1929 primary: false
1930 id_norma:
1931 notnull: true
1932 type: integer(8)
1933 fixed: false
1934 unsigned: false
1935 primary: false
1936 fecha_inscripcion:
1937 notnull: false
1938 type: timestamp(7)
1939 fixed: false
1940 unsigned: false
1941 primary: false
1942 id_novedad:
1943 notnull: false
1944 type: integer(8)
1945 fixed: false
1946 unsigned: false
1947 primary: false
1948 actual:
1949 notnull: true
1950 type: integer(1)
1951 fixed: false
1952 unsigned: false
1953 primary: false
1954 descripcion:
1955 notnull: true
1956 type: string(256)
1957 fixed: false
1958 unsigned: false
1959 primary: false
1960 fecha_vigencia:
1961 notnull: true
1962 type: timestamp(7)
1963 fixed: false
1964 unsigned: false
1965 primary: false
1966 estado:
1967 notnull: true
1968 type: integer(1)
1969 fixed: false
1970 unsigned: false
1971 primary: false
1972CA_USUARIO:
1973 connection: doctrine
1974 tableName: CA_USUARIO
1975 columns:
1976 id_usuario:
1977 type: integer(8)
1978 fixed: false
1979 unsigned: false
1980 primary: true
1981 username:
1982 notnull: true
1983 type: string(64)
1984 fixed: false
1985 unsigned: false
1986 primary: false
1987 password:
1988 notnull: true
1989 type: string(128)
1990 fixed: false
1991 unsigned: false
1992 primary: false
1993 estado:
1994 notnull: true
1995 type: integer(1)
1996 fixed: false
1997 unsigned: false
1998 primary: false
1999 relations:
2000 CA_USUARIO_COMPETENCIA:
2001 local: id_usuario
2002 foreign: id_usuario
2003 type: many
2004 CA_USUARIO_PERFIL:
2005 local: id_usuario
2006 foreign: id_usuario
2007 type: many
2008 CA_RECIBO:
2009 local: id_usuario
2010 foreign: id_usuario_anula
2011 type: many
2012 CA_PREG_SEGURIDAD:
2013 local: id_usuario
2014 foreign: id_usuario
2015 type: many
2016 CA_LOG:
2017 local: id_usuario
2018 foreign: id_usuario
2019 type: many
2020 CA_LIQ_CANON:
2021 local: id_usuario
2022 foreign: id_usuario_cierre
2023 type: many
2024 CA_LIQ_CANON_3:
2025 class: CA_LIQ_CANON
2026 local: id_usuario
2027 foreign: id_usuario_anula
2028 type: many
2029 CA_DET_LIQ_CANON:
2030 local: id_usuario
2031 foreign: id_usuario_aprueba
2032 type: many
2033 CA_DET_LIQ_CANON_9:
2034 class: CA_DET_LIQ_CANON
2035 local: id_usuario
2036 foreign: id_usuario_anula
2037 type: many
2038CA_USUARIO_COMPETENCIA:
2039 connection: doctrine
2040 tableName: CA_USUARIO_COMPETENCIA
2041 columns:
2042 id_usuario:
2043 type: integer(8)
2044 fixed: false
2045 unsigned: false
2046 primary: true
2047 id_competencia:
2048 type: integer(8)
2049 fixed: false
2050 unsigned: false
2051 primary: true
2052 relations:
2053 CA_USUARIO:
2054 local: id_usuario
2055 foreign: id_usuario
2056 type: one
2057 RMN_COMPETENCIA:
2058 local: id_competencia
2059 foreign: id_competencia
2060 type: one
2061CA_USUARIO_PERFIL:
2062 connection: doctrine
2063 tableName: CA_USUARIO_PERFIL
2064 columns:
2065 id_usuario:
2066 type: integer(8)
2067 fixed: false
2068 unsigned: false
2069 primary: true
2070 id_perfil:
2071 type: integer(8)
2072 fixed: false
2073 unsigned: false
2074 primary: true
2075 relations:
2076 CA_PERFIL:
2077 local: id_perfil
2078 foreign: id_perfil
2079 type: one
2080 CA_USUARIO:
2081 local: id_usuario
2082 foreign: id_usuario
2083 type: one
2084CA_VARIABLE:
2085 connection: doctrine
2086 tableName: CA_VARIABLE
2087 columns:
2088 id_variable:
2089 type: integer(8)
2090 fixed: false
2091 unsigned: false
2092 primary: true
2093 nombre:
2094 notnull: false
2095 type: string(101)
2096 fixed: false
2097 unsigned: false
2098 primary: false
2099 tabla:
2100 notnull: false
2101 type: string(150)
2102 fixed: false
2103 unsigned: false
2104 primary: false
2105CRON_MANAGER:
2106 connection: doctrine
2107 tableName: CRON_MANAGER
2108 columns:
2109 id_cron_manager:
2110 type: integer(8)
2111 fixed: false
2112 unsigned: false
2113 primary: true
2114 nombre:
2115 notnull: true
2116 type: string(256)
2117 fixed: false
2118 unsigned: false
2119 default: '''-'' '
2120 primary: false
2121 script_path:
2122 notnull: true
2123 type: string(256)
2124 fixed: false
2125 unsigned: false
2126 primary: false
2127 minutes:
2128 notnull: true
2129 type: string(3)
2130 fixed: false
2131 unsigned: false
2132 default: '''*'' '
2133 primary: false
2134 hours:
2135 notnull: true
2136 type: string(3)
2137 fixed: false
2138 unsigned: false
2139 default: '''*'' '
2140 primary: false
2141 days:
2142 notnull: true
2143 type: string(3)
2144 fixed: false
2145 unsigned: false
2146 default: '''*'' '
2147 primary: false
2148 months:
2149 notnull: true
2150 type: string(3)
2151 fixed: false
2152 unsigned: false
2153 default: '''*'' '
2154 primary: false
2155 day_of_week:
2156 notnull: true
2157 type: string(3)
2158 fixed: false
2159 unsigned: false
2160 default: '''*'' '
2161 primary: false
2162 log_path:
2163 notnull: true
2164 type: string(256)
2165 fixed: false
2166 unsigned: false
2167 default: '''-'' '
2168 primary: false
2169IN_TITULO_AREA:
2170 connection: doctrine
2171 tableName: IN_TITULO_AREA
2172 columns:
2173 id_area_titulo:
2174 type: integer(8)
2175 fixed: false
2176 unsigned: false
2177 primary: true
2178 id_titulo:
2179 notnull: true
2180 type: integer(8)
2181 fixed: false
2182 unsigned: false
2183 primary: false
2184 area:
2185 notnull: true
2186 type: decimal(18)
2187 fixed: false
2188 unsigned: false
2189 default: 'NULL'
2190 primary: false
2191 fecha_asignacion:
2192 notnull: false
2193 type: timestamp(7)
2194 fixed: false
2195 unsigned: false
2196 primary: false
2197 fecha_fin:
2198 notnull: false
2199 type: timestamp(7)
2200 fixed: false
2201 unsigned: false
2202 primary: false
2203 estado:
2204 notnull: true
2205 type: integer(1)
2206 fixed: false
2207 unsigned: false
2208 default: '0'
2209 primary: false
2210 id_novedad:
2211 notnull: false
2212 type: integer(8)
2213 fixed: false
2214 unsigned: false
2215 primary: false
2216 actual:
2217 notnull: true
2218 type: integer(1)
2219 fixed: false
2220 unsigned: false
2221 default: "0\n "
2222 primary: false
2223 relations:
2224 CA_NOVEDAD:
2225 local: id_novedad
2226 foreign: id_novedad
2227 type: one
2228 RMN_TITULO:
2229 local: id_titulo
2230 foreign: id_titulo
2231 type: one
2232IN_TITULO_COMPETENCIA:
2233 connection: doctrine
2234 tableName: IN_TITULO_COMPETENCIA
2235 columns:
2236 id_titulo:
2237 notnull: true
2238 type: integer(8)
2239 fixed: false
2240 unsigned: false
2241 primary: false
2242 id_competencia:
2243 notnull: true
2244 type: integer(8)
2245 fixed: false
2246 unsigned: false
2247 primary: false
2248 tipo:
2249 notnull: true
2250 type: integer(1)
2251 fixed: false
2252 unsigned: false
2253 default: '0'
2254 primary: false
2255 fecha_asignacion:
2256 notnull: false
2257 type: timestamp(7)
2258 fixed: false
2259 unsigned: false
2260 primary: false
2261 actual:
2262 notnull: true
2263 type: integer(1)
2264 fixed: false
2265 unsigned: false
2266 default: '0'
2267 primary: false
2268 id_titulo_competencia:
2269 type: integer(8)
2270 fixed: false
2271 unsigned: false
2272 primary: true
2273 id_novedad:
2274 notnull: false
2275 type: integer(8)
2276 fixed: false
2277 unsigned: false
2278 primary: false
2279 relations:
2280 CA_NOVEDAD:
2281 local: id_novedad
2282 foreign: id_novedad
2283 type: one
2284 RMN_TITULO:
2285 local: id_titulo
2286 foreign: id_titulo
2287 type: one
2288 RMN_COMPETENCIA:
2289 local: id_competencia
2290 foreign: id_competencia
2291 type: one
2292IN_TITULO_COMPETENCIA_MV:
2293 connection: doctrine
2294 tableName: IN_TITULO_COMPETENCIA_MV
2295 columns:
2296 id:
2297 type: integer(8)
2298 autoincrement: true
2299 primary: true
2300 id_titulo:
2301 notnull: true
2302 type: integer(8)
2303 fixed: false
2304 unsigned: false
2305 primary: false
2306 id_competencia:
2307 notnull: true
2308 type: integer(8)
2309 fixed: false
2310 unsigned: false
2311 primary: false
2312 tipo:
2313 notnull: true
2314 type: integer(1)
2315 fixed: false
2316 unsigned: false
2317 primary: false
2318 fecha_asignacion:
2319 notnull: false
2320 type: timestamp(7)
2321 fixed: false
2322 unsigned: false
2323 primary: false
2324 actual:
2325 notnull: true
2326 type: integer(1)
2327 fixed: false
2328 unsigned: false
2329 primary: false
2330 id_titulo_competencia:
2331 notnull: true
2332 type: integer(8)
2333 fixed: false
2334 unsigned: false
2335 primary: false
2336 id_novedad:
2337 notnull: false
2338 type: integer(8)
2339 fixed: false
2340 unsigned: false
2341 primary: false
2342 nombre:
2343 notnull: true
2344 type: string(128)
2345 fixed: false
2346 unsigned: false
2347 primary: false
2348 num_doc:
2349 notnull: true
2350 type: string(50)
2351 fixed: false
2352 unsigned: false
2353 primary: false
2354 id_departamento:
2355 notnull: false
2356 type: integer(8)
2357 fixed: false
2358 unsigned: false
2359 primary: false
2360 activo:
2361 notnull: true
2362 type: integer(1)
2363 fixed: false
2364 unsigned: false
2365 primary: false
2366MLOG_CA_ANUAL_ETAPA:
2367 connection: doctrine
2368 tableName: MLOG$_CA_ANUAL_ETAPA
2369 columns:
2370 id:
2371 type: integer(8)
2372 autoincrement: true
2373 primary: true
2374 id_anual_etapa:
2375 notnull: false
2376 type: integer(8)
2377 fixed: false
2378 unsigned: false
2379 primary: false
2380 m_row$$:
2381 notnull: false
2382 type: string(255)
2383 fixed: false
2384 unsigned: false
2385 primary: false
2386 sequence$$:
2387 notnull: false
2388 type: integer(8)
2389 fixed: false
2390 unsigned: false
2391 primary: false
2392 snaptime$$:
2393 notnull: false
2394 type: timestamp(7)
2395 fixed: false
2396 unsigned: false
2397 primary: false
2398 dmltype$$:
2399 notnull: false
2400 type: string(1)
2401 fixed: false
2402 unsigned: false
2403 primary: false
2404 old_new$$:
2405 notnull: false
2406 type: string(1)
2407 fixed: false
2408 unsigned: false
2409 primary: false
2410 change_vector$$:
2411 notnull: false
2412 type: blob(255)
2413 fixed: false
2414 unsigned: false
2415 primary: false
2416 xid$$:
2417 notnull: false
2418 type: integer(8)
2419 fixed: false
2420 unsigned: false
2421 primary: false
2422MLOG_CA_DET_LIQ_CANON:
2423 connection: doctrine
2424 tableName: MLOG$_CA_DET_LIQ_CANON
2425 columns:
2426 id:
2427 type: integer(8)
2428 autoincrement: true
2429 primary: true
2430 id_det_liq_canon:
2431 notnull: false
2432 type: integer(8)
2433 fixed: false
2434 unsigned: false
2435 primary: false
2436 m_row$$:
2437 notnull: false
2438 type: string(255)
2439 fixed: false
2440 unsigned: false
2441 primary: false
2442 sequence$$:
2443 notnull: false
2444 type: integer(8)
2445 fixed: false
2446 unsigned: false
2447 primary: false
2448 snaptime$$:
2449 notnull: false
2450 type: timestamp(7)
2451 fixed: false
2452 unsigned: false
2453 primary: false
2454 dmltype$$:
2455 notnull: false
2456 type: string(1)
2457 fixed: false
2458 unsigned: false
2459 primary: false
2460 old_new$$:
2461 notnull: false
2462 type: string(1)
2463 fixed: false
2464 unsigned: false
2465 primary: false
2466 change_vector$$:
2467 notnull: false
2468 type: blob(255)
2469 fixed: false
2470 unsigned: false
2471 primary: false
2472 xid$$:
2473 notnull: false
2474 type: integer(8)
2475 fixed: false
2476 unsigned: false
2477 primary: false
2478MLOG_CA_ETAPA:
2479 connection: doctrine
2480 tableName: MLOG$_CA_ETAPA
2481 columns:
2482 id:
2483 type: integer(8)
2484 autoincrement: true
2485 primary: true
2486 id_etapa:
2487 notnull: false
2488 type: integer(8)
2489 fixed: false
2490 unsigned: false
2491 primary: false
2492 m_row$$:
2493 notnull: false
2494 type: string(255)
2495 fixed: false
2496 unsigned: false
2497 primary: false
2498 sequence$$:
2499 notnull: false
2500 type: integer(8)
2501 fixed: false
2502 unsigned: false
2503 primary: false
2504 snaptime$$:
2505 notnull: false
2506 type: timestamp(7)
2507 fixed: false
2508 unsigned: false
2509 primary: false
2510 dmltype$$:
2511 notnull: false
2512 type: string(1)
2513 fixed: false
2514 unsigned: false
2515 primary: false
2516 old_new$$:
2517 notnull: false
2518 type: string(1)
2519 fixed: false
2520 unsigned: false
2521 primary: false
2522 change_vector$$:
2523 notnull: false
2524 type: blob(255)
2525 fixed: false
2526 unsigned: false
2527 primary: false
2528 xid$$:
2529 notnull: false
2530 type: integer(8)
2531 fixed: false
2532 unsigned: false
2533 primary: false
2534MLOG_CA_LIQ_CANON:
2535 connection: doctrine
2536 tableName: MLOG$_CA_LIQ_CANON
2537 columns:
2538 id:
2539 type: integer(8)
2540 autoincrement: true
2541 primary: true
2542 id_liq_canon:
2543 notnull: false
2544 type: integer(8)
2545 fixed: false
2546 unsigned: false
2547 primary: false
2548 m_row$$:
2549 notnull: false
2550 type: string(255)
2551 fixed: false
2552 unsigned: false
2553 primary: false
2554 sequence$$:
2555 notnull: false
2556 type: integer(8)
2557 fixed: false
2558 unsigned: false
2559 primary: false
2560 snaptime$$:
2561 notnull: false
2562 type: timestamp(7)
2563 fixed: false
2564 unsigned: false
2565 primary: false
2566 dmltype$$:
2567 notnull: false
2568 type: string(1)
2569 fixed: false
2570 unsigned: false
2571 primary: false
2572 old_new$$:
2573 notnull: false
2574 type: string(1)
2575 fixed: false
2576 unsigned: false
2577 primary: false
2578 change_vector$$:
2579 notnull: false
2580 type: blob(255)
2581 fixed: false
2582 unsigned: false
2583 primary: false
2584 xid$$:
2585 notnull: false
2586 type: integer(8)
2587 fixed: false
2588 unsigned: false
2589 primary: false
2590MLOG_CA_LOG:
2591 connection: doctrine
2592 tableName: MLOG$_CA_LOG
2593 columns:
2594 id:
2595 type: integer(8)
2596 autoincrement: true
2597 primary: true
2598 id_log:
2599 notnull: false
2600 type: integer(8)
2601 fixed: false
2602 unsigned: false
2603 primary: false
2604 m_row$$:
2605 notnull: false
2606 type: string(255)
2607 fixed: false
2608 unsigned: false
2609 primary: false
2610 sequence$$:
2611 notnull: false
2612 type: integer(8)
2613 fixed: false
2614 unsigned: false
2615 primary: false
2616 snaptime$$:
2617 notnull: false
2618 type: timestamp(7)
2619 fixed: false
2620 unsigned: false
2621 primary: false
2622 dmltype$$:
2623 notnull: false
2624 type: string(1)
2625 fixed: false
2626 unsigned: false
2627 primary: false
2628 old_new$$:
2629 notnull: false
2630 type: string(1)
2631 fixed: false
2632 unsigned: false
2633 primary: false
2634 change_vector$$:
2635 notnull: false
2636 type: blob(255)
2637 fixed: false
2638 unsigned: false
2639 primary: false
2640 xid$$:
2641 notnull: false
2642 type: integer(8)
2643 fixed: false
2644 unsigned: false
2645 primary: false
2646MLOG_CA_NORMA_CANON:
2647 connection: doctrine
2648 tableName: MLOG$_CA_NORMA_CANON
2649 columns:
2650 id:
2651 type: integer(8)
2652 autoincrement: true
2653 primary: true
2654 id_norma:
2655 notnull: false
2656 type: integer(8)
2657 fixed: false
2658 unsigned: false
2659 primary: false
2660 m_row$$:
2661 notnull: false
2662 type: string(255)
2663 fixed: false
2664 unsigned: false
2665 primary: false
2666 sequence$$:
2667 notnull: false
2668 type: integer(8)
2669 fixed: false
2670 unsigned: false
2671 primary: false
2672 snaptime$$:
2673 notnull: false
2674 type: timestamp(7)
2675 fixed: false
2676 unsigned: false
2677 primary: false
2678 dmltype$$:
2679 notnull: false
2680 type: string(1)
2681 fixed: false
2682 unsigned: false
2683 primary: false
2684 old_new$$:
2685 notnull: false
2686 type: string(1)
2687 fixed: false
2688 unsigned: false
2689 primary: false
2690 change_vector$$:
2691 notnull: false
2692 type: blob(255)
2693 fixed: false
2694 unsigned: false
2695 primary: false
2696 xid$$:
2697 notnull: false
2698 type: integer(8)
2699 fixed: false
2700 unsigned: false
2701 primary: false
2702MLOG_CA_NOVEDAD:
2703 connection: doctrine
2704 tableName: MLOG$_CA_NOVEDAD
2705 columns:
2706 id:
2707 type: integer(8)
2708 autoincrement: true
2709 primary: true
2710 id_novedad:
2711 notnull: false
2712 type: integer(8)
2713 fixed: false
2714 unsigned: false
2715 primary: false
2716 m_row$$:
2717 notnull: false
2718 type: string(255)
2719 fixed: false
2720 unsigned: false
2721 primary: false
2722 sequence$$:
2723 notnull: false
2724 type: integer(8)
2725 fixed: false
2726 unsigned: false
2727 primary: false
2728 snaptime$$:
2729 notnull: false
2730 type: timestamp(7)
2731 fixed: false
2732 unsigned: false
2733 primary: false
2734 dmltype$$:
2735 notnull: false
2736 type: string(1)
2737 fixed: false
2738 unsigned: false
2739 primary: false
2740 old_new$$:
2741 notnull: false
2742 type: string(1)
2743 fixed: false
2744 unsigned: false
2745 primary: false
2746 change_vector$$:
2747 notnull: false
2748 type: blob(255)
2749 fixed: false
2750 unsigned: false
2751 primary: false
2752 xid$$:
2753 notnull: false
2754 type: integer(8)
2755 fixed: false
2756 unsigned: false
2757 primary: false
2758MLOG_CA_OPE_BD:
2759 connection: doctrine
2760 tableName: MLOG$_CA_OPE_BD
2761 columns:
2762 id:
2763 type: integer(8)
2764 autoincrement: true
2765 primary: true
2766 id_ope_bd:
2767 notnull: false
2768 type: integer(8)
2769 fixed: false
2770 unsigned: false
2771 primary: false
2772 m_row$$:
2773 notnull: false
2774 type: string(255)
2775 fixed: false
2776 unsigned: false
2777 primary: false
2778 sequence$$:
2779 notnull: false
2780 type: integer(8)
2781 fixed: false
2782 unsigned: false
2783 primary: false
2784 snaptime$$:
2785 notnull: false
2786 type: timestamp(7)
2787 fixed: false
2788 unsigned: false
2789 primary: false
2790 dmltype$$:
2791 notnull: false
2792 type: string(1)
2793 fixed: false
2794 unsigned: false
2795 primary: false
2796 old_new$$:
2797 notnull: false
2798 type: string(1)
2799 fixed: false
2800 unsigned: false
2801 primary: false
2802 change_vector$$:
2803 notnull: false
2804 type: blob(255)
2805 fixed: false
2806 unsigned: false
2807 primary: false
2808 xid$$:
2809 notnull: false
2810 type: integer(8)
2811 fixed: false
2812 unsigned: false
2813 primary: false
2814MLOG_CA_SMDLV:
2815 connection: doctrine
2816 tableName: MLOG$_CA_SMDLV
2817 columns:
2818 id:
2819 type: integer(8)
2820 autoincrement: true
2821 primary: true
2822 id_smdlv:
2823 notnull: false
2824 type: integer(8)
2825 fixed: false
2826 unsigned: false
2827 primary: false
2828 m_row$$:
2829 notnull: false
2830 type: string(255)
2831 fixed: false
2832 unsigned: false
2833 primary: false
2834 sequence$$:
2835 notnull: false
2836 type: integer(8)
2837 fixed: false
2838 unsigned: false
2839 primary: false
2840 snaptime$$:
2841 notnull: false
2842 type: timestamp(7)
2843 fixed: false
2844 unsigned: false
2845 primary: false
2846 dmltype$$:
2847 notnull: false
2848 type: string(1)
2849 fixed: false
2850 unsigned: false
2851 primary: false
2852 old_new$$:
2853 notnull: false
2854 type: string(1)
2855 fixed: false
2856 unsigned: false
2857 primary: false
2858 change_vector$$:
2859 notnull: false
2860 type: blob(255)
2861 fixed: false
2862 unsigned: false
2863 primary: false
2864 xid$$:
2865 notnull: false
2866 type: integer(8)
2867 fixed: false
2868 unsigned: false
2869 primary: false
2870MLOG_CA_TIPO_NOVEDAD:
2871 connection: doctrine
2872 tableName: MLOG$_CA_TIPO_NOVEDAD
2873 columns:
2874 id:
2875 type: integer(8)
2876 autoincrement: true
2877 primary: true
2878 id_tipo_novedad:
2879 notnull: false
2880 type: integer(8)
2881 fixed: false
2882 unsigned: false
2883 primary: false
2884 m_row$$:
2885 notnull: false
2886 type: string(255)
2887 fixed: false
2888 unsigned: false
2889 primary: false
2890 sequence$$:
2891 notnull: false
2892 type: integer(8)
2893 fixed: false
2894 unsigned: false
2895 primary: false
2896 snaptime$$:
2897 notnull: false
2898 type: timestamp(7)
2899 fixed: false
2900 unsigned: false
2901 primary: false
2902 dmltype$$:
2903 notnull: false
2904 type: string(1)
2905 fixed: false
2906 unsigned: false
2907 primary: false
2908 old_new$$:
2909 notnull: false
2910 type: string(1)
2911 fixed: false
2912 unsigned: false
2913 primary: false
2914 change_vector$$:
2915 notnull: false
2916 type: blob(255)
2917 fixed: false
2918 unsigned: false
2919 primary: false
2920 xid$$:
2921 notnull: false
2922 type: integer(8)
2923 fixed: false
2924 unsigned: false
2925 primary: false
2926MLOG_CA_TITULO_ETAPA:
2927 connection: doctrine
2928 tableName: MLOG$_CA_TITULO_ETAPA
2929 columns:
2930 id:
2931 type: integer(8)
2932 autoincrement: true
2933 primary: true
2934 id_titulo_etapa:
2935 notnull: false
2936 type: integer(8)
2937 fixed: false
2938 unsigned: false
2939 primary: false
2940 m_row$$:
2941 notnull: false
2942 type: string(255)
2943 fixed: false
2944 unsigned: false
2945 primary: false
2946 sequence$$:
2947 notnull: false
2948 type: integer(8)
2949 fixed: false
2950 unsigned: false
2951 primary: false
2952 snaptime$$:
2953 notnull: false
2954 type: timestamp(7)
2955 fixed: false
2956 unsigned: false
2957 primary: false
2958 dmltype$$:
2959 notnull: false
2960 type: string(1)
2961 fixed: false
2962 unsigned: false
2963 primary: false
2964 old_new$$:
2965 notnull: false
2966 type: string(1)
2967 fixed: false
2968 unsigned: false
2969 primary: false
2970 change_vector$$:
2971 notnull: false
2972 type: blob(255)
2973 fixed: false
2974 unsigned: false
2975 primary: false
2976 xid$$:
2977 notnull: false
2978 type: integer(8)
2979 fixed: false
2980 unsigned: false
2981 primary: false
2982MLOG_CA_TITULO_NORMA:
2983 connection: doctrine
2984 tableName: MLOG$_CA_TITULO_NORMA
2985 columns:
2986 id:
2987 type: integer(8)
2988 autoincrement: true
2989 primary: true
2990 id_titulo_norma:
2991 notnull: false
2992 type: integer(8)
2993 fixed: false
2994 unsigned: false
2995 primary: false
2996 m_row$$:
2997 notnull: false
2998 type: string(255)
2999 fixed: false
3000 unsigned: false
3001 primary: false
3002 sequence$$:
3003 notnull: false
3004 type: integer(8)
3005 fixed: false
3006 unsigned: false
3007 primary: false
3008 snaptime$$:
3009 notnull: false
3010 type: timestamp(7)
3011 fixed: false
3012 unsigned: false
3013 primary: false
3014 dmltype$$:
3015 notnull: false
3016 type: string(1)
3017 fixed: false
3018 unsigned: false
3019 primary: false
3020 old_new$$:
3021 notnull: false
3022 type: string(1)
3023 fixed: false
3024 unsigned: false
3025 primary: false
3026 change_vector$$:
3027 notnull: false
3028 type: blob(255)
3029 fixed: false
3030 unsigned: false
3031 primary: false
3032 xid$$:
3033 notnull: false
3034 type: integer(8)
3035 fixed: false
3036 unsigned: false
3037 primary: false
3038MLOG_CA_USUARIO:
3039 connection: doctrine
3040 tableName: MLOG$_CA_USUARIO
3041 columns:
3042 id:
3043 type: integer(8)
3044 autoincrement: true
3045 primary: true
3046 id_usuario:
3047 notnull: false
3048 type: integer(8)
3049 fixed: false
3050 unsigned: false
3051 primary: false
3052 m_row$$:
3053 notnull: false
3054 type: string(255)
3055 fixed: false
3056 unsigned: false
3057 primary: false
3058 sequence$$:
3059 notnull: false
3060 type: integer(8)
3061 fixed: false
3062 unsigned: false
3063 primary: false
3064 snaptime$$:
3065 notnull: false
3066 type: timestamp(7)
3067 fixed: false
3068 unsigned: false
3069 primary: false
3070 dmltype$$:
3071 notnull: false
3072 type: string(1)
3073 fixed: false
3074 unsigned: false
3075 primary: false
3076 old_new$$:
3077 notnull: false
3078 type: string(1)
3079 fixed: false
3080 unsigned: false
3081 primary: false
3082 change_vector$$:
3083 notnull: false
3084 type: blob(255)
3085 fixed: false
3086 unsigned: false
3087 primary: false
3088 xid$$:
3089 notnull: false
3090 type: integer(8)
3091 fixed: false
3092 unsigned: false
3093 primary: false
3094MLOG_IN_TITULO_COMPETENCI:
3095 connection: doctrine
3096 tableName: MLOG$_IN_TITULO_COMPETENCI
3097 columns:
3098 id:
3099 type: integer(8)
3100 autoincrement: true
3101 primary: true
3102 id_titulo_competencia:
3103 notnull: false
3104 type: integer(8)
3105 fixed: false
3106 unsigned: false
3107 primary: false
3108 m_row$$:
3109 notnull: false
3110 type: string(255)
3111 fixed: false
3112 unsigned: false
3113 primary: false
3114 sequence$$:
3115 notnull: false
3116 type: integer(8)
3117 fixed: false
3118 unsigned: false
3119 primary: false
3120 snaptime$$:
3121 notnull: false
3122 type: timestamp(7)
3123 fixed: false
3124 unsigned: false
3125 primary: false
3126 dmltype$$:
3127 notnull: false
3128 type: string(1)
3129 fixed: false
3130 unsigned: false
3131 primary: false
3132 old_new$$:
3133 notnull: false
3134 type: string(1)
3135 fixed: false
3136 unsigned: false
3137 primary: false
3138 change_vector$$:
3139 notnull: false
3140 type: blob(255)
3141 fixed: false
3142 unsigned: false
3143 primary: false
3144 xid$$:
3145 notnull: false
3146 type: integer(8)
3147 fixed: false
3148 unsigned: false
3149 primary: false
3150MLOG_RMN_COMPETENCIA:
3151 connection: doctrine
3152 tableName: MLOG$_RMN_COMPETENCIA
3153 columns:
3154 id:
3155 type: integer(8)
3156 autoincrement: true
3157 primary: true
3158 id_competencia:
3159 notnull: false
3160 type: integer(8)
3161 fixed: false
3162 unsigned: false
3163 primary: false
3164 m_row$$:
3165 notnull: false
3166 type: string(255)
3167 fixed: false
3168 unsigned: false
3169 primary: false
3170 sequence$$:
3171 notnull: false
3172 type: integer(8)
3173 fixed: false
3174 unsigned: false
3175 primary: false
3176 snaptime$$:
3177 notnull: false
3178 type: timestamp(7)
3179 fixed: false
3180 unsigned: false
3181 primary: false
3182 dmltype$$:
3183 notnull: false
3184 type: string(1)
3185 fixed: false
3186 unsigned: false
3187 primary: false
3188 old_new$$:
3189 notnull: false
3190 type: string(1)
3191 fixed: false
3192 unsigned: false
3193 primary: false
3194 change_vector$$:
3195 notnull: false
3196 type: blob(255)
3197 fixed: false
3198 unsigned: false
3199 primary: false
3200 xid$$:
3201 notnull: false
3202 type: integer(8)
3203 fixed: false
3204 unsigned: false
3205 primary: false
3206MLOG_RMN_MODALIDAD:
3207 connection: doctrine
3208 tableName: MLOG$_RMN_MODALIDAD
3209 columns:
3210 id:
3211 type: integer(8)
3212 autoincrement: true
3213 primary: true
3214 id_modalidad:
3215 notnull: false
3216 type: integer(8)
3217 fixed: false
3218 unsigned: false
3219 primary: false
3220 m_row$$:
3221 notnull: false
3222 type: string(255)
3223 fixed: false
3224 unsigned: false
3225 primary: false
3226 sequence$$:
3227 notnull: false
3228 type: integer(8)
3229 fixed: false
3230 unsigned: false
3231 primary: false
3232 snaptime$$:
3233 notnull: false
3234 type: timestamp(7)
3235 fixed: false
3236 unsigned: false
3237 primary: false
3238 dmltype$$:
3239 notnull: false
3240 type: string(1)
3241 fixed: false
3242 unsigned: false
3243 primary: false
3244 old_new$$:
3245 notnull: false
3246 type: string(1)
3247 fixed: false
3248 unsigned: false
3249 primary: false
3250 change_vector$$:
3251 notnull: false
3252 type: blob(255)
3253 fixed: false
3254 unsigned: false
3255 primary: false
3256 xid$$:
3257 notnull: false
3258 type: integer(8)
3259 fixed: false
3260 unsigned: false
3261 primary: false
3262MLOG_RMN_PERSONA:
3263 connection: doctrine
3264 tableName: MLOG$_RMN_PERSONA
3265 columns:
3266 id:
3267 type: integer(8)
3268 autoincrement: true
3269 primary: true
3270 id_persona:
3271 notnull: false
3272 type: integer(8)
3273 fixed: false
3274 unsigned: false
3275 primary: false
3276 m_row$$:
3277 notnull: false
3278 type: string(255)
3279 fixed: false
3280 unsigned: false
3281 primary: false
3282 sequence$$:
3283 notnull: false
3284 type: integer(8)
3285 fixed: false
3286 unsigned: false
3287 primary: false
3288 snaptime$$:
3289 notnull: false
3290 type: timestamp(7)
3291 fixed: false
3292 unsigned: false
3293 primary: false
3294 dmltype$$:
3295 notnull: false
3296 type: string(1)
3297 fixed: false
3298 unsigned: false
3299 primary: false
3300 old_new$$:
3301 notnull: false
3302 type: string(1)
3303 fixed: false
3304 unsigned: false
3305 primary: false
3306 change_vector$$:
3307 notnull: false
3308 type: blob(255)
3309 fixed: false
3310 unsigned: false
3311 primary: false
3312 xid$$:
3313 notnull: false
3314 type: integer(8)
3315 fixed: false
3316 unsigned: false
3317 primary: false
3318MLOG_RMN_TIPO_ROL_PERSONA:
3319 connection: doctrine
3320 tableName: MLOG$_RMN_TIPO_ROL_PERSONA
3321 columns:
3322 id:
3323 type: integer(8)
3324 autoincrement: true
3325 primary: true
3326 id_tipo_rol_persona:
3327 notnull: false
3328 type: integer(8)
3329 fixed: false
3330 unsigned: false
3331 primary: false
3332 m_row$$:
3333 notnull: false
3334 type: string(255)
3335 fixed: false
3336 unsigned: false
3337 primary: false
3338 sequence$$:
3339 notnull: false
3340 type: integer(8)
3341 fixed: false
3342 unsigned: false
3343 primary: false
3344 snaptime$$:
3345 notnull: false
3346 type: timestamp(7)
3347 fixed: false
3348 unsigned: false
3349 primary: false
3350 dmltype$$:
3351 notnull: false
3352 type: string(1)
3353 fixed: false
3354 unsigned: false
3355 primary: false
3356 old_new$$:
3357 notnull: false
3358 type: string(1)
3359 fixed: false
3360 unsigned: false
3361 primary: false
3362 change_vector$$:
3363 notnull: false
3364 type: blob(255)
3365 fixed: false
3366 unsigned: false
3367 primary: false
3368 xid$$:
3369 notnull: false
3370 type: integer(8)
3371 fixed: false
3372 unsigned: false
3373 primary: false
3374MLOG_RMN_TITULO:
3375 connection: doctrine
3376 tableName: MLOG$_RMN_TITULO
3377 columns:
3378 id:
3379 type: integer(8)
3380 autoincrement: true
3381 primary: true
3382 id_titulo:
3383 notnull: false
3384 type: integer(8)
3385 fixed: false
3386 unsigned: false
3387 primary: false
3388 m_row$$:
3389 notnull: false
3390 type: string(255)
3391 fixed: false
3392 unsigned: false
3393 primary: false
3394 sequence$$:
3395 notnull: false
3396 type: integer(8)
3397 fixed: false
3398 unsigned: false
3399 primary: false
3400 snaptime$$:
3401 notnull: false
3402 type: timestamp(7)
3403 fixed: false
3404 unsigned: false
3405 primary: false
3406 dmltype$$:
3407 notnull: false
3408 type: string(1)
3409 fixed: false
3410 unsigned: false
3411 primary: false
3412 old_new$$:
3413 notnull: false
3414 type: string(1)
3415 fixed: false
3416 unsigned: false
3417 primary: false
3418 change_vector$$:
3419 notnull: false
3420 type: blob(255)
3421 fixed: false
3422 unsigned: false
3423 primary: false
3424 xid$$:
3425 notnull: false
3426 type: integer(8)
3427 fixed: false
3428 unsigned: false
3429 primary: false
3430MLOG_RMN_TITULO_PERSONA:
3431 connection: doctrine
3432 tableName: MLOG$_RMN_TITULO_PERSONA
3433 columns:
3434 id:
3435 type: integer(8)
3436 autoincrement: true
3437 primary: true
3438 id_titulo_persona:
3439 notnull: false
3440 type: integer(8)
3441 fixed: false
3442 unsigned: false
3443 primary: false
3444 m_row$$:
3445 notnull: false
3446 type: string(255)
3447 fixed: false
3448 unsigned: false
3449 primary: false
3450 sequence$$:
3451 notnull: false
3452 type: integer(8)
3453 fixed: false
3454 unsigned: false
3455 primary: false
3456 snaptime$$:
3457 notnull: false
3458 type: timestamp(7)
3459 fixed: false
3460 unsigned: false
3461 primary: false
3462 dmltype$$:
3463 notnull: false
3464 type: string(1)
3465 fixed: false
3466 unsigned: false
3467 primary: false
3468 old_new$$:
3469 notnull: false
3470 type: string(1)
3471 fixed: false
3472 unsigned: false
3473 primary: false
3474 change_vector$$:
3475 notnull: false
3476 type: blob(255)
3477 fixed: false
3478 unsigned: false
3479 primary: false
3480 xid$$:
3481 notnull: false
3482 type: integer(8)
3483 fixed: false
3484 unsigned: false
3485 primary: false
3486PRUEBA_MV:
3487 connection: doctrine
3488 tableName: PRUEBA_MV
3489 columns:
3490 id:
3491 type: integer(8)
3492 autoincrement: true
3493 primary: true
3494 id_titulo_etapa:
3495 notnull: true
3496 type: integer(8)
3497 fixed: false
3498 unsigned: false
3499 primary: false
3500 id_titulo:
3501 notnull: true
3502 type: integer(8)
3503 fixed: false
3504 unsigned: false
3505 primary: false
3506 id_etapa:
3507 notnull: true
3508 type: integer(8)
3509 fixed: false
3510 unsigned: false
3511 primary: false
3512 id_novedad:
3513 notnull: false
3514 type: integer(8)
3515 fixed: false
3516 unsigned: false
3517 primary: false
3518 fecha_inicio:
3519 notnull: false
3520 type: timestamp(7)
3521 fixed: false
3522 unsigned: false
3523 primary: false
3524 fecha_fin:
3525 notnull: false
3526 type: timestamp(7)
3527 fixed: false
3528 unsigned: false
3529 primary: false
3530 fecha_inscripcion:
3531 notnull: false
3532 type: timestamp(7)
3533 fixed: false
3534 unsigned: false
3535 primary: false
3536 anualidades:
3537 notnull: false
3538 type: integer(8)
3539 fixed: false
3540 unsigned: false
3541 primary: false
3542 estado:
3543 notnull: true
3544 type: integer(1)
3545 fixed: false
3546 unsigned: false
3547 primary: false
3548 actual:
3549 notnull: true
3550 type: integer(1)
3551 fixed: false
3552 unsigned: false
3553 primary: false
3554 nombre:
3555 notnull: true
3556 type: string(128)
3557 fixed: false
3558 unsigned: false
3559 primary: false
3560 descripcion:
3561 notnull: false
3562 type: string(256)
3563 fixed: false
3564 unsigned: false
3565 primary: false
3566 cod_titulo:
3567 notnull: true
3568 type: string(128)
3569 fixed: false
3570 unsigned: false
3571 primary: false
3572 fecha_contrato:
3573 notnull: false
3574 type: timestamp(7)
3575 fixed: false
3576 unsigned: false
3577 primary: false
3578RMN_ANOTACION:
3579 connection: doctrine
3580 tableName: RMN_ANOTACION
3581 columns:
3582 id_titulo:
3583 notnull: true
3584 type: integer(8)
3585 fixed: false
3586 unsigned: false
3587 primary: false
3588 id_anotacion:
3589 type: integer(8)
3590 fixed: false
3591 unsigned: false
3592 primary: true
3593 id_tipo_anotacion:
3594 notnull: true
3595 type: integer(8)
3596 fixed: false
3597 unsigned: false
3598 primary: false
3599 fecha_inscripcion:
3600 notnull: false
3601 type: timestamp(7)
3602 fixed: false
3603 unsigned: false
3604 primary: false
3605 relations:
3606 RMN_TIPO_ANOTACION:
3607 local: id_tipo_anotacion
3608 foreign: id_tipo_anotacion
3609 type: one
3610 RMN_TITULO:
3611 local: id_titulo
3612 foreign: id_titulo
3613 type: one
3614 CA_NOVEDAD:
3615 local: id_anotacion
3616 foreign: id_anotacion
3617 type: many
3618RMN_COMPETENCIA:
3619 connection: doctrine
3620 tableName: RMN_COMPETENCIA
3621 columns:
3622 id_competencia:
3623 type: integer(8)
3624 fixed: false
3625 unsigned: false
3626 primary: true
3627 nombre:
3628 notnull: true
3629 type: string(128)
3630 fixed: false
3631 unsigned: false
3632 primary: false
3633 num_doc:
3634 notnull: true
3635 type: string(50)
3636 fixed: false
3637 unsigned: false
3638 default: '0'
3639 primary: false
3640 id_departamento:
3641 notnull: false
3642 type: integer(8)
3643 fixed: false
3644 unsigned: false
3645 primary: false
3646 activo:
3647 notnull: true
3648 type: integer(1)
3649 fixed: false
3650 unsigned: false
3651 default: "0\n "
3652 primary: false
3653 relations:
3654 RMN_DEPARTAMENTO:
3655 local: id_departamento
3656 foreign: id_departamento
3657 type: one
3658 CA_USUARIO_COMPETENCIA:
3659 local: id_competencia
3660 foreign: id_competencia
3661 type: many
3662 IN_TITULO_COMPETENCIA:
3663 local: id_competencia
3664 foreign: id_competencia
3665 type: many
3666 CA_LIQ_CANON:
3667 local: id_competencia
3668 foreign: id_competencia
3669 type: many
3670RMN_DEPARTAMENTO:
3671 connection: doctrine
3672 tableName: RMN_DEPARTAMENTO
3673 columns:
3674 id_departamento:
3675 type: integer(8)
3676 fixed: false
3677 unsigned: false
3678 primary: true
3679 nombre:
3680 notnull: true
3681 type: string(128)
3682 fixed: false
3683 unsigned: false
3684 primary: false
3685 relations:
3686 RMN_COMPETENCIA:
3687 local: id_departamento
3688 foreign: id_departamento
3689 type: many
3690RMN_MODALIDAD:
3691 connection: doctrine
3692 tableName: RMN_MODALIDAD
3693 columns:
3694 id_modalidad:
3695 type: integer(8)
3696 fixed: false
3697 unsigned: false
3698 primary: true
3699 id_ley:
3700 notnull: true
3701 type: integer(8)
3702 fixed: false
3703 unsigned: false
3704 primary: false
3705 nombre:
3706 notnull: true
3707 type: string(64)
3708 fixed: false
3709 unsigned: false
3710 primary: false
3711 estado:
3712 notnull: true
3713 type: integer(1)
3714 fixed: false
3715 unsigned: false
3716 default: '0'
3717 primary: false
3718 duracion_meses:
3719 notnull: false
3720 type: integer(8)
3721 fixed: false
3722 unsigned: false
3723 primary: false
3724 relations:
3725 CA_MODALIDAD_NORMA:
3726 local: id_modalidad
3727 foreign: id_modalidad
3728 type: many
3729 CA_ETAPA_MODALIDAD:
3730 local: id_modalidad
3731 foreign: id_modalidad
3732 type: many
3733 RMN_TITULO_MODALIDAD:
3734 local: id_modalidad
3735 foreign: id_modalidad
3736 type: many
3737RMN_PERSONA:
3738 connection: doctrine
3739 tableName: RMN_PERSONA
3740 columns:
3741 id_persona:
3742 type: integer(8)
3743 fixed: false
3744 unsigned: false
3745 primary: true
3746 nombre:
3747 notnull: false
3748 type: string(100)
3749 fixed: false
3750 unsigned: false
3751 primary: false
3752 primer_apellido:
3753 notnull: false
3754 type: string(100)
3755 fixed: false
3756 unsigned: false
3757 primary: false
3758 segundo_apellido:
3759 notnull: false
3760 type: string(100)
3761 fixed: false
3762 unsigned: false
3763 primary: false
3764 telefono:
3765 notnull: false
3766 type: string(50)
3767 fixed: false
3768 unsigned: false
3769 primary: false
3770 celular:
3771 notnull: false
3772 type: string(50)
3773 fixed: false
3774 unsigned: false
3775 primary: false
3776 correo:
3777 notnull: false
3778 type: string(100)
3779 fixed: false
3780 unsigned: false
3781 primary: false
3782 correo_alt:
3783 notnull: false
3784 type: string(100)
3785 fixed: false
3786 unsigned: false
3787 primary: false
3788 raz_soc:
3789 notnull: false
3790 type: string(300)
3791 fixed: false
3792 unsigned: false
3793 primary: false
3794 num_doc:
3795 notnull: true
3796 type: string(100)
3797 fixed: false
3798 unsigned: false
3799 default: "NULL\n "
3800 primary: false
3801 relations:
3802 RMN_TITULO_PERSONA:
3803 local: id_persona
3804 foreign: id_titular
3805 type: many
3806RMN_TIPO_ANOTACION:
3807 connection: doctrine
3808 tableName: RMN_TIPO_ANOTACION
3809 columns:
3810 id_tipo_anotacion:
3811 type: integer(8)
3812 fixed: false
3813 unsigned: false
3814 primary: true
3815 nombre:
3816 notnull: true
3817 type: string(100)
3818 fixed: false
3819 unsigned: false
3820 primary: false
3821 modifica:
3822 notnull: true
3823 type: integer(1)
3824 fixed: false
3825 unsigned: false
3826 default: "0\n "
3827 primary: false
3828 relations:
3829 RMN_ANOTACION:
3830 local: id_tipo_anotacion
3831 foreign: id_tipo_anotacion
3832 type: many
3833 CA_NOVEDAD:
3834 local: id_tipo_anotacion
3835 foreign: id_tipo_anotacion
3836 type: many
3837RMN_TIPO_ROL_PERSONA:
3838 connection: doctrine
3839 tableName: RMN_TIPO_ROL_PERSONA
3840 columns:
3841 id_tipo_rol_persona:
3842 type: integer(8)
3843 fixed: false
3844 unsigned: false
3845 primary: true
3846 nombre:
3847 notnull: true
3848 type: string(100)
3849 fixed: false
3850 unsigned: false
3851 primary: false
3852 usuario_canon:
3853 notnull: true
3854 type: integer(1)
3855 fixed: false
3856 unsigned: false
3857 default: "0\n "
3858 primary: false
3859 relations:
3860 RMN_TITULO_PERSONA:
3861 local: id_tipo_rol_persona
3862 foreign: id_rol_titulo
3863 type: many
3864RMN_TITULO:
3865 connection: doctrine
3866 tableName: RMN_TITULO
3867 columns:
3868 id_titulo:
3869 type: integer(8)
3870 fixed: false
3871 unsigned: false
3872 primary: true
3873 cod_titulo:
3874 notnull: true
3875 type: string(128)
3876 fixed: false
3877 unsigned: false
3878 primary: false
3879 fecha_contrato:
3880 notnull: false
3881 type: timestamp(7)
3882 fixed: false
3883 unsigned: false
3884 primary: false
3885 fecha_inscripcion_rmn:
3886 notnull: false
3887 type: timestamp(7)
3888 fixed: false
3889 unsigned: false
3890 primary: false
3891 placa_rmn:
3892 notnull: false
3893 type: string(100)
3894 fixed: false
3895 unsigned: false
3896 primary: false
3897 relations:
3898 RMN_ANOTACION:
3899 local: id_titulo
3900 foreign: id_titulo
3901 type: many
3902 IN_TITULO_COMPETENCIA:
3903 local: id_titulo
3904 foreign: id_titulo
3905 type: many
3906 IN_TITULO_AREA:
3907 local: id_titulo
3908 foreign: id_titulo
3909 type: many
3910 CA_TITULO_NORMA:
3911 local: id_titulo
3912 foreign: id_titulo
3913 type: many
3914 CA_TITULO_ETAPA:
3915 local: id_titulo
3916 foreign: id_titulo
3917 type: many
3918 CA_NOVEDAD:
3919 local: id_titulo
3920 foreign: id_titulo
3921 type: many
3922 CA_DET_LIQ_CANON:
3923 local: id_titulo
3924 foreign: id_titulo
3925 type: many
3926 RMN_TITULO_PERSONA:
3927 local: id_titulo
3928 foreign: id_titulo
3929 type: many
3930 RMN_TITULO_MODALIDAD:
3931 local: id_titulo
3932 foreign: id_titulo
3933 type: many
3934RMN_TITULO_MODALIDAD:
3935 connection: doctrine
3936 tableName: RMN_TITULO_MODALIDAD
3937 columns:
3938 id_titulo_modalidad:
3939 type: integer(8)
3940 fixed: false
3941 unsigned: false
3942 primary: true
3943 id_titulo:
3944 notnull: true
3945 type: integer(8)
3946 fixed: false
3947 unsigned: false
3948 primary: false
3949 id_modalidad:
3950 notnull: true
3951 type: integer(8)
3952 fixed: false
3953 unsigned: false
3954 primary: false
3955 fecha_inscripcion:
3956 notnull: false
3957 type: timestamp(7)
3958 fixed: false
3959 unsigned: false
3960 primary: false
3961 fecha_fin:
3962 notnull: false
3963 type: timestamp(7)
3964 fixed: false
3965 unsigned: false
3966 primary: false
3967 id_novedad:
3968 notnull: false
3969 type: integer(8)
3970 fixed: false
3971 unsigned: false
3972 primary: false
3973 relations:
3974 CA_NOVEDAD:
3975 local: id_novedad
3976 foreign: id_novedad
3977 type: one
3978 RMN_TITULO:
3979 local: id_titulo
3980 foreign: id_titulo
3981 type: one
3982 RMN_MODALIDAD:
3983 local: id_modalidad
3984 foreign: id_modalidad
3985 type: one
3986RMN_TITULO_MODALIDAD_MV:
3987 connection: doctrine
3988 tableName: RMN_TITULO_MODALIDAD_MV
3989 columns:
3990 id:
3991 type: integer(8)
3992 autoincrement: true
3993 primary: true
3994 id_titulo_modalidad:
3995 notnull: true
3996 type: integer(8)
3997 fixed: false
3998 unsigned: false
3999 primary: false
4000 id_titulo:
4001 notnull: true
4002 type: integer(8)
4003 fixed: false
4004 unsigned: false
4005 primary: false
4006 id_modalidad:
4007 notnull: true
4008 type: integer(8)
4009 fixed: false
4010 unsigned: false
4011 primary: false
4012 fecha_inscripcion:
4013 notnull: false
4014 type: timestamp(7)
4015 fixed: false
4016 unsigned: false
4017 primary: false
4018 fecha_fin:
4019 notnull: false
4020 type: timestamp(7)
4021 fixed: false
4022 unsigned: false
4023 primary: false
4024 id_novedad:
4025 notnull: false
4026 type: integer(8)
4027 fixed: false
4028 unsigned: false
4029 primary: false
4030 id_ley:
4031 notnull: true
4032 type: integer(8)
4033 fixed: false
4034 unsigned: false
4035 primary: false
4036 nombre:
4037 notnull: true
4038 type: string(64)
4039 fixed: false
4040 unsigned: false
4041 primary: false
4042 estado:
4043 notnull: true
4044 type: integer(1)
4045 fixed: false
4046 unsigned: false
4047 primary: false
4048 duracion_meses:
4049 notnull: false
4050 type: integer(8)
4051 fixed: false
4052 unsigned: false
4053 primary: false
4054RMN_TITULO_PERSONA:
4055 connection: doctrine
4056 tableName: RMN_TITULO_PERSONA
4057 columns:
4058 id_titulo:
4059 notnull: true
4060 type: integer(8)
4061 fixed: false
4062 unsigned: false
4063 primary: false
4064 id_titular:
4065 notnull: true
4066 type: integer(8)
4067 fixed: false
4068 unsigned: false
4069 primary: false
4070 id_rol_titulo:
4071 notnull: true
4072 type: integer(8)
4073 fixed: false
4074 unsigned: false
4075 primary: false
4076 fecha_inicial:
4077 notnull: false
4078 type: timestamp(7)
4079 fixed: false
4080 unsigned: false
4081 primary: false
4082 fecha_fin:
4083 notnull: false
4084 type: timestamp(7)
4085 fixed: false
4086 unsigned: false
4087 primary: false
4088 id_titulo_persona:
4089 type: integer(8)
4090 fixed: false
4091 unsigned: false
4092 primary: true
4093 id_novedad:
4094 notnull: false
4095 type: integer(8)
4096 fixed: false
4097 unsigned: false
4098 primary: false
4099 relations:
4100 CA_NOVEDAD:
4101 local: id_novedad
4102 foreign: id_novedad
4103 type: one
4104 RMN_PERSONA:
4105 local: id_titular
4106 foreign: id_persona
4107 type: one
4108 RMN_TIPO_ROL_PERSONA:
4109 local: id_rol_titulo
4110 foreign: id_tipo_rol_persona
4111 type: one
4112 RMN_TITULO:
4113 local: id_titulo
4114 foreign: id_titulo
4115 type: one
4116RMN_TITULO_PERSONA_MV:
4117 connection: doctrine
4118 tableName: RMN_TITULO_PERSONA_MV
4119 columns:
4120 id:
4121 type: integer(8)
4122 autoincrement: true
4123 primary: true
4124 id_titulo:
4125 notnull: true
4126 type: integer(8)
4127 fixed: false
4128 unsigned: false
4129 primary: false
4130 id_titular:
4131 notnull: true
4132 type: integer(8)
4133 fixed: false
4134 unsigned: false
4135 primary: false
4136 id_rol_titulo:
4137 notnull: true
4138 type: integer(8)
4139 fixed: false
4140 unsigned: false
4141 primary: false
4142 fecha_inicial:
4143 notnull: false
4144 type: timestamp(7)
4145 fixed: false
4146 unsigned: false
4147 primary: false
4148 fecha_fin:
4149 notnull: false
4150 type: timestamp(7)
4151 fixed: false
4152 unsigned: false
4153 primary: false
4154 id_titulo_persona:
4155 notnull: true
4156 type: integer(8)
4157 fixed: false
4158 unsigned: false
4159 primary: false
4160 id_novedad:
4161 notnull: false
4162 type: integer(8)
4163 fixed: false
4164 unsigned: false
4165 primary: false
4166 id_persona:
4167 notnull: true
4168 type: integer(8)
4169 fixed: false
4170 unsigned: false
4171 primary: false
4172 nombre:
4173 notnull: false
4174 type: string(100)
4175 fixed: false
4176 unsigned: false
4177 primary: false
4178 primer_apellido:
4179 notnull: false
4180 type: string(100)
4181 fixed: false
4182 unsigned: false
4183 primary: false
4184 segundo_apellido:
4185 notnull: false
4186 type: string(100)
4187 fixed: false
4188 unsigned: false
4189 primary: false
4190 telefono:
4191 notnull: false
4192 type: string(50)
4193 fixed: false
4194 unsigned: false
4195 primary: false
4196 celular:
4197 notnull: false
4198 type: string(50)
4199 fixed: false
4200 unsigned: false
4201 primary: false
4202 correo:
4203 notnull: false
4204 type: string(100)
4205 fixed: false
4206 unsigned: false
4207 primary: false
4208 correo_alt:
4209 notnull: false
4210 type: string(100)
4211 fixed: false
4212 unsigned: false
4213 primary: false
4214 raz_soc:
4215 notnull: false
4216 type: string(300)
4217 fixed: false
4218 unsigned: false
4219 primary: false
4220 num_doc:
4221 notnull: true
4222 type: string(100)
4223 fixed: false
4224 unsigned: false
4225 primary: false
4226 nombre_rol:
4227 notnull: true
4228 type: string(100)
4229 fixed: false
4230 unsigned: false
4231 primary: false
4232 usuario_canon:
4233 notnull: true
4234 type: integer(1)
4235 fixed: false
4236 unsigned: false
4237 primary: false