ㄴㄴㄴ
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)