NewsPace

Tables (15)

ARTICLE

  • article_id — BIGINT — Primary key — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • summary — TEXT — NOT NULL
  • original_url — VARCHAR(500) — NOT NULL
  • thumbnail_url — VARCHAR(500)
  • category — VARCHAR(20) — NOT NULL
  • source — VARCHAR(50) — NOT NULL
  • published_at — DATE — NOT NULL
  • created_at — DATETIME

ATTENDANCE

  • attendance_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → USER.user_id — NOT NULL
  • attend_date — DATE — NOT NULL
  • continuous_days — INT

CHARACTER

  • character_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → USER.user_id — NOT NULL
  • level — INT
  • exp — INT
  • max_exp — INT
  • stage — VARCHAR(20)
  • updated_at — DATETIME

GROUP

  • group_id — BIGINT — Primary key — NOT NULL
  • leader_id — BIGINT — Foreign key → USER.user_id — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • is_public — BOOLEAN
  • invite_code — VARCHAR(20) — NOT NULL
  • created_at — DATETIME

GROUP_GOAL

  • goal_id — BIGINT — Primary key — NOT NULL
  • group_id — BIGINT — Foreign key → GROUP.group_id — NOT NULL
  • description — VARCHAR(255) — NOT NULL
  • target_count — INT — NOT NULL
  • current_count — INT
  • start_date — DATE — NOT NULL
  • end_date — DATE — NOT NULL
  • is_achieved — BOOLEAN

GROUP_MEMBER

  • group_member_id — BIGINT — Primary key — NOT NULL
  • group_id — BIGINT — Foreign key → GROUP.group_id — NOT NULL
  • user_id — BIGINT — Foreign key → USER.user_id — NOT NULL
  • status — VARCHAR(10)
  • joined_at — DATETIME

ITEM

  • item_id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • type — VARCHAR(20) — NOT NULL
  • price — INT — NOT NULL
  • is_event — BOOLEAN
  • created_at — DATETIME

QUIZ

  • quiz_id — BIGINT — Primary key — NOT NULL
  • article_id — BIGINT — Foreign key → ARTICLE.article_id — NOT NULL
  • question — TEXT — NOT NULL
  • answer — INT — NOT NULL
  • explanation — TEXT — NOT NULL
  • quiz_date — DATE — NOT NULL
  • created_at — DATETIME

QUIZ_OPTION

  • option_id — BIGINT — Primary key — NOT NULL
  • quiz_id — BIGINT — Foreign key → QUIZ.quiz_id — NOT NULL
  • option_no — INT — NOT NULL
  • content — VARCHAR(255) — NOT NULL

STREAK

  • streak_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → USER.user_id — NOT NULL
  • streak_date — DATE — NOT NULL
  • read_count — INT

USER

  • user_id — BIGINT — Primary key — NOT NULL
  • nickname — VARCHAR(10) — NOT NULL
  • birth — DATE — NOT NULL
  • gender — VARCHAR(10) — NOT NULL
  • social_type — VARCHAR(20) — NOT NULL
  • coin — INT
  • created_at — DATETIME

USER_ARTICLE

  • user_article_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → USER.user_id — NOT NULL
  • article_id — BIGINT — Foreign key → ARTICLE.article_id — NOT NULL
  • is_read — BOOLEAN
  • is_scraped — BOOLEAN
  • read_at — DATETIME
  • scraped_at — DATETIME

USER_INTEREST

  • interest_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → USER.user_id — NOT NULL
  • category — VARCHAR(20) — NOT NULL

USER_ITEM

  • user_item_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → USER.user_id — NOT NULL
  • item_id — BIGINT — Foreign key → ITEM.item_id — NOT NULL
  • is_equipped — BOOLEAN
  • purchased_at — DATETIME

USER_QUIZ

  • user_quiz_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → USER.user_id — NOT NULL
  • quiz_id — BIGINT — Foreign key → QUIZ.quiz_id — NOT NULL
  • selected_no — INT — NOT NULL
  • is_correct — BOOLEAN — NOT NULL
  • solved_at — DATETIME