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)