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'