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)