Nuzip

Tables (11)

category

  • id — BIGINT(20) — Primary key — NOT NULL
  • is_active_for_collection — BIT(1) — NOT NULL
  • name — VARCHAR(255) — NOT NULL

email_verification_tokens

  • id — BIGINT(20) — Primary key — NOT NULL
  • code — VARCHAR(12) — NOT NULL
  • consumed — BIT(1) — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • email — VARCHAR(120) — NOT NULL
  • expires_at — DATETIME(6) — NOT NULL
  • verified — BIT(1) — NOT NULL
  • verified_at — DATETIME(6)
  • id (id2) — BIGINT(20) — Foreign key → users.id — NOT NULL

gemini_log

  • id — INT(11) — Primary key — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • keywords — VARCHAR(1000)
  • request_content — TEXT
  • response_content — TEXT
  • summary — TEXT
  • id (id2) — BIGINT(20) — Foreign key → users.id — NOT NULL

memos

  • id — BIGINT(20) — Primary key — NOT NULL
  • content — VARCHAR(2000) — NOT NULL
  • created_at — DATETIME(6)
  • updated_at — DATETIME(6)
  • user_id — VARCHAR(255)
  • scrap_id — BIGINT(20) — NOT NULL
  • INDEX — `FKocj3j4id9yaw2v20ogjid4u9n`
  • id (id2) — BIGINT(20) — Foreign key → users.id — NOT NULL
  • id (id3) — BIGINT(20) — Foreign key → scraps.id — NOT NULL

news_article

  • id — BIGINT(20) — Primary key — NOT NULL
  • collected_at — DATETIME(6)
  • published_at — DATETIME(6)
  • original_link — VARCHAR(500) — NOT NULL
  • category — VARCHAR(255)
  • image_url — VARCHAR(255)
  • keywords — TEXT
  • summary — TEXT
  • title — VARCHAR(255)
  • created_at — DATETIME(6) — NOT NULL
  • sub_category — TEXT
  • summarized_content — TEXT
  • category_id — VARCHAR(255)
  • id (id2) — BIGINT(20) — Foreign key → users.id — NOT NULL
  • id (id3) — BIGINT(20) — Foreign key → category.id — NOT NULL

notification

  • id — BIGINT(20) — Primary key — NOT NULL
  • article_id — BIGINT(20)
  • created_at — DATETIME(6)
  • is_read — BIT(1) — NOT NULL
  • message — VARCHAR(255)
  • user_id — VARCHAR(100)
  • id (id2) — BIGINT(20) — Foreign key → users.id — NOT NULL

scraps

  • id — BIGINT(20) — Primary key — NOT NULL
  • created_at — DATETIME(6)
  • summary — VARCHAR(255)
  • title — VARCHAR(255)
  • updated_at — DATETIME(6)
  • url — VARCHAR(255)
  • user_id — VARCHAR(255)
  • id (id2) — BIGINT(20) — Foreign key → users.id — NOT NULL

star_ratings

  • id — BIGINT(20) — Primary key — NOT NULL
  • created_at — DATETIME(6)
  • feedback — VARCHAR(255)
  • rating — INT(11)
  • scrap_id — BIGINT(20)
  • updated_at — DATETIME(6)
  • user_id — VARCHAR(255)
  • id (id2) — BIGINT(20) — Foreign key → users.id — NOT NULL

subscription

  • id — BIGINT(20) — Primary key — NOT NULL
  • category_id — BIGINT(20)
  • created_at — DATETIME(6)
  • user_id — VARCHAR(255)
  • id (id2) — BIGINT(20) — Foreign key → users.id — NOT NULL
  • id (id3) — BIGINT(20) — Foreign key → category.id — NOT NULL

user_categories

  • user_id — VARCHAR(100) — NOT NULL
  • category — ENUM('ECONOMY','ENTERTAINMENT','IT_SCIENCE','LIFE_CULTURE','POLITICS','SOCIETY','SPORTS','WORLD')
  • INDEX — `FKdqpxght56isds8smi1frxg0xo`
  • id (id2) — BIGINT(20) — Foreign key → category.id — NOT NULL
  • id (id3) — BIGINT(20) — Foreign key → users.id — NOT NULL
  • id (id4) — BIGINT(20) — Foreign key → users.id — NOT NULL

users

  • id — BIGINT(20) — Primary key — NOT NULL
  • birth_date — DATE
  • password — VARCHAR(255) — NOT NULL
  • phone — VARCHAR(11)
  • provider — ENUM('LOCAL','OAUTH_GOOGLE','OAUTH_NAVER') — NOT NULL
  • username — VARCHAR(50) — NOT NULL
  • email_verified — BIT(1) — NOT NULL
  • user_id — VARCHAR(100) — NOT NULL