sinchonthon
Tables (7)
categories
- id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(30) — NOT NULL
- slug — VARCHAR(30) — NOT NULL
- icon_name — VARCHAR(50)
- sort_order — INT — NOT NULL
- is_active — BOOLEAN — NOT NULL
places
- id — BIGINT — Primary key — NOT NULL
- category_id — BIGINT — Foreign key → categories.id — NOT NULL
- created_by — BIGINT — Foreign key → users.id
- name — VARCHAR(150) — NOT NULL
- address — VARCHAR(255)
- latitude — DECIMAL(10, 7) — NOT NULL
- longitude — DECIMAL(10, 7) — NOT NULL
- phone — VARCHAR(30)
- external_source — VARCHAR(20) — kakao, naver, user
- external_place_id — VARCHAR(100)
- status — VARCHAR(20) — 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
- parent_comment_id — BIGINT — Foreign key → tip_comments.id
- content — TEXT — NOT NULL
- status — VARCHAR(20) — 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
- reaction_type — VARCHAR(20) — NOT NULL — helpful, inaccurate
- created_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
- title — VARCHAR(100) — NOT NULL
- content — TEXT — NOT NULL
- tip_type — VARCHAR(30) — NOT NULL — general, price, warning, discount, recommendation, job
- price — INT
- visited_at — DATE
- status — VARCHAR(20) — NOT NULL
- view_count — INT — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_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
- school_name — VARCHAR(100)
- is_school_verified — BOOLEAN — NOT NULL
- profile_image_url — VARCHAR(1000)
- trust_score — DECIMAL(5,2) — NOT NULL
- status — VARCHAR(20) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL