-
Notifications
You must be signed in to change notification settings - Fork 1
/
models.py
50 lines (44 loc) · 2.47 KB
/
models.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
from app import db
#from sqlalchemy_utils import ScalarListType
from sqlalchemy.dialects import postgresql
from sqlalchemy.dialects.postgresql import JSON
from sqlalchemy.dialects.postgresql.base import UUID
db.UUID = UUID
class All_EMRSites(db.Model):
__tablename__ = 'All_EMRSites'
MFL_Code = db.Column(db.String(100), nullable=False, primary_key=True)
Facility_Name = db.Column('Facility_Name', db.String(100), nullable=False)
County = db.Column(db.String(100), nullable=False)
SubCounty = db.Column(db.String(100), nullable=False)
Owner = db.Column(db.String(100), nullable=False)
Latitude = db.Column(db.String(100), nullable=False)
Longitude = db.Column(db.String(100), nullable=False)
SDP = db.Column(db.String(100), nullable=False)
SDP_Agency = db.Column('SDP_Agency',db.String(100), nullable=False)
Implementation = db.Column(db.String(100), nullable=False)
EMR = db.Column(db.String(100), nullable=False)
EMR_Status = db.Column('EMR_Status',db.String(100), nullable=False)
HTS_Use = db.Column('HTS_Use', db.String(100), nullable=False)
HTS_Deployment = db.Column('HTS_Deployment', db.String(100), nullable=False)
HTS_Status = db.Column('HTS_Status', db.String(100), nullable=False)
KEPH_Level = db.Column('KEPH_Level',db.String(100), nullable=False)
InfrastructureType = db.Column('InfrastructureType',db.String(100), nullable=False)
# Phamarmacy_IE = db.Column('Phamarmacy IE',db.String(100), nullable=False)
mlab = db.Column(db.String(100), nullable=False)
Ushauri = db.Column(db.String(100), nullable=False)
Nishauri = db.Column(db.String(100), nullable=False)
# Appointment_Management_IE = db.Column('Appointment Management IE', db.String(100), nullable=False)
OVC = db.Column(db.String(100), nullable=False)
OTZ = db.Column(db.String(100), nullable=False)
PrEP = db.Column(db.String(100), nullable=False)
# three_PM = db.Column('3PM',db.String(100), nullable=False)
AIR = db.Column(db.String(100), nullable=False)
KP = db.Column(db.String(100), nullable=False)
MCH = db.Column(db.String(100), nullable=False)
# TB = db.Column(db.String(100), nullable=False)
Lab_Manifest = db.Column('Lab_Manifest',db.String(100), nullable=False)
Comments = db.Column(db.String(100), nullable=False)
Project = db.Column(db.String(100), nullable=False)
EMRType = db.Column(db.String(50), nullable=True)
def __repr__(self):
return f'<Facility_Name {self.Facility_Name}>'