fd

Tables (21)

Post

  • post_id — INT — Primary key — NOT NULL
  • user_id — INT — NOT NULL
  • title — VARCHAR(255)
  • content — TEXT — NOT NULL
  • average_point — DOUBLE — NOT NULL
  • post_like — INT — NOT NULL
  • post_date — DATETIME — NOT NULL
  • is_deleted — BOOLEAN — NOT NULL
  • representative_image — TEXT

achievement

  • id — INT — Primary key — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • description — VARCHAR(255) — NOT NULL
  • condition_type — VARCHAR(100) — NOT NULL
  • reward_type — VARCHAR(20) — NOT NULL
  • reward_value — VARCHAR(50) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

area

  • code — VARCHAR(10) — Primary key — NOT NULL
  • sido — VARCHAR(20) — NOT NULL
  • sigungu — VARCHAR(20) — NOT NULL
  • eupmyeondong — VARCHAR(20) — NOT NULL
  • ri — VARCHAR(20)

badge

  • id — INT — Primary key — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • description — VARCHAR(255) — NOT NULL
  • image_url — VARCHAR(255) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

checkpoint

  • checkpoint_id — INT — Primary key — NOT NULL
  • post_id — INT — NOT NULL
  • latitude — DOUBLE — NOT NULL
  • longitude — DOUBLE — NOT NULL
  • memo — VARCHAR(100)
  • created_date — DATETIME — NOT NULL
  • checkpoint_like — INT — NOT NULL

checkpoint_comment

  • id — INT — Primary key — NOT NULL
  • checkpoint_id — INT — NOT NULL
  • user_id — INT — NOT NULL
  • content — VARCHAR(255)
  • created_at — TIMESTAMP — NOT NULL

checkpoint_like

  • checkpoint_id — INT — Primary key — NOT NULL
  • user_id — INT — Primary key — NOT NULL

checkpoint_photo

  • checkpoint_id — INT — Primary key — NOT NULL
  • order_no — INT — Primary key — NOT NULL
  • photo_url — TEXT — NOT NULL

checkpoint_visit

  • id — INT — Primary key — NOT NULL
  • user_id — INT — NOT NULL
  • checkpoint_id — INT — NOT NULL
  • visited_at — TIMESTAMP — NOT NULL
  • earned_experience — INT — NOT NULL
  • earned_point — INT — NOT NULL

follow

  • follow_id — INT — Primary key — NOT NULL
  • follower_id — INT — NOT NULL
  • following_id — INT — NOT NULL
  • created_at — DATETIME — NOT NULL

follow_post

  • id — INT — Primary key — NOT NULL
  • user_id — INT — NOT NULL
  • post_id — INT — NOT NULL
  • started_at — TIMESTAMP — NOT NULL
  • finished_at — TIMESTAMP
  • completion_rate — DOUBLE — NOT NULL
  • distance — INT — NOT NULL
  • duration — INT — NOT NULL
  • ghost_defeated — INT — NOT NULL
  • treasure_found — INT — NOT NULL
  • comment — VARCHAR(255)
  • is_completed — BOOLEAN — NOT NULL
  • total_point — INT — NOT NULL
  • total_exp — INT — NOT NULL

interest_area

  • area_id — INT — Primary key — NOT NULL
  • user_id — INT — NOT NULL
  • priority — INT — NOT NULL
  • area_code — VARCHAR(10) — NOT NULL
  • CHECK — (`priority` BETWEEN 1 AND 3)

notification

  • notification_id — INT — Primary key — NOT NULL
  • user_id — INT — NOT NULL
  • type — VARCHAR(50) — NOT NULL
  • message — TEXT — NOT NULL
  • is_read — BOOLEAN — NOT NULL
  • created_at — DATETIME — NOT NULL

post_comment

  • id — INT — Primary key — NOT NULL
  • post_id — INT — NOT NULL
  • user_id — INT — NOT NULL
  • content — VARCHAR(255)
  • created_at — TIMESTAMP — NOT NULL

post_like

  • post_id — INT — Primary key — NOT NULL
  • user_id — INT — Primary key — NOT NULL

scrap

  • id — INT — Primary key — NOT NULL
  • user_id — INT — NOT NULL
  • post_id — INT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

shop_item

  • id — INT — Primary key — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • type — VARCHAR(20) — NOT NULL
  • price — INT — NOT NULL
  • image_url — VARCHAR(255) — NOT NULL

step_board

  • id — INT — Primary key — NOT NULL
  • user_id — INT — NOT NULL
  • region_code — VARCHAR(100) — NOT NULL
  • grid_count — INT — NOT NULL
  • total_distance — INT — NOT NULL
  • total_time — INT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

user

  • user_id — INT — Primary key — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • nickname — VARCHAR(30) — NOT NULL
  • profile_image — TEXT
  • exp — INT — NOT NULL
  • point — INT — NOT NULL
  • status — ENUM('ACTIVE','SUSPENDED','DELETED') — NOT NULL
  • oauth_provider — ENUM('KAKAO','NAVER','GOOGLE')
  • oauth_id — VARCHAR(255)
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL

user_badge

  • id — INT — Primary key — NOT NULL
  • user_id — INT — NOT NULL
  • badge_id — INT — NOT NULL
  • achieved_at — TIMESTAMP — NOT NULL
  • achieve_id — INT — NOT NULL

user_item

  • id — INT — Primary key — NOT NULL
  • user_id — INT — NOT NULL
  • item_id — INT — NOT NULL
  • purchased_at — TIMESTAMP — NOT NULL
  • equipped — BOOLEAN — NOT NULL