# import db object from flask app
from app import db

# database tables
class Con_dpd_transaction_detail(db.Model):
   id = db.Column(db.Integer, primary_key =True)
   DetailID = db.Column(db.Integer, nullable = False)
   AccountTranDetailsID = db.Column(db.Integer, nullable = False)
   MemberRefNo = db.Column(db.Numeric, nullable = False)
   StartDate = db.Column(db.DateTime, nullable = False)
   Code = db.Column(db.String, nullable = False)
   EntryDate = db.Column(db.DateTime, 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)