boomap

Tables (5)

User (Untitled)

  • id — int — Primary key — NOT NULL
  • name — varchar(32)
  • email — varchar(64)

mindmap (meetings)

  • id — int — Primary key — NOT NULL
  • aiContent (ai) — text
  • title
  • content (c)
  • aiCount (Field)
  • connection_id

node (Untitled2)

  • id (PK) — int — Primary key — NOT NULL
  • user_id — int — Foreign key → User.id — NOT NULL
  • mindmap_id (meetings_id) — int — Foreign key → mindmap.id — NOT NULL
  • location_x — float
  • location_y — float
  • keyword — varchar(32)
  • depth — TINYINT

node_closure

  • ancestor_id — int — Foreign key → node.id — NOT NULL
  • descendant_id — int — Foreign key → node.id — NOT NULL

user_mindmap_role

  • id (PK) — int — Primary key — NOT NULL
  • user_id — int — Foreign key → User.id — NOT NULL
  • mindmap_id — int — Foreign key → mindmap.id — NOT NULL
  • role — ENUM