EzenMarket

Tables (12)

admin (관리자)

  • admin_Number (관리자번호) — Primary key — NOT NULL
  • admin_Id (관리자아이디)
  • admin_Pw (관리자비밀번호)

category (카테고리)

  • category_Id (카테고리번호) — Primary key — NOT NULL
  • category_Name (카테고리이름)

chattingContent (채팅내용)

  • chatting_ContentId (채팅내용번호) — Primary key — NOT NULL
  • chatting_RoomId (채팅방번호) — Foreign key → chattingRoom.chatting_RoomId — NOT NULL
  • user_Number (유저번호) — Foreign key → user.user_number — NOT NULL
  • contents (채팅내용)
  • chatting_Time (채팅시간)

chattingRoom (채팅목록)

  • chatting_RoomId (채팅방번호) — Primary key — NOT NULL
  • seller_user_number (판매자Id)
  • buyer_user_number (구매자Id)
  • post_Id (게시물번호) — Foreign key → post.post_Id — NOT NULL

endDeal (거래종료된 게시물)

  • endDeal_Id (거래종료번호) — Primary key — NOT NULL
  • seller_user_number (판매자Id)
  • buyer_user_number (구매자Id)
  • post_Id (게시물번호) — Foreign key → post.post_Id — NOT NULL
  • endDeal_Date (거래완료날짜)

post (상품)

  • post_Id (게시물번호) — Primary key — NOT NULL
  • user_number (유저번호)
  • title (제목)
  • post_content (내용)
  • category_Id (카테고리번호) — Foreign key → category.category_Id — NOT NULL
  • post_address (거래지역)
  • price (가격)
  • created (게시물업로드시간)
  • updated (끌올시간)
  • post_view (조회수)

postImage (게시물이미지)

  • post_ImageId (이미지번호) — Primary key — NOT NULL
  • post_Id (게시물번호) — Foreign key → post.post_Id — NOT NULL
  • image_URL (이미지URL)

report (신고목록)

  • report_Id (신고번호) — Primary key
  • report_Type (신고타입)
  • report_Detail (신고게시물번호)
  • user_number (유저번호) — Foreign key → user.user_number — NOT NULL
  • report_Content (신고내용)
  • report_status (처리여부)

review (거래후기)

  • review_Id (리뷰번호) — Primary key — NOT NULL
  • endDeal_Id (거래종료번호) — Foreign key → endDeal.endDeal_Id — NOT NULL
  • user_number (유저번호)
  • rating (평가)
  • review_Contents (리뷰내용(text))

user (유저)

  • user_number (유저번호) — Primary key — NOT NULL
  • user_name (유저이름)
  • user_Id (유저아이디)
  • user_pw (유저비밀번호)
  • nick_name (유저닉네임)
  • phone_number (유저핸드폰번호)
  • email (유저이메일)
  • user_address (유저 주소)
  • user_image (유저이미지)
  • user_intro (자기소개)
  • banned (정지여부)

visitor (방문기록)

  • visit_id (접속자번호(세션)) — Primary key — NOT NULL
  • visit_date (접속시간)

wishList (찜목록)

  • wishList_Id (찜번호) — Primary key
  • user_Number (유저번호) — Foreign key → user.user_number — NOT NULL
  • post_Id (게시물번호) — Foreign key → post.post_Id — NOT NULL