my_food_map
Tables (3)
Restaurant (식당)
- restaurantId (식당ID) — INT — Primary key — NOT NULL
- kakaoId (카카오ID) — VARCHAR(191) — NOT NULL
- name (식당이름) — VARCHAR(191) — NOT NULL
- address (식당주소) — VARCHAR(191) — NOT NULL
- category (식당분류) — VARCHAR(191) — NOT NULL
- x (경도) — VARCHAR(191) — NOT NULL
- y (위도) — VARCHAR(191) — NOT NULL
Review (리뷰)
- reviewId (리뷰ID) — INT — Primary key — NOT NULL
- userId (유저ID) — INT — Foreign key → User.userId — NOT NULL
- restaurantId (식당ID) — INT — Foreign key → Restaurant.restaurantId — NOT NULL
- menuName (메뉴명) — VARCHAR(191) — NOT NULL
- price (가격) — INT — NOT NULL
- visitDate (방문일) — DATETIME(3) — NOT NULL
- content (내용) — TEXT — NOT NULL
- imageUrl (이미지경로) — VARCHAR(191)
- createdAt (생생시간) — DATETIME(3) — NOT NULL
User (사용자)
- userId (유저ID) — INT — Primary key — NOT NULL
- username (아이디) — VARCHAR(191) — NOT NULL
- password (비밀번호) — VARCHAR(191) — NOT NULL
- nickname (유저명) — VARCHAR(191) — NOT NULL
- createdAt (생성시간) — DATETIME(3) — NOT NULL