yf

Tables (11)

comment

  • id — bigint — Primary key — NOT NULL
  • review_id — bigint — NOT NULL
  • member_id — bigint — NOT NULL
  • content — text
  • created_at — datetime
  • updated_atd — datetime

food_category

  • id — bigint — Primary key — NOT NULL
  • name — varchar(15) — Enum 관리 방안 존재
  • created_at — datetime(6)
  • updated_at — datetime(6)

member

  • id — bigint — Primary key — NOT NULL
  • name — varchar(20) — NOT NULL
  • gender — varchar(10) — NOT NULL
  • age — int — NOT NULL
  • birth — timestamp
  • address — varchar(40) — NOT NULL
  • spec_address — varchar(40) — NOT NULL
  • status — varchar(15) — NOT NULL
  • inactive_date — datetime — NOT NULL
  • social_type — varchar(10) — NOT NULL
  • email — varchar(50)
  • point — int
  • created_at — datetime(6)
  • updated_at — datetime(6)

member_agreement

  • id — bigint — Primary key — NOT NULL
  • member_id — bigint — NOT NULL
  • terms_id — bigint — NOT NULL
  • agreed_at — datetime

member_mission

  • id — bigint — Primary key — NOT NULL
  • member_id — bigint — NOT NULL
  • mission_id — bigint — NOT NULL
  • status — Enum — Complete, Challenging, Cancel
  • created_at — datetime(6)
  • updated_at — datetime(6)

member_prefer

  • id — bigint — Primary key — NOT NULL
  • member_id — bigint — NOT NULL
  • category_id — bigint — NOT NULL
  • created_at — datetime(6)
  • updated_at — datetime(6)

mission

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

review

  • id — bigint — Primary key — NOT NULL
  • member_id — bigint — NOT NULL
  • store_id — bigint — NOT NULL
  • body — text
  • score — float
  • created_at — datetime
  • updated_at — datetime

review_image

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

store

  • id — bigint — Primary key — NOT NULL
  • name — varchar(50)
  • address — varchar(50)
  • category — varchar(20) — Enum 방안도 존재
  • score — float
  • is_open — boolean
  • created_at — datetime(6)
  • updated_at — datetime(6)

terms

  • id — bigint — Primary key — NOT NULL
  • title — varchar(20)
  • content — text
  • optional — boolean
  • created_at — datetime(6)
  • updated_at — datetime(6)