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