1121 lines
24 KiB
Plaintext
1121 lines
24 KiB
Plaintext
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
|