Finsight
Tables (11)
User (users)
- id (Key) — BIGINT — Primary key — NOT NULL
- email (Field) — VARCHAR(255) — NOT NULL
- nickname (Field2) — VARCHAR(50) — NOT NULL
- profile_image_url (Field3) — TEXT
- created_at (Field4) — TIMESTAMP
article_terms
- id (Key) — BIGINT — Primary key — NOT NULL
- article_id (FK) — BIGINT — Foreign key → articles.id — NOT NULL
- term_id (Fk2) — BIGINT — Foreign key → terms.id — NOT NULL
articles
- id (Key) — BIGINT — Primary key — NOT NULL
- title (Field) — VARCHAR(255) — NOT NULL
- content (Field2) — LONGTEXT — NOT NULL
- category (Field3) — VARCHAR(50) — NOT NULL
- source_url (Field4) — TEXT — NOT NULL
- reporter (Field5) — VARCHAR(100)
- published_at (Field6) — DATETIME — NOT NULL
- created_at (Field7) — TIMESTAMP
quiz_questions
- id (Key) — BIGINT — Primary key — NOT NULL
- quiz_id (FK) — BIGINT — Foreign key → quizzes.id — NOT NULL
- question_text (Field) — TEXT — NOT NULL
- options (Field2) — JSON — NOT NULL
- answer (Field3) — INT — NOT NULL
- created_at (Field4) — TIMESTAMP
quizzes
- id (Key) — BIGINT — Primary key — NOT NULL
- article_id (FK) — BIGINT — Foreign key → articles.id — NOT NULL
- type (Field) — VARCHAR(20) — NOT NULL
- created_at (Field2) — TIMESTAMP
terms
- id (Key) — BIGINT — Primary key — NOT NULL
- name (Field) — VARCHAR(100) — NOT NULL
- description (Field2) — TEXT — NOT NULL
- created_at (Field3) — TIMESTAMP
user_article_views
- id (Key) — BIGINT — Primary key — NOT NULL
- user_id (FK) — BIGINT — Foreign key → User.id — NOT NULL
- article_id (FK2) — BIGINT — Foreign key → articles.id — NOT NULL
- created_at (Field) — TIMESTAMP — NOT NULL
user_auths
- id (Key) — BIGINT — Primary key — NOT NULL
- user_id (FK) — BIGINT — Foreign key → User.id — NOT NULL
- provider_user_id (Field) — VARCHAR(255)
- created_at (Field2) — TIMESTAMP
user_collections
- id (Key) — BIGINT — Primary key — NOT NULL
- user_id (FK) — BIGINT — Foreign key → User.id — NOT NULL
- type (Field) — VARCHAR(20) — NOT NULL
- target_id (Field2) — BIGINT — NOT NULL
- created_at (Field3) — TIMESTAMP
user_interests
- id (Key) — BIGINT — Primary key — NOT NULL
- user_id (FK) — BIGINT — Foreign key → User.id — NOT NULL
- category (Field) — VARCHAR(50) — NOT NULL
user_quiz_results
- id (Key) — BIGINT — Primary key — NOT NULL
- user_id (FK) — BIGINT — Foreign key → User.id — NOT NULL
- quiz_id (Fk2) — BIGINT — Foreign key → quizzes.id — NOT NULL
- score (Field) — INT — NOT NULL
- created_at (Field2) — TIMESTAMP