웹기술
테이블 (18)
ARTICLE
- article_id — BIGINT — 기본 키 — NOT NULL
- title — VARCHAR(255) — NOT NULL
- summary — TEXT
- original_url — VARCHAR(500) — NOT NULL
- category — VARCHAR(20) — NOT NULL
- difficulty — VARCHAR(10)
- published_at — DATE — NOT NULL
- created_at — DATETIME
ATTENDANCE
- attendance_id — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT — 외래 키 → USER.user_id — NOT NULL
- attend_date — DATE — NOT NULL
CHARACTER
- character_id — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT — 외래 키 → USER.user_id — NOT NULL
- level — INT
- exp — INT
- stage — VARCHAR(20)
- updated_at — DATETIME
FRIEND
- friend_id — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT — 외래 키 → USER.user_id — NOT NULL
- friend_user_id — BIGINT — 외래 키 → USER.user_id — NOT NULL
- created_at — DATETIME
GROUP
- group_id — BIGINT — 기본 키 — NOT NULL
- leader_id — BIGINT — 외래 키 → USER.user_id — NOT NULL
- name — VARCHAR(100) — NOT NULL
- is_public — BOOLEAN
- created_at — DATETIME
GROUP_GOAL
- goal_id — BIGINT — 기본 키 — NOT NULL
- group_id — BIGINT — 외래 키 → 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 — 기본 키 — NOT NULL
- group_id — BIGINT — 외래 키 → GROUP.group_id — NOT NULL
- user_id — BIGINT — 외래 키 → USER.user_id — NOT NULL
- status — VARCHAR(10)
- joined_at — DATETIME
GROUP_NOTICE
- notice_id — BIGINT — 기본 키 — NOT NULL
- group_id — BIGINT — 외래 키 → GROUP.group_id — NOT NULL
- title — VARCHAR(200) — NOT NULL
- content — TEXT — NOT NULL
- created_at — DATETIME
ITEM
- item_id — BIGINT — 기본 키 — NOT NULL
- name — VARCHAR(100) — NOT NULL
- type — VARCHAR(20) — NOT NULL
- price — INT — NOT NULL
- created_at — DATETIME
QUIZ
- quiz_id — BIGINT — 기본 키 — NOT NULL
- article_id — BIGINT — 외래 키 → ARTICLE.article_id — NOT NULL
- type — VARCHAR(20) — NOT NULL
- quiz_category — VARCHAR(10) — NOT NULL
- question — TEXT — NOT NULL
- answer — VARCHAR(255) — NOT NULL
- explanation — TEXT
- created_at — DATETIME
QUIZ_OPTION
- option_id — BIGINT — 기본 키 — NOT NULL
- quiz_id — BIGINT — 외래 키 → QUIZ.quiz_id — NOT NULL
- option_no — INT — NOT NULL
- content — VARCHAR(255) — NOT NULL
SCRAP_FOLDER
- folder_id — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT — 외래 키 → USER.user_id — NOT NULL
- name — VARCHAR(100) — NOT NULL
- created_at — DATETIME
STREAK
- streak_id — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT — 외래 키 → USER.user_id — NOT NULL
- streak_date — DATE — NOT NULL
- read_count — INT
USER
- user_id — BIGINT — 기본 키 — NOT NULL
- email — VARCHAR(100) — NOT NULL
- password — VARCHAR(255)
- nickname — VARCHAR(50) — NOT NULL
- age — INT
- birth — DATE
- gender — VARCHAR(10)
- social_type — VARCHAR(20)
- coin — INT
- created_at — DATETIME
USER_ARTICLE
- user_article_id — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT — 외래 키 → USER.user_id — NOT NULL
- article_id — BIGINT — 외래 키 → ARTICLE.article_id — NOT NULL
- is_read — BOOLEAN
- is_scraped — BOOLEAN
- read_at — DATETIME
USER_INTEREST
- interest_id — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT — 외래 키 → USER.user_id — NOT NULL
- category — VARCHAR(20) — NOT NULL
USER_ITEM
- user_item_id — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT — 외래 키 → USER.user_id — NOT NULL
- item_id — BIGINT — 외래 키 → ITEM.item_id — NOT NULL
- is_equipped — BOOLEAN
- purchased_at — DATETIME
USER_QUIZ
- user_quiz_id — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT — 외래 키 → USER.user_id — NOT NULL
- quiz_id — BIGINT — 외래 키 → QUIZ.quiz_id — NOT NULL
- is_correct — BOOLEAN — NOT NULL
- solved_at — DATETIME