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