UMC_W1_mission

Tables (8)

Member (Untitled)

  • member_id (id) — bigint — Primary key — NOT NULL
  • gender — bool
  • birthday (birth) — datetime
  • address — varchar(20)
  • member_pw — varchar(20)
  • nickname — varchar(10)
  • email — varchar(20)
  • mypoint — bigint

Mission (Untitled2)

  • mission_id — bigint — Primary key — NOT NULL
  • reward — int
  • deadline — datetime
  • upload_date — datetime

Mission_member (Untitled3)

  • id — bigint — Primary key — NOT NULL
  • member_id (id2) — dtype — Foreign key → Member.member_id — NOT NULL
  • mission_id — bigint — Foreign key → Mission.mission_id — NOT NULL
  • status — varchar(10)

food_category (Untitled7)

  • id — bigint — Primary key — NOT NULL
  • category_name — varchat(20)

member_like (Untitled6)

  • id — bigint — Primary key — NOT NULL
  • member_id (id2) — bigint — Foreign key → Member.member_id — NOT NULL
  • id (id3) — bigint — Foreign key → food_category.id — NOT NULL

review (Untitled4)

  • id — bigint — Primary key — NOT NULL
  • id (id2) — bigint — Foreign key → store.id — NOT NULL
  • member_id (id3) — bigint — Foreign key → Member.member_id — NOT NULL
  • star — int
  • create_date — datetime
  • Field

review_image (Untitled8)

  • image_id (id) — bigint — Primary key — NOT NULL
  • id (id2) — bigint — Foreign key → review.id — NOT NULL
  • id (id22) — bigint — Foreign key → review.id — NOT NULL
  • member_id (id3) — bigint — Foreign key → review.member_id — NOT NULL
  • url — string
  • upload_date — datetime

store (Untitled5)

  • id — bigint — Primary key — NOT NULL
  • store_name — varchar(20)
  • locate — varchar(50)
  • open_state — bool