테스트
테이블 (6)
Admin
- admin_id — BIGINT — 기본 키 — NOT NULL
- username — VARCHAR(50) — NOT NULL
- email — VARCHAR(100) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- role — ENUM('admin', 'superadmin') — NOT NULL
Badge
- badge_id — BIGINT — 기본 키
- name — VARCHAR(50) — NOT NULL
- description — VARCHAR(255) — NOT NULL
- image_url — VARCHAR(255) — NOT NULL
Mission
- mission_id — BIGINT — 기본 키
- title — VARCHAR(100) — NOT NULL
- description — TEXT — NOT NULL
- points_reward — INT — NOT NULL
- badge_reward — BIGINT
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- badge_id — BIGINT — 외래 키 → Badge.badge_id
- campaign_id — BIGINT — 외래 키
User
- user_id — BIGINT — 기본 키
- username — VARCHAR(50) — NOT NULL
- email — VARCHAR(100) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- points — INT — NOT NULL
- rank — INT
- created_at — DATETIME — NOT NULL
User_Badge
- user_badge_id — BIGINT — 기본 키
- user_id — BIGINT — 외래 키 → User.user_id
- badge_id — BIGINT — 외래 키 → Badge.badge_id
- earned_at — DATETIME — NOT NULL
User_Mission
- user_mission_id — BIGINT — 기본 키
- admin_id — BIGINT — 외래 키 → Admin.admin_id
- user_id (user_id2) — BIGINT — 외래 키 → User.user_id
- mission_id — BIGINT — 외래 키 → Mission.mission_id
- status — ENUM('진행중', '승인대기', '승인완료', '반려') — NOT NULL
- proof_image_url — VARCHAR(255)
- proof_text — TEXT
- submitted_at — DATETIME — NOT NULL
- approved_at — DATETIME
- approver_id — BIGINT