1 Tablas Utilizadas por ECO MUPIS y su explicación.
\r
2 ---------------------------------------------------------------------------------------------------------------------------------
\r
5 +---------+--------------+------+-----+---------+-------+
\r
6 | Field | Type | Null | Key | Default | Extra |
\r
7 +---------+--------------+------+-----+---------+-------+
\r
8 | address | varchar(255) | NO | PRI | NULL | |
\r
9 | lon | float | YES | | NULL | |
\r
10 | lat | float | YES | | NULL | |
\r
11 +---------+--------------+------+-----+---------+-------+
\r
14 +---------------+--------------+------+-----+---------+----------------+
\r
15 | Field | Type | Null | Key | Default | Extra |
\r
16 +---------------+--------------+------+-----+---------+----------------+
\r
17 | id | int(11) | NO | PRI | NULL | auto_increment |
\r
18 | codigo_mupi | varchar(100) | NO | | NULL | |
\r
19 | direccion | varchar(255) | YES | | NULL | |
\r
20 | foto_generica | varchar(255) | YES | | NULL | |
\r
21 | lon | float | YES | | NULL | |
\r
22 | lat | float | YES | | NULL | |
\r
23 | codigo_evento | varchar(50) | YES | | NULL | |
\r
24 +---------------+--------------+------+-----+---------+----------------+
\r
27 +-----------------+--------------+------+-----+---------+----------------+
\r
28 | Field | Type | Null | Key | Default | Extra |
\r
29 +-----------------+--------------+------+-----+---------+----------------+
\r
30 | id | int(11) | NO | PRI | NULL | auto_increment |
\r
31 | codigo_mupi | varchar(100) | NO | | NULL | |
\r
32 | codigo | varchar(100) | YES | | NULL | |
\r
33 | alquilado_desde | int(11) | YES | | NULL | |
\r
34 | codigo_evento | varchar(50) | YES | | NULL | |
\r
35 +-----------------+--------------+------+-----+---------+----------------+
\r
38 +--------------------+--------------+------+-----+---------+----------------+
\r
39 | Field | Type | Null | Key | Default | Extra |
\r
40 +--------------------+--------------+------+-----+---------+----------------+
\r
41 | id | int(11) | NO | PRI | NULL | auto_increment |
\r
42 | codigo_evento | varchar(50) | YES | | NULL | |
\r
43 | descripcion_evento | varchar(500) | YES | | NULL | |
\r
44 +--------------------+--------------+------+-----+---------+----------------+
\r
47 +-------+--------------+------+-----+---------+-------+
\r
48 | Field | Type | Null | Key | Default | Extra |
\r
49 +-------+--------------+------+-----+---------+-------+
\r
50 | clave | varchar(255) | NO | PRI | NULL | |
\r
51 | valor | varchar(255) | YES | | NULL | |
\r
52 +-------+--------------+------+-----+---------+-------+
\r
55 +-----------+---------------------+------+-----+---------+-------+
\r
56 | Field | Type | Null | Key | Default | Extra |
\r
57 +-----------+---------------------+------+-----+---------+-------+
\r
58 | codigo | varchar(100) | NO | PRI | NULL | |
\r
59 | clave | varchar(32) | NO | | NULL | |
\r
60 | nombre | varchar(32) | NO | | NULL | |
\r
61 | razon | varchar(100) | NO | | NULL | |
\r
62 | email | varchar(50) | YES | | NULL | |
\r
63 | telefono1 | varchar(20) | NO | | NULL | |
\r
64 | telefono2 | varchar(20) | YES | | NULL | |
\r
65 | telefono3 | varchar(20) | YES | | NULL | |
\r
66 | logotipo | varchar(200) | YES | | NULL | |
\r
67 | notas | varchar(500) | YES | | NULL | |
\r
68 | userlevel | tinyint(1) unsigned | NO | | NULL | |
\r
69 | userid | varchar(32) | YES | | NULL | |
\r
70 | timestamp | int(11) unsigned | NO | | NULL | |
\r
71 +-----------+---------------------+------+-----+---------+-------+
\r
73 emupi_usuarios_activos
\r
74 +-----------+------------------+------+-----+---------+-------+
\r
75 | Field | Type | Null | Key | Default | Extra |
\r
76 +-----------+------------------+------+-----+---------+-------+
\r
77 | codigo | varchar(30) | NO | PRI | NULL | |
\r
78 | timestamp | int(11) unsigned | NO | | NULL | |
\r
79 +-----------+------------------+------+-----+---------+-------+
\r
81 emupi_visitantes_activos
\r
82 +-----------+------------------+------+-----+---------+-------+
\r
83 | Field | Type | Null | Key | Default | Extra |
\r
84 +-----------+------------------+------+-----+---------+-------+
\r
85 | ip | varchar(15) | NO | PRI | NULL | |
\r
86 | timestamp | int(11) unsigned | NO | | NULL | |
\r
87 +-----------+------------------+------+-----+---------+-------+
\r