sinchonthon
Tables (8)
categories
- id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(30) — NOT NULL
places
- id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(150) — NOT NULL
- address — VARCHAR(255)
- latitude — DECIMAL(10,7) — NOT NULL
- longitude — DECIMAL(10,7) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
tip_comments
- id — BIGINT — Primary key — NOT NULL
- tip_id — BIGINT — Foreign key → tips.id — NOT NULL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- content — TEXT — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
tip_reactions
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- tip_id — BIGINT — Foreign key → tips.id — NOT NULL
- is_like — BOOLEAN — NOT NULL — TRUE: 좋아요, FALSE: 싫어요
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
tip_scraps
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- tip_id — BIGINT — Foreign key → tips.id — NOT NULL
- created_at — DATETIME — NOT NULL
tips
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- place_id — BIGINT — Foreign key → places.id — NOT NULL
- category_id — BIGINT — Foreign key → categories.id — NOT NULL
- title — VARCHAR(100) — NOT NULL
- content — TEXT — NOT NULL — 가격 정보도 본문에 작성
- visited_at — DATE
- valid_until — DATETIME — NOT NULL — 등록 시 created_at 기준 1년 후 저장
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
user_follows
- follower_id — BIGINT — Foreign key → users.id — NOT NULL — 팔로우하는 사용자
- following_id — BIGINT — Foreign key → users.id — NOT NULL — 팔로우 대상 사용자
- created_at — DATETIME — NOT NULL
users
- id — BIGINT — Primary key — NOT NULL
- email — VARCHAR(255) — NOT NULL
- password_hash — VARCHAR(255) — NOT NULL
- nickname — VARCHAR(30) — NOT NULL
- trust_score — DECIMAL(5,2) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL