from django.db import models


#  关键词任务表
class KeywordMission(models.Model):
    # 关键词任务id
    keyword_mission_id = models.AutoField(primary_key=True)
    # 关键词
    keyword = models.CharField(max_length=256)


#  日期任务表
class DateMission(models.Model):
    # 日期任务id
    date_mission_id = models.AutoField(primary_key=True)
    # 日期
    date = models.DateField()
    # 是否已完成
    is_date_finished = models.BooleanField(default=False)
    # 关键词任务
    keyword_mission = models.ForeignKey(KeywordMission, on_delete=models.CASCADE, related_name='DateMission')


#  时间任务表
class TimeMission(models.Model):
    # 时间任务id
    time_mission_id = models.AutoField(primary_key=True)
    # 时间
    time = models.DateTimeField()
    # 是否已完成
    is_time_finished = models.BooleanField(default=False)
    # 关键词任务
    keyword_mission = models.ForeignKey(KeywordMission, on_delete=models.CASCADE, related_name='TimeMission')
    # 日期任务
    date_mission = models.ForeignKey(DateMission, on_delete=models.CASCADE, related_name='TimeMission')