k-chelin
Tables (7)
Bookmark_recommend (북마크기반 추천)
- id (Key) — INT — Primary key — NOT NULL
- bookmarked (북마크횟수) — INT
Category_recommend (카테고리별 추천)
- id (Key) — INT — Primary key — NOT NULL
- store_type (가게업종) — VARCHAR
- menu_type (음식종류) — VARCHAR
Data (빅데이터)
- id (Key) — INT — Primary key — NOT NULL
- hashtag (해시태그) — VARCHAR
- group (그룹명) — VARCHAR
- singer_name (가수명) — VARCHAR
- full_text (본문) — VARCHAR
- image_url (이미지링크) — VARCHAR
- address (주소) — VARCHAR
- store_name (가게명) — VARCHAR
- tweet_url (트윗링크) — VARCHAR
- created_at (작성일) — DATE
- favorite_count (추천수) — INT
Idol_recommend (아이돌별 추천)
- id (Key) — INT — Primary key — NOT NULL
- hashtag (해시태그) — VARCHAR
- group (그룹명) — VARCHAR
- singer_name (가수명) — VARCHAR
Location_recommend (위치기반 추천)
- id (Key) — INT — Primary key — NOT NULL
- location_now (현재위치) — VARCHAR
User (유저)
- Email (이메일) — VARCHAR — Primary key — NOT NULL
- password (비밀번호) — VARCHAR
- nickname (닉네임) — VARCHAR
- id (pk) — INT
User_pattern_recommend (사용자패턴기반 추천)
- id (Key) — INT — Primary key — NOT NULL
- now_time (현재시간) — DATE
- now_season (현재계절) — VARCHAR
- weather (현재날씨) — VARCHAR