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)