UMC_chapter4 - 2023-10-12 03:50:46

Tables (7)

member

  • id — bigint — Primary key — NOT NULL
  • name — varchar(40) — NOT NULL
  • Field
  • point — bigint — NOT NULL
  • mission_count — bigint

mission (Untitled2)

  • id — bigint — Primary key — NOT NULL
  • shop_id — bigint — Foreign key — NOT NULL
  • name — varchar(100)

my_like (Untitled5)

  • like_id — bigint — Foreign key — NOT NULL
  • member_id — bigint — Foreign key — NOT NULL

mymission (domission)

  • id (Key) — bigint — Primary key — NOT NULL
  • member_id — bigint — Foreign key — NOT NULL
  • mission_id — bigint — Foreign key — NOT NULL
  • doing_done — isActive — NOT NULL

review (Untitled3)

  • member_id — bigint — Foreign key — NOT NULL
  • mission_id — bigint — Foreign key — NOT NULL
  • id (id2) — bigint — Foreign key — NOT NULL
  • title — varchar(40) — NOT NULL
  • body — varchar(100)

shop (Untitled4)

  • id — bigint — Primary key — NOT NULL
  • name — varchar(40) — NOT NULL
  • introduce — varchar(100)

sunho_like (Untitled)

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