pj
Tables (7)
CoComment (대댓글)
- ID (login_id) — NOT NULL — Foreign key → Comment.ID — NOT NULL
- 작성날짜 (write_save) — NOT NULL
- 삭제날짜 (del_save) — NOT NULL
- 내용 (txt) — NOT NULL
- 답글쓰기 (reply_com) — NOT NULL
Comment (댓글)
- ID (post_id) — NOT NULL — Foreign key → Post.ID — NOT NULL
- ID (login_id) — NOT NULL — Foreign key → Post.ID — NOT NULL
- 번호 (num) — NOT NULL
- 글쓴이 (member_id) — NOT NULL
- 작성날짜 (write_save) — NOT NULL
- 삭제날짜 (del_save) — NOT NULL
- 내용 (txt) — NOT NULL
- 답글쓰기 (reply_com) — NOT NULL
HashTag (해시태그)
- ID (hash_id) — NOT NULL — Primary key — NOT NULL
- 이름 (nm) — NOT NULL
Heart (좋아요)
- 인조키 (ID) — NOT NULL — Primary key — NOT NULL
- ID (login_id) — NOT NULL — Foreign key → User.ID — NOT NULL
- ID (post_id) — NOT NULL — Foreign key → Comment.ID — NOT NULL
Post (게시글)
- ID (post_id) — NOT NULL — Primary key — NOT NULL
- ID (login_id) — NOT NULL — Foreign key → User.ID — NOT NULL
- 상세내용 (post_write) — NOT NULL
- 메인카테고리 (main_cag) — NOT NULL
- 서브카테고리 (sub_cag) — NOT NULL
- 등록날짜 (date_save) — NOT NULL
- 좋아요 (post_like) — NOT NULL
- 번호 (num) — NOT NULL
PostTag (게시글해시태그)
- ID (login_id2) — NOT NULL — Foreign key → Post.ID — NOT NULL
- ID (hash_id) — NOT NULL — Foreign key → HashTag.ID — NOT NULL
User (회원)
- ID (login_id) — NOT NULL — Primary key — NOT NULL
- ID (Key) — NOT NULL — Primary key — NOT NULL
- 비밀번호 (pwd) — NOT NULL
- 이름 (nm) — NOT NULL
- 전화번호 (phone) — NOT NULL
- 주소 (addr) — NOT NULL
- 생년월일 (birth) — NULL
- 이메일 (email) — NOT NULL
- 생성일시 (date_new) — NOT NULL
- 수정일시 (date_cof) — NOT NULL