zi존 백엔드
테이블 (8)
Comment
- id — BIGINT — 기본 키
- user_id — BIGINT — NOT NULL
- post_id — BIGINT — NOT NULL
- content — TEXT — NOT NULL
- created_at — DATETIME
- updated_at — DATETIME
Follow
- id — BIGINT — 기본 키
- follower_id — BIGINT — NOT NULL
- following_id — BIGINT — NOT NULL
- created_at — DATETIME
- UNIQUE(follower_id, — following_id)
Like
- id — BIGINT — 기본 키
- user_id — BIGINT — NOT NULL
- post_id — BIGINT — NOT NULL
- created_at — DATETIME
- UNIQUE(user_id, — post_id)
Place
- id — BIGINT — 기본 키
- name — VARCHAR(255) — NOT NULL
- category — VARCHAR(100) — NOT NULL
- latitude — DECIMAL(10,8) — NOT NULL
- longitude — DECIMAL(11,8) — NOT NULL
- created_at — DATETIME
Post
- id — BIGINT — 기본 키
- user_id — BIGINT — NOT NULL
- title — VARCHAR(255) — NOT NULL
- content — TEXT — NOT NULL
- image_url — VARCHAR(500)
- latitude — DECIMAL(10,8)
- longitude — DECIMAL(11,8)
- place_id — BIGINT
- created_at — DATETIME
- updated_at — DATETIME
Ranking
- id — BIGINT
- place_id — BIGINT — NOT NULL
- post_id — BIGINT — NOT NULL
- like_count — INT — NOT NULL
- period — ENUM('1개월', '3개월', '6개월') — NOT NULL
- created_at — DATETIME
Scrap
- id — BIGINT — 기본 키
- user_id — BIGINT — NOT NULL
- post_id — BIGINT — NOT NULL
- created_at — DATETIME
- UNIQUE(user_id, — post_id)
User
- id — BIGINT — 기본 키
- email — VARCHAR(255) — NOT NULL
- nickname — VARCHAR(50) — NOT NULL
- profile_image_url — VARCHAR(500)
- provider — ENUM('naver', 'google', 'local') — NOT NULL
- created_at — DATETIME
- updated_at — DATETIME