Models

不写注释的程序员-Models

# 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 __future__ import unicode_literals

from django.db import models

class AffirmCategory(models.Model):

    affirmcategoryname = models.CharField(db_column='affirmCategoryName', max_length=255, blank=True,

                                          null=True)  # Field name made lowercase.

    class Meta:

        managed = False

        db_table = 'affirm_category'

class AffirmCi(models.Model):

    affirmkeywordname = models.CharField(db_column='affirmKeyWordName', max_length=255, blank=True,

                                         null=True)  # Field name made lowercase.

    affirmsearch_volume = models.IntegerField(db_column='affirmSearch_volume', blank=True,

                                              null=True)  # Field name made lowercase.

    affirmresults = models.IntegerField(db_column='affirmResults', blank=True, null=True)  # Field name made lowercase.

    affirmpurchase = models.IntegerField(db_column='affirmPurchase', blank=True,

                                         null=True)  # Field name made lowercase.

    affirmcvr = models.DecimalField(db_column='affirmCvr', max_digits=10, decimal_places=2, blank=True,

                                    null=True)  # Field name made lowercase.

    affirmquality = models.DecimalField(db_column='affirmQuality', max_digits=10, decimal_places=2, blank=True,

                                        null=True)  # Field name made lowercase.

    affirmqualitygrade = models.DecimalField(db_column='affirmQualityGrade', max_digits=10, decimal_places=2,

                                             blank=True, null=True)  # Field name made lowercase.

    affirm_foreign = models.ForeignKey(AffirmCategory, models.DO_NOTHING, db_column='affirm_foreign', blank=True,

                                       null=True)

    create_time = models.DateTimeField(auto_now_add=True, verbose_name="创建时间")

    update_time = models.DateTimeField(auto_now=True, verbose_name="更新时间")

    class Meta:

        managed = False

        db_table = 'affirm_ci'

class AffirmWords(models.Model):

    affirmname = models.CharField(db_column='affirmName', max_length=255, blank=True,

                                  null=True)  # Field name made lowercase.

    affirmfrequency = models.IntegerField(db_column='affirmFrequency', blank=True,

                                          null=True)  # Field name made lowercase.

    cate = models.ForeignKey(AffirmCategory, models.DO_NOTHING, blank=True, null=True)

    class Meta:

        managed = False

        db_table = 'affirm_words'

class Asin(models.Model):

    asin_name = models.CharField(max_length=255, blank=True, null=True)

    create_time = models.DateTimeField(auto_now_add=True, verbose_name="创建时间")

    update_time = models.DateTimeField(auto_now=True, verbose_name="更新时间")

    class Meta:

        managed = False

        db_table = 'asin'

class AsinKeywordInfo(models.Model):

    keywordinfo_name = models.CharField(max_length=255, blank=True, null=True)

    search_trend = models.TextField(blank=True, null=True)

    purchase = models.IntegerField(blank=True, null=True)

    search_volume = models.IntegerField(blank=True, null=True)

    search_hot = models.IntegerField(blank=True, null=True)

    results = models.IntegerField(blank=True, null=True)

    cvr = models.DecimalField(max_digits=10, decimal_places=2, blank=True, null=True)

    quality = models.DecimalField(max_digits=10, decimal_places=2, blank=True, null=True)

    create_time = models.DateTimeField(auto_now_add=True, verbose_name="创建时间")

    update_time = models.DateTimeField(auto_now=True, verbose_name="更新时间")

    class Meta:

        managed = False

        db_table = 'asin_keyword_info'

class Asininfo(models.Model):

    asin = models.ForeignKey(Asin, models.DO_NOTHING, blank=True, null=True)

    asininfo = models.ForeignKey(AsinKeywordInfo, models.DO_NOTHING, blank=True, null=True)

    class Meta:

        managed = False

        db_table = 'asininfo'

class Keyword(models.Model):

    keyword_name = models.CharField(max_length=255, blank=True, null=True)

    create_time = models.DateTimeField(auto_now_add=True, verbose_name="创建时间")

    update_time = models.DateTimeField(auto_now=True, verbose_name="更新时间")

    class Meta:

        managed = False

        db_table = 'keyword'

class Keywordinfo(models.Model):

    keyword = models.ForeignKey(Keyword, models.DO_NOTHING, blank=True, null=True)

    keywordinfo = models.ForeignKey(AsinKeywordInfo, models.DO_NOTHING, blank=True, null=True)

    class Meta:

        managed = False

        db_table = 'keywordinfo'

class NegativeCi(models.Model):

    negativekeywordname = models.CharField(db_column='negativeKeyWordName', max_length=255, blank=True,

                                           null=True)  # Field name made lowercase.

    negativesearchvolume = models.IntegerField(db_column='negativeSearchVolume', blank=True,

                                               null=True)  # Field name made lowercase.

    negative_foreign = models.ForeignKey(AffirmCategory, models.DO_NOTHING, db_column='negative_foreign', blank=True,

                                         null=True)

    create_time = models.DateTimeField(auto_now_add=True, verbose_name="创建时间")

    update_time = models.DateTimeField(auto_now=True, verbose_name="更新时间")

    class Meta:

        managed = False

        db_table = 'negative_ci'

class NegativeWords(models.Model):

    negativename = models.CharField(db_column='negativeName', max_length=255, blank=True,

                                    null=True)  # Field name made lowercase.

    negativefrequency = models.IntegerField(db_column='negativeFrequency', blank=True,

                                            null=True)  # Field name made lowercase.

    negative_cate = models.ForeignKey(AffirmCategory, models.DO_NOTHING, blank=True, null=True)

    class Meta:

        managed = False

        db_table = 'negative_words'

class Site(models.Model):

    site_name = models.CharField(max_length=255, blank=True, null=True)

    create_time = models.DateTimeField(auto_now_add=True, verbose_name="创建时间")

    update_time = models.DateTimeField(auto_now=True, verbose_name="更新时间")

    class Meta:

        managed = False

        db_table = 'site'

class SiteAsin(models.Model):

    sid = models.ForeignKey(Site, models.DO_NOTHING, db_column='sid', blank=True, null=True)

    aid = models.ForeignKey(Asin, models.DO_NOTHING, db_column='aid', blank=True, null=True)

    class Meta:

        managed = False

        db_table = 'site_asin'

class SiteKeyword(models.Model):

    sid = models.ForeignKey(Site, models.DO_NOTHING, db_column='sid', blank=True, null=True)

    kid = models.ForeignKey(Keyword, models.DO_NOTHING, db_column='kid', blank=True, null=True)

    class Meta:

        managed = False

        db_table = 'site_keyword'