-
Notifications
You must be signed in to change notification settings - Fork 0
/
db_model.py
291 lines (243 loc) · 12.8 KB
/
db_model.py
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
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
# coding: utf-8
from sqlalchemy import Column, DateTime, ForeignKey, Integer, String, text
from sqlalchemy.orm import relationship
from sqlalchemy.ext.declarative import declarative_base
Base = declarative_base()
metadata = Base.metadata
class AddressType(Base):
__tablename__ = 'address_type'
address_type_id = Column(Integer, primary_key=True, unique=True)
address_type_uuid = Column(String(36), nullable=False, unique=True)
slug = Column(String(128), nullable=False, unique=True)
display_name = Column(String(255), nullable=False, unique=True)
description = Column(String(255))
active = Column(Integer, nullable=False, server_default=text("'1'"))
display = Column(Integer, nullable=False, server_default=text("'1'"))
created_date = Column(DateTime, nullable=False)
created_by = Column(ForeignKey('user.user_id'), nullable=False, index=True)
modified_date = Column(DateTime)
modified_by = Column(ForeignKey('user.user_id'), index=True)
deactivated_date = Column(DateTime)
deactivated_by = Column(ForeignKey('user.user_id'), index=True)
valid_from_date = Column(DateTime, nullable=False)
valid_to_date = Column(DateTime)
user = relationship('User', primaryjoin='AddressType.created_by == User.user_id')
user1 = relationship('User', primaryjoin='AddressType.deactivated_by == User.user_id')
user2 = relationship('User', primaryjoin='AddressType.modified_by == User.user_id')
class ContactType(Base):
__tablename__ = 'contact_type'
contact_type_id = Column(Integer, primary_key=True, unique=True)
contact_type_uuid = Column(String(36), nullable=False, unique=True)
slug = Column(String(128), nullable=False, unique=True)
display_name = Column(String(255), nullable=False, unique=True)
description = Column(String(255))
active = Column(Integer, nullable=False, server_default=text("'1'"))
display = Column(Integer, nullable=False, server_default=text("'1'"))
created_date = Column(DateTime, nullable=False)
created_by = Column(ForeignKey('user.user_id'), nullable=False, index=True)
modified_date = Column(DateTime)
modified_by = Column(ForeignKey('user.user_id'), index=True)
deactivated_date = Column(DateTime)
deactivated_by = Column(ForeignKey('user.user_id'), index=True)
valid_from_date = Column(DateTime, nullable=False)
valid_to_date = Column(DateTime)
user = relationship('User', primaryjoin='ContactType.created_by == User.user_id')
user1 = relationship('User', primaryjoin='ContactType.deactivated_by == User.user_id')
user2 = relationship('User', primaryjoin='ContactType.modified_by == User.user_id')
class Metadatum(Base):
__tablename__ = 'metadata'
tablename_id = Column(Integer, primary_key=True, unique=True)
active = Column(Integer, nullable=False, server_default=text("'1'"))
display = Column(Integer, nullable=False, server_default=text("'1'"))
created_date = Column(DateTime, nullable=False)
created_by = Column(Integer, nullable=False)
modified_date = Column(DateTime)
modified_by = Column(Integer)
deactivated_date = Column(DateTime)
deactivated_by = Column(Integer)
valid_from_date = Column(DateTime, nullable=False)
valid_to_date = Column(DateTime)
class Organization(Base):
__tablename__ = 'organization'
organization_id = Column(Integer, primary_key=True, unique=True)
organization_uuid = Column(String(36), nullable=False, unique=True)
parent_organization_id = Column(String(36), index=True)
organization_type_id = Column(ForeignKey('organization_type.organization_type_id'), nullable=False, index=True)
name = Column(String(255), nullable=False, unique=True)
description = Column(String(255))
active = Column(Integer, nullable=False, server_default=text("'1'"))
display = Column(Integer, nullable=False, server_default=text("'1'"))
created_date = Column(DateTime, nullable=False)
created_by = Column(ForeignKey('user.user_id'), nullable=False, index=True)
modified_date = Column(DateTime)
modified_by = Column(Integer)
deactivated_date = Column(DateTime)
deactivated_by = Column(Integer)
valid_from_date = Column(DateTime, nullable=False)
valid_to_date = Column(DateTime)
user = relationship('User')
organization_type = relationship('OrganizationType')
class OrganizationAddres(Base):
__tablename__ = 'organization_address'
organization_address_id = Column(Integer, primary_key=True, unique=True)
organization_address_uuid = Column(String(36), nullable=False, unique=True)
organization_id = Column(ForeignKey('organization.organization_id'), nullable=False, index=True)
address_type_id = Column(ForeignKey('address_type.address_type_id'), nullable=False, index=True)
address_line_1 = Column(String(255), nullable=False, server_default=text("'1'"))
address_line_2 = Column(String(255))
city = Column(String(255), nullable=False)
state_province = Column(String(128), nullable=False)
country_id = Column(String(45))
postal_code = Column(String(12), nullable=False)
display = Column(Integer, nullable=False, server_default=text("'1'"))
created_date = Column(DateTime, nullable=False)
created_by = Column(ForeignKey('user.user_id'), nullable=False, index=True)
modified_date = Column(DateTime)
modified_by = Column(Integer)
deactivated_date = Column(DateTime)
deactivated_by = Column(Integer)
valid_from_date = Column(DateTime, nullable=False)
valid_to_date = Column(DateTime)
address_type = relationship('AddressType')
user = relationship('User')
organization = relationship('Organization')
class OrganizationContact(Base):
__tablename__ = 'organization_contact'
organization_contact_id = Column(Integer, primary_key=True, unique=True)
organization_contact_uuid = Column(String(36), nullable=False, unique=True)
organization_id = Column(ForeignKey('organization.organization_id'), nullable=False, index=True)
contact_type_id = Column(ForeignKey('contact_type.contact_type_id'), nullable=False, index=True)
value = Column(String(255), nullable=False)
active = Column(Integer, nullable=False, server_default=text("'1'"))
display = Column(Integer, nullable=False, server_default=text("'1'"))
created_date = Column(DateTime, nullable=False)
created_by = Column(ForeignKey('user.user_id'), nullable=False, index=True)
modified_date = Column(DateTime)
modified_by = Column(Integer)
deactivated_date = Column(DateTime)
deactivated_by = Column(Integer)
valid_from_date = Column(DateTime, nullable=False)
valid_to_date = Column(DateTime)
contact_type = relationship('ContactType')
user = relationship('User')
organization = relationship('Organization')
class OrganizationType(Base):
__tablename__ = 'organization_type'
organization_type_id = Column(Integer, primary_key=True, unique=True)
organization_type_uuid = Column(String(36), nullable=False)
slug = Column(String(128), nullable=False, unique=True)
display_name = Column(String(255), nullable=False, unique=True)
description = Column(String(255))
active = Column(Integer, nullable=False, server_default=text("'1'"))
display = Column(Integer, nullable=False, server_default=text("'1'"))
created_date = Column(DateTime, nullable=False)
created_by = Column(ForeignKey('user.user_id'), nullable=False, index=True)
modified_date = Column(DateTime)
modified_by = Column(Integer)
deactivated_date = Column(DateTime)
deactivated_by = Column(Integer)
valid_from_date = Column(DateTime, nullable=False)
valid_to_date = Column(DateTime)
user = relationship('User')
class OrganizationUserRole(Base):
__tablename__ = 'organization_user_role'
organization_user_role_id = Column(Integer, primary_key=True, unique=True)
organization_user_role_uuid = Column(String(36), nullable=False, unique=True)
organization_id = Column(ForeignKey('organization.organization_id'), nullable=False, index=True)
user_id = Column(ForeignKey('user.user_id'), nullable=False, index=True)
role_id = Column(ForeignKey('role.role_id'), nullable=False, index=True)
active = Column(Integer, nullable=False, server_default=text("'1'"))
display = Column(Integer, nullable=False, server_default=text("'1'"))
created_date = Column(DateTime, nullable=False)
created_by = Column(ForeignKey('user.user_id'), nullable=False, index=True)
modified_date = Column(DateTime)
modified_by = Column(Integer)
deactivated_date = Column(DateTime)
deactivated_by = Column(Integer)
valid_from_date = Column(DateTime, nullable=False)
valid_to_date = Column(DateTime)
user = relationship('User', primaryjoin='OrganizationUserRole.created_by == User.user_id')
organization = relationship('Organization')
role = relationship('Role')
user1 = relationship('User', primaryjoin='OrganizationUserRole.user_id == User.user_id')
class Role(Base):
__tablename__ = 'role'
role_id = Column(Integer, primary_key=True, unique=True)
role_uuid = Column(String(36), nullable=False, unique=True)
parent_role_id = Column(ForeignKey('role.role_id'), index=True)
role_type_id = Column(ForeignKey('role_type.role_type_id'), nullable=False, index=True)
display_name = Column(String(255), nullable=False, unique=True)
description = Column(String(255))
active = Column(Integer, nullable=False, server_default=text("'1'"))
display = Column(Integer, nullable=False, server_default=text("'1'"))
created_date = Column(DateTime, nullable=False)
created_by = Column(ForeignKey('user.user_id'), nullable=False, index=True)
modified_date = Column(DateTime)
modified_by = Column(Integer)
deactivated_date = Column(DateTime)
deactivated_by = Column(Integer)
valid_from_date = Column(DateTime, nullable=False)
valid_to_date = Column(DateTime)
user = relationship('User')
parent_role = relationship('Role', remote_side=[role_id])
role_type = relationship('RoleType')
class RoleType(Base):
__tablename__ = 'role_type'
role_type_id = Column(Integer, primary_key=True, unique=True)
role_type_uuid = Column(String(36), nullable=False, unique=True)
organization_uuid = Column(Integer, nullable=False)
slug = Column(String(128), nullable=False, unique=True)
display_name = Column(String(255), nullable=False, unique=True)
description = Column(String(255))
active = Column(Integer, nullable=False, server_default=text("'1'"))
display = Column(Integer, nullable=False, server_default=text("'1'"))
created_date = Column(DateTime, nullable=False)
created_by = Column(ForeignKey('user.user_id'), nullable=False, index=True)
modified_date = Column(DateTime)
modified_by = Column(Integer)
deactivated_date = Column(DateTime)
deactivated_by = Column(Integer)
valid_from_date = Column(DateTime, nullable=False)
valid_to_date = Column(DateTime)
user = relationship('User')
class User(Base):
__tablename__ = 'user'
user_id = Column(Integer, primary_key=True, unique=True)
user_uuid = Column(String(36), nullable=False, unique=True)
user_type_id = Column(ForeignKey('user_type.user_type_id'), nullable=False, index=True)
email = Column(String(255), nullable=False)
password = Column(String(255))
confirmed_at = Column(DateTime)
current_login_at = Column(DateTime)
current_login_ip = Column(String(45))
last_login_at = Column(DateTime)
last_login_ip = Column(String(45))
login_count = Column(Integer, nullable=False, server_default=text("'0'"))
active = Column(Integer, nullable=False, server_default=text("'1'"))
display = Column(Integer, nullable=False, server_default=text("'1'"))
created_date = Column(DateTime, nullable=False)
created_by = Column(Integer, nullable=False, index=True)
modified_date = Column(DateTime)
modified_by = Column(Integer)
deactivated_date = Column(DateTime)
deactivated_by = Column(Integer)
valid_from_date = Column(DateTime, nullable=False)
valid_to_date = Column(DateTime)
user_type = relationship('UserType')
class UserType(Base):
__tablename__ = 'user_type'
user_type_id = Column(Integer, primary_key=True, unique=True)
user_type_uuid = Column(String(36), nullable=False, unique=True)
slug = Column(String(128), nullable=False, unique=True)
display_name = Column(String(255), nullable=False, unique=True)
description = Column(String(255))
active = Column(Integer, nullable=False, server_default=text("'1'"))
display = Column(Integer, nullable=False, server_default=text("'1'"))
created_date = Column(DateTime, nullable=False)
created_by = Column(Integer, nullable=False)
modified_date = Column(DateTime)
modified_by = Column(Integer)
deactivated_date = Column(DateTime)
deactivated_by = Column(Integer)
valid_from_date = Column(DateTime, nullable=False)
valid_to_date = Column(DateTime)