2nd erd

Tables (28)

AI_RESULT

  • ai_result_id — BIGINT — Primary key — NOT NULL
  • resource_id — BIGINT — Foreign key → RESOURCE.resource_id — NOT NULL
  • summary — TEXT
  • auto_tags — TEXT
  • topic — VARCHAR(100)
  • created_at — DATETIME

CANVAS

  • canvas_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → USER.user_id — NOT NULL
  • title — VARCHAR(255)
  • description — TEXT
  • layout_json — TEXT
  • thumbnail_url — TEXT
  • created_at — DATETIME
  • updated_at — DATETIME

CANVAS_EDGE

  • edge_id — BIGINT — Primary key — NOT NULL
  • canvas_id — BIGINT — Foreign key → CANVAS.canvas_id — NOT NULL
  • source_node_id — BIGINT — Foreign key → CANVAS_NODE.node_id — NOT NULL
  • target_node_id — BIGINT — Foreign key → CANVAS_NODE.node_id — NOT NULL
  • edge_type — ENUM( 'STRAIGHT', 'CURVED', 'DASHED', 'ARROW' )
  • label — VARCHAR(255) — 연결선 레이블
  • color — VARCHAR(20) — 선 색상 (#000000 등)
  • stroke_width — INT
  • created_at — DATETIME

CANVAS_GROUP

  • group_id — BIGINT — Primary key — NOT NULL
  • canvas_id — BIGINT — Foreign key → CANVAS.canvas_id — NOT NULL
  • name — VARCHAR(255) — 그룹 이름
  • color — VARCHAR(20) — 그룹 테두리 색상
  • position_x — INT
  • position_y — INT
  • width — INT
  • height — INT
  • created_at — DATETIME

CANVAS_GROUP_NODE

  • group_id — BIGINT — Foreign key → CANVAS_GROUP.group_id — NOT NULL — 어느 그룹에 속하는지
  • node_id — BIGINT — Foreign key → CANVAS_NODE.node_id — NOT NULL — 어느 노드가 속하는지

CANVAS_NODE

  • node_id — BIGINT — Primary key — NOT NULL
  • canvas_id — BIGINT — Foreign key → CANVAS.canvas_id — NOT NULL
  • resource_id — BIGINT — Foreign key → RESOURCE.resource_id — 자료 참조 — MEMO 타입은 NULL
  • node_type — ENUM( 'RESOURCE', 'MEMO', 'IMAGE', 'PDF' ) — NOT NULL — RESOURCE=자료노드 / MEMO=포스트잇 / IMAGE=이미지 직접업로드 / PDF=PDF 직접업로드
  • title — VARCHAR(255) — 노드 제목 또는 포스트잇 내용
  • content — TEXT — 포스트잇 본문
  • color — VARCHAR(20) — 포스트잇 배경색 (#FFEB3B 등)
  • position_x — INT
  • position_y — INT
  • width — INT
  • height — INT
  • z_index — INT — 레이어 순서
  • is_locked — BOOLEAN — 잠금 여부
  • note — TEXT
  • created_at — DATETIME
  • updated_at — DATETIME

COLABO_LOG

  • log_id — BIGINT — Primary key — NOT NULL
  • space_id — BIGINT — Foreign key → COLABO_SPACE.space_id — NOT NULL
  • user_id — BIGINT — Foreign key → USER.user_id — NOT NULL
  • action — VARCHAR(255)
  • created_at — DATETIME

COLABO_SPACE

  • space_id — BIGINT — Primary key — NOT NULL
  • owner_id — BIGINT — Foreign key → USER.user_id — NOT NULL
  • name — VARCHAR(255)
  • created_at — DATETIME

EMAIL_VERIFICATION

  • email — VARCHAR(100) — Primary key — NOT NULL
  • code — VARCHAR(6)
  • expires_at — DATETIME
  • is_verified — BOOLEAN

FAQ

  • faq_id — BIGINT — Primary key — NOT NULL
  • question — TEXT
  • answer — TEXT
  • created_at — DATETIME

FOLDER

  • folder_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → USER.user_id — NOT NULL
  • parent_id — BIGINT — Foreign key → FOLDER.folder_id
  • name — VARCHAR(100)
  • is_ai_classified — BOOLEAN
  • created_at — DATETIME
  • updated_at — DATETIME

FOLDER_SUMMARY

  • id — BIGINT — Primary key — NOT NULL
  • folder_id — BIGINT — Foreign key → FOLDER.folder_id — NOT NULL
  • summary — TEXT
  • key_topics — TEXT
  • resource_count — INT
  • generated_at — DATETIME

INQUIRY

  • inquiry_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → USER.user_id — NOT NULL
  • title — VARCHAR(255)
  • content — TEXT
  • status — ENUM('WAITING','ANSWERED')
  • created_at — DATETIME

INQUIRY_ANSWER

  • answer_id — BIGINT — Primary key — NOT NULL
  • inquiry_id — BIGINT — Foreign key → INQUIRY.inquiry_id — NOT NULL
  • admin_id — BIGINT — Foreign key → USER.user_id — NOT NULL
  • content — TEXT
  • created_at — DATETIME

MINDMAP

  • mindmap_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → USER.user_id — NOT NULL
  • title — VARCHAR(255)
  • created_at — DATETIME
  • updated_at — DATETIME

MINDMAP_NODE

  • node_id — BIGINT — Primary key — NOT NULL
  • mindmap_id — BIGINT — Foreign key → MINDMAP.mindmap_id — NOT NULL
  • resource_id — BIGINT — Foreign key → RESOURCE.resource_id
  • parent_id — BIGINT — Foreign key → MINDMAP_NODE.node_id
  • title — VARCHAR(255)
  • note — TEXT
  • position_x — INT
  • position_y — INT

RESOURCE

  • resource_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → USER.user_id — NOT NULL
  • folder_id — BIGINT — Foreign key → FOLDER.folder_id
  • type — ENUM('FILE','URL')
  • title — VARCHAR(255)
  • file_url — TEXT
  • source_url — TEXT
  • created_at — DATETIME
  • updated_at — DATETIME

RESOURCE_FOLDER_MAPPING

  • resource_id — BIGINT — Foreign key → RESOURCE.resource_id — NOT NULL
  • folder_id — BIGINT — Foreign key → FOLDER.folder_id — NOT NULL

RESOURCE_RECOMMENDATION

  • id — BIGINT — Primary key — NOT NULL
  • source_resource_id — BIGINT — Foreign key → RESOURCE.resource_id
  • source_folder_id — BIGINT — Foreign key → FOLDER.folder_id
  • target_resource_id — BIGINT — Foreign key → RESOURCE.resource_id
  • recommendation_type — VARCHAR(50)
  • similarity_score — DOUBLE
  • reason — TEXT
  • created_at — DATETIME

RESOURCE_TAG

  • resource_id — BIGINT — Foreign key → RESOURCE.resource_id — NOT NULL
  • tag_id — BIGINT — Foreign key → TAG.tag_id — NOT NULL

SEARCH_HISTORY

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → USER.user_id — NOT NULL
  • keyword — VARCHAR(255)
  • filters — VARCHAR(500)
  • searched_at — DATETIME

SPACE_INVITATION

  • invite_id — BIGINT — Primary key — NOT NULL
  • space_id — BIGINT — Foreign key → COLABO_SPACE.space_id — NOT NULL
  • email — VARCHAR(100)
  • role — ENUM('VIEWER','EDITOR')
  • invite_code — VARCHAR(100)
  • expires_at — DATETIME
  • accepted — BOOLEAN

SPACE_MEMBER

  • space_id — BIGINT — Foreign key → COLABO_SPACE.space_id — NOT NULL
  • user_id — BIGINT — Foreign key → USER.user_id — NOT NULL
  • role — ENUM('OWNER','EDITOR','VIEWER')

SPACE_MINDMAP

  • space_id — BIGINT — Foreign key → COLABO_SPACE.space_id — NOT NULL
  • mindmap_id — BIGINT — Foreign key → MINDMAP.mindmap_id — NOT NULL

SPACE_RESOURCE

  • space_id — BIGINT — Foreign key → COLABO_SPACE.space_id — NOT NULL
  • resource_id — BIGINT — Foreign key → RESOURCE.resource_id — NOT NULL

TAG

  • tag_id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(50)

USER

  • user_id — BIGINT — Primary key — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • nickname — VARCHAR(50)
  • role — ENUM('USER','ADMIN') — NOT NULL
  • created_at — DATETIME
  • updated_at — DATETIME

VISUALIZATION_SETTING

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → USER.user_id — NOT NULL
  • target_type — VARCHAR(50)
  • target_id — BIGINT
  • visualization_type — VARCHAR(50)
  • layout_config — TEXT
  • created_at — DATETIME
  • updated_at — DATETIME