from django.db import models
from basic.models import Language

# Create your models here.

# FAQ

class FAQCategory(models.Model):
    createdDate = models.DateTimeField()
    updatedDate = models.DateTimeField()


class FAQCategoryLanguage(models.Model):
    title = models.TextField()
    createdDate = models.DateTimeField()
    updatedDate = models.DateTimeField()
    faqCategoryId = models.ForeignKey(
        FAQCategory,
        on_delete=models.CASCADE,
        related_name="faqcategory_faqcategorylanguage",
    )
    languageId = models.ForeignKey(
        Language,
        on_delete=models.CASCADE,
        related_name="language_faqcategorylanguage",
    )

class FAQ(models.Model):
    createdDate = models.DateTimeField()
    updatedDate = models.DateTimeField()
    faqCategoryId = models.ForeignKey(
        FAQCategory,
        on_delete=models.CASCADE,
        related_name="faqcategory_faq",
    )


class FAQLanguage(models.Model):
    question = models.TextField()
    answer = models.TextField()
    createdDate = models.DateTimeField()
    updatedDate = models.DateTimeField()
    faqId = models.ForeignKey(
        FAQ,
        on_delete=models.CASCADE,
        related_name="faq_faqlanguage",
    )
    languageId = models.ForeignKey(
        Language,
        on_delete=models.CASCADE,
        related_name="language_faqlanguage",
    )


#Information Type

class InformationType(models.Model):
    keyName = models.TextField()

#Information

class Information(models.Model):
    createdDate = models.DateTimeField()
    updatedDate = models.DateTimeField()
    informationTypeId = models.ForeignKey(
        InformationType,
        on_delete=models.CASCADE,
        related_name="information_informationtype"
    )

class InformationLanguage(models.Model):
    title = models.TextField()
    createdDate = models.DateTimeField()
    updatedDate = models.DateTimeField()
    informationId = models.ForeignKey(
        Information,
        on_delete=models.CASCADE,
        related_name="information_informationlanguage",
    )
    languageId = models.ForeignKey(
        Language,
        on_delete=models.CASCADE,
        related_name="language_informationlanguage",
    )


#Section

class Section(models.Model):
    keyName = models.TextField(blank=True,default='',null=True)
    createdDate = models.DateTimeField()
    updatedDate = models.DateTimeField()
    informationId = models.ForeignKey(
        Information,
        on_delete=models.CASCADE,
        related_name="information_section",
    )

class SectionLanguage(models.Model):
    description = models.TextField()
    createdDate = models.DateTimeField()
    updatedDate = models.DateTimeField()
    sectionId = models.ForeignKey(
        Section,
        on_delete=models.CASCADE,
        related_name="section_sectionlanguage",
    )
    languageId = models.ForeignKey(
        Language,
        on_delete=models.CASCADE,
        related_name="language_sectionlanguage",
    )

#Content

class Content(models.Model):
    keyName = models.TextField(blank=True,default='',null=True)
    createdDate = models.DateTimeField()
    updatedDate = models.DateTimeField()
    sectionId = models.ForeignKey(
        Section,
        on_delete=models.CASCADE,
        related_name="section_content",
    )

class ContentLanguage(models.Model):
    description = models.TextField()
    createdDate = models.DateTimeField()
    updatedDate = models.DateTimeField()
    contentId = models.ForeignKey(
        Content,
        on_delete=models.CASCADE,
        related_name="content_contentlanguage",
    )
    languageId = models.ForeignKey(
        Language,
        on_delete=models.CASCADE,
        related_name="language_contentlanguage",
    )