File size: 2,586 Bytes
5026c77
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
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
from . import db
from flask_login import UserMixin

class User(db.Model, UserMixin):
    userid = db.Column(db.String(300), primary_key=True)
    password = db.Column(db.String(300), nullable=True)
    firstname = db.Column(db.String(255), nullable=False)
    lastname = db.Column(db.String(255), nullable=False)
    mobile = db.Column(db.String(200), nullable=False)
    gender = db.Column(db.String(255), nullable=False)
    pincode = db.Column(db.String(200), nullable=False)
    city = db.Column(db.String(255), nullable=False)
    state = db.Column(db.String(255), nullable=False)
    country = db.Column(db.String(255), nullable=False)
    add1 = db.Column(db.String(1000), nullable=False)
    add2 = db.Column(db.String(1000), nullable=False)

class Pincodes(db.Model):
    CircleName = db.Column(db.String(255), nullable=False)
    RegionName = db.Column(db.String(255), nullable=False)
    DivisionName = db.Column(db.String(255), nullable=False)
    OfficeName = db.Column(db.String(255), primary_key=True)
    Pincode = db.Column(db.String(255), nullable=False)
    OfficeType = db.Column(db.String(255), nullable=False)
    Delivery = db.Column(db.String(255), nullable=False)
    District = db.Column(db.String(255), nullable=False)
    StateName = db.Column(db.String(255), nullable=False)
    Latitude = db.Column(db.String(255), nullable=False)
    Longitude = db.Column(db.String(255), nullable=False)

class Offices(db.Model):
    PostOfficeName = db.Column(db.String(255), primary_key=True)
    Pincode = db.Column(db.String(255), nullable=False)
    OfficeType = db.Column(db.String(255), nullable=False)
    Services = db.Column(db.String(5000), nullable=False)
    Location = db.Column(db.String(255), nullable=False)
    Telephone = db.Column(db.String(255), nullable=False)
    DepartmentalInformation = db.Column(db.String(255), nullable=False)

class EF71929279(db.Model):
    Date = db.Column(db.String(255), nullable=False)
    Time = db.Column(db.String(255), primary_key=True)
    Office = db.Column(db.String(255), nullable=False)
    Event = db.Column(db.String(255), nullable=False)

class Bookings(db.Model):
    name = db.Column(db.String(2000), nullable=False)
    mobile = db.Column(db.String(100), nullable=False)
    email = db.Column(db.String(200), primary_key=True)
    aadhar = db.Column(db.String(100), nullable=False)
    service = db.Column(db.String(200), nullable=False)
    date = db.Column(db.String(100), nullable=False)
    time = db.Column(db.String(100), nullable=False)