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