DevPhone_erd

테이블 (9)

BADGE(뱃지시스템) (BADGE)

  • badge_id — INT{PK}
  • name — VARCHAR(50) — NOT NULL
  • description — TEXT
  • image_url — VARCHAR(255)

CHARACTER(게임 캐릭터 관리) (CHARACTER)

  • user_id — INT — 외래 키 → USER(사용자 관리).user_id — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • level — INT
  • exp_points — INT
  • created_at — TIMESTAMP

MISSION(금융 미션 관리) (MISSION)

  • user_id — INT — 외래 키 → USER(사용자 관리).user_id — NOT NULL
  • question — TEXT — NOT NULL
  • correct_answer — TEXT — NOT NULL
  • difficulty_level — INT — NOT NULL
  • category — VARCHAR(50) — NOT NULL
  • created_at — TIMESTAMP

QUIZ_ATTEMPT(퀴즈 참여 기록) (QUIZ_ATTEMPT)

  • attempt_id — INT — 기본 키 — NOT NULL
  • user_id (user_id2) — INT — 외래 키 → MISSION(금융 미션 관리).user_id — NOT NULL
  • is_correct — BOOLEAN — NOT NULL
  • attempt_date — TIMESTAMP
  • points_earned — INT

STOCK_REPORT(주식거래결과리포트) (STOCK_REPORT)

  • report_id — INT — 기본 키 — NOT NULL
  • user_id — INT — 외래 키 → VIRTUAL_ACCOUNT(가상계좌).user_id — NOT NULL
  • score — INT
  • content — VARCHAR(255)
  • created_at — TIMESTAMP

USER(사용자 관리) (USER)

  • user_id — INT — 기본 키 — NOT NULL
  • username — VARCHAR(50) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • phone — VARCHAR(20)
  • birth_date — DATE — NOT NULL
  • age_section — INT
  • created_at — TIMESTAMP

USER_BADGE(사용자 뱃지) (USER_BADGE)

  • badge_id — INT — 기본 키 — NOT NULL
  • user_id — INT — 외래 키 → CHARACTER(게임 캐릭터 관리).user_id — NOT NULL
  • earned_date — TIMESTAMP

VIRTUAL_ACCOUNT(가상계좌) (VIRTUAL_ACCOUNT)

  • user_id — INT — 외래 키 → USER(사용자 관리).user_id — NOT NULL
  • account_id — INT{PK}
  • account_number — VARCHAR(20) — NOT NULL
  • balance — DECIMAL(15,2)
  • created_at — TIMESTAMP

VOICE_COMMAND(라즈베리파이용) (VOICE_COMMAND)

  • command_id — INT{PK}
  • user_id — INT{FK} — NOT NULL
  • command_text — TEXT — NOT NULL
  • recorded_at — TIMESTAMP
  • status — VARCHAR(20)