kang
Tables (10)
Alarm (Untitled9)
- 알림번호 (alarm_id) — NOT NULL — Primary key — NOT NULL
- 유저아이디 (user_id) — NOT NULL — Foreign key → User.유저아이디 — NOT NULL
- 내용 (content) — NOT NULL — NOT NULL
- 알림시간 (alarm_date) — NOU NULL — NOT NULL
Comment (Untitled7)
- 댓글번호 (comment_id) — NOT NULL — Primary key — NOT NULL
- 게시글번호 (post_id) — NOT NULL — Foreign key → Post.게시글번호 — NOT NULL
- 상위댓글번호 (parent_comment_id)
- 댓글 (content) — NOT NULL — NOT NULL
- 작성자 (writer) — NOT NULL — NOT NULL
- 댓글일자 (comment_date) — NOT NULL — NOT NULL
- 좋아요 (like_cnt) — NOT NULL — NOT NULL
- 최고에요 (love_cnt) — NOT NULL — NOT NULL
- 웃겨요 (haah_cnt) — NOT NULL — NOT NULL
- 멋져요 (wow_cnt) — NOT NULL — NOT NULL
- 슬퍼요 (sad_cnt) — NOT NULL — NOT NULL
- 화나요 (angry_cnt) — NOT NULL — NOT NULL
Comment_user_tag (Untitled6)
- 유저태그번호 (user_tag_id) — NOT NULL — Primary key — NOT NULL
- 댓글번호 (comment_id) — NOT NULL — Foreign key → Comment.댓글번호 — NOT NULL
- 유저아이디 (user_id) — NOT NULL — Foreign key → User.유저아이디 — NOT NULL
Friend (Untitled2)
- 친구아이디 (friend_id) — NOT NULL — Primary key — NOT NULL
- 유저아이디 (user_id) — NOT NULL — Foreign key → User.유저아이디 — NOT NULL
- 친구이름 (freind_name) — NOT NULL — NOT NULL
Post (Untitled3)
- 게시글번호 (post_id) — NOT NULL — Primary key — NOT NULL
- 유저아이디 (user_id) — NOT NULL — Foreign key → User.유저아이디 — NOT NULL
- 제목 (title) — NOT NULL — NOT NULL
- 내용 (content) — NO T NULL — NOT NULL
- 댓글갯수 (comment_cnt) — NOT NULL — NOT NULL
- 게시일자 (post_date) — NOT NULL — NOT NULL
- 좋아요 (like_cnt) — NOT NULL — NOT NULL
- 최고예요 (love_cnt) — NOT NULL — NOT NULL
- 웃겨요 (haha_cnt) — NOT NULL — NOT NULL
- 멋져요 (wow_cnt) — NOT NULL — NOT NULL
- 슬퍼요 (sad_cnt) — NOT NULL — NOT NULL
- 화나요 (angry_cnt) — NOT NULL — NOT NULL
Post_hash_tag (Untitled4)
- 해시태그번호 (hash_tag_id) — NOT NULL — Primary key — NOT NULL
- 게시글번호 (post_id) — NOT NULL — Foreign key → Post.게시글번호 — NOT NULL
- 이름 (name) — NOT NULL — NOT NULL
Post_user_tag (Untitled5)
- 유저태그번호 (user_tag_id) — NOT NULL — Primary key — NOT NULL
- 게시글번호 (post_id) — NOT NULL — Foreign key → Post.게시글번호 — NOT NULL
- 유저아이디 (user_id) — NOT NULL — Foreign key → User.유저아이디 — NOT NULL
Share (Untitled10)
- 공유번호 (share_id) — NOT NULL — Primary key — NOT NULL
- 친구아이디 (friend_id) — NOT NULL — Foreign key → Friend.친구아이디 — NOT NULL
- 게시글번호 (post_id) — NOT NULL — Foreign key → Post.게시글번호 — NOT NULL
Update (Untitled8)
- 수정번호 (save_id) — NOT NULL — Primary key — NOT NULL
- 게시글번호 (post_id) — NOT NULL — Foreign key → Post.게시글번호 — NOT NULL
- 수정일자 (update_date) — NOT NULL — NOT NULL
User (Untitled)
- 유저아이디 (user_id) — NOT NULL — Primary key — NOT NULL
- 이메일 (email) — NOT NULL — NOT NULL
- 비밀번호 (password) — NOT NULL — NOT NULL
- 이름 (last_name) — NOT NULL — NOT NULL
- 생일 (birth_date) — NOT NULL — NOT NULL
- 전화번호 (phone_number) — NOT NULL — NOT NULL
- 성별 (gender) — NOT NULL — NOT NULL
- 학력 (career)
- 거주지 (address)
- 출신지 (birthplace)