for_umc2

Tables (13)

alarm

  • id — bigint — Primary key
  • title — varchar(50) — NOT NULL
  • content — text — NOT NULL
  • dtype — varchar(20) — NOT NULL
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • is_read (Field) — tinyint(1)
  • read_at (Field2) — datetime(6)

food

  • id — bigint — Primary key
  • name — varchar(20)
  • created_at — datetime(6)
  • updated_at — datetime(6)

mission

  • id — bigint — Primary key
  • store_id — bigint — NOT NULL
  • title — varchar(100) — NOT NULL
  • reward_point — int
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • store_id (id2) — bigint — Foreign key → store.id

point_history

  • id — bigint — Primary key
  • change_type — enum
  • amount_point — int — NOT NULL
  • content — varchar(30)
  • created_at — datetime(6)
  • user_id (id2) — bigint — Foreign key → user.id
  • store_id (id3) — bigint — Foreign key → store.id

preferred_food

  • id — bigint — Primary key
  • updated_at (field2)
  • created_at — datetime(6)
  • user_id — bigint — Foreign key → user.id
  • food_id — bigint — Foreign key → food.id

review

  • id — bigint — Primary key
  • rating — decimal(2, 1) — NOT NULL
  • content — text
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • user_id (id2) — bigint — Foreign key → user.id
  • store_id (id3) — bigint — Foreign key → store.id

review_answer

  • id — bigint — Primary key
  • content — varchar(400)
  • created_at — datetime(6)
  • review_id (id2) — bigint — Foreign key → review.id
  • store_id (id3) — bigint — Foreign key → store.id

review_image

  • id — bigint — Primary key
  • image_url — varchar(100) — NOT NULL
  • created_at — datetime(6)
  • review_id (id2) — bigint — Foreign key → review.id

social_account

  • id — bigint — Primary key
  • social_type — enum
  • social_id — varchar(30) — NOT NULL
  • refresh_token — varchar(255)
  • email — varchar(50)
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • user_id (id2) — bigint — Foreign key → user.id

store

  • id — bigint — Primary key
  • name — varchar(20) — NOT NULL
  • address — varchar(40) — NOT NULL
  • latitude — decimal(10, 7)
  • longitude — decimal(10, 7)
  • created_at — datetime(6)
  • updated_at — datetime(6)

user

  • id — bigint — Primary key
  • email — varchar(100)
  • password — varchar(255)
  • name — varchar(10)
  • gender — enum
  • birth_date — date
  • address — varchar(40)
  • phone_number — varchar(15)
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • status — enum
  • id (id2) — bigint — Foreign key → alarm.id

user_consent

  • id — bigint — Primary key
  • is_required — tinyint(1) — NOT NULL
  • location_agree — tinyint(1)
  • marketing_agree — tinyint(1)
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • user_id — bigint — Foreign key → user.id

user_mission

  • id — bigint — Primary key
  • status — enum
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • requested_at — datetime(6)
  • completed_at — datetime(6)
  • user_id (id2) — bigint — Foreign key → user.id
  • mission_id (id3) — bigint — Foreign key → mission.id