+Extra/MySQL+Tablas.txt

   1 Tablas Utilizadas por ECO MUPIS y su explicación.\r
   2 ---------------------------------------------------------------------------------------------------------------------------------\r
   3 \r
   4 emupi_geocode_cache\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
  12 \r
  13 emupi_mupis\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
  25 \r
  26 emupi_mupis_caras\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
  36 \r
  37 emupi_mupis_eventos\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
  45 \r
  46 emupi_registro\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
  53 \r
  54 emupi_usuarios\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
  72 \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
  80 \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