project "Portal de Musica"
  description = "Tablas usadas por el portal infdj.com"
  dbtype = "1"
  copyrights = "1999 - 2002 JDsoft"
  author = "José David Guillén"
  builddate = ""
  scripttype = "1"
  remarks = ""
  table "news"
    description = "Almacena las noticias posteadas"
    remarks = ""
    left = "20"
    top = "10"
    width = "97"
    height = "105"
    column "id"
      description = "id de la noticia posteada"
      coltype = "counter"
      size = "0"
      decimals = "0"
      notnull = "T"
      default = ""
      remarks = ""
    end
    column "fecha"
      description = "Fecha de la noticia"
      coltype = "date"
      size = "0"
      decimals = "0"
      notnull = "T"
      default = ""
      remarks = ""
    end
    column "uid"
      description = "usuario que postea la noticia"
      coltype = "integer"
      size = "0"
      decimals = "0"
      notnull = "F"
      default = ""
      remarks = ""
    end
    column "asunto"
      description = "cabecera para la noticia"
      coltype = "varchar"
      size = "50"
      decimals = "0"
      notnull = "F"
      default = ""
      remarks = ""
    end
    column "noticia"
      description = "cuerpo de la noticia"
      coltype = "text"
      size = "0"
      decimals = "0"
      notnull = "F"
      default = ""
      remarks = ""
    end
    index "PrimaryKey"
      description = ""
      columns = "id"
      indextype = "2"
      remarks = ""
    end
  end
  table "users"
    description = "Informacion sobre los usuarios"
    remarks = ""
    left = "157"
    top = "10"
    width = "97"
    height = "105"
    column "id"
      description = "Identificador del usuario"
      coltype = "counter"
      size = "0"
      decimals = "0"
      notnull = "T"
      default = ""
      remarks = ""
    end
    column "nick"
      description = "Nick del usuario"
      coltype = "varchar"
      size = "15"
      decimals = "0"
      notnull = "F"
      default = ""
      remarks = ""
    end
    column "level"
      description = "nivel de acceso concedido"
      coltype = "integer"
      size = "0"
      decimals = "0"
      notnull = "T"
      default = "0"
      remarks = ""
    end
    column "ultimaEntrada"
      description = "Última vez que se valido"
      coltype = "date"
      size = "0"
      decimals = "0"
      notnull = "F"
      default = ""
      remarks = ""
    end
    column "primeraEntrada"
      description = "Fecha de alta en el sistema"
      coltype = "date"
      size = "0"
      decimals = "0"
      notnull = "F"
      default = ""
      remarks = ""
    end
    column "pass"
      description = "pasword del usuario"
      coltype = "varchar"
      size = "15"
      decimals = "0"
      notnull = "F"
      default = ""
      remarks = ""
    end
    column "Nombre"
      description = "nombre real del usuario"
      coltype = "varchar"
      size = "15"
      decimals = "0"
      notnull = "F"
      default = ""
      remarks = ""
    end
    column "Apellidos"
      description = "apellidos del usuario"
      coltype = "varchar"
      size = "25"
      decimals = "0"
      notnull = "F"
      default = ""
      remarks = ""
    end
    column "fechaNacimiento"
      description = "Fecha de nacimento"
      coltype = "datetime"
      size = "0"
      decimals = "0"
      notnull = "F"
      default = ""
      remarks = ""
    end
    column "calle"
      description = "dirección del usr"
      coltype = "varchar"
      size = "30"
      decimals = "0"
      notnull = "F"
      default = ""
      remarks = ""
    end
    column "ciudad"
      description = "ciudad"
      coltype = "varchar"
      size = "15"
      decimals = "0"
      notnull = "F"
      default = ""
      remarks = ""
    end
    column "provincia"
      description = "provincia"
      coltype = "varchar"
      size = "15"
      decimals = "0"
      notnull = "F"
      default = ""
      remarks = ""
    end
    column "nacionalidad"
      description = "nacionalidad"
      coltype = "varchar"
      size = "15"
      decimals = "0"
      notnull = "F"
      default = ""
      remarks = ""
    end
    column "cp"
      description = "Código Postal"
      coltype = "integer"
      size = "0"
      decimals = "0"
      notnull = "F"
      default = ""
      remarks = ""
    end
    column "telefono"
      description = "teléfono"
      coltype = "varchar"
      size = "15"
      decimals = "0"
      notnull = "F"
      default = ""
      remarks = ""
    end
    column "mobil"
      description = "mobil"
      coltype = "varchar"
      size = "15"
      decimals = "0"
      notnull = "F"
      default = ""
      remarks = ""
    end
    column "email"
      description = "eMail externo a nuestra empresa"
      coltype = "varchar"
      size = "50"
      decimals = "0"
      notnull = "F"
      default = ""
      remarks = ""
    end
    column "usaCorreo"
      description = "Indica si usa nuestro servidor de correo"
      coltype = "bool"
      size = "0"
      decimals = "0"
      notnull = "F"
      default = "\'N\'"
      remarks = ""
    end
    column "preguntaSecreta"
      description = "Pregunta secreta (para verificar su identidad)"
      coltype = "varchar"
      size = "25"
      decimals = "0"
      notnull = "F"
      default = ""
      remarks = ""
    end
    column "respuestaPregunta"
      description = "Respuesta a la pregunta secreta"
      coltype = "varchar"
      size = "25"
      decimals = "0"
      notnull = "F"
      default = ""
      remarks = ""
    end
    index "PrimaryKey"
      description = ""
      columns = "id"
      indextype = "2"
      remarks = ""
    end
  end
  table "miniChat"
    description = "miniChat para dejar miniMensajes"
    remarks = ""
    left = "312"
    top = "8"
    width = "97"
    height = "105"
    column "id"
      description = "id del mensaje"
      coltype = "integer"
      size = "0"
      decimals = "0"
      notnull = "F"
      default = ""
      remarks = ""
    end
    column "fecha"
      description = "Fecha del mensaje"
      coltype = "date"
      size = "0"
      decimals = "0"
      notnull = "F"
      default = ""
      remarks = ""
    end
    column "hora"
      description = "Hora del mensaje"
      coltype = "time"
      size = "0"
      decimals = "0"
      notnull = "F"
      default = ""
      remarks = ""
    end
    column "uid"
      description = "Usuario que deja el mensaje"
      coltype = "integer"
      size = "0"
      decimals = "0"
      notnull = "F"
      default = "0"
      remarks = ""
    end
    column "msg"
      description = "mensaje"
      coltype = "varchar"
      size = "80"
      decimals = "0"
      notnull = "F"
      default = ""
      remarks = ""
    end
  end
  table "encuestas"
    description = ""
    remarks = ""
    left = "20"
    top = "135"
    width = "97"
    height = "105"
    column "id"
      description = "ID encuesta"
      coltype = "integer"
      size = "0"
      decimals = "0"
      notnull = "T"
      default = ""
      remarks = ""
    end
    column "fecha"
      description = "Fecha de la encuesta"
      coltype = "date"
      size = "0"
      decimals = "0"
      notnull = "F"
      default = ""
      remarks = ""
    end
    column "validaHasta"
      description = "Validez de la encuesta"
      coltype = "date"
      size = "0"
      decimals = "0"
      notnull = "F"
      default = ""
      remarks = ""
    end
    column "pregunta"
      description = "Pregunta"
      coltype = "varchar"
      size = "50"
      decimals = "0"
      notnull = "F"
      default = ""
      remarks = ""
    end
    column "resp1"
      description = "Respuesta 1"
      coltype = "varchar"
      size = "35"
      decimals = "0"
      notnull = "F"
      default = ""
      remarks = ""
    end
    column "vresp1"
      description = "Votos a  la respuesta 1"
      coltype = "smallint"
      size = "0"
      decimals = "0"
      notnull = "F"
      default = "0"
      remarks = ""
    end
    column "resp2"
      description = "Respuesta 2"
      coltype = "varchar"
      size = "35"
      decimals = "0"
      notnull = "F"
      default = ""
      remarks = ""
    end
    column "vresp2"
      description = "Votos a la respuesta 2"
      coltype = "smallint"
      size = "0"
      decimals = "0"
      notnull = "F"
      default = "0"
      remarks = ""
    end
    column "resp3"
      description = "Respuesta 3"
      coltype = "varchar"
      size = "35"
      decimals = "0"
      notnull = "F"
      default = ""
      remarks = ""
    end
    column "vresp3"
      description = "Votos a la respuesta 3"
      coltype = "smallint"
      size = "0"
      decimals = "0"
      notnull = "F"
      default = "0"
      remarks = ""
    end
    column "resp4"
      description = "Respuesta 4"
      coltype = "varchar"
      size = "35"
      decimals = "0"
      notnull = "F"
      default = ""
      remarks = ""
    end
    column "vresp4"
      description = "Votos a la respuesta 4"
      coltype = "smallint"
      size = "0"
      decimals = "0"
      notnull = "F"
      default = "0"
      remarks = ""
    end
    column "uip"
      description = "Última dirección IP que voto."
      coltype = "varchar"
      size = "15"
      decimals = "0"
      notnull = "F"
      default = ""
      remarks = ""
    end
    index "primario"
      description = ""
      columns = "id"
      indextype = "2"
      remarks = ""
    end
  end
  table "useronline"
    description = ""
    remarks = ""
    left = "311"
    top = "118"
    width = "97"
    height = "105"
    column "hora"
      description = "Hora de la última transacción"
      coltype = "integer"
      size = "0"
      decimals = "0"
      notnull = "T"
      default = ""
      remarks = ""
    end
    column "ip"
      description = "Dirección IP"
      coltype = "varchar"
      size = "15"
      decimals = "0"
      notnull = "T"
      default = ""
      remarks = ""
    end
    column "uid"
      description = "Usuario registrado?"
      coltype = "integer"
      size = "0"
      decimals = "0"
      notnull = "T"
      default = ""
      remarks = "Cuando uid < 0 ( Significa invitado )"
    end
    index "hora"
      description = ""
      columns = "hora"
      indextype = "2"
      remarks = ""
    end
    index "ip"
      description = ""
      columns = "ip"
      indextype = "0"
      remarks = ""
    end
    index "uid"
      description = ""
      columns = "uid"
      indextype = "0"
      remarks = ""
    end
  end
  table "artistas"
    description = "Datos personales de un artista concreto\r\n"
    remarks = ""
    left = "99"
    top = "296"
    width = "97"
    height = "105"
    column "id"
      description = "Id del Artista"
      coltype = "counter"
      size = "0"
      decimals = "0"
      notnull = "T"
      default = ""
      remarks = ""
    end
    column "FAlta"
      description = "FAlta"
      coltype = "datetime"
      size = "0"
      decimals = "0"
      notnull = "T"
      default = ""
      remarks = ""
    end
    column "Nombre"
      description = "Nombre del artista"
      coltype = "varchar"
      size = "15"
      decimals = "0"
      notnull = "F"
      default = ""
      remarks = ""
    end
    column "Apellido"
      description = "Apellido del artista"
      coltype = "varchar"
      size = "40"
      decimals = "0"
      notnull = "F"
      default = ""
      remarks = ""
    end
    column "Instrumento"
      description = "Instrumento o función dentro del grupo"
      coltype = "varchar"
      size = "50"
      decimals = "0"
      notnull = "F"
      default = ""
      remarks = ""
    end
    column "Foto_mime"
      description = "Tipo mime (Indica si posee foto)"
      coltype = "varchar"
      size = "50"
      decimals = "0"
      notnull = "F"
      default = ""
      remarks = "La foto se guardará mediante PHP en un directorio concreto ( ~user/DB/artistas/[ID_ARTISTA] )\r\n"
    end
    column "Foto_W"
      description = "Dimensiones de la imagen"
      coltype = "integer"
      size = "0"
      decimals = "0"
      notnull = "F"
      default = ""
      remarks = ""
    end
    column "Foto_H"
      description = "Dimensiones de la imagen"
      coltype = "integer"
      size = "0"
      decimals = "0"
      notnull = "F"
      default = ""
      remarks = ""
    end
    column "Telefono1"
      description = "Numero de Telefono"
      coltype = "varchar"
      size = "15"
      decimals = "0"
      notnull = "F"
      default = ""
      remarks = ""
    end
    column "Telefono2"
      description = "Numero del Movil"
      coltype = "varchar"
      size = "15"
      decimals = "0"
      notnull = "F"
      default = ""
      remarks = ""
    end
    column "NIF"
      description = "NIF"
      coltype = "varchar"
      size = "20"
      decimals = "0"
      notnull = "F"
      default = ""
      remarks = ""
    end
    column "Calle"
      description = "Dirección"
      coltype = "varchar"
      size = "50"
      decimals = "0"
      notnull = "F"
      default = ""
      remarks = ""
    end
    column "Localidad"
      description = "Localidad"
      coltype = "varchar"
      size = "20"
      decimals = "0"
      notnull = "F"
      default = ""
      remarks = ""
    end
    column "Provincia"
      description = "Provincia"
      coltype = "varchar"
      size = "20"
      decimals = "0"
      notnull = "F"
      default = ""
      remarks = ""
    end
    column "CP"
      description = "CP"
      coltype = "integer"
      size = "0"
      decimals = "0"
      notnull = "F"
      default = ""
      remarks = ""
    end
    column "url"
      description = "url del artista"
      coltype = "varchar"
      size = "50"
      decimals = "0"
      notnull = "F"
      default = ""
      remarks = ""
    end
    column "e_Mail"
      description = "Correo-e del artista"
      coltype = "varchar"
      size = "30"
      decimals = "0"
      notnull = "F"
      default = ""
      remarks = ""
    end
    column "FechaNacimiento"
      description = "FechaNacimiento"
      coltype = "date"
      size = "0"
      decimals = "0"
      notnull = "F"
      default = ""
      remarks = ""
    end
    column "comentario"
      description = "Comentario o curriculum del artista"
      coltype = "text"
      size = "0"
      decimals = "0"
      notnull = "F"
      default = ""
      remarks = ""
    end
    index "id"
      description = ""
      columns = "id"
      indextype = "2"
      remarks = ""
    end
    index "FAlta"
      description = ""
      columns = "FAlta"
      indextype = "0"
      remarks = ""
    end
  end
  table "grupos"
    description = "Contiene información de los grupos..."
    remarks = "Cada grupo tiene tambien asociada una lista de personas (componentes), esta asociación se puede ver en la tabla \'componentesGrupo\'\r\n"
    left = "483"
    top = "283"
    width = "97"
    height = "191"
    column "id"
      description = "ID del Grupo"
      coltype = "counter"
      size = "0"
      decimals = "0"
      notnull = "T"
      default = ""
      remarks = ""
    end
    column "ide"
      description = "id - Estilo general del grupo"
      coltype = "integer"
      size = "0"
      decimals = "0"
      notnull = "F"
      default = ""
      remarks = ""
    end
    column "FAlta"
      description = "Fecha de Alta del Grupo"
      coltype = "date"
      size = "0"
      decimals = "0"
      notnull = "F"
      default = ""
      remarks = ""
    end
    column "nombre"
      description = "Nombre del grupo"
      coltype = "varchar"
      size = "50"
      decimals = "0"
      notnull = "F"
      default = ""
      remarks = ""
    end
    column "comentario"
      description = "Comentario del Grupo"
      coltype = "text"
      size = "0"
      decimals = "0"
      notnull = "F"
      default = ""
      remarks = ""
    end
    column "cache"
      description = "Cache del grupo (cuanto cobran por actuacion y cosas asi)"
      coltype = "varchar"
      size = "50"
      decimals = "0"
      notnull = "F"
      default = ""
      remarks = ""
    end
    column "equipoSonidoLuces"
      description = "Indicación si disponen de equipo se sonido y luces"
      coltype = "varchar"
      size = "50"
      decimals = "0"
      notnull = "F"
      default = ""
      remarks = ""
    end
    column "estadisticas"
      description = "NPI"
      coltype = "tinytext"
      size = "0"
      decimals = "0"
      notnull = "F"
      default = ""
      remarks = ""
    end
    column "croquiMusicos"
      description = "Croquis de situacion del grupo dentro del escenario (baterias, altavoces, cantantes)"
      coltype = "varchar"
      size = "100"
      decimals = "0"
      notnull = "F"
      default = ""
      remarks = ""
    end
    column "sugerenciasGrupo"
      description = "Sugerencias del grupo"
      coltype = "varchar"
      size = "50"
      decimals = "0"
      notnull = "F"
      default = ""
      remarks = ""
    end
    column "contratacion"
      description = "Datos para su contratación"
      coltype = "tinytext"
      size = "0"
      decimals = "0"
      notnull = "F"
      default = ""
      remarks = ""
    end
    column "Foto"
      description = "Nombre original del archivo que contenia la fotografia..."
      coltype = "varchar"
      size = "50"
      decimals = "0"
      notnull = "F"
      default = ""
      remarks = ""
    end
    column "Foto_w"
      description = "Width"
      coltype = "integer"
      size = "0"
      decimals = "0"
      notnull = "F"
      default = ""
      remarks = ""
    end
    column "Foto_h"
      description = "Height"
      coltype = "integer"
      size = "0"
      decimals = "0"
      notnull = "F"
      default = ""
      remarks = ""
    end
    index "PrimaryKey"
      description = ""
      columns = "id"
      indextype = "2"
      remarks = ""
    end
  end
  table "componentesGrupo"
    description = "Indica los componentes de un grupo"
    remarks = ""
    left = "311"
    top = "283"
    width = "97"
    height = "107"
    column "idg"
      description = "ID del grupo"
      coltype = "integer"
      size = "0"
      decimals = "0"
      notnull = "T"
      default = ""
      remarks = ""
    end
    column "idp"
      description = "ID del artista"
      coltype = "integer"
      size = "0"
      decimals = "0"
      notnull = "T"
      default = ""
      remarks = ""
    end
    index "idg"
      description = ""
      columns = "idg"
      indextype = "2"
      remarks = ""
    end
    index "idp"
      description = ""
      columns = "idp"
      indextype = "0"
      remarks = ""
    end
  end
  table "estilos"
    description = "Estilos musicales"
    remarks = ""
    left = "613"
    top = "137"
    width = "97"
    height = "105"
    column "id"
      description = "Id del Artista"
      coltype = "counter"
      size = "0"
      decimals = "0"
      notnull = "T"
      default = ""
      remarks = ""
    end
    column "parent"
      description = "Padre de este estilo"
      coltype = "integer"
      size = "0"
      decimals = "0"
      notnull = "T"
      default = "0"
      remarks = "Los estilos se organizan en una especie de arbol"
    end
    column "titulo"
      description = "Titulo del estilo"
      coltype = "varchar"
      size = "50"
      decimals = "0"
      notnull = "F"
      default = ""
      remarks = ""
    end
    column "descr"
      description = "Descripción del estilo"
      coltype = "tinytext"
      size = "0"
      decimals = "0"
      notnull = "F"
      default = ""
      remarks = ""
    end
    column "Foto_mime"
      description = "Tipo mime del grafico asociado"
      coltype = "varchar"
      size = "50"
      decimals = "0"
      notnull = "F"
      default = ""
      remarks = ""
    end
    column "Foto_w"
      description = "Foto_w"
      coltype = "smallint"
      size = "0"
      decimals = "0"
      notnull = "F"
      default = ""
      remarks = ""
    end
    column "Foto_h"
      description = "Foto_h"
      coltype = "smallint"
      size = "0"
      decimals = "0"
      notnull = "F"
      default = ""
      remarks = ""
    end
    index "PrimaryKey"
      description = ""
      columns = "id"
      indextype = "2"
      remarks = ""
    end
    index "parent"
      description = ""
      columns = "parent"
      indextype = "0"
      remarks = ""
    end
  end
  table "eventos"
    description = "Describe los eventos de los distintos grupos."
    remarks = "Con esta tabla de eventos, podremos construir un calendario en el cual se observen los dias que hay actuaciones.\r\nCada usuario dispone de la posibilidad (si asi lo indica el administrador), de gestionar los eventos de un (UNICO) grupo.\r\n\r\nAdicionalmente el administrador podrá fijar eventos de cualquier grupo (indicando el grupo mediante su ID)."
    left = "311"
    top = "404"
    width = "97"
    height = "136"
    column "id"
      description = "id del evento"
      coltype = "counter"
      size = "0"
      decimals = "0"
      notnull = "T"
      default = ""
      remarks = ""
    end
    column "idg"
      description = "Grupo al que pertenece este evento"
      coltype = "integer"
      size = "0"
      decimals = "0"
      notnull = "T"
      default = ""
      remarks = ""
    end
    column "FAlta"
      description = "Fecha de insercion de la noticia en el sistema"
      coltype = "date"
      size = "0"
      decimals = "0"
      notnull = "F"
      default = ""
      remarks = ""
    end
    column "FEvento"
      description = "Fecha del Evento"
      coltype = "date"
      size = "0"
      decimals = "0"
      notnull = "T"
      default = ""
      remarks = ""
    end
    column "HEvento"
      description = "Hora del Evento"
      coltype = "time"
      size = "0"
      decimals = "0"
      notnull = "F"
      default = ""
      remarks = ""
    end
    column "Lugar"
      description = "Lugar del Evento"
      coltype = "varchar"
      size = "30"
      decimals = "0"
      notnull = "F"
      default = ""
      remarks = ""
    end
    column "Titulo"
      description = "Titulo del Evento"
      coltype = "varchar"
      size = "50"
      decimals = "0"
      notnull = "F"
      default = ""
      remarks = ""
    end
    column "Notas"
      description = "Informacion ampliada sobre el evento"
      coltype = "text"
      size = "0"
      decimals = "0"
      notnull = "F"
      default = ""
      remarks = ""
    end
    index "PrimaryKey"
      description = ""
      columns = "id"
      indextype = "2"
      remarks = ""
    end
    index "EventosGrp"
      description = ""
      columns = "idg;FEvento"
      indextype = "0"
      remarks = ""
    end
  end
  link "artistas_componentesGrupo"
    description = ""
    linktype = "0"
    cascadeupdates = "F"
    cascadedeletes = "F"
    remarks = ""
    lefttable = "artistas"
    leftcolumns = "id"
    righttable = "componentesGrupo"
    rightcolumns = "idp"
  end
  link "grupo_deComponentesGrupo"
    description = ""
    linktype = "0"
    cascadeupdates = "F"
    cascadedeletes = "F"
    remarks = ""
    lefttable = "grupos"
    leftcolumns = "id"
    righttable = "componentesGrupo"
    rightcolumns = "idg"
  end
  link "news_users"
    description = ""
    linktype = "0"
    cascadeupdates = "F"
    cascadedeletes = "F"
    remarks = ""
    lefttable = "news"
    leftcolumns = "uid"
    righttable = "users"
    rightcolumns = "id"
  end
  link "users_miniChat"
    description = ""
    linktype = "0"
    cascadeupdates = "F"
    cascadedeletes = "F"
    remarks = ""
    lefttable = "users"
    leftcolumns = "id"
    righttable = "miniChat"
    rightcolumns = "uid"
  end
  link "users_useronline"
    description = ""
    linktype = "0"
    cascadeupdates = "F"
    cascadedeletes = "F"
    remarks = ""
    lefttable = "users"
    leftcolumns = "id"
    righttable = "useronline"
    rightcolumns = "uid"
  end
  link "estilos_grupo"
    description = ""
    linktype = "0"
    cascadeupdates = "F"
    cascadedeletes = "F"
    remarks = ""
    lefttable = "estilos"
    leftcolumns = "id"
    righttable = "grupos"
    rightcolumns = "ide"
  end
  link "eventos_grupo"
    description = ""
    linktype = "0"
    cascadeupdates = "F"
    cascadedeletes = "F"
    remarks = ""
    lefttable = "grupos"
    leftcolumns = "id"
    righttable = "eventos"
    rightcolumns = "idg"
  end
end
