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