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