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 = "36"
    width = "97"
    height = "179"
    column "id"
      description = "Identificador del usuario"
      coltype = "counter"
      size = "0"
      decimals = "0"
      notnull = "T"
      default = ""
      remarks = ""
    end
    column "idg"
      description = "Grupo al que pertenece"
      coltype = "integer"
      size = "0"
      decimals = "0"
      notnull = "F"
      default = ""
      remarks = "Indica el \'id\' del grupo que puede controlar, para añadir/eliminar/modificar eventos."
    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 = "317"
    top = "-3"
    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 = "119"
    width = "97"
    height = "152"
    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 = "316"
    top = "149"
    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 = "28"
    top = "308"
    width = "97"
    height = "111"
    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 = "314"
    top = "295"
    width = "97"
    height = "192"
    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 "imagen"
      description = "Nombre original del archivo que contenia la fotografia..."
      coltype = "varchar"
      size = "50"
      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 = "167"
    top = "295"
    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\r\n"
    remarks = ""
    left = "588"
    top = "307"
    width = "97"
    height = "125"
    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 ""
      description = ""
      columns = "id"
      indextype = "2"
      remarks = ""
    end
    index "parent"
      description = ""
      columns = "parent"
      indextype = "0"
      remarks = ""
    end
  end
  table "discos"
    description = "Discos de los distintos grupos\r\n"
    remarks = ""
    left = "444"
    top = "176"
    width = "97"
    height = "147"
    column "id"
      description = "id del disco"
      coltype = "counter"
      size = "0"
      decimals = "0"
      notnull = "T"
      default = ""
      remarks = ""
    end
    column "idg"
      description = "id del Grupo"
      coltype = "integer"
      size = "0"
      decimals = "0"
      notnull = "F"
      default = ""
      remarks = ""
    end
    column "ide"
      description = "id del Estilo de este disco"
      coltype = "integer"
      size = "0"
      decimals = "0"
      notnull = "F"
      default = ""
      remarks = ""
    end
    column "FAlta"
      description = "Fecha de alta de este registro"
      coltype = "date"
      size = "0"
      decimals = "0"
      notnull = "F"
      default = ""
      remarks = ""
    end
    column "FEdicion"
      description = "Fecha de Edicion del disco"
      coltype = "date"
      size = "0"
      decimals = "0"
      notnull = "F"
      default = ""
      remarks = ""
    end
    column "ids"
      description = "id Status"
      coltype = "smallint"
      size = "0"
      decimals = "0"
      notnull = "F"
      default = "3"
      remarks = "Los estados pueden ser:\r\n Maqueta sin editar  -> 0\r\n Maqueta editada   -> 1\r\n Disco no editado -> 2\r\n Disco editado  -> 3"
    end
    column "titulo"
      description = "Titulo del disco"
      coltype = "varchar"
      size = "50"
      decimals = "0"
      notnull = "F"
      default = ""
      remarks = ""
    end
    column "pv"
      description = "Precio de venta del disco"
      coltype = "numeric"
      size = "6"
      decimals = "2"
      notnull = "F"
      default = ""
      remarks = ""
    end
    column "comentario"
      description = "Notas adicionales"
      coltype = "text"
      size = "0"
      decimals = "0"
      notnull = "F"
      default = ""
      remarks = ""
    end
    index "PrimaryKey"
      description = ""
      columns = "id"
      indextype = "2"
      remarks = ""
    end
  end
  table "extrasDiscos"
    description = "Datos extras para los discos"
    remarks = ""
    left = "594"
    top = "163"
    width = "97"
    height = "122"
    column "id"
      description = "id de este extra"
      coltype = "counter"
      size = "0"
      decimals = "0"
      notnull = "T"
      default = ""
      remarks = ""
    end
    column "idd"
      description = "id del disco "
      coltype = "integer"
      size = "0"
      decimals = "0"
      notnull = "F"
      default = ""
      remarks = ""
    end
    column "tipo"
      description = "tipo del extra"
      coltype = "char"
      size = "0"
      decimals = "0"
      notnull = "F"
      default = "\'O\'"
      remarks = "Los tipos pueden ser:\r\n\r\n-> Foto  \'F\'\r\n-> Audio \'A\'\r\n-> Video \'V\'\r\n-> Texto \'T\'\r\n"
    end
    column "id_data"
      description = "id dentro del disco"
      coltype = "integer"
      size = "0"
      decimals = "0"
      notnull = "F"
      default = ""
      remarks = ""
    end
    column "file"
      description = "Nombre original del fichero"
      coltype = "varchar"
      size = "50"
      decimals = "0"
      notnull = "F"
      default = ""
      remarks = ""
    end
    column "W"
      description = "Width en caso de tipo Foto"
      coltype = "integer"
      size = "0"
      decimals = "0"
      notnull = "F"
      default = ""
      remarks = ""
    end
    column "H"
      description = "Heigth en caso de tipo Foto"
      coltype = "integer"
      size = "0"
      decimals = "0"
      notnull = "F"
      default = ""
      remarks = ""
    end
    index "PrimaryKey"
      description = ""
      columns = "id"
      indextype = "2"
      remarks = ""
    end
  end
  table "cancionesDisco"
    description = "contiene la información de cada una de las canciones de un disco determinado"
    remarks = ""
    left = "575"
    top = "4"
    width = "97"
    height = "136"
    column "id"
      description = "id de la cancion"
      coltype = "counter"
      size = "0"
      decimals = "0"
      notnull = "T"
      default = ""
      remarks = ""
    end
    column "idd"
      description = "id del disco"
      coltype = "integer"
      size = "0"
      decimals = "0"
      notnull = "F"
      default = ""
      remarks = ""
    end
    column "posicion"
      description = "posicion de la cancion dentro del disco"
      coltype = "smallint"
      size = "0"
      decimals = "0"
      notnull = "T"
      default = ""
      remarks = ""
    end
    column "duracion"
      description = "duracion de la cancion"
      coltype = "time"
      size = "0"
      decimals = "0"
      notnull = "F"
      default = ""
      remarks = "Esta duracion se expresa en formato de tiempo HH:MM:SS"
    end
    column "titulo"
      description = "titulo de la cancion"
      coltype = "varchar"
      size = "50"
      decimals = "0"
      notnull = "F"
      default = ""
      remarks = ""
    end
    column "autorLetra"
      description = "autor de la letra de la cancion"
      coltype = "varchar"
      size = "50"
      decimals = "0"
      notnull = "F"
      default = ""
      remarks = ""
    end
    column "autorMusica"
      description = "autor de la musica de la cancion"
      coltype = "varchar"
      size = "50"
      decimals = "0"
      notnull = "F"
      default = ""
      remarks = ""
    end
    column "f_partitura"
      description = "nombre del fichero que contiene la partitura"
      coltype = "varchar"
      size = "50"
      decimals = "0"
      notnull = "F"
      default = ""
      remarks = ""
    end
    column "f_audio"
      description = "nombre del fichero que contiene el audio"
      coltype = "varchar"
      size = "50"
      decimals = "0"
      notnull = "F"
      default = ""
      remarks = ""
    end
    column "f_letra"
      description = "nombre del fichero que contiene la letra"
      coltype = "varchar"
      size = "50"
      decimals = "0"
      notnull = "F"
      default = ""
      remarks = ""
    end
    column "f_midi"
      description = "nombre del fichero que contiene el midi"
      coltype = "varchar"
      size = "50"
      decimals = "0"
      notnull = "F"
      default = ""
      remarks = ""
    end
    index "PrimaryKey"
      description = ""
      columns = "id"
      indextype = "0"
      remarks = ""
    end
    index "posiciones"
      description = "canciones ordenadas de un disco"
      columns = "id;posicion"
      indextype = "0"
      remarks = ""
    end
    index "PrimaryKey"
      description = ""
      columns = "id"
      indextype = "2"
      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 = "167"
    top = "429"
    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
  table "TiposDiscos"
    description = "Define las distintas clases de discos que existen"
    remarks = ""
    left = "576"
    top = "438"
    width = "97"
    height = "105"
    column "id"
      description = "Id para este tipo de disco"
      coltype = "counter"
      size = "0"
      decimals = "0"
      notnull = "T"
      default = ""
      remarks = ""
    end
    column "pvp"
      description = "Precio venta público de este tipo"
      coltype = "numeric"
      size = "8"
      decimals = "2"
      notnull = "F"
      default = ""
      remarks = ""
    end
    column "descrCorta"
      description = "Breve descripcion del tipo"
      coltype = "varchar"
      size = "20"
      decimals = "0"
      notnull = "F"
      default = ""
      remarks = ""
    end
    column "descrLarga"
      description = "Descripcion larga del tipo"
      coltype = "text"
      size = "0"
      decimals = "0"
      notnull = "F"
      default = ""
      remarks = ""
    end
    index "PrimaryKey"
      description = ""
      columns = "id"
      indextype = "2"
      remarks = ""
    end
  end
  table "publicidad"
    description = "Gestiona el control de Banners"
    remarks = ""
    left = "431"
    top = "510"
    width = "97"
    height = "105"
    column "id"
      description = "id del banners"
      coltype = "counter"
      size = "0"
      decimals = "0"
      notnull = "T"
      default = ""
      remarks = ""
    end
    column "FAlta"
      description = "Fecha de Alta"
      coltype = "date"
      size = "0"
      decimals = "0"
      notnull = "F"
      default = ""
      remarks = ""
    end
    column "anunciante"
      description = "Nombre del Anunciante"
      coltype = "varchar"
      size = "50"
      decimals = "0"
      notnull = "F"
      default = ""
      remarks = ""
    end
    column "descr"
      description = "Descripcion del anuncio"
      coltype = "varchar"
      size = "50"
      decimals = "0"
      notnull = "F"
      default = ""
      remarks = ""
    end
    column "url"
      description = "Url del banner"
      coltype = "varchar"
      size = "90"
      decimals = "0"
      notnull = "F"
      default = ""
      remarks = ""
    end
    column "tipo"
      description = "Tipo del banner"
      coltype = "char"
      size = "0"
      decimals = "0"
      notnull = "F"
      default = "\'H\'"
      remarks = ""
    end
    column "nVistos"
      description = "número de veces que se ha mostrado el banner"
      coltype = "integer"
      size = "0"
      decimals = "0"
      notnull = "F"
      default = "0"
      remarks = ""
    end
    column "nVisitas"
      description = "número de clicks sobre este banner"
      coltype = "integer"
      size = "0"
      decimals = "0"
      notnull = "F"
      default = "0"
      remarks = ""
    end
    column "filename"
      description = "nombre del archivo conteniendo el banner"
      coltype = "varchar"
      size = "30"
      decimals = "0"
      notnull = "F"
      default = ""
      remarks = ""
    end
    index "PrimaryKey"
      description = ""
      columns = "id"
      indextype = "2"
      remarks = ""
    end
  end
  link "eventos_grupo"
    description = ""
    linktype = "0"
    cascadeupdates = "F"
    cascadedeletes = "F"
    remarks = ""
    lefttable = "grupos"
    leftcolumns = "id"
    righttable = "eventos"
    rightcolumns = "idg"
  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 "discos_grupo"
    description = ""
    linktype = "0"
    cascadeupdates = "F"
    cascadedeletes = "F"
    remarks = ""
    lefttable = "grupos"
    leftcolumns = "id"
    righttable = "discos"
    rightcolumns = "idg"
  end
  link "estilo_disco"
    description = ""
    linktype = "0"
    cascadeupdates = "F"
    cascadedeletes = "F"
    remarks = ""
    lefttable = "estilos"
    leftcolumns = "id"
    righttable = "discos"
    rightcolumns = "ide"
  end
  link "extras_de_un_disco"
    description = ""
    linktype = "0"
    cascadeupdates = "F"
    cascadedeletes = "F"
    remarks = ""
    lefttable = "extrasDiscos"
    leftcolumns = "idd"
    righttable = "discos"
    rightcolumns = "id"
  end
  link "canciones_del_disco"
    description = ""
    linktype = "0"
    cascadeupdates = "F"
    cascadedeletes = "F"
    remarks = ""
    lefttable = "discos"
    leftcolumns = "id"
    righttable = "cancionesDisco"
    rightcolumns = "idd"
  end
  link "usuario_controla_grupo"
    description = ""
    linktype = "0"
    cascadeupdates = "F"
    cascadedeletes = "F"
    remarks = ""
    lefttable = "users"
    leftcolumns = "idg"
    righttable = "grupos"
    rightcolumns = "id"
  end
  link "tipo_del_disco"
    description = ""
    linktype = "0"
    cascadeupdates = "F"
    cascadedeletes = "F"
    remarks = ""
    lefttable = "discos"
    leftcolumns = "pv"
    righttable = "TiposDiscos"
    rightcolumns = "id"
  end
end