mm_mindmap

5 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 √ null
mm_collaboration.mindmap_id mm_collaboration_ibfk_2 C
mm_mapas_contactos.map_id FK8C9415933A308352 R
mm_mapas_instituciones.map_id FK729BCDE63A308352 R
mm_mapas_relaciones.map_id FKD2731B6C3A308352 R
mm_mindmap_history.mindmap_id mm_mindmap_history_ibfk_1 C
mm_r_label_mindmap.mindmap_id mm_r_label_mindmap_ibfk_1 R
title VARCHAR 255 null
description VARCHAR 255 null
xml MEDIUMBLOB 16777215 null
public BIT 1 0
creation_date DATETIME 19 √ null
edition_date DATETIME 19 √ null
creator_id INT 10 null
mm_user.colaborator_id mm_mindmap_ibfk_1 C
tags VARCHAR 1014 √ null
last_editor_id INT 10 null
mm_user.colaborator_id FK3F7147CA13C78625 R
palabras_clave VARCHAR 4000 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
creator_id Performance Asc creator_id
FK3F7147CA13C78625 Performance Asc last_editor_id

Relationships

Close relationships within degrees of separation