K_Mate
Tables (7)
bookmarks
- id — BIGINT
- user_id — BIGINT — NOT NULL
- place_id — BIGINT — NOT NULL
- created_at — DATETIME — NOT NULL
comments
- id — BIGINT
- post_id — BIGINT — NOT NULL
- author_id — BIGINT — NOT NULL
- content — TEXT — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
likes
- id — BIGINT
- user_id — BIGINT — NOT NULL
- post_id — BIGINT — NOT NULL
- created_at — DATETIME — NOT NULL
places
- id — BIGINT
- type — ENUM('travel', 'food', 'cafe') — NOT NULL
- name — VARCHAR(255) — NOT NULL
- description — TEXT
- google_place_id — VARCHAR(255)
- lat — DECIMAL(9,6) — NOT NULL
- lng — DECIMAL(9,6) — NOT NULL
- address — VARCHAR(255)
- phone — VARCHAR(50)
- website — VARCHAR(255)
posts
- id — BIGINT
- type — ENUM('buzz','trend','tips') — NOT NULL
- author_id — BIGINT — NOT NULL
- title — VARCHAR(200) — NOT NULL
- content — LONGTEXT — NOT NULL
- buzz_category — ENUM('travel_tip', 'food_review', 'cafe_review', 'general')
- trend_week — INT
- tips_region — VARCHAR(100)
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
scraps
- id — BIGINT
- user_id — BIGINT — NOT NULL
- post_id — BIGINT — NOT NULL
- created_at — DATETIME — NOT NULL
users
- id — BIGINT
- email — VARCHAR(255) — NOT NULL
- name — VARCHAR(100) — NOT NULL
- avatar_url — VARCHAR(512)
- google_sub — VARCHAR(64) — NOT NULL
- role — ENUM('user','admin') — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL