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