ingstar

Tables (13)

comment (Untitled5)

  • 댓글일련번호 (comment_sn) — bigint — Primary key — NOT NULL
  • 개시물일련번호 (post_sn) — bigint — Foreign key → post.개시물일련번호 — NOT NULL
  • 회원일련번호 (member_sn) — bigint — Foreign key → member.회원일련번호 — NOT NULL
  • 댓글내용 (comment_msg) — varchar(300)
  • Field

comment_likes (CopyOfUntitled11)

  • 댓글일련번호 (comment_sn) — bigint — Foreign key → comment.댓글일련번호 — NOT NULL
  • 회원일련번호 (member_sn) — bigint — Foreign key → member.회원일련번호 — NOT NULL

follow (Untitled2)

  • 팔로우회원일련번호 (followed_member_sn) — bigint — Foreign key → member.회원일련번호 — NOT NULL
  • 팔로잉회원일련번호 (following_member_sn) — bigint — Foreign key → member.회원일련번호 — NOT NULL

member (Untitled)

  • 회원일련번호 (member_sn) — bigint — Primary key — NOT NULL
  • 로그인아이디 (login_id) — varchar(20)
  • 회원명 (member_name) — varchar(30)
  • 비밀번호 (member_password) — varchar(20)
  • 전화번호 (phone_no) — varchar(20)
  • 회원상태 (member_status) — varchar(20)
  • Field

message (Untitled8)

  • 메세지일련번호 (message_sn) — bigint — Primary key — NOT NULL
  • 메세지그룹일련번호 (message_group_sn) — bigint — Foreign key → message_group.메세지그룹일련번호 — NOT NULL
  • 회원일련번호 (member_sn2) — bigint — Foreign key → member.회원일련번호 — NOT NULL
  • 메세지 (msg) — varchar(1000)
  • 작성자 (member_sn) — bigint
  • Field

message_group (Untitled7)

  • 메세지그룹일련번호 (message_group_sn) — bigint — Primary key — NOT NULL
  • 참여자A (member_sn_a) — bigint
  • 참여자B (member_sn_b) — bigint
  • Field

post (Untitled3)

  • 개시물일련번호 (post_sn) — bigint — Primary key — NOT NULL
  • 회원일련번호 (member_sn) — bigint — Foreign key → member.회원일련번호 — NOT NULL
  • 내용 (content) — varchar(300)
  • Field

post_img (Untitled4)

  • 이미지일련번호 (post_img_sn) — bigint — Primary key — NOT NULL
  • 개시물일련번호 (post_sn) — bigint — Foreign key → post.개시물일련번호 — NOT NULL
  • 파일타입 (file_type) — varchar(10)
  • 파일경로 (url) — varchar(300)
  • 우선순위 (sort_order) — varchar(10)
  • Field

post_likes (Untitled11)

  • 개시물일련번호 (post_sn) — bigint — Foreign key → post.개시물일련번호 — NOT NULL
  • 회원일련번호 (member_sn2) — bigint — Foreign key → member.회원일련번호 — NOT NULL

post_tag (Untitled9)

  • 개시물태그일련번호 (post_tag_sn) — bigint — Primary key — NOT NULL
  • 태그일련번호 (tag_sn2) — bigint — Foreign key → tag.태그일련번호 — NOT NULL
  • 개시물일련번호 (post_sn) — bigint — Foreign key → post.개시물일련번호 — NOT NULL
  • Field

reply (Untitled6)

  • 답글일련번호 (reply_sn) — bigint — Primary key — NOT NULL
  • 댓글일련번호 (comment_sn) — bigint — Foreign key → comment.댓글일련번호 — NOT NULL
  • 회원일련번호 (member_sn) — bigint — Foreign key → member.회원일련번호 — NOT NULL
  • 상위답글일련번호 (parent_reply_sn) — bigint — Foreign key → reply.답글일련번호 — NOT NULL
  • 답글내용 (reply_msg) — varchar(300)
  • Field

reply_likes (CopyOfCopyOfUntitled11)

  • 답글일련번호 (reply_sn) — bigint — Foreign key → reply.답글일련번호 — NOT NULL
  • 회원일련번호 (member_sn) — bigint — Foreign key → member.회원일련번호 — NOT NULL

tag (Untitled10)

  • 태그일련번호 (tag_sn) — bigint — Primary key — NOT NULL
  • 태그명 (tag_nm) — varchar(50)
  • Field