cafein

Tables (11)

Cafe (카페)

  • Key (cafe_id) — int — Primary key — NOT NULL
  • (name) — char(100)
  • (max_occupancy) — int
  • (address) — char(100)
  • (datail_add) — char(100)
  • (char(50)) — CharField
  • (like_users) — email
  • Key (user_id) — email — Foreign key → User.Key — NOT NULL

Cafe_comment (리뷰댓글)

  • Key (comment_id) — auto — Primary key — NOT NULL
  • (content) — char
  • (deleted) — bool
  • (date) — datetime
  • Key (review_id) — int — Foreign key → Cafe_review.Key — NOT NULL
  • Key (user_id) — email — Foreign key → User.Key — NOT NULL

Cafe_congestion (카페 혼잡도)

  • Key (congestion_id) — auto — Primary key — NOT NULL
  • Field (congestion) — int
  • Key (cafe_id) — int — Foreign key → Cafe.Key — NOT NULL

Cafe_image (카페 이미지)

  • Key (image_id) — int — Primary key — NOT NULL
  • (image) — image
  • Key (cafe_id) — int — Foreign key → Cafe.Key — NOT NULL

Cafe_keyword (카테고리별 키워드)

  • Key (keyword_id) — int — Primary key — NOT NULL
  • (price_word) — char
  • (price_count) — int
  • (drink_word) — char
  • (drink_count) — int
  • (dessert_word) — char
  • (dessert_count) — int
  • (service_word) — char
  • (service_count) — int
  • (customers_word) — char
  • (customers_count) — int
  • (interior_word) — char
  • (interior_count) — int
  • (view_word) — char
  • (view_count) — int
  • (parking_word) — char
  • (parking_count) — int
  • Key (cafe_id) — int — Foreign key → Cafe.Key — NOT NULL

Cafe_menu (카페메뉴)

  • Key (menu_id) — int — Primary key — NOT NULL
  • Field (name) — char(100)
  • Field2 (price) — int
  • Field3 (image) — image
  • Key (cafe_id) — int — Foreign key → Cafe.Key — NOT NULL

Cafe_rank (카테고리별 긍부정)

  • Key (rank_id) — int — Primary key — NOT NULL
  • (category) — char
  • (rank) — int
  • (ratio) — float
  • (cnt) — int
  • (positive_cnt) — int
  • Key (sentiment_id) — int — Foreign key → Cafe_sentiment.Key — NOT NULL

Cafe_review (카페리뷰)

  • Key (review_id) — int — Primary key — NOT NULL
  • (title) — char(100)
  • (score) — int
  • (content) — char
  • (deleted) — bool
  • (image) — image
  • (date) — datetime
  • Key (cafe_id) — int — Foreign key → Cafe.Key — NOT NULL
  • Key (user_id) — email — Foreign key → User.Key — NOT NULL

Cafe_sentiment (전체 긍부정)

  • Key (sentiment_id) — int — Primary key — NOT NULL
  • (total) — float
  • (total_count) — int
  • Key (cafe_id) — int — Foreign key → Cafe.Key — NOT NULL

Cafe_wordcloud (워드클라우드)

  • Key (word_id) — int — Primary key — NOT NULL
  • (price) — image
  • (drink) — image
  • (dessert) — image
  • (service) — image
  • (customers) — image
  • (interior) — image
  • (view) — image
  • (parking) — image
  • Key (cafe_id) — int — Foreign key → Cafe.Key — NOT NULL

User (회원)

  • Key (user_id) — email — Primary key — NOT NULL
  • (email) — email
  • (password) — char(300)
  • (phone) — char(25)
  • (is_admin) — bool
  • (is_active) — bool
  • (is_superuser) — bool
  • (is_owner) — bool