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