foodlog

Tables (7)

Member (유저)

  • memberId (유저 PK) — Long — Primary key — NOT NULL
  • user_id (닉네임) — VARCHAR(200)
  • password (유저 앱 아이디) — VARCHAR(1000)
  • created_At (생성일) — TimeStamp
  • updated_At (최종 수정일) — TImeStamp
  • lastLoginDate (마지막 앱 접속 날) — TImeStamp
  • profile (프로필) — VARCHAR(1000)
  • firebaseToken (파이어베이스 토큰) — VARCHAR(1000)

Member-Notification (알림)

  • notification (알림 pk) — Long — Primary key — NOT NULL
  • body (본문내용) — VARCHAR(200)
  • title (제목) — VARCHAR(200)
  • created_At (생성일) — TimeStamp
  • updated_At (최종 수정일) — TImeStamp
  • memberId (유저 PK) — Long — Foreign key → Member.memberId — NOT NULL

NonMember (비회원)

  • memberId (비회원 PK) — Long — Primary key — NOT NULL
  • created_At (생성일) — TimeStamp
  • updated_At (최종 수정일) — TImeStamp
  • lastLoginDate (마지막 앱 접속 날) — TImeStamp
  • firebaseToken (파이어베이스 토큰) — VARCHAR(1000)

NonMember-Notification (비회원 알림)

  • notification (알림 pk) — Long — Primary key — NOT NULL
  • body (본문내용) — VARCHAR(200)
  • title (제목) — VARCHAR(200)
  • created_At (생성일) — TimeStamp
  • updated_At (최종 수정일) — TImeStamp
  • memberId (비회원 PK) — Long — Foreign key → NonMember.memberId — NOT NULL

food (음식점)

  • food_id (음식점 Pk) — Long — Primary key — NOT NULL
  • created_at (생성 날) — VARCHAR(2000)
  • updated_at (수정 날) — VARCHAR(2000)
  • total_review (리뷰 수) — VARCHAR(2000)
  • address (주소) — VARCHAR(2000)
  • category (카테고리) — VARCHAR(2000)
  • latitude (위도) — VARCHAR(2000)
  • longitude (경도) — VARCHAR(2000)
  • naver_link (네이버 링크) — VARCHAR(2000)
  • food_phone_number (음식점 전화번호) — VARCHAR(2000)
  • rating (별점) — VARCHAR(2000)
  • representative_image (대표 이미지) — VARCHAR(2000)
  • restaurant (음식점 명) — VARCHAR(2000)
  • youtube_link (유튜브 링크) — VARCHAR(2000)
  • youtuber_id (Key) — Long — Foreign key → youtuber.youtuber_id — NOT NULL

food_ favorites (즐쳐찾기)

  • food_favorites_id (즐겨찾기 pk) — Long — Primary key — NOT NULL
  • memberId (유저 PK) — Long — Foreign key → Member.memberId — NOT NULL
  • food_id (음식점 Pk) — Long — Foreign key → food.food_id — NOT NULL

youtuber (유튜버)

  • youtuber_id (유튜버 pk) — Long — Primary key — NOT NULL
  • created_at (생성 날) — VARCHAR(2000)
  • updated_at (수정 날) — VARCHAR(2000)
  • channel_id (채널 고유아이디) — VARCHAR(2000)
  • youtube_name (유튜버 이름) — VARCHAR(2000)
  • youtube_profile (유투버 프로필) — VARCHAR(2000)