사슬골드채굴모바일앱
테이블 (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