1week

Tables (10)

food (Untitled7)

  • id — int — Primary key — NOT NULL
  • type — varchar(10)

member (Untitled)

  • id — int — Primary key — NOT NULL
  • name — varchar(20)
  • gender — varchar20)
  • birth — datetime(6)
  • address — varchar(40)
  • email — varchar(40)
  • phone_number — varchar(20)
  • point — int
  • nickname — varchar(20)

member_agree (Untitled2)

  • id — int — Primary key — NOT NULL
  • member_id — int — Foreign key → member.id — NOT NULL
  • terms_id — int — Foreign key → terms.id — NOT NULL

member_mission (Untitled4)

  • id — int — Primary key — NOT NULL
  • member_id — int — Foreign key → member.id — NOT NULL
  • mission_id — int — Foreign key → mission.id — NOT NULL
  • status — varchar(10)

member_prefer (Untitled3)

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

mission (Untitled10)

  • id — int — Primary key — NOT NULL
  • store_id — int — Foreign key → store.id — NOT NULL
  • contents — text
  • point — int
  • deadline — datetime(6)

region (Untitled5)

  • id — int — Primary key — NOT NULL
  • name — varchar(20)

review (Untitled8)

  • id — int — Primary key — NOT NULL
  • member_id — int — Foreign key → member.id — NOT NULL
  • store_id — int — Foreign key → store.id — NOT NULL
  • id (id2) — int — Foreign key → store.region_id — NOT NULL
  • image — text
  • contents — text
  • score — float
  • day — datetime(6)

store (Untitled9)

  • id — int — Primary key — NOT NULL
  • food_id — int — Foreign key → food.id — NOT NULL
  • region_id — int — Foreign key → region.id — NOT NULL
  • region — varchar(20)
  • score — float

terms (Untitled6)

  • id — int — Primary key — NOT NULL
  • title — varchar(20)
  • contents — text
  • option — boolean