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