workshop_tool_api/models.py at master · FutureFitBiz/workshop_tool_api · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
from app import db


class Company(db.Model):
    id = db.Column(db.Integer, primary_key=True, autoincrement=True)
    name = db.Column(db.String(120), nullable=True)
    description = db.Column(db.Text, nullable=True)
    business_activity = db.Column(db.String(120), nullable=True)
    break_evens = db.relationship('BreakEven', backref='company', cascade="all,delete", lazy=True)
    break_even_assessment = db.relationship('BreakEvenAssessment', backref='company', cascade="delete", lazy=True)
    products = db.relationship('Product', backref='company', cascade="all,delete", lazy=True)
    users = db.relationship('User', backref='company', lazy=True)

class User(db.Model):
    id = db.Column(db.Integer, primary_key=True, autoincrement=True)
    company_id = db.Column(db.Integer, db.ForeignKey('company.id'), nullable=True)
    password = db.Column(db.String(80), nullable=False)
    email = db.Column(db.String(120), unique=True, nullable=False)
    first = db.Column(db.String(120), nullable=True)
    last = db.Column(db.String(120), nullable=True)
    admin = db.Column(db.Boolean, nullable=True, default=False)
    investor = db.Column(db.Boolean, nullable=True, default=False)
    onboarding_complete = db.Column(db.Boolean, nullable=True, default=False)
    be_onboarding_complete = db.Column(db.Boolean, nullable=True, default=False)
    pp_onboarding_complete = db.Column(db.Boolean, nullable=True, default=False)


class Bug(db.Model):
    id = db.Column(db.Integer, primary_key=True, autoincrement=True)
    text = db.Column(db.Text, nullable=True)
    user_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=True)


class BreakEven(db.Model):
    id = db.Column(db.Integer, primary_key=True, autoincrement=True)
    company_id = db.Column(db.Integer, db.ForeignKey('company.id'), nullable=True)
    code = db.Column(db.String(20), nullable=True)
    risk = db.Column(db.Integer, nullable=True) # 0 Unlikely 1 Low 2 Moderate 3 High

    answers = db.relationship('BreakEvenAnswer', backref="break_even", cascade="all,delete", lazy='subquery')


class BreakEvenAnswer(db.Model):
    id = db.Column(db.Integer, primary_key=True, autoincrement=True)
    break_even_id = db.Column(db.Integer, db.ForeignKey('break_even.id'))
    code = db.Column(db.String(20), nullable=False)
    data = db.Column(db.String(200), nullable=False)


class BreakEvenAssessment(db.Model):
    """the inital assessment, so you can be assigned a risk per BE"""
    id = db.Column(db.Integer, primary_key=True, autoincrement=True)
    company_id = db.Column(db.Integer, db.ForeignKey('company.id'))
    status = db.Column(db.String(120), nullable=True)

    goals = db.relationship('BreakEvenAssessmentGoal', backref="break_even_assessment", cascade="all,delete", lazy='subquery')

class BreakEvenAssessmentGoal(db.Model):
    id = db.Column(db.Integer, primary_key=True, autoincrement=True)
    break_even_assessment_id = db.Column(db.Integer, db.ForeignKey('break_even_assessment.id'))
    risk = db.Column(db.String(12), nullable=True)
    code = db.Column(db.String(6), nullable=True)
    saved = db.Column(db.Boolean, nullable=True, default=False)
    answers = db.relationship('BreakEvenAssessmentAnswer', backref="break_even_assessment_goal", cascade="all,delete", lazy='subquery')

class BreakEvenAssessmentAnswer(db.Model):
    id = db.Column(db.Integer, primary_key=True, autoincrement=True)
    goal_id = db.Column(db.Integer, db.ForeignKey('break_even_assessment_goal.id'))
    code = db.Column(db.String(20), nullable=True) # question code
    value = db.Column(db.Boolean, nullable=True)


class Product(db.Model):
    id = db.Column(db.Integer, primary_key=True, autoincrement=True)
    company_id = db.Column(db.Integer, db.ForeignKey('company.id'), nullable=True)
    name = db.Column(db.String(120), nullable=False)
    code = db.Column(db.String(20), nullable=True)
    setup_complete = db.Column(db.Boolean, nullable=True, default=False)
    impacts = db.relationship('Impact', backref="product",  cascade="all,delete")
    facets = db.relationship('ProductFacet', backref="product",  cascade="all,delete")
    product_properties = db.relationship('ProductProperty', backref="product",  cascade="all,delete")

    def __repr__(self):
        return '<Product %r>' % self.name


class ProductFacet(db.Model):
    id = db.Column(db.Integer, primary_key=True, autoincrement=True)
    code = db.Column(db.String(80), nullable=False)
    product_id = db.Column(db.Integer, db.ForeignKey('product.id'))


class ProductProperty(db.Model):
    """
    property - refers to the 'Properties' tab, ie X, X1, X2, etc
    ie, this is a link between the Product & all the Identification answers
    """
    id = db.Column(db.Integer, primary_key=True, autoincrement=True)
    code = db.Column(db.String(80), nullable=False)  # property code
    product_id = db.Column(db.Integer, db.ForeignKey('product.id'))

    answers = db.relationship('ProductPropertyAnswer', cascade="all,delete", backref="product_property")


class ProductPropertyAnswer(db.Model):
    id = db.Column(db.Integer, primary_key=True, autoincrement=True)
    code = db.Column(db.String(80), nullable=False)
    product_property_id = db.Column(db.Integer, db.ForeignKey('product_property.id'))


class Impact(db.Model):
    """
    so, it's unique on PP action + Option text (not the option number)
    the result of doing Setup & 2 and then having your actions mapped
    save pp action, text, SDGs
    where do we want to save the data from the survey that links to this tho?
    """
    id = db.Column(db.Integer, primary_key=True, autoincrement=True)
    product_id = db.Column(db.Integer, db.ForeignKey('product.id'))

    property_code = db.Column(db.String(80), nullable=False)  # property code
    pp_action = db.Column(db.String(80), nullable=False)  # ie PP01.01
    option_code = db.Column(db.String(80), nullable=False)
    option_text = db.Column(db.String(500), nullable=False)
    active = db.Column(db.Boolean, nullable=False, default=True)

    sdgs = db.relationship('ImpactSdg', backref="impact",  cascade="all,delete")
    answers = db.relationship('ImpactAnswer', backref="impact", cascade="all,delete", lazy='subquery')


class ImpactSdg(db.Model):
    id = db.Column(db.Integer, primary_key=True, autoincrement=True)
    sdg = db.Column(db.String(80), nullable=False)
    impact_id = db.Column(db.Integer, db.ForeignKey('impact.id'))


class ImpactAnswer(db.Model):
    """
    so, it's unique on PP action + Option text (not the option number)
    the result of doing Setup & 2 and then having your actions mapped
    save pp action, text, SDGs
    where do we want to save the data from the survey that links to this tho?
    """
    id = db.Column(db.Integer, primary_key=True, autoincrement=True)
    impact_id = db.Column(db.Integer, db.ForeignKey('impact.id'))

    # ie A-2
    number = db.Column(db.String(20), nullable=False)
    data = db.Column(db.String(200), nullable=True)  # going to be code or the number or string
    # for 14&16 they want to enter paragraphs..
    text = db.Column(db.Text, nullable=True)