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