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