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