umc_6th_w4

Tables (13)

Copy Of Untitled (ReviewImage)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (review_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (img) — bigint

Copy Of Untitled2 (QuestionImage)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (question_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (img) — bigint

FoodCategory

  • key (id) — bigint — Primary key — NOT NULL
  • field (name) — varchar(20)
  • field (content) — varchar(50)

MemberFoodCategory

  • Key (id) — bigint — Primary key — NOT NULL
  • key (food_category_id) — bigint — Foreign key → FoodCategory.key — NOT NULL
  • Key (member_id) — BIGINT — Foreign key → Untitled3.Key — NOT NULL

Untitled (Store)

  • Key (id) — bigint — Primary key — NOT NULL
  • key (food_category_id) — bigint — Foreign key → FoodCategory.key — NOT NULL
  • Key (region_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (name) — varchar(20)
  • Field2 (address) — varchar(30)
  • Field (rating) — double

Untitled (MemberMission)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (mission_id) — bigint — Foreign key → Untitled4.Key — NOT NULL
  • Key (member_id) — BIGINT — Foreign key → Untitled3.Key — NOT NULL

Untitled (Review)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (store_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Key (member_id) — BIGINT — Foreign key → Untitled3.Key — NOT NULL
  • Field (content) — varchar(200)
  • Field2 (rating) — bigint

Untitled (Region)

  • Key (id) — bigint — Primary key — NOT NULL
  • Field (name) — varchar(30)

Untitled (Alarm)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (member_id) — BIGINT — Foreign key → Untitled3.Key — NOT NULL
  • Field (content) — varchar(30)

Untitled (Question)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (member_id) — BIGINT — Foreign key → Untitled3.Key — NOT NULL
  • Field (title) — bigint
  • Field (content) — bigint

Untitled (StoreImage)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (store_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (img) — bigint

Untitled3 (Member)

  • Key (id) — BIGINT — Primary key — NOT NULL
  • Key (region_id) — bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (email) — VARCHAR(30)
  • Field2 (name) — varchar(20)
  • Field3 (nickname) — varchar(20)
  • Field3 (gender) — enum — MALE, FEMALE
  • Field4 (point_value) — int
  • Field5 (birth_day) — date
  • Field (address) — varchar(20)
  • Field4 (phone_number) — bigint

Untitled4 (Mission)

  • Key (id) — bigint — Primary key — NOT NULL
  • Field (state) — enum
  • Field (content) — varchar(30)
  • Field (lower_price) — bigint
  • Field (reward) — bigint
  • Field (deadline) — datetime
  • Field (authcode) — varchar(20)