GongBang
Tables (6)
CoffeeCafe (카페)
- id (ID) — Int — Primary key — NOT NULL
- name (카페_이름) — Char(100)
- address (카페_주소) — Char(100)
- time (카페_시간) — Char(100)
- total_score (카페_총점수) — Float()
- lat (카페_위도) — Float()
- lng (카페_경도) — Float()
- vibe (카페_분위기) — Float()
- seat (카페_자리) — Float()
- coffee (카페_음료) — Float()
- plug (카페_콘센트) — Float()
- wifi (카페_와이파이) — Float()
- toilet (카페_화장실) — Float()
- parking (카페_주차) — Float()
CoffeeCafeImage (coffeecafeimage_set)
- id (ID) — Int — Primary key — NOT NULL
- cafe (카페_ID) — Int — Foreign key → CoffeeCafe.id — NOT NULL
- image (이미지) — Image
RecoCafe (카페 추천)
- id (ID) — Int — Primary key — NOT NULL
- title (카페추천_제목) — Char(50)
- content (카페추천_내용) — TEXT(500)
- date (카페추천_날짜) — Date()
- name (카페추천_작성유저) — Char(10
- image (카페추천_이미지) — Image()
- lat (카페추천_위도) — Float()
- lng (카페추천_경도) — Float()
Review (review_set)
- id (ID) — Int — Primary key — NOT NULL
- cafe_id (카페(PK)) — Int — Foreign key → CoffeeCafe.id — NOT NULL
- user_id (유저(PK)) — Int — Foreign key → User.id — NOT NULL
- title (리뷰_제목) — Char(50)
- content (리뷰_내용) — Text(500)
- data (리뷰_날짜) — Date()
- score (리뷰_총점수) — Float()
- type (리뷰_타입) — Int
- name (리뷰_작성유저) — Char(10)
ReviewImage (reviewimage_set)
- id (ID) — Int — Primary key — NOT NULL
- review_id (리뷰_ID) — Int — Foreign key → Review.id — NOT NULL
- cafe_id (카페(PK)) — Int — Foreign key → Review.cafe_id — NOT NULL
- user_id (유저(PK)) — Foreign key → Review.user_id — NOT NULL
- image (이미지) — Image
User (유저)
- id (ID) — Int — Primary key — NOT NULL
- email (이메일) — Email — NOT NULL
- username (이름) — Char(10)