DB modeling

Tables (7)

Follow (회원 팔로우 상태)

  • follow_ID (팔로우 회원) — INT — Primary key — NOT NULL
  • member_ID (회원 아이디2) — INT — Foreign key → Members.member_ID — NOT NULL
  • follower_ID (팔로워) — INT
  • following_ID (팔로잉) — INT
  • follow_date (팔로우 날짜) — DATETIME

Hashtags (해시태그)

  • hashtag (해시태그) — VARCHAR — Primary key — NOT NULL
  • hashtag_text (해시태그 글) — VARCHAR

Like (좋아요)

  • post_ID (게시물) — INT — Foreign key → Post.post_ID — NOT NULL
  • member_ID (회원 아이디) — INT — Foreign key → Members.member_ID — NOT NULL

Members (회원)

  • member_ID (회원 아이디) — INT — Primary key — NOT NULL
  • follow_ID (팔로우 회원) — INT — Foreign key → Follow.follow_ID — NOT NULL
  • password (비밀번호) — VARCHAR(255)
  • member_name (회원 이름) — VARCHAR(100)
  • gender (회원 성별) — ENUM
  • birthday (회원 생일) — DATE
  • phone (연락처) — VARCHAR

Post (게시물)

  • post_ID (게시물) — INT — Primary key — NOT NULL
  • member_ID (회원 아이디) — INT — Foreign key → Members.member_ID — NOT NULL
  • post_text (게시글) — TEXT
  • like_count (게시물 좋아요 수) — INT
  • comment_text (댓글) — TEXT
  • upload_date (게시물 등록 시간) — DATETIME
  • content_file (게시물 내용) — VARCHAR

comment (댓글)

  • post_ID (게시물2) — INT — Foreign key → Post.post_ID — NOT NULL
  • member_ID (회원 아이디) — INT — Foreign key → Post.member_ID — NOT NULL
  • comment_text (댓글) — TEXT
  • comment_upload_date (댓글 등록된 시간) — DATETIME

post_hashtag (게시글헤시태그)

  • hashtag (해시태그) — VARCHAR — Foreign key → Hashtags.hashtag — NOT NULL
  • post_ID (게시물) — INT — Foreign key → Post.post_ID — NOT NULL
  • member_ID (회원 아이디) — INT — Foreign key → Post.member_ID — NOT NULL