umc_week1_미션

테이블 (8)

Untitled (app_mission)

  • Key (id) — bigint — 기본 키 — NOT NULL
  • Key (store_id) — bigint — 외래 키 → Untitled.Key — NOT NULL
  • Field (reward_point) — int
  • Field (created_at) — datetime(6)
  • Field (required_amount) — int
  • Field (expiration_date) — datetime(6)

Untitled (app_mission_user)

  • Key (id) — bigint — 기본 키 — NOT NULL
  • Key (mission_id) — bigint — 외래 키 → Untitled.Key — NOT NULL
  • Key (user_id) — bigint — 외래 키 → app_user.Key — NOT NULL
  • Field (status) — varchar(15)
  • Field (completion_date) — datetime(6)
  • Field (is_reward_paid) — boolean

Untitled (app_region)

  • Key (id) — bigint — 기본 키 — NOT NULL
  • Field (region_name) — varchar(20)

Untitled (review)

  • Key (id) — bigint — 기본 키 — NOT NULL
  • Key (store_id) — bigint — 외래 키 → Untitled.Key — NOT NULL
  • Key (user_id) — bigint — 외래 키 → app_user.Key — NOT NULL
  • Field (rating) — decimal(2,1)
  • Field (text_content) — text
  • Field (created_at) — datetime(6)
  • Field (image_url) — varchar(255)

Untitled (app_user_terms)

  • Key (id) — bigint — 기본 키 — NOT NULL
  • Key (user_id) — bigint — 외래 키 → app_user.Key — NOT NULL
  • Key (terms_id) — bigint — 외래 키 → Untitled.Key — NOT NULL
  • Field (agreed_at) — datetime(6)

Untitled (app_store)

  • Key (id) — bigint — 기본 키 — NOT NULL
  • Key (region_id) — bigint — 외래 키 → Untitled.Key — NOT NULL
  • Field (store_name) — varchar(50)
  • Field (address) — varchar(100)
  • Field (latitude) — decimot(10,7)
  • Field (longitude) — decimal(10,7)
  • Field (contact_info) — varchar(20)
  • Field (rating) — decimal(2,1)
  • Field (review_count) — int

Untitled (app_terms)

  • Key (id) — bigint — 기본 키 — NOT NULL
  • Field (title) — varchar(30)
  • Field (content) — text
  • Field (version) — varchar(10)
  • Field (is_mandatory) — boolean

app_user

  • Key (id) — bigint — 기본 키 — NOT NULL
  • Field (user_name) — varchar(20)
  • Field (gender) — varchar(10)
  • Field (birthday) — char(10)
  • Field (created_at) — datetime(6)
  • Field (updated_at) — datetime(6)
  • Field (address) — varchar(100)
  • Field (email) — varchar(50)
  • Field (password) — varchar(100)
  • Field (preferred_food_type) — varchar(50)
  • Field (phone_number) — varchar(15)