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