테스트

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