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)