umc_1_2

Tables (10)

food_category

  • id — int — Primary key — NOT NULL
  • name — varchar(20)
  • created_at — datetime(6)
  • updated_at — datetime(6)

member

  • id — bigint — Primary key — NOT NULL
  • name — varchar(15)
  • gender — varchar(10)
  • address — text
  • birth — date
  • email — varchar(50)
  • phone_num — varchar(20)
  • points — bigint
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • status — varchar(15)
  • inactive_date — datetime

member_agree

  • id — bigint — Primary key — NOT NULL
  • member_id — bigint — Foreign key → member.id — NOT NULL
  • title — varchar(20)
  • description — text
  • optional — boolean
  • created_at — datetime(6)
  • updated_at — datetime(6)

member_mission

  • member_id — bigint — Foreign key → member.id — NOT NULL
  • mission_id — bigint — Foreign key → mission.id — NOT NULL
  • status — varchar(10)
  • mission_name — varchar(50)
  • created_at — datetime(6)
  • updated_at — datetime(6)

member_prefer

  • member_id — bigint — Foreign key → member.id — NOT NULL
  • food_id — int — Foreign key → food_category.id — NOT NULL
  • food_name — varchar(20)
  • created_at — datetime(6)
  • updated_at — datetime(6)

mission

  • id — bigint — Primary key — NOT NULL
  • name — varchar(50)
  • description — text
  • deadline — date
  • point — int
  • store_id — bigint — Foreign key → store.id — NOT NULL
  • created_at — datetime(6)
  • updated_at — datetime(6)

region

  • id — bigint — Primary key — NOT NULL
  • name — varchar(30)
  • created_at — datetime(6)
  • updated_at — datetime(6)

review

  • id — bigint — Primary key — NOT NULL
  • content — text
  • rating — int
  • image_url — text
  • member_name — varchar(15)
  • member_id — bigint — Foreign key → member.id — NOT NULL
  • store_id — bigint — Foreign key → store.id — NOT NULL
  • created_at — datetime(6)
  • updated_at — datetime(6)

review_image

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

store

  • id — bigint — Primary key — NOT NULL
  • name — varchar(50)
  • region_id — bigint — Foreign key → region.id — NOT NULL
  • created_at — datetime(6)
  • updated_at — datetime(6)