p
Tables (15)
ActionLog (행동 기록)
- action_id — Primary key — NOT NULL
- context — NOT NULL
- user_id — Foreign key → User.user_id — NOT NULL — 사용자 고유 ID
- node_id — Foreign key → Node.node_id — NOT NULL
- created_at — NOT NULL
Comment (댓글)
- comment_id — Primary key — NOT NULL
- content — NOT NULL
- memo_id — Foreign key → Memo.memo_id — NOT NULL
- user_id — Foreign key → User.user_id — NOT NULL — 사용자 고유 ID
- created_at — NOT NULL
GroupMergeHistory (그룹 합병 기록)
- GroupMergeHistory_id — Primary key — NOT NULL
- user_id — Foreign key → User.user_id — NOT NULL — 사용자 고유 ID
- from_group_id — Foreign key → Gruop.group_id — NOT NULL
- to_group_id — Foreign key → Gruop.group_id — NOT NULL
GroupNode (그룹 노드)
- group_id — Foreign key → Gruop.group_id — NOT NULL
- node_id — Foreign key → Node.node_id — NOT NULL
Gruop (그룹)
- group_id — Primary key — NOT NULL
- user_id — Foreign key → User.user_id — NOT NULL — 사용자 고유 ID
- name — NOT NULL — 그룹명
- created_at — NOT NULL
- category — NOT NULL — 그룹 카테고리 ( 대학친구, 동네친구 )
Like (좋아요)
- like_id — Primary key — NOT NULL
- entity_id — NOT NULL
- entity_type — ENUM(MEMO, COMMENT, REPLY ) — NOT NULL
- user_id — Foreign key → User.user_id — NOT NULL — 사용자 고유 ID
- created_at — NOT NULL
Mate (친구)
- id — Primary key — NOT NULL
- status — Enum — NOT NULL — 친구 요청 상태 (pending, accepted, blocked)
- from_user_id — Foreign key → User.user_id — NOT NULL — 친구 요청 사용자
- to_user_id — Foreign key → User.user_id — NOT NULL — 친구 요청 대상 사용자
- created_at — NOT NULL
Memo (기록)
- memo_id — Primary key — NOT NULL
- content — NOT NULL
- node_id — Foreign key → Node.node_id — NOT NULL
- user_id — Foreign key → User.user_id — NOT NULL — 사용자 고유 ID
- action_id — Foreign key → ActionLog.action_id — NOT NULL
- created_at — NOT NULL
MemoTag (메모_태그)
- nodeTag_id — Primary key — NOT NULL
- tag_id — Foreign key → Tag.tag_id — NOT NULL
- memo_id — Foreign key → Memo.memo_id — NOT NULL
Node
- node_id — Primary key — NOT NULL
- user_id — Foreign key → User.user_id — NOT NULL — 사용자 고유 ID
- name — NOT NULL — 노드 이름
- created_at — NOT NULL
NodeRelationship (Edge)
- relation_id — Primary key — NOT NULL
- from_node_id — Foreign key → Node.node_id — NOT NULL
- to_node_id — Foreign key → Node.node_id — NOT NULL
- description — NOT NULL — 노드간의 구체적 관계
- created_at — NOT NULL
Reply (대댓글)
- reply_id — Primary key — NOT NULL
- content — NOT NULL
- comment_id (comment_id2) — Foreign key → Comment.comment_id — NOT NULL
- user_id — Foreign key → User.user_id — NOT NULL — 사용자 고유 ID
- created_at — NOT NULL
Tag (태그)
- tag_id — Primary key — NOT NULL
- tag — varchar(50) — NOT NULL
User (회원 정보)
- user_id — Primary key — NOT NULL — 사용자 고유 ID
- email (emai) — NOT NULL
- password — NOT NULL
- nickname — NOT NULL
- profile_img
- created_at — NOT NULL
VisitHistory (방문기록)
- visit_id — Primary key — NOT NULL
- visited_at — TimeStamp — NOT NULL
- user_id — Foreign key → User.user_id — NOT NULL — 사용자 고유 ID
- node_id — Foreign key → Node.node_id — NOT NULL