nodexr
Tables (9)
assets (에셋)
- asset_id (Key) — UUID — Primary key — NOT NULL
- node_id (Key2) — UUID — Foreign key → nodes.node_id — NOT NULL
- img_url (Field) — String
- type (Field2) — Enum
- category_detail_id (Key3) — UUID — Foreign key → category_details.category_detail_id — NOT NULL
categories (카테고리)
- category_id (Key) — UUID — Primary key — NOT NULL
- room_id (Key3) — UUID — Foreign key → rooms.room_id — NOT NULL
- category_name (Field) — String
category_details (상세 카테고리)
- category_detail_id (Key) — UUID — Primary key — NOT NULL
- category_id (Key2) — UUID — Foreign key → categories.category_id — NOT NULL
- node_id (Key3) — UUID — Foreign key → nodes.node_id — NOT NULL
- detail_text (Field) — String
- order (Field2) — INT
edges (엣지)
- edge_id (Key) — UUID — Primary key — NOT NULL
- from_node_id (Key2) — UUID — Foreign key → nodes.node_id — NOT NULL
- to_node_id (Key3) — UUID — Foreign key → nodes.node_id — NOT NULL
graph_snapshots (그래프 스냅샷)
- graph_snapshot_id (Key) — UUID — Primary key — NOT NULL
- room_id (Key2) — UUID — Foreign key → rooms.room_id — NOT NULL
- graph_state (Field) — JSON
- created_at (Field2) — datetime
nodes (노드)
- node_id (Key) — UUID — Primary key — NOT NULL
- room_id (Key2) — UUID — Foreign key → rooms.room_id — NOT NULL
- node_type (Field) — Enum
rooms (회의실)
- room_id (Key) — UUID — Primary key — NOT NULL
- room_topic (Field) — String
- password (Field4) — String
- phase (Field2) — Enum
- created_at (Field3) — datetime
users (사용자)
- user_id (Key) — UUID — Primary key — NOT NULL
- room_id (FK) — UUID — Foreign key → rooms.room_id — NOT NULL
- nickname (Field) — String
- leader (Field2) — Boolean
utterances (발화)
- utterance_id (Key) — UUID — Primary key — NOT NULL
- user_id (FK) — UUID — Foreign key → users.user_id — NOT NULL
- text (Field) — String
- created_at (Field2) — datetime