subak

Tables (7)

COMMENT (댓글)

  • cm_id (댓글아이디) — Primary key — NOT NULL
  • post_Id (게시글아이디) — Foreign key → POST.post_Id — NOT NULL
  • member_Id (회원아이디) — Foreign key → MEMBER.member_Id — NOT NULL
  • cm_content (댓글내용)
  • cm_date (댓글작성일)

GOOGLE (구글)

    HEART (좋아요)

    • like_id (좋아요아이디) — Primary key — NOT NULL
    • member_Id (회원아이디) — Foreign key → MEMBER.member_Id — NOT NULL
    • post_Id (게시글아이디) — Foreign key → POST.post_Id — NOT NULL

    KAKAO (카카오)

      MEMBER (멤버)

      • member_Id (회원아이디) — Primary key — NOT NULL
      • member_email (회원이메일)
      • member_name (이름)
      • member_pw (비밀번호)
      • member_phone (전화번호)
      • member_temp (매너온도)
      • member_picture (프로필사진)
      • authentication_type (인증타입)

      POST (게시글)

      • post_Id (게시글아이디) — Primary key — NOT NULL
      • member_Id (회원아이디) — Foreign key → MEMBER.member_Id — NOT NULL
      • category (카테고리)
      • post_title (제목)
      • price (가격)
      • like (즐겨찾기)
      • post_time (게시시간)
      • views (조회수)
      • post_image (게시글사진)
      • product_status (상품상태)
      • post_status (게시글상태)

      REVIEW (리뷰)

      • review_id (리뷰아이디) — Primary key — NOT NULL
      • member_Id (회원아이디) — Foreign key → MEMBER.member_Id — NOT NULL
      • post_Id (게시글아이디) — Foreign key → POST.post_Id — NOT NULL
      • score (리뷰점수)