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)