K-Mate
Tables (8)
bookmark_items
- id — BIGINT
- list_id — BIGINT — NOT NULL
- place_id — BIGINT — NOT NULL
- note — VARCHAR(255)
- created_at — DATETIME — NOT NULL
bookmark_lists
- id — BIGINT
- user_id — BIGINT — NOT NULL
- name — VARCHAR(100) — NOT NULL
- description — VARCHAR(255)
- visibility — ENUM('private','unlisted','public') — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
comments
- id — BIGINT
- post_id — BIGINT — NOT NULL
- author_id — BIGINT — NOT NULL
- content — TEXT — NOT NULL
- status — ENUM('visible','hidden','removed') — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
places
- id — BIGINT
- type — ENUM('tourism', 'restaurant', 'cafe') — NOT NULL
- name — VARCHAR(255) — NOT NULL
- description — TEXT
- lat — DECIMAL(9,6) — NOT NULL
- lng — DECIMAL(9,6) — NOT NULL
- address — VARCHAR(255)
- phone — VARCHAR(50)
- website — VARCHAR(255)
- google_place_id — VARCHAR(128)
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
posts
- id — BIGINT
- type — ENUM('guide','trend') — NOT NULL
- author_id — BIGINT — NOT NULL
- title — VARCHAR(200) — NOT NULL
- slug — VARCHAR(200) — NOT NULL
- content — LONGTEXT — NOT NULL
- source_url — VARCHAR(1024)
- source_url_hash — BINARY(16)
- source_title — VARCHAR(300)
- source_desc — TEXT
- source_image_url — VARCHAR(1024)
- source_site_name — VARCHAR(200)
- source_author — VARCHAR(200)
- source_published_at — DATETIME
- visibility — ENUM('public','unlisted','private') — NOT NULL
- moderation_status — ENUM('visible','hidden','reported','removed') — NOT NULL
- status — ENUM('draft','published','archived') — NOT NULL
- published_at — DATETIME
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- trend_week_key — INT
user_post_likes
- id — BIGINT
- user_id — BIGINT — NOT NULL
- post_id — BIGINT — NOT NULL
- created_at — DATETIME — NOT NULL
user_post_scraps
- id — BIGINT
- user_id — BIGINT — NOT NULL
- post_id — BIGINT — NOT NULL
- note — VARCHAR(255)
- 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
- email_verified — TINYINT(1) — NOT NULL
- role — ENUM('user','admin') — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL