# This is an auto-generated Django model module.
# You'll have to do the following manually to clean this up:
#   * Rearrange models' order
#   * Make sure each model has one field with primary_key=True
#   * Make sure each ForeignKey has `on_delete` set to the desired behavior.
#   * Remove `managed = False` lines if you wish to allow Django to create, modify, and delete the table
# Feel free to rename the models, but don't rename db_table values or field names.
from django.db import models


class Favorite(models.Model):   #用户收藏
    user = models.ForeignKey('User', models.DO_NOTHING, blank=True, null=True)
    gameid = models.ForeignKey('Gamedetails', models.DO_NOTHING, db_column='gameid', blank=True, null=True)
    invitation = models.ForeignKey('Invitation', models.DO_NOTHING, blank=True, null=True)

    class Meta:

        db_table = 'favorite'


class Fenlei(models.Model):    #游戏分类
    fid = models.AutoField(primary_key=True)
    fname = models.CharField(max_length=20, blank=True, null=True)

    class Meta:

        db_table = 'fenlei'


class Gamedetails(models.Model):    #游戏详情
    gameid = models.AutoField(primary_key=True)
    gamename = models.CharField(max_length=10, blank=True, null=True)
    fid = models.ForeignKey(Fenlei, models.DO_NOTHING, db_column='fid', blank=True, null=True)
    gamescore = models.FloatField(blank=True, null=True)
    gameclass = models.CharField(max_length=20, blank=True, null=True)
    gamecont = models.CharField(max_length=20, blank=True, null=True)
    gamecomments = models.CharField(max_length=20, blank=True, null=True)
    gameversion = models.CharField(max_length=20, blank=True, null=True)
    gamememory = models.CharField(max_length=20, blank=True, null=True)
    gamerequire = models.CharField(max_length=20, blank=True, null=True)
    gametime = models.CharField(max_length=20, blank=True, null=True)
    gamelanguage = models.CharField(max_length=20, blank=True, null=True)

    class Meta:

        db_table = 'gamedetails'


class Gameimage(models.Model):   #游戏图片
    gameid = models.ForeignKey(Gamedetails, models.DO_NOTHING, db_column='gameid', blank=True, null=True)
    topimage = models.CharField(max_length=20, blank=True, null=True)
    simage = models.CharField(max_length=20, blank=True, null=True)
    imageone = models.CharField(max_length=20, blank=True, null=True)
    imagetwo = models.CharField(max_length=20, blank=True, null=True)
    imagethree = models.CharField(max_length=20, blank=True, null=True)
    imagefour = models.CharField(max_length=20, blank=True, null=True)

    class Meta:

        db_table = 'gameimage'


class Invitation(models.Model):    #游戏帖子
    user = models.ForeignKey('User', models.DO_NOTHING, blank=True, null=True)
    invitation_id = models.AutoField(primary_key=True)
    title = models.CharField(max_length=50, blank=True, null=True)
    content = models.CharField(max_length=50, blank=True, null=True)

    class Meta:

        db_table = 'invitation'


class Talk(models.Model):   #用户评论
    user = models.ForeignKey('User', models.DO_NOTHING, blank=True, null=True)
    usertalk = models.CharField(max_length=100, blank=True, null=True)

    class Meta:

        db_table = 'talk'


class User(models.Model):   #用户模型
    user_id = models.AutoField(primary_key=True)
    username = models.CharField(max_length=20, blank=True, null=True)
    telphone = models.IntegerField(blank=True, null=True)
    userpic = models.CharField(max_length=50, blank=True, null=True)
    signature = models.CharField(max_length=50, blank=True, null=True)
    profession = models.CharField(max_length=50, blank=True, null=True)
    sex = models.CharField(max_length=2, blank=True, null=True)
    area = models.CharField(max_length=50, blank=True, null=True)

    class Meta:
        db_table = 'user'