ㅇ
Tables (21)
achievement
- id — BIGINT
- 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)
- sido — VARCHAR(20) — NOT NULL
- sigungu — VARCHAR(20) — NOT NULL
- eupmyeondong — VARCHAR(20) — NOT NULL
- ri — VARCHAR(20)
badge
- id — BIGINT
- name — VARCHAR(50) — NOT NULL
- description — VARCHAR(255) — NOT NULL
- image_url — VARCHAR(255) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
checkpoint
- checkpoint_id — BIGINT
- post_id — BIGINT — NOT NULL
- latitude — DOUBLE — NOT NULL
- longitude — DOUBLE — NOT NULL
- memo — VARCHAR(100)
- created_at — TIMESTAMP — NOT NULL
- checkpoint_like — INT — NOT NULL
checkpoint_comment
- id — BIGINT
- checkpoint_id — BIGINT — NOT NULL
- user_id — BIGINT — NOT NULL
- content — VARCHAR(1000) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
checkpoint_like
- checkpoint_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Primary key — NOT NULL
checkpoint_photo
- id — BIGINT
- checkpoint_id — BIGINT — NOT NULL
- photo_url — TEXT — NOT NULL
- order — INT
checkpoint_visit
- id — BIGINT
- user_id — BIGINT — NOT NULL
- checkpoint_id — BIGINT — NOT NULL
- visited_at — TIMESTAMP — NOT NULL
- earned_experience — INT — NOT NULL
- earned_point — INT — NOT NULL
follow
- follow_id — BIGINT
- follower_id — BIGINT — NOT NULL
- following_id — BIGINT — NOT NULL
- created_at — TIMESTAMP — NOT NULL
follow_post
- id — BIGINT
- user_id — BIGINT — NOT NULL
- post_id — BIGINT — 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(1000) — ARCHAR(1000
interest_area
- area_id — BIGINT
- user_id — BIGINT — NOT NULL
- area_code — VARCHAR(10) — NOT NULL
- priority — INT — NOT NULL
notification
- notification_id — BIGINT
- user_id — BIGINT — NOT NULL
- type — VARCHAR(50) — NOT NULL
- message — TEXT — NOT NULL
- is_read — BOOLEAN — NOT NULL
- created_at — TIMESTAMP — NOT NULL
post
- post_id — BIGINT
- user_id — BIGINT — NOT NULL
- title — VARCHAR(255)
- content — TEXT — NOT NULL
- average_point — DOUBLE
- post_like — INT — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- is_deleted — BOOLEAN — NOT NULL
- thumbnail_url — TEXT
post_comment
- id — BIGINT
- post_id — BIGINT — NOT NULL
- user_id — BIGINT — NOT NULL
- content — VARCHAR(1000) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
post_like
- post_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Primary key — NOT NULL
scrap
- id — BIGINT
- user_id — BIGINT — NOT NULL
- post_id — BIGINT — NOT NULL
- created_at — TIMESTAMP — NOT NULL
shop_item
- id — BIGINT
- name — VARCHAR(100) — NOT NULL
- type — VARCHAR(20) — NOT NULL
- price — INT — NOT NULL
- image_url — VARCHAR(255) — NOT NULL
step_board
- id — BIGINT
- user_id — BIGINT — NOT NULL
- region_code — VARCHAR(10) — 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 — BIGINT
- 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 — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
user_badge
- id — BIGINT
- user_id — BIGINT — NOT NULL
- badge_id — BIGINT — NOT NULL
- achieve_id — BIGINT — NOT NULL
- achieved_at — TIMESTAMP — NOT NULL
user_item
- id — BIGINT
- user_id — BIGINT — NOT NULL
- item_id — BIGINT — NOT NULL
- purchased_at — TIMESTAMP — NOT NULL
- equipped — BOOLEAN — NOT NULL