WelfarePrize.php 726 B

123456789101112131415161718192021222324
  1. <?php
  2. namespace App\Modules\Welfare\Models;
  3. use Illuminate\Database\Eloquent\Model;
  4. /*
  5. CREATE TABLE `welfare_prizes` (
  6. `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  7. `channel_user_id` int(11) NOT NULL COMMENT '账号ID',
  8. `date` date NOT NULL,
  9. `num` int(11) NOT NULL DEFAULT '0' COMMENT '总数量',
  10. `left` int(11) NOT NULL DEFAULT '0' COMMENT '剩余数量',
  11. `created_at` datetime NOT NULL,
  12. `updated_at` datetime NOT NULL,
  13. PRIMARY KEY (`id`),
  14. KEY `uid-date-ink` (`channel_user_id`,`date`)
  15. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='分销登录奖励表';
  16. */
  17. class WelfarePrize extends Model
  18. {
  19. protected $table = 'welfare_prizes';
  20. protected $fillable = ['channel_user_id','date','num','left'];
  21. }