My project

Tables (6)

LIKE (Untitled3)

  • 좋아요번호 (LIKE_NO) — VARCHAR(50) — Primary key — NOT NULL
  • 회원아이디 (MEMBER_ID) — VARCHAR(50) — Foreign key → Member.회원아이디 — NOT NULL
  • 게시글번호 (REVIEW_NUMBER) — VARCHAR(50) — Foreign key → Review.게시글번호 — NOT NULL
  • 좋아요수 (LIKE_CHECK) — VARCHAR(10)
  • 싫어요 (LIKE_HATECHECK) — VARCHAR(10)

Member (Untitled)

  • 회원아이디 (MEMBER_ID) — VARCHAR(50) — Primary key — NOT NULL
  • 회원비밀번호 (MEMBER_PW) — VARCHAR(50)
  • 회원전화번호 (MEMBER_PHON) — VARCHAR(50)
  • 회원주소 (MEMBER_ADRESS) — VARCHAR(200)
  • 회원이메일 (MEMBER_EMAIL) — VARCHAR(100)
  • 회원이름 (MEMBER_NAME) — VARCHAR(50)
  • 성별 (MEMBER_GENDER) — CHAR()

Review (CopyOfUntitled)

  • 게시글번호 (REVIEW_NUMBER) — VARCHAR(50) — Primary key — NOT NULL
  • 회원아이디 (MEMBER_ID) — VARCHAR(50) — Foreign key → Member.회원아이디 — NOT NULL
  • 게시글내용 (REVIEW_CONTENTS) — TEXT
  • 작성일 (REVIEW_DATE) — TIMESTAMP() — NOT NULL
  • 게시글제목 (REVIEW_title) — VARCHAR(50)
  • 리뷰사진 (REVIEW_PHOTO) — VARCHAR(800)
  • 업체번호 (Shop_NO) — VARCHAR(50) — Foreign key → Shop.업체번호 — NOT NULL

Shop (Untitled5)

  • 업체번호 (Shop_NO) — VARCHAR(50) — Primary key — NOT NULL
  • 업체지역 (ShopAdress) — VARCHAR(200)
  • 업체번호 (ShopPhone) — VARCHAR(50
  • 업체아이디 (ShopID) — VARCHAR(50)
  • 업체비번 (ShopPW) — VARCHAR(50)
  • 업체가격 (SHOP_PRICE) — VARCHAR(50)
  • 호텔모텔여부 (SHOP_HOMOTEL) — VARCHAR(50)
  • 주차장여부 (SHOP_PARKING) — CHAR()
  • 반려견여부 (SHOP_PET) — CHAR()
  • 업체별점 (SHOP_ASTERION) — NUMBER

category (Untitled4)

  • 카테고리번호 (CATEGORY_NUMBER) — VARCHAR(50) — Primary key — NOT NULL
  • 지역 (CATEGORY_ADRESS) — VARCHAR(50)
  • 가격 (CATEGORY_PRICE) — VARCHAR(50)
  • 호텔모텔여부 (CATEGORY_HOMOTEL) — CHAR()
  • 주차장여부 (CATEGORY_PARKIN) — CHAR()
  • 반려견여부 (CATEGORY_PET) — CHAR()
  • 업체번호 (Shop_NO) — VARCHAR(50) — Foreign key → Shop.업체번호 — NOT NULL

coment (Untitled2)

  • 댓글번호 (COMENT_NUMBER) — VARCHAR(50) — Primary key — NOT NULL
  • 회원아이디 (MEMBER_ID) — VARCHAR(50) — Foreign key → Member.회원아이디 — NOT NULL
  • 게시글번호 (REVIEW_NUMBER) — VARCHAR(50) — Foreign key → Review.게시글번호 — NOT NULL
  • 댓글내용 (COMENT_CONTENTS) — TEXT
  • 댓글작성일 (COMENT_DATE) — DATE