web-pocket

Tables (4)

bookmarks

  • bookmark_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • website_id — BIGINT — Foreign key → websites.website_id — NOT NULL
  • created_at — DATETIME

comments

  • comment_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • website_id — BIGINT — Foreign key → websites.website_id — NOT NULL
  • parent_comment_id — BIGINT — Foreign key → comments.comment_id
  • content — TEXT — NOT NULL
  • created_at — DATETIME

users

  • user_id — BIGINT — Primary key — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • nickname — VARCHAR(50) — NOT NULL
  • role — VARCHAR(20)
  • profile_image — VARCHAR(500)
  • refresh_token — VARCHAR(255)
  • provider — VARCHAR(20)
  • provider_id — VARCHAR(255)
  • created_at — DATETIME

websites

  • website_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • title — VARCHAR(100) — NOT NULL
  • url — VARCHAR(500) — NOT NULL
  • description — TEXT
  • logo_url — VARCHAR(500)
  • category — VARCHAR(50)
  • view_count — BIGINT
  • bookmark_count — BIGINT
  • comment_count — BIGINT
  • status — VARCHAR(20)
  • created_at — DATETIME