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