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