사슬골드채굴모바일앱

테이블 (3)

MiningSession (session_logs)

  • id — bigint — 기본 키 — NOT NULL
  • user_id — bigint — 외래 키 → User.id — NOT NULL
  • start_time — timestamp
  • end_time — timestamp
  • duration — int
  • status — enum
  • device_info — varchar(150)
  • ip_hash — char(64)
  • avg_hashrate — numeric(30,8)
  • total_reward — numeric(30, 8)

RewardLog (reward_logs)

  • id (Key) — bigint — 기본 키 — NOT NULL
  • session_id — bigint — 외래 키 → MiningSession.id — NOT NULL
  • user_id — bigint — 외래 키 → MiningSession.user_id — NOT NULL
  • reward_amount — numeric(30, 8)
  • reward_time — timestamp
  • tx_hash — char(64)

User (users)

  • id — bigint — 기본 키 — NOT NULL
  • wallet_address_hash — char(64)
  • is_mining — boolean
  • is_blocked — boolean
  • is_admin — boolean
  • created_at — timestamp
  • updated_at — timestamp