(modifying)umc_week1

Tables (14)

inquiry

  • id — bigint — Primary key — NOT NULL
  • member_id — bigint — Foreign key → member.id — NOT NULL
  • title — varchar(50)
  • body — varchar(500)
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • dtype — enum
  • images — text

inquiry_answer (answer)

  • id — bigint — Primary key — NOT NULL
  • inquiry_id — bigint — Foreign key → inquiry.id — NOT NULL
  • created_at — datetime(6)
  • updated_at (updated_at2) — datetime(6)
  • title — varchar(50)
  • body — text

member

  • id — bigint — Primary key — NOT NULL
  • user_password — varchar(255)
  • name — varchar(40)
  • nickname — varchar(20)
  • phone_number — varchar(15)
  • gender — enum
  • birthday — datetime(6)
  • email — varchar(30)
  • address — varchar(100)
  • status — enum
  • inactive_date — datetime
  • created_at — datetime(6)
  • updated_at — datetime(6)

mission

  • id — bigint — Primary key — NOT NULL
  • store_id — bigint — Foreign key → store.id — NOT NULL
  • title — varchar(50)
  • body — varchar(255)
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • deadline — datetime(6)

my_mission

  • id — Primary key — NOT NULL
  • member_id — bigint — Foreign key → member.id — NOT NULL
  • mission_id — bigint — Foreign key → mission.id — NOT NULL
  • dtype — enum

new_event

  • id — bigint — Primary key — NOT NULL
  • push_id — bigint — Foreign key → push_notification.id — NOT NULL
  • title — varchar(50)
  • body — varchar(255)

push_notification

  • id — bigint — Primary key — NOT NULL
  • is_confirmed — boolean
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • member_id — bigint — Foreign key → member.id — NOT NULL

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
  • contents — varchar(255)
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • score — int
  • images — text

review_answer

  • id — bigint — Primary key — NOT NULL
  • push_id — bigint — Foreign key → push_notification.id — NOT NULL
  • title — varchar(50)
  • body — varchar(255)

review_comment

  • id — bigint — Primary key — NOT NULL
  • review_id — bigint — Foreign key → review.id — NOT NULL
  • member_id — bigint — Foreign key → member.id — NOT NULL

store

  • id — bigint — Primary key — NOT NULL
  • name — varchar(30)
  • address — varchar(100)

tag

  • id — bigint — Primary key — NOT NULL
  • store_id — bigint — Foreign key → store.id — NOT NULL
  • member_id — bigint — Foreign key → member.id — NOT NULL
  • title — varchar(15)

terms

  • id — bigint — Primary key — NOT NULL
  • title — varchar(50)
  • body — varchar(255)
  • essential — enum

terms_agreement

  • id — bigint — Primary key — NOT NULL
  • member_id — bigint — Foreign key → member.id — NOT NULL
  • agreement_id — bigint — Foreign key → terms.id — NOT NULL
  • agreement — enum
  • agreement_at — datetime(6)