웹기술

테이블 (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