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