market_mission

테이블 (12)

food_category

  • food_id — bigint — 기본 키 — NOT NULL
  • prefer_id (id2) — bigint — 외래 키 → member_prefer.prefer_id — NOT NULL
  • member_id (id22) — bigint — 외래 키 → member_prefer.member_id — NOT NULL
  • food_name (name) — varchar(10)
  • created_at — datetime(6)
  • updated_at — datetime(6)

member

  • member_id (id) — bigint — 기본 키 — NOT NULL
  • member_password (password) — varchar(15)
  • member_name (name) — varchar(10)
  • member_gender (gender) — varchar(10)
  • member_birth (birth) — varchar(10)
  • member_address (address) — varchar(40)
  • member_email (email) — varchar(15)
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • status — varchar(15)
  • inactive_date — datetime
  • member_point (point) — int

member_mission

  • mem_mission_id (id) — bigint — 기본 키 — NOT NULL
  • mission_id (id2) — bigint — 외래 키 → mission.mission_id — NOT NULL
  • member_id (id3) — bigint — 외래 키 → member.member_id — NOT NULL
  • status — varchar(15)
  • created_at — datetime(6)
  • updated_at — datetime(6)

member_prefer

  • prefer_id (id) — bigint — 기본 키 — NOT NULL
  • member_id (id2) — bigint — 외래 키 → member.member_id — NOT NULL
  • created_at — datetime(6)
  • updated_at — datetime(6)

mission

  • mission_id (id) — bigint — 기본 키 — NOT NULL
  • reward_point — int
  • description — text
  • expireday — varchar(10)
  • created_at — datetime(6)
  • updated_at — datetime(6)

new_mission

  • new_id (id) — bigint — 기본 키 — NOT NULL
  • alarm_id (id2) — bigint — 외래 키 → 알람.alarm_id — NOT NULL
  • member_id (id22) — bigint — 외래 키 → 알람.member_id — NOT NULL
  • new_title (title) — varchar(30)
  • new_body (body) — text

restaurant

  • restaurant_id (id) — bigint — 기본 키 — NOT NULL
  • category_id (id2) — bigint — 외래 키 → restaurant_category.category_id — NOT NULL
  • location — varchar(40)
  • restaurant_name (name) — varchar(10)
  • reward — int
  • rating — float
  • opening_hours — TIME
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • closing_hours — TIME

restaurant_category (resta_category)

  • category_id (id) — bigint — 기본 키 — NOT NULL
  • category_name (name) — varchar(20)
  • created_at — datetime(6)
  • updated_at — datetime(6)

review

  • review_id (id) — bigint — 기본 키 — NOT NULL
  • member_id (id2) — bigint — 외래 키 → member.member_id — NOT NULL
  • restaurant_id (id3) — bigint — 외래 키 → restaurant.restaurant_id — NOT NULL
  • category_id (id22) — bigint — 외래 키 → restaurant.category_id — NOT NULL
  • title — varchar(30)
  • content — text
  • rating — float
  • created_at — datetime(6)
  • updated_at — datetime(6)

review_request

  • review_request_id (id) — bigint — 기본 키 — NOT NULL
  • alarm_id (id2) — bigint — 외래 키 → 알람.alarm_id — NOT NULL
  • member_id (id22) — bigint — 외래 키 → 알람.member_id — NOT NULL
  • review_re_title (title) — varchar(30)
  • review_re_body (body) — text

termsOfService (terms)

  • terms_id (id) — bigint — 기본 키 — NOT NULL
  • member_id (id2) — bigint — 외래 키 → member.member_id — NOT NULL
  • content — text
  • effective_date — datetime
  • enddate — datetime
  • is_checked — boolean
  • created_at — datetime(6)
  • updated_at — datetime(6)

알람 (alarm)

  • alarm_id (id) — bigint — 기본 키 — NOT NULL
  • member_id (id2) — bigint — 외래 키 → member.member_id — NOT NULL
  • is_conformed — boolean
  • created_at — datetime(6)
  • updated_at — datetime(6)