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