UMC 4주차

테이블 (8)

food (Untitled5)

  • id (Key) — bigint — 기본 키 — NOT NULL
  • name (Field) — varchar
  • price (Field2) — int
  • restaurant_id (Key2) — bigint — 외래 키 → restaurant.id — NOT NULL
  • food_type_id (Key3) — bigint — 외래 키 → food_type.id — NOT NULL

food_type (Untitled2)

  • id (Key) — bigint — 기본 키 — NOT NULL
  • name (Field) — varchar

inquire (Untitled8)

  • Key — bigint — 기본 키 — NOT NULL
  • title (Field) — varchar
  • content (Field2) — varchar
  • date (Field3) — timestamp
  • user_id (Key2) — bigint — 외래 키 → user.id — NOT NULL
  • Field4 — varchar

mission (Untitled7)

  • id (Key) — 기본 키 — NOT NULL
  • point (Field) — int
  • minimum_price (Field2) — int
  • user_id (Key2) — bigint — 외래 키 → user.id — NOT NULL
  • restaurant_id (Key3) — bigint — 외래 키 → restaurant.id — NOT NULL
  • deadline (Field3) — date
  • status (Field4) — varchar

restaurant (Untitled4)

  • id (Key) — bigint — 기본 키 — NOT NULL
  • name (Field) — varchar
  • type (Field2) — varchar
  • address (Field3) — varchar
  • food_type_id (Key2) — bigint — 외래 키 → food_type.id — NOT NULL

review (Untitled6)

  • Key — bigint — 기본 키 — NOT NULL
  • content (Field) — varchar
  • date (Field2) — timestamp
  • id (Key2) — bigint — 외래 키 → user.id — NOT NULL
  • restaurant_id (Key3) — bigint — 외래 키 → restaurant.id — NOT NULL
  • star (Field3) — long

user (Untitled)

  • id (Key) — bigint — 기본 키 — NOT NULL
  • name (Field) — varchar
  • gender (Field2) — varchar
  • birthday (Field3) — date
  • address (Field4) — varchar
  • email (Field5) — varchar
  • phone_number (Field6) — varchar
  • point (Field7) — int
  • Field8 — boolean

user_food_type (Untitled3)

  • Key — bigint — 기본 키 — NOT NULL
  • user_id (Key2) — bigint — 외래 키 → user.id — NOT NULL
  • food_id (Key3) — bigint — 외래 키 → food_type.id — NOT NULL