UMC week1

Tables (12)

Untitled (region)

  • Field (id) — bigint — Primary key
  • Field (name) — varchar(10)

Untitled (store)

  • Field (id) — bigint — Primary key
  • Field (name) — varchar(20)
  • Field (address) — varchar(20)
  • Field (created_at) — datetime(6)
  • Field2 (updated_at) — datetime(6)
  • Field (region_id) — bigint — Foreign key → Untitled.Field

Untitled (mission)

  • Field (id) — bigint — Primary key
  • Field (name) — varchar(20)
  • Field (reward_point) — int
  • Field (condition) — varchar(20)
  • Field2 (condition_value) — int
  • Field (start_date) — datetime(6)
  • Field2 (end_date) — datetime(6)
  • Field (created_at) — datetime(6)
  • Field2 (updated_at) — datetime(6)
  • Field (store_id) — bigint — Foreign key → Untitled.Field

Untitled (user_mission)

  • Field (user_mission_id) — bigint — Primary key
  • Field (status) — varchar(10)
  • Field (started_at) — datetime(6)
  • Field (completed_at) — datetime(6)
  • Field (progress_count) — int
  • Field2 (current_amount) — int
  • Field2 (reward_point) — int
  • Field (updated_at) — datetimme(6)
  • Field (user_id) — bigint — Foreign key → user.Field
  • Field (missoin_id) — bigint — Foreign key → Untitled.Field

Untitled (review)

  • Field (id) — bigint — Primary key
  • Field (rating) — int
  • Field (comment) — varchar(500)
  • Field (created_at) — datetime(6)
  • Field (updated_at) — datetime(6)
  • Field (store_id) — bigint — Foreign key → Untitled.Field
  • Field (user_id) — bigint — Foreign key → user.Field

Untitled (category)

  • Field (id) — bigint — Primary key
  • Field (name) — varchar(20)

Untitled (user_category)

  • Field (category_id) — bigint — Foreign key → Untitled.Field
  • Field (user_id) — bigint — Foreign key → user.Field

Untitled (point)

  • Field (id) — bigint — Primary key
  • Field (amount) — int
  • Field (created_at) — datetime(6)
  • Field (updated_at) — datetime(6)
  • Field (user_id) — bigint — Foreign key → user.Field

Untitled (inquiry)

  • Field (id) — bigint — Primary key
  • Field (title) — varchar(20)
  • Field (content) — varchar(100)
  • Field (status) — varchar(10)
  • Field (created_at) — datetime(6)
  • Field (updated_at) — datetime
  • Field (user_id) — bigint — Foreign key → user.Field

Untitled (user_region_progress)

  • Field (id) — bigint — Primary key
  • Field (completed_count) — int
  • Field (updated_at) — datetime(6)
  • Field (user_id) — bigint — Foreign key → user.Field
  • Field (region_id) — bigint — Foreign key → Untitled.Field

Untitled (store_category)

  • Field (category_id) — bigint — Foreign key → Untitled.Field
  • Field (store_id) — bigint — Foreign key → Untitled.Field

user

  • Field (id) — bigint — Primary key
  • Field (email) — varchar(20)
  • Field2 (phone_num) — varchar(15)
  • Field (name) — varchar(10)
  • Field (login_id) — bigint
  • Field (nickname) — varchar(20)
  • Field (password) — varchar(20)
  • Field (gender) — varchar(10)
  • Field (address) — varchar(20)
  • Field (birth_date) — datetime
  • Field (created_at) — datetime(6)
  • Field2 (updated_at) — datetime(6)
  • Field3 (status) — varchar(10)
  • Field (inactive_date) — datetime(6)
  • Field (total_point) — int