ㄴㄴㄴ

Tables (21)

achievement

  • id — BIGINT
  • name — VARCHAR(100)
  • description — VARCHAR(255)
  • condition_type — VARCHAR(100)
  • reward_type — VARCHAR(20)
  • reward_value — VARCHAR(50)
  • created_at — DATETIME

area

  • code — VARCHAR(10)
  • sido — VARCHAR(20)
  • sigungu — VARCHAR(20)
  • eupmyeondong — VARCHAR(20)
  • ri — VARCHAR(20)

badge

  • id — BIGINT
  • name — VARCHAR(50)
  • description — VARCHAR(255)
  • image_url — VARCHAR(255)
  • created_at — DATETIME

checkpoint

  • checkpoint_id — BIGINT
  • post_id — BIGINT
  • latitude — DOUBLE
  • longitude — DOUBLE
  • memo — VARCHAR(100)
  • created_at — DATETIME
  • checkpoint_like — INT

checkpoint_comment

  • id — BIGINT
  • checkpoint_id — BIGINT
  • user_id — BIGINT
  • content — VARCHAR(1000)
  • created_at — DATETIME

checkpoint_like

  • checkpoint_id — BIGINT
  • user_id — BIGINT

checkpoint_photo

  • id — BIGINT
  • checkpoint_id — BIGINT
  • photo_url — TEXT
  • order — INT

checkpoint_visit

  • id — BIGINT
  • user_id — BIGINT
  • checkpoint_id — BIGINT
  • visited_at — DATETIME
  • earned_experience — INT
  • earned_point — INT

follow

  • follow_id — BIGINT
  • follower_id — BIGINT
  • following_id — BIGINT
  • created_at — DATETIME

follow_post

  • id — BIGINT
  • user_id — BIGINT
  • post_id — BIGINT
  • started_at — DATETIME
  • finished_at — DATETIME
  • completion_rate — DOUBLE
  • distance — INT
  • duration — INT
  • ghost_defeated — INT
  • treasure_found — INT
  • comment — VARCHAR(1000) — ARCHAR(1000

interest_area

  • area_id — BIGINT
  • user_id — BIGINT
  • area_code — VARCHAR(10)
  • priority — INT

notification

  • notification_id — BIGINT
  • user_id — BIGINT
  • type — VARCHAR(50)
  • message — TEXT
  • is_read — TINYINT(1)
  • created_at — DATETIME

post

  • post_id — BIGINT
  • user_id — BIGINT
  • title — VARCHAR(255)
  • content — TEXT
  • average_point — DOUBLE
  • post_like — INT
  • created_at — DATETIME
  • is_deleted — TINYINT(1)
  • thumbnail_url — TEXT

post_comment

  • id — BIGINT
  • post_id — BIGINT
  • user_id — BIGINT
  • content — VARCHAR(1000)
  • created_at — DATETIME

post_like

  • post_id — BIGINT
  • user_id — BIGINT

scrap

  • id — BIGINT
  • user_id — BIGINT
  • post_id — BIGINT

shop_item

  • id — BIGINT
  • name — VARCHAR(100)
  • type — VARCHAR(20)
  • price — INT
  • image_url — VARCHAR(255)

step_board

  • id — BIGINT
  • user_id — BIGINT
  • region_code — VARCHAR(10)
  • grid_count — INT
  • total_distance — INT
  • total_time — INT
  • created_at — DATETIME

user

  • user_id — BIGINT
  • email — VARCHAR(255)
  • password — VARCHAR(255)
  • name — VARCHAR(100)
  • nickname — VARCHAR(30)
  • profile_image — TEXT
  • exp — INT
  • point — INT
  • status — VARCHAR(20)
  • oauth_provider — VARCHAR(20)
  • oauth_id — VARCHAR(255)
  • created_at — DATETIME
  • updated_at — DATETIME

user_badge

  • id — BIGINT
  • user_id — BIGINT
  • badge_id — BIGINT
  • achieve_id — BIGINT
  • achieved_at — DATETIME

user_item

  • id — BIGINT
  • user_id — BIGINT
  • item_id — BIGINT
  • purchased_at — DATETIME
  • equipped — TINYINT(1)