financial-assistant

1
from django.db import models
2
class Bank(models.Model):
3
    nameRus = models.CharField(max_length=255)
4
    nameEng = models.CharField(max_length=255)
5
    def __str__(self):
6
        return self.nameEng
7
    
8
		
9
class FinancialProduct(models.Model):
10
    nameRus = models.CharField(max_length=255)
11
    nameEng = models.CharField(max_length=255)
12

13
    def __str__(self):
14
        return self.nameEng
15

16
class ProductCategories(models.Model):
17
    bank_id = models.ForeignKey(Bank, on_delete=models.CASCADE)
18
    product_id = models.ForeignKey(FinancialProduct, on_delete=models.CASCADE)
19
    categoryNameRus = models.CharField(max_length=255)
20
    categoryNameEng = models.CharField(max_length=255)
21

22
    def __str__(self):
23
        return self.categoryNameEng
24

25
class BankLoanSubsection(models.Model):
26
    category_id = models.ForeignKey(ProductCategories, on_delete=models.CASCADE)
27
    titleRus = models.CharField(max_length=1000)
28
    titleEng = models.CharField(max_length=1000)
29
    
30
class BankLoanDetail(models.Model):
31
    subsection_id = models.ForeignKey(BankLoanSubsection, on_delete=models.CASCADE)
32
    title = models.CharField(max_length=255)
33
    
34
class LoanDetailedDescription(models.Model):
35
    loanDetail_id = models.ForeignKey(BankLoanDetail, on_delete=models.CASCADE)
36
    title = models.CharField(max_length=255)
37
    description = models.CharField(max_length=10000)
38
    link = models.CharField(max_length=1000)
39
    bank_id = models.ForeignKey(Bank, on_delete=models.CASCADE)
40
    product_id = models.ForeignKey(FinancialProduct, on_delete=models.CASCADE)
41
    category_id = models.ForeignKey(ProductCategories, on_delete=models.CASCADE)