투데잇

테이블 (4)

Dislike (Untitled2)

  • food_id (Key) — String — 외래 키 → Food.food_id — NOT NULL
  • user_id (Key2) — Number — 외래 키 → User.user_id — NOT NULL
  • dislike_date (Field) — date

Food (음식)

  • food_id (Key) — Number — 기본 키 — NOT NULL
  • name (Field) — String
  • category (Field2) — [String]
  • calorie (Field4) — Number
  • price (Field5) — String
  • image (Field6) — String
  • likes (Field3) — Number

Like (Untitled)

  • user_id (Key2) — String — 외래 키 → User.user_id — NOT NULL
  • food_id (Key) — Number — 외래 키 → Food.food_id — NOT NULL
  • like_date (Field) — date

User (사용자)

  • user_id (Key) — String — 기본 키 — NOT NULL
  • connected_date (Field) — date