UMC-5th-mission

Tables (6)

Member (member)

  • id — bigint — Primary key — NOT NULL
  • name — varchar(20)
  • gender — varchar(10)
  • birth — datetime
  • address — varchar(40)
  • food_type — varchar(20)
  • status — varchar(15)
  • inactive_data — datetime
  • userId — varchar(40)
  • pw — varchar(40)
  • email — varchar(50)
  • phone_number — varchar(10)
  • point — int
  • updated_at — datetime(6)
  • careated_at — datetime(6)

MemberMission (memberMission)

  • id — bigint — Primary key — NOT NULL
  • member_id — bigint — Foreign key → Member.id — NOT NULL
  • mission_id — bigint — Foreign key → Mission.id — NOT NULL
  • state — varchar(15)
  • created_at — datetime(6)
  • updated_at — datetime(6)

Mission (mission)

  • id — bigint — Primary key — NOT NULL
  • reward — int
  • deadline — datetime
  • content — text
  • created_at — datetime(6)
  • updated_at — datetime(6)

Review (review)

  • id — bigint — Primary key — NOT NULL
  • member_id — bigint — Foreign key → Member.id — NOT NULL
  • store_id — bigint — Foreign key → Store.id — NOT NULL
  • score — float
  • content — text
  • created_at — datetime(6)
  • updated_at — datetime(6)

ReviewImage (reviewImage)

  • id — bigint — Primary key — NOT NULL
  • review_id — bigint — Foreign key → Review.id — NOT NULL
  • image_url — text
  • created_at — datetime(6)
  • updated_at — datetime(6)

Store (store)

  • id — bigint — Primary key — NOT NULL
  • address — varchar(40)
  • score — float
  • name — varchar(10)
  • created_at — datetime(6)
  • updated_at — datetime(6)