UMC_chapter4

Tables (9)

food_type (Untitled)

  • Key — Primary key — NOT NULL
  • name — varchar(40) — NOT NULL

member

  • Key — Primary key — NOT NULL
  • region_address — bigint — Foreign key → my_region.Key — NOT NULL
  • spec_address — archer(40)
  • name — varchar(40) — NOT NULL
  • gender — bigint — NOT NULL
  • birthday — bigint
  • email — varchar(40)
  • point — bigint — NOT NULL
  • mission_count — bigint

mission (Untitled2)

  • id — bigint — Primary key — NOT NULL
  • shop_id — bigint — Foreign key → shop.id — NOT NULL
  • name — varchar(100)
  • deadline (Field) — bigint
  • how_success — varcher(100) — NOT NULL
  • point — bigint — NOT NULL
  • reward (reawrd) — archer(100)

my_like (Untitled5)

  • like_id — bigint — Foreign key → food_type.Key — NOT NULL
  • Key — Foreign key → member.Key — NOT NULL

my_region (Untitled7)

  • Key (Key2) — Foreign key → region.Key — NOT NULL

mymission (domission)

  • id (Key) — bigint — Primary key — NOT NULL
  • mission_id — bigint — Foreign key → mission.id — NOT NULL
  • Key (Key2) — Foreign key → member.Key — NOT NULL
  • doing_done — isActive — NOT NULL

region (Untitled6)

  • Key — Primary key — NOT NULL
  • name — NOT NULL

review (Untitled3)

  • Key2 — Primary key — NOT NULL
  • mission_id — bigint — Foreign key → mission.id — NOT NULL
  • shop_id — bigint — Foreign key → shop.id — NOT NULL
  • member_id — Foreign key → member.Key — NOT NULL
  • body — varchar(100) — NOT NULL
  • reviewstar — bigint — NOT NULL
  • date — bigint — NOT NULL

shop (Untitled4)

  • id — bigint — Primary key — NOT NULL
  • foodtype_id (Key) — Foreign key → food_type.Key — NOT NULL
  • name — varchar(40) — NOT NULL
  • introduce — varchar(100)