umc

Tables (6)

food (Untitled2)

  • id — Primary key — NOT NULL
  • foodname — varchar(10)
  • food_field — varchar(10)

member (Untitled)

  • id — Primary key — NOT NULL
  • name — varchar(10)
  • birth — varchar(10)
  • gender — varchar(10)
  • photo — text
  • address — varchar(10)
  • nickname — varchar(10)
  • date — varchar(10)
  • phone number — varchar(20)
  • email — varchar(50)

member_prefer (Untitled4)

  • id — Primary key — NOT NULL
  • member_id — int — Foreign key → member.id — NOT NULL
  • food_id — int — Foreign key → food.id — NOT NULL

mission (Untitled3)

  • id — int — Primary key — NOT NULL
  • store_name — int
  • contents — varchar(10)
  • deadline — int
  • store_field — varchar(10)

review (Untitled5)

  • Key (id) — int — Primary key — NOT NULL
  • Key — Foreign key → member.id — NOT NULL
  • member_id — int
  • store_id — text
  • photo — text
  • contents — text
  • score — int

store (Untitled6)

  • id — int — Primary key — NOT NULL
  • id (id2) — int — Foreign key → mission.id — NOT NULL
  • food_id — int
  • place — varchar(10)
  • score