-
Notifications
You must be signed in to change notification settings - Fork 0
1.3 Tablas
Tabla de relacion entre projectos y tags de areas de impacto (impact-tags)
- projectID
- tagID
projects.id <-> projects-impact-tags-a.projectID
impact-tags.id <-> projects-impact-tags-a.tagID
Tabla de relacion entre projectos y tags de enfoque (dsi-focus-tags)
projectID, tagID
projects.id <-> projects-impact-tags-b.projectID
dsi-focus-tags.id <-> projects-impact-tags-b.tagID
Tabla de relacion entre projectos y tags de tecnologias (impact-tags)
projectID,tagID
projects.id <-> projects-impact-tags-c.projectID
impact-tags.id <-> projects-impact-tags-c.tagID
Tabla de entidad proyectos
id, ownerID, name, shortDescription, description, url, status, startDate, endDate, countryID, countryRegionID, organisationsCount, importID, created, lastUpdate, logo, headerImage, socialImpact, isWaitingApproval, isPublished
users.id <-> projects.ownerID
countries.id <-> projects.countryID
country-regions.id <-> countryRegionID
El importID es el id de la base de datos de origen
Tabla de paises
id, name
projects.countryID <-> countries.id
organisations.countryID <-> countries.id
Tabla de regiones del pais
id, countryID, name, lat, lng
countries.id <-> country-regions.countryID
projects.countryRegionID <-> country-regions.id
organisations.countryRegionID <-> country-regions.id
Etiquetas que describen la organización
id, tag
organisation-tags.tagID <-> tags-for-organisations.id
Relacion entre organizaciones y tags de organizaciones
organisationID, tagID, organisationTagId
organisation.id <-> organisation-tags.organisationID
tags-for-organisations.id <-> organisation-tags.tagID
Etiquetas que describen los proyectos
id, tag
project-tags.tagID <-> tags-for-projects.id
Relacion entre proyectos y tags de proyectos
projectID, tagID, projectTagId
project.id <-> project-tags.projectID
tags-for-project.id <-> project-tags.tagID
Enfoque
id, tag, description
project-impact-tags-b.tagID <-> dsi-focus-tags.id
Etiquetas para redes
id, tag
project-network-tags.tagID <-> network-tags.id
organisation-network-tags.tagID <-> network-tags.id
Relacion entre organizaciones y network tags
organisationID, tagID
organisations.id <-> organisation-network-tag.organisationID
network-tags.id <-> organisation-network-tag.tagID
Relacion entre organizaciones y network tags
projectID, tagID
projects.id <-> project-network-tag.projectID
network-tags.id <-> project-network-tag.tagID
Tags
id, tag, isMain, order
projects-impact-tags-a.tagID <-> impact-tags.id
projects-impact-tags-c.tagID <-> impact-tags.id