# import db object from flask app
from app import db

# database tables
class Con_enquiry_detail(db.Model):
   id = db.Column(db.Integer, primary_key =True)
   EnquiryID = db.Column(db.Integer, nullable = False)
   MemberReferenceNumber = db.Column(db.Numeric, nullable = False)
   DateOfEnquiry = db.Column(db.DateTime, nullable = False)
   EnquiringMemberShortName = db.Column(db.String, nullable = False)
   EnquiryPurpose = db.Column(db.String, nullable = False)
   EnquiryAmount = db.Column(db.Numeric, nullable = False)
   createdAt = db.Column(db.DateTime, nullable = False)
   updatedAt = db.Column(db.DateTime, nullable = False)
   createdby = db.Column(db.Integer, nullable = False)
   updatedby = db.Column(db.Integer, nullable = False)