# # coding: utf-8
# from flask_sqlalchemy import SQLAlchemy
#
#
# db = SQLAlchemy()
from exts import db
__all__ = [
 "t_t_a_attendence" ,
 "TAHoliday" ,
 "TAHolidaytype" ,
 "TASystemparam" ,
 "TBConsumer" ,
 "TBConsumerFace" ,
 "TBConsumerFingerprint" ,
 "TBControlholiday" ,
 "TBController" ,
 "TBControllerFingerprint" ,
 "TBControllernormalopentimelist" ,
 "TBControllertasklist" ,
 "TBControllertasklist4floor" ,
 "TBControllerZone" ,
 "TBControllerZone4operator" ,
 "TBControlseg" ,
 "TBDoor" ,
 "TBFloor" ,
 "TBGroup" ,
 "TBGroup4operator" ,
 "TBGroup4pccheckacces" ,
 "TBIdcardLost" ,
 "TBReader" ,
 "TBReaderpassword" ,
 "TBThirdpartynetdevice" ,
 "TBUserfloor" ,
 "TDAttendencedatum" ,
 "TDAttstatistic" ,
 "TDDoorfirstcarduser" ,
 "TDDoormorecardsuser" ,
 "TDLeave" ,
 "TDManualcardrecord" ,
 "TDMap" ,
 "TDMapdoor" ,
 "TDMeeting" ,
 "TDPatrolroutelist" ,
 "TDPatrolstatistic" ,
 "TDPrivilege" ,
 "TDPrivilegeOfPrivilegetype" ,
 "TDPrivilegetype" ,
 "TDPatroldetaildatum" ,
 "TDPatrolroutedetail" ,
 "TDSwiperecord2022" ,
 "TDShiftdatum" ,
 "TDSwiperecord" ,
 "TDShiftAttreport" ,
 "TDShiftAttstatistic" ,
 "TDShiftWorkSchedule" ,
 "TSWglog" ,
 "TSOperator" ,
 "TSOperatorprivilege" ,
 "TSWglog4dooropentoolongwarn" ,
 ]
if 82 - 82: Iii1i
t_t_a_attendence = db . Table (
 't_a_attendence' ,
 db . Column ( 'f_No' , db . Integer , nullable = False ) ,
 db . Column ( 'f_Name' , db . String ( 50 ) ) ,
 db . Column ( 'f_EName' , db . String ( 50 ) ) ,
 db . Column ( 'f_Value' , db . String ( 50 ) ) ,
 db . Column ( 'f_Notes' , db . Text )
 )
if 87 - 87: Ii % i1i1i1111I . Oo / OooOoo * I1Ii1I1 - I1I
if 81 - 81: i1 + ooOOO / oOo0O00 * i1iiIII111 * IiIIii11Ii
if 84 - 84: ooo000 - Ooo0Ooo + iI1iII1I1I1i . IIiIIiIi11I1
class TAHoliday ( db . Model ) :
 __tablename__ = 't_a_holiday'
 if 98 - 98: I11iiIi11i1I % oOO
 f_NO = db . Column ( db . Integer , primary_key = True )
 f_Name = db . Column ( db . String ( 50 ) )
 f_EName = db . Column ( db . String ( 50 ) )
 f_Value = db . Column ( db . String ( 50 ) )
 f_Value1 = db . Column ( db . String ( 50 ) )
 f_Value2 = db . Column ( db . String ( 50 ) )
 f_Value3 = db . Column ( db . String ( 50 ) )
 f_Type = db . Column ( db . String ( 50 ) )
 f_Note = db . Column ( db . Text )
 if 31 - 31: i1I
 if 9 - 9: IiI11Ii111 / oOo0O00 / IiIIii11Ii - I11iiIi11i1I - iI1iII1I1I1i
 if 16 - 16: i1i1i1111I / i1iiIII111
class TAHolidaytype ( db . Model ) :
 __tablename__ = 't_a_holidaytype'
 if 3 - 3: i1 % i1 % i1i1i1111I . Ii * i1
 f_No = db . Column ( db . Integer , primary_key = True )
 f_HolidayType = db . Column ( db . String ( 50 ) , nullable = False )
 if 9 - 9: i1iiIII111
 if 10 - 10: ooOOO / IIiIIiIi11I1 * oOO / i1I / i1I
 if 61 - 61: Ooo0Ooo - I1I
iIIIII1i111i = db . Table (
 't_a_shift_attendence' ,
 db . Column ( 'f_NO' , db . Integer , nullable = False ) ,
 db . Column ( 'f_EName' , db . String ( 50 ) ) ,
 db . Column ( 'f_Value' , db . String ( 50 ) ) ,
 db . Column ( 'f_Notes' , db . Text )
 )
if 8 - 8: i1iiIII111 * i1 . I1I / oOO
if 58 - 58: I1Ii1I1 - ooOOO
if 60 - 60: iI1iII1I1I1i . oOO
class TASystemparam ( db . Model ) :
 __tablename__ = 't_a_systemparam'
 if 13 - 13: oOO
 f_NO = db . Column ( db . Integer , primary_key = True )
 f_Name = db . Column ( db . String ( 50 ) )
 f_EName = db . Column ( db . String ( 50 ) )
 f_Value = db . Column ( db . String ( 50 ) )
 f_Notes = db . Column ( db . Text )
 f_Modified = db . Column ( db . DateTime , nullable = False , server_default = db . FetchedValue ( ) )
 if 2 - 2: i1
 if 22 - 22: IIiIIiIi11I1 - ooo000 / I1Ii1I1 . ooo000
 if 1 - 1: iI1iII1I1I1i + Ooo0Ooo + oOO * IIiIIiIi11I1
iii111 = db . Table (
 't_b_camera' ,
 db . Column ( 'f_CameraId' , db . Integer , nullable = False ) ,
 db . Column ( 'f_CameraName' , db . String ( 255 ) , nullable = False , server_default = db . FetchedValue ( ) ) ,
 db . Column ( 'f_CameraIP' , db . String ( 255 ) , nullable = False , server_default = db . FetchedValue ( ) ) ,
 db . Column ( 'f_CameraPort' , db . Integer , nullable = False , server_default = db . FetchedValue ( ) ) ,
 db . Column ( 'f_CameraChannel' , db . Integer , nullable = False , server_default = db . FetchedValue ( ) ) ,
 db . Column ( 'f_Enabled' , db . Integer , nullable = False , server_default = db . FetchedValue ( ) ) ,
 db . Column ( 'f_CameraUser' , db . String ( 255 ) , server_default = db . FetchedValue ( ) ) ,
 db . Column ( 'f_CameraPassword' , db . String ( 255 ) , server_default = db . FetchedValue ( ) ) ,
 db . Column ( 'f_Type' , db . Integer , nullable = False , server_default = db . FetchedValue ( ) ) ,
 db . Column ( 'f_Notes' , db . Text )
 )
if 8 - 8: Ii + i1I . I11iiIi11i1I - I1Ii1I1 % I11iiIi11i1I . i1i1i1111I
if 24 - 24: IiI11Ii111
if 9 - 9: ooo000 / i1I . i1I / Ii % i1i1i1111I % Ooo0Ooo
O00Oo = db . Table (
 't_b_cameratriggersource' ,
 db . Column ( 'f_Id' , db . Integer , nullable = False ) ,
 db . Column ( 'f_CameraId' , db . Integer , nullable = False , server_default = db . FetchedValue ( ) ) ,
 db . Column ( 'f_ReaderID' , db . Integer , nullable = False , server_default = db . FetchedValue ( ) ) ,
 db . Column ( 'f_Type' , db . Integer , nullable = False , server_default = db . FetchedValue ( ) ) ,
 db . Column ( 'f_Notes' , db . Text )
 )
if 34 - 34: oOo0O00 / i1iiIII111 - Iii1i . iI1iII1I1I1i
if 80 - 80: i1i1i1111I . I1I % ooOOO % IiIIii11Ii / i1i1i1111I
if 32 - 32: I1Ii1I1 + oOO - oOo0O00
class TBConsumer ( db . Model ) :
 __tablename__ = 't_b_consumer'
 if 79 - 79: Iii1i % oOO * Oo + ooOOO / Oo . oOO
 f_ConsumerID = db . Column ( db . Integer , primary_key = True )
 f_ConsumerNO = db . Column ( db . String ( 20 ) , nullable = False , unique = True )
 f_ConsumerName = db . Column ( db . String ( 50 ) , nullable = False , index = True )
 f_CardNO = db . Column ( db . BigInteger , index = True )
 f_GroupID = db . Column ( db . Integer , nullable = False , server_default = db . FetchedValue ( ) )
 f_AttendEnabled = db . Column ( db . SmallInteger , nullable = False , server_default = db . FetchedValue ( ) )
 f_ShiftEnabled = db . Column ( db . SmallInteger , nullable = False , server_default = db . FetchedValue ( ) )
 f_DoorEnabled = db . Column ( db . SmallInteger , nullable = False , server_default = db . FetchedValue ( ) )
 f_BeginYMD = db . Column ( db . DateTime , nullable = False , server_default = db . FetchedValue ( ) )
 f_EndYMD = db . Column ( db . DateTime , nullable = False , server_default = db . FetchedValue ( ) )
 f_PIN = db . Column ( db . Integer , nullable = False , server_default = db . FetchedValue ( ) )
 f_PrivilegeTypeID = db . Column ( db . Integer , nullable = False , server_default = db . FetchedValue ( ) )
 if 20 - 20: IiI11Ii111 + i1iiIII111 / I1I
 if 88 - 88: I11iiIi11i1I + ooOOO - i1i1i1111I . Ooo0Ooo * Ii + Iii1i
 if 43 - 43: ooOOO * I1Ii1I1
Oooo0o0oO0 = db . Table (
 't_b_consumer_delete' ,
 db . Column ( 'f_DeletedID' , db . Integer , nullable = False ) ,
 db . Column ( 'f_ConsumerID' , db . Integer , nullable = False ) ,
 db . Column ( 'f_ConsumerNO' , db . String ( 20 ) , nullable = False ) ,
 db . Column ( 'f_ConsumerName' , db . String ( 50 ) , nullable = False ) ,
 db . Column ( 'f_CardNO' , db . BigInteger ) ,
 db . Column ( 'f_GroupID' , db . Integer , nullable = False ) ,
 db . Column ( 'f_AttendEnabled' , db . SmallInteger , nullable = False ) ,
 db . Column ( 'f_ShiftEnabled' , db . SmallInteger , nullable = False ) ,
 db . Column ( 'f_DoorEnabled' , db . SmallInteger , nullable = False ) ,
 db . Column ( 'f_BeginYMD' , db . DateTime , nullable = False ) ,
 db . Column ( 'f_EndYMD' , db . DateTime , nullable = False ) ,
 db . Column ( 'f_PIN' , db . Integer , nullable = False ) ,
 db . Column ( 'f_PrivilegeTypeID' , db . Integer , nullable = False )
 )
if 71 - 71: OooOoo - Ii
if 40 - 40: IiIIii11Ii . i1 / Oo
if 46 - 46: IiI11Ii111 - OooOoo * I1Ii1I1 / Ooo0Ooo / Iii1i
class TBConsumerFace ( db . Model ) :
 __tablename__ = 't_b_consumer_face'
 if 23 - 23: Ooo0Ooo + i1 * I1Ii1I1 + Oo * Ii - IIiIIiIi11I1
 f_ConsumerID = db . Column ( db . Integer , primary_key = True )
 f_FaceInfo = db . Column ( db . Text )
 f_Note = db . Column ( db . Text )
 if 29 - 29: IiIIii11Ii - oOo0O00
 if 30 - 30: I1I . ooo000
 if 43 - 43: ooOOO . I11iiIi11i1I + ooo000
class TBConsumerFingerprint ( db . Model ) :
 __tablename__ = 't_b_consumer_fingerprint'
 if 87 - 87: Iii1i + ooOOO . i1I / Ii + Oo
 f_FingerID = db . Column ( db . Integer , primary_key = True )
 f_FingerNO = db . Column ( db . Integer , nullable = False )
 f_FingerInfo = db . Column ( db . Text )
 f_ConsumerID = db . Column ( db . Integer )
 f_Description = db . Column ( db . String ( 255 ) )
 f_RegisterTime = db . Column ( db . DateTime )
 f_Note = db . Column ( db . Text )
 if 77 - 77: i1iiIII111 + IiI11Ii111 - Oo % ooo000
 if 74 - 74: Ii + Ooo0Ooo
 if 1 - 1: I1I % Ooo0Ooo + i1iiIII111 . i1iiIII111 % Oo
OOOO0O0ooO0O = db . Table (
 't_b_consumer_location' ,
 db . Column ( 'f_ConsumerID' , db . Integer , nullable = False ) ,
 db . Column ( 'f_Note' , db . Text ) ,
 db . Column ( 'f_lastSwipe_CardNO' , db . Integer , nullable = False , server_default = db . FetchedValue ( ) ) ,
 db . Column ( 'f_lastSwipe_RecID' , db . Integer , nullable = False , server_default = db . FetchedValue ( ) ) ,
 db . Column ( 'f_lastSwipe_ReadDate' , db . DateTime ) ,
 db . Column ( 'f_lastSwipe_ReaderID' , db . SmallInteger , nullable = False , server_default = db . FetchedValue ( ) ) ,
 db . Column ( 'f_lastSwipe_InOut' , db . SmallInteger , nullable = False , server_default = db . FetchedValue ( ) ) ,
 db . Column ( 'f_lastSwipe_ControllerSN' , db . Integer , nullable = False , server_default = db . FetchedValue ( ) ) ,
 db . Column ( 'f_lastRemoteOpen_ReadDate' , db . DateTime ) ,
 db . Column ( 'f_lastRemoteOpen_ControllerSN' , db . Integer , nullable = False , server_default = db . FetchedValue ( ) ) ,
 db . Column ( 'f_lastRemoteOpen_DoorNO' , db . SmallInteger , nullable = False , server_default = db . FetchedValue ( ) ) ,
 db . Column ( 'f_Last_InOut' , db . SmallInteger , nullable = False , server_default = db . FetchedValue ( ) )
 )
if 87 - 87: IiI11Ii111 / oOo0O00 % oOO - oOo0O00 . I1I + Ooo0Ooo
if 75 - 75: i1iiIII111 * iI1iII1I1I1i - I1I - IIiIIiIi11I1 % I1Ii1I1
if 85 - 85: oOo0O00
o0Ooo = db . Table (
 't_b_consumer_other' ,
 db . Column ( 'f_ConsumerID' , db . Integer , nullable = False ) ,
 db . Column ( 'f_Note' , db . Text ) ,
 db . Column ( 'f_WorkNo' , db . String ( 50 ) ) ,
 db . Column ( 'f_Title' , db . String ( 50 ) ) ,
 db . Column ( 'f_Culture' , db . String ( 50 ) ) ,
 db . Column ( 'f_Hometown' , db . String ( 50 ) ) ,
 db . Column ( 'f_Birthday' , db . String ( 50 ) ) ,
 db . Column ( 'f_Marriage' , db . String ( 50 ) ) ,
 db . Column ( 'f_JoinDate' , db . String ( 50 ) ) ,
 db . Column ( 'f_LeaveDate' , db . String ( 50 ) ) ,
 db . Column ( 'f_CertificateType' , db . String ( 50 ) ) ,
 db . Column ( 'f_CertificateID' , db . String ( 50 ) ) ,
 db . Column ( 'f_SocialInsuranceNo' , db . String ( 50 ) ) ,
 db . Column ( 'f_Addr' , db . String ( 50 ) ) ,
 db . Column ( 'f_Postcode' , db . String ( 50 ) ) ,
 db . Column ( 'f_Sex' , db . String ( 50 ) ) ,
 db . Column ( 'f_Nationality' , db . String ( 50 ) ) ,
 db . Column ( 'f_Religion' , db . String ( 50 ) ) ,
 db . Column ( 'f_EnglishName' , db . String ( 50 ) ) ,
 db . Column ( 'f_Mobile' , db . String ( 50 ) ) ,
 db . Column ( 'f_HomePhone' , db . String ( 50 ) ) ,
 db . Column ( 'f_Telephone' , db . String ( 50 ) ) ,
 db . Column ( 'f_Email' , db . String ( 50 ) ) ,
 db . Column ( 'f_Political' , db . String ( 50 ) ) ,
 db . Column ( 'f_CorporationName' , db . String ( 50 ) ) ,
 db . Column ( 'f_TechGrade' , db . String ( 50 ) )
 )
if 19 - 19: Ii
if 32 - 32: i1i1i1111I % Ooo0Ooo - i1I * I1I
if 92 - 92: IIiIIiIi11I1 - i1 - Iii1i / Ooo0Ooo . I1Ii1I1 / I11iiIi11i1I
class TBControlholiday ( db . Model ) :
 __tablename__ = 't_b_controlholidays'
 if 60 - 60: oOO
 f_Id = db . Column ( db . Integer , primary_key = True )
 f_BeginYMDHMS = db . Column ( db . DateTime , nullable = False , server_default = db . FetchedValue ( ) )
 f_EndYMDHMS = db . Column ( db . DateTime , nullable = False , server_default = db . FetchedValue ( ) )
 f_forceWork = db . Column ( db . Integer , nullable = False , server_default = db . FetchedValue ( ) )
 f_Notes = db . Column ( db . Text )
 if 32 - 32: iI1iII1I1I1i
 if 18 - 18: I11iiIi11i1I * IiI11Ii111 % iI1iII1I1I1i + IiI11Ii111
 if 93 - 93: oOO - I1Ii1I1 - IIiIIiIi11I1 * ooOOO - i1
class TBController ( db . Model ) :
 __tablename__ = 't_b_controller'
 if 82 - 82: IIiIIiIi11I1 % i1 * ooOOO
 f_ControllerID = db . Column ( db . Integer , primary_key = True )
 f_ControllerNO = db . Column ( db . Integer , nullable = False , unique = True )
 f_ControllerSN = db . Column ( db . Integer , nullable = False , unique = True )
 f_Enabled = db . Column ( db . SmallInteger , nullable = False , server_default = db . FetchedValue ( ) )
 f_IP = db . Column ( db . String ( 50 ) )
 f_PORT = db . Column ( db . Integer , nullable = False , server_default = db . FetchedValue ( ) )
 f_Note = db . Column ( db . String ( 50 ) )
 f_ZoneID = db . Column ( db . Integer , nullable = False , server_default = db . FetchedValue ( ) )
 f_AntiBack = db . Column ( db . Integer , nullable = False , server_default = db . FetchedValue ( ) )
 f_InterLock = db . Column ( db . Integer , nullable = False , server_default = db . FetchedValue ( ) )
 f_MoreCards_GoInOut = db . Column ( db . Integer , nullable = False , server_default = db . FetchedValue ( ) )
 f_DoorInvalidOpen = db . Column ( db . Integer , nullable = False , server_default = db . FetchedValue ( ) )
 f_DoorOpenTooLong = db . Column ( db . Integer , nullable = False , server_default = db . FetchedValue ( ) )
 f_ForceWarn = db . Column ( db . Integer , nullable = False , server_default = db . FetchedValue ( ) )
 f_InvalidCardWarn = db . Column ( db . Integer , nullable = False , server_default = db . FetchedValue ( ) )
 f_PeripheralControl = db . Column ( db . String ( 500 ) )
 f_lastDelAddDateTime = db . Column ( db . String ( 50 ) )
 f_lastDelAddConsuemrsTotal = db . Column ( db . Integer , nullable = False , server_default = db . FetchedValue ( ) )
 f_lastDelAddAndUploadDateTime = db . Column ( db . String ( 50 ) )
 f_lastDelAddAndUploadConsuemrsTotal = db . Column ( db . Integer , nullable = False , server_default = db . FetchedValue ( ) )
 f_lastConsoleUploadDateTime = db . Column ( db . String ( 50 ) )
 f_lastConsoleUploadConsuemrsTotal = db . Column ( db . Integer , nullable = False , server_default = db . FetchedValue ( ) )
 f_lastConsoleUploadPrivilege = db . Column ( db . Integer , nullable = False , server_default = db . FetchedValue ( ) )
 f_lastConsoleUploadValidPrivilege = db . Column ( db . Integer , nullable = False , server_default = db . FetchedValue ( ) )
 f_DoorsNames = db . Column ( db . String ( 1024 ) )
 if 57 - 57: oOo0O00
 if 31 - 31: i1iiIII111 + i1i1i1111I % OooOoo
 if 20 - 20: OooOoo - I1I
class TBControllerFingerprint ( db . Model ) :
 __tablename__ = 't_b_controller_fingerprint'
 if 9 - 9: i1iiIII111 - iI1iII1I1I1i % Ii - I1I
 f_ControllerID = db . Column ( db . Integer , primary_key = True )
 f_ControllerSN = db . Column ( db . Integer , nullable = False )
 f_FingerPrintName = db . Column ( db . String ( 255 ) , nullable = False , server_default = db . FetchedValue ( ) )
 f_IP = db . Column ( db . String ( 255 ) )
 f_Port = db . Column ( db . Integer , nullable = False , server_default = db . FetchedValue ( ) )
 f_Enabled = db . Column ( db . Integer , nullable = False , server_default = db . FetchedValue ( ) )
 f_ReaderID = db . Column ( db . Integer , nullable = False , server_default = db . FetchedValue ( ) )
 f_Notes = db . Column ( db . Text )
 if 54 - 54: Iii1i % ooo000 % Iii1i - IiIIii11Ii
 if 39 - 39: oOO - oOO * i1 % IIiIIiIi11I1
 if 29 - 29: IIiIIiIi11I1 - ooo000 . i1iiIII111
class TBControllerZone ( db . Model ) :
 __tablename__ = 't_b_controller_zone'
 if 86 - 86: I1Ii1I1 - OooOoo - oOO % ooo000 . i1I % Iii1i
 f_ZoneID = db . Column ( db . Integer , primary_key = True )
 f_ZoneName = db . Column ( db . String ( 2047 ) )
 f_ZoneNO = db . Column ( db . Integer , nullable = False , server_default = db . FetchedValue ( ) )
 if 11 - 11: OooOoo - I1Ii1I1 - ooOOO . i1iiIII111 - iI1iII1I1I1i / i1iiIII111
 if 44 - 44: Ooo0Ooo + i1i1i1111I + Iii1i - oOO
 if 7 - 7: i1i1i1111I / Ii * Iii1i
class TBControllerZone4operator ( db . Model ) :
 __tablename__ = 't_b_controller_zone4operator'
 if 32 - 32: IiI11Ii111 . OooOoo
 f_OperatorZoneId = db . Column ( db . Integer , primary_key = True )
 f_ZoneID = db . Column ( db . Integer , nullable = False , server_default = db . FetchedValue ( ) )
 f_OperatorID = db . Column ( db . Integer , nullable = False , server_default = db . FetchedValue ( ) )
 if 31 - 31: Oo - i1I
 if 28 - 28: ooOOO * I1Ii1I1 + IiI11Ii111 % Oo
 if 100 - 100: Oo + i1I
I1II1ii111i = db . Table (
 't_b_controller_zone_userlimit' ,
 db . Column ( 'f_RecId' , db . Integer , nullable = False ) ,
 db . Column ( 'f_ZoneID' , db . Integer , nullable = False ) ,
 db . Column ( 'f_UserLimit' , db . String ( 255 ) ) ,
 db . Column ( 'f_LEDIP' , db . String ( 255 ) ) ,
 db . Column ( 'f_Note' , db . Text )
 )
if 14 - 14: IiI11Ii111 + i1I . IiIIii11Ii . Ooo0Ooo % IiIIii11Ii * i1i1i1111I
if 65 - 65: Iii1i + IIiIIiIi11I1 - Ooo0Ooo . iI1iII1I1I1i + OooOoo * Ooo0Ooo
if 23 - 23: ooOOO % oOO % iI1iII1I1I1i - i1I - i1iiIII111 + i1
class TBControllernormalopentimelist ( db . Model ) :
 __tablename__ = 't_b_controllernormalopentimelist'
 if 12 - 12: i1 - i1I - IiI11Ii111
 f_Id = db . Column ( db . Integer , primary_key = True )
 f_BeginYMD = db . Column ( db . DateTime , nullable = False )
 f_EndYMD = db . Column ( db . DateTime , nullable = False )
 f_OperateTime = db . Column ( db . DateTime , nullable = False )
 f_OperateTimeEnd = db . Column ( db . DateTime , nullable = False )
 f_Monday = db . Column ( db . SmallInteger , nullable = False )
 f_Tuesday = db . Column ( db . SmallInteger , nullable = False )
 f_Wednesday = db . Column ( db . SmallInteger , nullable = False )
 f_Thursday = db . Column ( db . SmallInteger , nullable = False )
 f_Friday = db . Column ( db . SmallInteger , nullable = False )
 f_Saturday = db . Column ( db . SmallInteger , nullable = False )
 f_Sunday = db . Column ( db . SmallInteger , nullable = False )
 f_DoorID = db . Column ( db . Integer , nullable = False )
 f_DoorControl = db . Column ( db . Integer , nullable = False )
 f_Notes = db . Column ( db . Text )
 f_FloorNames = db . Column ( db . Text )
 if 86 - 86: Iii1i + i1iiIII111 - IIiIIiIi11I1 / I1I
 if 46 - 46: ooOOO + ooOOO % oOO
 if 2 - 2: i1i1i1111I / Ooo0Ooo / oOO - IIiIIiIi11I1 / IIiIIiIi11I1
class TBControllertasklist ( db . Model ) :
 __tablename__ = 't_b_controllertasklist'
 if 58 - 58: i1i1i1111I
 f_Id = db . Column ( db . Integer , primary_key = True )
 f_BeginYMD = db . Column ( db . DateTime , nullable = False , server_default = db . FetchedValue ( ) )
 f_EndYMD = db . Column ( db . DateTime , nullable = False , server_default = db . FetchedValue ( ) )
 f_OperateTime = db . Column ( db . DateTime , nullable = False , server_default = db . FetchedValue ( ) )
 f_Monday = db . Column ( db . SmallInteger , nullable = False , server_default = db . FetchedValue ( ) )
 f_Tuesday = db . Column ( db . SmallInteger , nullable = False , server_default = db . FetchedValue ( ) )
 f_Wednesday = db . Column ( db . SmallInteger , nullable = False , server_default = db . FetchedValue ( ) )
 f_Thursday = db . Column ( db . SmallInteger , nullable = False , server_default = db . FetchedValue ( ) )
 f_Friday = db . Column ( db . SmallInteger , nullable = False , server_default = db . FetchedValue ( ) )
 f_Saturday = db . Column ( db . SmallInteger , nullable = False , server_default = db . FetchedValue ( ) )
 f_Sunday = db . Column ( db . SmallInteger , nullable = False , server_default = db . FetchedValue ( ) )
 f_DoorID = db . Column ( db . Integer , nullable = False , server_default = db . FetchedValue ( ) )
 f_DoorControl = db . Column ( db . Integer , nullable = False , server_default = db . FetchedValue ( ) )
 f_Notes = db . Column ( db . Text )
 if 38 - 38: i1 - oOo0O00
 if 85 - 85: IIiIIiIi11I1 + I11iiIi11i1I % Ooo0Ooo + oOO * i1iiIII111
 if 46 - 46: ooOOO - ooOOO + Oo / I1I * Oo + oOO
class TBControllertasklist4floor ( db . Model ) :
 __tablename__ = 't_b_controllertasklist4floor'
 if 98 - 98: I1I / IIiIIiIi11I1 / i1I + IiI11Ii111 % Oo + I1I
 f_Id = db . Column ( db . Integer , primary_key = True )
 f_BeginYMD = db . Column ( db . DateTime , nullable = False )
 f_EndYMD = db . Column ( db . DateTime , nullable = False )
 f_OperateTime = db . Column ( db . DateTime , nullable = False )
 f_Monday = db . Column ( db . SmallInteger , nullable = False )
 f_Tuesday = db . Column ( db . SmallInteger , nullable = False )
 f_Wednesday = db . Column ( db . SmallInteger , nullable = False )
 f_Thursday = db . Column ( db . SmallInteger , nullable = False )
 f_Friday = db . Column ( db . SmallInteger , nullable = False )
 f_Saturday = db . Column ( db . SmallInteger , nullable = False )
 f_Sunday = db . Column ( db . SmallInteger , nullable = False )
 f_DoorID = db . Column ( db . Integer , nullable = False )
 f_DoorControl = db . Column ( db . Integer , nullable = False )
 f_Notes = db . Column ( db . Text )
 f_FloorNames = db . Column ( db . Text )
 if 38 - 38: I1Ii1I1 + oOo0O00
 if 2 - 2: OooOoo % Ii + oOO . OooOoo + IIiIIiIi11I1 * Oo
 if 2 - 2: IIiIIiIi11I1 + iI1iII1I1I1i - I1Ii1I1 + ooOOO . IIiIIiIi11I1
class TBControlseg ( db . Model ) :
 __tablename__ = 't_b_controlseg'
 if 15 - 15: ooo000
 f_ControlSegID = db . Column ( db . Integer , primary_key = True )
 f_ControlSegName = db . Column ( db . String ( 50 ) )
 f_DateControl = db . Column ( db . SmallInteger , server_default = db . FetchedValue ( ) )
 f_Monday = db . Column ( db . SmallInteger , nullable = False , server_default = db . FetchedValue ( ) )
 f_Tuesday = db . Column ( db . SmallInteger , nullable = False , server_default = db . FetchedValue ( ) )
 f_Wednesday = db . Column ( db . SmallInteger , nullable = False , server_default = db . FetchedValue ( ) )
 f_Thursday = db . Column ( db . SmallInteger , nullable = False , server_default = db . FetchedValue ( ) )
 f_Friday = db . Column ( db . SmallInteger , nullable = False , server_default = db . FetchedValue ( ) )
 f_Saturday = db . Column ( db . SmallInteger , nullable = False , server_default = db . FetchedValue ( ) )
 f_Sunday = db . Column ( db . SmallInteger , nullable = False , server_default = db . FetchedValue ( ) )
 f_BeginHMS1 = db . Column ( db . DateTime , nullable = False , server_default = db . FetchedValue ( ) )
 f_EndHMS1 = db . Column ( db . DateTime , nullable = False , server_default = db . FetchedValue ( ) )
 f_BeginHMS2 = db . Column ( db . DateTime , nullable = False , server_default = db . FetchedValue ( ) )
 f_EndHMS2 = db . Column ( db . DateTime , nullable = False , server_default = db . FetchedValue ( ) )
 f_BeginHMS3 = db . Column ( db . DateTime , nullable = False , server_default = db . FetchedValue ( ) )
 f_EndHMS3 = db . Column ( db . DateTime , nullable = False , server_default = db . FetchedValue ( ) )
 f_BeginYMD = db . Column ( db . DateTime , nullable = False , server_default = db . FetchedValue ( ) )
 f_EndYMD = db . Column ( db . DateTime , nullable = False , server_default = db . FetchedValue ( ) )
 f_ControlSegIDLinked = db . Column ( db . Integer , nullable = False , server_default = db . FetchedValue ( ) )
 f_ReaderCount = db . Column ( db . SmallInteger , nullable = False , server_default = db . FetchedValue ( ) )
 f_LimitedTimesOfDay = db . Column ( db . Integer , nullable = False , server_default = db . FetchedValue ( ) )
 f_LimitedTimesOfHMS1 = db . Column ( db . Integer , nullable = False , server_default = db . FetchedValue ( ) )
 f_LimitedTimesOfHMS2 = db . Column ( db . Integer , nullable = False , server_default = db . FetchedValue ( ) )
 f_LimitedTimesOfHMS3 = db . Column ( db . Integer , nullable = False , server_default = db . FetchedValue ( ) )
 f_ControlByHoliday = db . Column ( db . Integer , nullable = False , server_default = db . FetchedValue ( ) )
 if 63 - 63: i1I
 if 81 - 81: OooOoo . i1I / i1i1i1111I + Oo / Ooo0Ooo % IiI11Ii111
 if 77 - 77: I11iiIi11i1I / iI1iII1I1I1i - oOo0O00 - Ooo0Ooo % oOo0O00
class TBDoor ( db . Model ) :
 __tablename__ = 't_b_door'
 __table_args__ = (
 db . Index ( 't_b_Door_IX_t_b_Door_DoorNO' , 'f_ControllerID' , 'f_DoorNO' ) ,
 )
 if 73 - 73: IiI11Ii111 . Oo * I1I / i1i1i1111I + I1Ii1I1
 f_DoorID = db . Column ( db . Integer , primary_key = True )
 f_ControllerID = db . Column ( db . Integer , nullable = False )
 f_DoorNO = db . Column ( db . SmallInteger , nullable = False , server_default = db . FetchedValue ( ) )
 f_DoorName = db . Column ( db . String ( 1024 ) )
 f_DoorControl = db . Column ( db . Integer , nullable = False , server_default = db . FetchedValue ( ) )
 f_DoorDelay = db . Column ( db . Integer , nullable = False , server_default = db . FetchedValue ( ) )
 f_DoorEnabled = db . Column ( db . Integer , nullable = False , server_default = db . FetchedValue ( ) )
 f_MoreCards_Total = db . Column ( db . Integer , nullable = False , server_default = db . FetchedValue ( ) )
 f_MoreCards_Grp1 = db . Column ( db . Integer , nullable = False , server_default = db . FetchedValue ( ) )
 f_MoreCards_Grp2 = db . Column ( db . Integer , nullable = False , server_default = db . FetchedValue ( ) )
 f_MoreCards_Grp3 = db . Column ( db . Integer , nullable = False , server_default = db . FetchedValue ( ) )
 f_MoreCards_Grp4 = db . Column ( db . Integer , nullable = False , server_default = db . FetchedValue ( ) )
 f_MoreCards_Grp5 = db . Column ( db . Integer , nullable = False , server_default = db . FetchedValue ( ) )
 f_MoreCards_Grp6 = db . Column ( db . Integer , nullable = False , server_default = db . FetchedValue ( ) )
 f_MoreCards_Grp7 = db . Column ( db . Integer , nullable = False , server_default = db . FetchedValue ( ) )
 f_MoreCards_Grp8 = db . Column ( db . Integer , nullable = False , server_default = db . FetchedValue ( ) )
 f_MoreCards_Option = db . Column ( db . Integer , nullable = False , server_default = db . FetchedValue ( ) )
 f_FirstCard_Enabled = db . Column ( db . Integer , nullable = False , server_default = db . FetchedValue ( ) )
 f_FirstCard_Weekday = db . Column ( db . Integer , nullable = False , server_default = db . FetchedValue ( ) )
 f_FirstCard_BeginHMS = db . Column ( db . String ( 100 ) , nullable = False , server_default = db . FetchedValue ( ) )
 f_FirstCard_BeginControl = db . Column ( db . Integer , nullable = False , server_default = db . FetchedValue ( ) )
 f_FirstCard_EndHMS = db . Column ( db . String ( 100 ) , nullable = False , server_default = db . FetchedValue ( ) )
 f_FirstCard_EndControl = db . Column ( db . Integer , nullable = False , server_default = db . FetchedValue ( ) )
 if 31 - 31: i1i1i1111I % I1Ii1I1
 if 1 - 1: IiI11Ii111 - oOo0O00 - i1 . oOo0O00
 if 91 - 91: iI1iII1I1I1i * i1 . ooOOO
I1i = db . Table (
 't_b_elevatorgroup' ,
 db . Column ( 'f_DoorID' , db . Integer , nullable = False , server_default = db . FetchedValue ( ) ) ,
 db . Column ( 'f_ControllerID' , db . Integer , nullable = False , server_default = db . FetchedValue ( ) ) ,
 db . Column ( 'f_ElevatorGroupNO' , db . Integer , nullable = False , server_default = db . FetchedValue ( ) ) ,
 db . Column ( 'f_Notes' , db . Text )
 )
if 83 - 83: OooOoo + i1i1i1111I
if 8 - 8: IiI11Ii111 + i1I
if 37 - 37: iI1iII1I1I1i . oOo0O00 * ooo000 * ooOOO
class TBFloor ( db . Model ) :
 __tablename__ = 't_b_floor'
 if 65 - 65: iI1iII1I1I1i - IiI11Ii111 . Ooo0Ooo . i1iiIII111 * IiI11Ii111
 f_FloorId = db . Column ( db . Integer , primary_key = True )
 f_DoorID = db . Column ( db . Integer , nullable = False , server_default = db . FetchedValue ( ) )
 f_ControllerID = db . Column ( db . Integer , nullable = False , server_default = db . FetchedValue ( ) )
 f_FloorNO = db . Column ( db . Integer , nullable = False , server_default = db . FetchedValue ( ) )
 f_FloorName = db . Column ( db . String ( 255 ) , nullable = False , server_default = db . FetchedValue ( ) )
 f_Notes = db . Column ( db . Text )
 if 33 - 33: i1i1i1111I
 if 30 - 30: i1I % ooOOO . Ii % IIiIIiIi11I1 / iI1iII1I1I1i % ooOOO
 if 24 - 24: IIiIIiIi11I1 - IIiIIiIi11I1 . Ooo0Ooo + i1iiIII111 + Oo
class TBGroup ( db . Model ) :
 __tablename__ = 't_b_group'
 if 21 - 21: IIiIIiIi11I1 - ooo000 + oOO
 f_GroupID = db . Column ( db . Integer , primary_key = True )
 f_GroupName = db . Column ( db . String ( 2047 ) )
 f_GroupNO = db . Column ( db . Integer , nullable = False , server_default = db . FetchedValue ( ) )
 if 5 - 5: i1iiIII111 . i1iiIII111 + ooo000 . I11iiIi11i1I
 if 1 - 1: iI1iII1I1I1i % Ii - I11iiIi11i1I / IiI11Ii111 + iI1iII1I1I1i - Ii
 if 27 - 27: OooOoo % iI1iII1I1I1i + IIiIIiIi11I1
i1i1iI1i1Iii = db . Table (
 't_b_group4meal' ,
 db . Column ( 'f_Id' , db . Integer , nullable = False ) ,
 db . Column ( 'f_GroupID' , db . Integer , nullable = False , server_default = db . FetchedValue ( ) ) ,
 db . Column ( 'f_Morning' , db . BigInteger , nullable = False , server_default = db . FetchedValue ( ) ) ,
 db . Column ( 'f_Lunch' , db . BigInteger , nullable = False , server_default = db . FetchedValue ( ) ) ,
 db . Column ( 'f_Evening' , db . BigInteger , nullable = False , server_default = db . FetchedValue ( ) ) ,
 db . Column ( 'f_Other' , db . BigInteger , nullable = False , server_default = db . FetchedValue ( ) ) ,
 db . Column ( 'f_Enabled' , db . Integer , nullable = False , server_default = db . FetchedValue ( ) ) ,
 db . Column ( 'f_Notes' , db . Text )
 )
if 15 - 15: OooOoo . oOo0O00 - ooOOO % Ooo0Ooo
if 62 - 62: iI1iII1I1I1i / OooOoo % I1I - IiI11Ii111
if 66 - 66: i1i1i1111I / Ooo0Ooo + I11iiIi11i1I + Iii1i + oOo0O00 + i1I
class TBGroup4operator ( db . Model ) :
 __tablename__ = 't_b_group4operator'
 if 75 - 75: OooOoo - oOO - IiIIii11Ii - oOO + ooo000 % iI1iII1I1I1i
 f_OperatorGroupId = db . Column ( db . Integer , primary_key = True )
 f_GroupID = db . Column ( db . Integer , nullable = False , server_default = db . FetchedValue ( ) )
 f_OperatorID = db . Column ( db . Integer , nullable = False , server_default = db . FetchedValue ( ) )
 if 42 - 42: i1 * i1I
 if 50 - 50: Ii - i1iiIII111
 if 96 - 96: ooo000 * OooOoo - Ii - OooOoo
class TBGroup4pccheckacces ( db . Model ) :
 __tablename__ = 't_b_group4pccheckaccess'
 if 65 - 65: Oo + Oo - iI1iII1I1I1i % OooOoo . Ooo0Ooo
 f_Id = db . Column ( db . Integer , primary_key = True )
 f_GroupID = db . Column ( db . Integer , nullable = False , server_default = db . FetchedValue ( ) )
 f_GroupType = db . Column ( db . Integer , nullable = False , server_default = db . FetchedValue ( ) )
 f_CheckAccessActive = db . Column ( db . Integer , nullable = False , server_default = db . FetchedValue ( ) )
 f_MoreCards = db . Column ( db . Integer , nullable = False , server_default = db . FetchedValue ( ) )
 f_SoundFileName = db . Column ( db . String ( 255 ) )
 f_Notes = db . Column ( db . Text )
 if 84 - 84: IIiIIiIi11I1 . ooOOO
 if 44 - 44: ooo000 * i1i1i1111I * oOO + i1iiIII111 - IIiIIiIi11I1
 if 70 - 70: IiI11Ii111
class TBIdcardLost ( db . Model ) :
 __tablename__ = 't_b_idcard_lost'
 if 9 - 9: oOo0O00 * i1
 f_CardNO = db . Column ( db . BigInteger , primary_key = True )
 f_ConsumerID = db . Column ( db . Integer , nullable = False )
 f_Modified = db . Column ( db . DateTime , nullable = False , server_default = db . FetchedValue ( ) )
 if 96 - 96: Ooo0Ooo
 if 13 - 13: Oo * I1Ii1I1 - oOo0O00 * Ii . Ii + oOo0O00
 if 46 - 46: OooOoo - I11iiIi11i1I / Ooo0Ooo
ii1I = db . Table (
 't_b_idcard_phone' ,
 db . Column ( 'f_CardNO' , db . BigInteger , nullable = False ) ,
 db . Column ( 'f_ConsumerID' , db . Integer , nullable = False )
 )
if 80 - 80: IIiIIiIi11I1 / OooOoo % iI1iII1I1I1i / ooOOO * ooOOO - Iii1i
if 60 - 60: oOO * i1i1i1111I / iI1iII1I1I1i
if 45 - 45: Ooo0Ooo + ooOOO * oOo0O00 - ooo000 / IIiIIiIi11I1
i1I1I1Ii = db . Table (
 't_b_mealsetup' ,
 db . Column ( 'f_ID' , db . Integer , nullable = False ) ,
 db . Column ( 'f_Value' , db . Integer ) ,
 db . Column ( 'f_BeginHMS' , db . DateTime ) ,
 db . Column ( 'f_EndHMS' , db . DateTime ) ,
 db . Column ( 'f_ParamVal' , db . BigInteger ) ,
 db . Column ( 'f_Notes' , db . Text )
 )
if 85 - 85: Iii1i + Ii % IIiIIiIi11I1 % oOo0O00
if 100 - 100: IiIIii11Ii % i1
if 82 - 82: ooOOO % OooOoo
class TBReader ( db . Model ) :
 __tablename__ = 't_b_reader'
 __table_args__ = (
 db . Index ( 't_b_Reader_IX_t_b_ReaderNO' , 'f_ControllerID' , 'f_ReaderNO' ) ,
 )
 if 81 - 81: Ii
 f_ReaderID = db . Column ( db . Integer , primary_key = True )
 f_ControllerID = db . Column ( db . Integer , nullable = False )
 f_ReaderNO = db . Column ( db . Integer , nullable = False )
 f_ReaderName = db . Column ( db . String ( 1024 ) )
 f_PasswordEnabled = db . Column ( db . Integer , nullable = False , server_default = db . FetchedValue ( ) )
 f_Attend = db . Column ( db . Integer , nullable = False , server_default = db . FetchedValue ( ) )
 f_Patrol = db . Column ( db . Integer , nullable = False , server_default = db . FetchedValue ( ) )
 f_DutyOnOff = db . Column ( db . Integer , nullable = False )
 f_InputCardno_Enabled = db . Column ( db . Integer , nullable = False , server_default = db . FetchedValue ( ) )
 f_DoorIDIndex = db . Column ( db . Integer , nullable = False , server_default = db . FetchedValue ( ) )
 if 40 - 40: i1I . OooOoo + oOo0O00 . i1iiIII111
 if 96 - 96: I1I / oOO / I11iiIi11i1I + I11iiIi11i1I
 if 35 - 35: IIiIIiIi11I1 + oOo0O00
oooo000O0 = db . Table (
 't_b_reader4patrol' ,
 db . Column ( 'f_ReaderID' , db . Integer )
 )
if 47 - 47: ooo000
if 2 - 2: Oo % IiIIii11Ii - ooOOO
if 75 - 75: IiIIii11Ii * i1 . Iii1i - IiI11Ii111
class TBReaderpassword ( db . Model ) :
 __tablename__ = 't_b_readerpassword'
 if 72 - 72: i1 % i1i1i1111I * iI1iII1I1I1i
 f_Id = db . Column ( db . Integer , primary_key = True )
 f_Password = db . Column ( db . Integer , server_default = db . FetchedValue ( ) )
 f_BAll = db . Column ( db . Integer , server_default = db . FetchedValue ( ) )
 f_ReaderID = db . Column ( db . Integer , server_default = db . FetchedValue ( ) )
 f_Notes = db . Column ( db . Text )
 if 90 - 90: Ooo0Ooo * OooOoo . Ii
 if 5 - 5: Oo - i1 . oOO
 if 18 - 18: IiIIii11Ii - oOO * i1I - OooOoo
o0OOo0OoO = db . Table (
 't_b_shiftset' ,
 db . Column ( 'f_ShiftID' , db . Integer , nullable = False ) ,
 db . Column ( 'f_ShiftName' , db . String ( 50 ) ) ,
 db . Column ( 'f_ReadTimes' , db . Integer ) ,
 db . Column ( 'f_OnDuty1' , db . DateTime ) ,
 db . Column ( 'f_OffDuty1' , db . DateTime ) ,
 db . Column ( 'f_OnDuty2' , db . DateTime ) ,
 db . Column ( 'f_OffDuty2' , db . DateTime ) ,
 db . Column ( 'f_OnDuty3' , db . DateTime ) ,
 db . Column ( 'f_OffDuty3' , db . DateTime ) ,
 db . Column ( 'f_OnDuty4' , db . DateTime ) ,
 db . Column ( 'f_OffDuty4' , db . DateTime ) ,
 db . Column ( 'f_bOvertimeShift' , db . Integer ) ,
 db . Column ( 'f_Notes' , db . Text )
 )
if 57 - 57: Oo + IiIIii11Ii
if 70 - 70: Ii + ooOOO - Oo / i1i1i1111I - I1I * IiI11Ii111
if 3 - 3: i1iiIII111
class TBThirdpartynetdevice ( db . Model ) :
 __tablename__ = 't_b_thirdpartynetdevice'
 if 32 - 32: I1I % i1i1i1111I
 f_DeviceId = db . Column ( db . Integer , primary_key = True )
 f_DeviceName = db . Column ( db . String ( 255 ) , nullable = False , server_default = db . FetchedValue ( ) )
 f_DeviceIP = db . Column ( db . String ( 255 ) , nullable = False , server_default = db . FetchedValue ( ) )
 f_DevicePort = db . Column ( db . Integer , nullable = False , server_default = db . FetchedValue ( ) )
 f_DeviceChannel = db . Column ( db . Integer , nullable = False , server_default = db . FetchedValue ( ) )
 f_Enabled = db . Column ( db . Integer , nullable = False , server_default = db . FetchedValue ( ) )
 f_DeviceUser = db . Column ( db . String ( 255 ) , server_default = db . FetchedValue ( ) )
 f_DevicePassword = db . Column ( db . String ( 255 ) , server_default = db . FetchedValue ( ) )
 f_DeviceType = db . Column ( db . String ( 255 ) )
 f_Factory = db . Column ( db . String ( 255 ) , nullable = False )
 f_CardNOWorkNODiff = db . Column ( db . String ( 255 ) , nullable = False )
 f_ReaderID = db . Column ( db . Integer , nullable = False , server_default = db . FetchedValue ( ) )
 f_Notes = db . Column ( db . Text )
 if 98 - 98: i1I / i1 / OooOoo + Iii1i % ooOOO
 if 19 - 19: ooOOO % I1Ii1I1
 if 15 - 15: OooOoo . IiIIii11Ii . i1I / Iii1i + ooOOO / Ii
class TBUserfloor ( db . Model ) :
 __tablename__ = 't_b_userfloor'
 if 17 - 17: I11iiIi11i1I - i1i1i1111I . iI1iII1I1I1i - I11iiIi11i1I + Oo % iI1iII1I1I1i
 f_RecId = db . Column ( db . Integer , primary_key = True )
 f_FloorId = db . Column ( db . Integer , nullable = False , server_default = db . FetchedValue ( ) )
 f_ConsumerID = db . Column ( db . Integer , nullable = False , server_default = db . FetchedValue ( ) )
 f_ControlSegID = db . Column ( db . Integer , nullable = False , server_default = db . FetchedValue ( ) )
 f_MoreFloorNum = db . Column ( db . Integer , nullable = False , server_default = db . FetchedValue ( ) )
 f_Notes = db . Column ( db . Text )
 if 65 - 65: Ii % I11iiIi11i1I
 if 39 - 39: Iii1i * IIiIIiIi11I1 . Ooo0Ooo - Oo
 if 63 - 63: i1i1i1111I - i1iiIII111 . OooOoo % OooOoo . IiI11Ii111 + i1I
class TDAttendencedatum ( db . Model ) :
 __tablename__ = 't_d_attendencedata'
 if 71 - 71: ooo000 + I11iiIi11i1I % iI1iII1I1I1i + IiI11Ii111 % Oo - Oo
 f_RecID = db . Column ( db . Integer , primary_key = True )
 f_ConsumerID = db . Column ( db . Integer , server_default = db . FetchedValue ( ) )
 f_AttDate = db . Column ( db . DateTime )
 f_Onduty1 = db . Column ( db . DateTime )
 f_Onduty1Desc = db . Column ( db . String ( 50 ) )
 f_Offduty1 = db . Column ( db . DateTime )
 f_Offduty1Desc = db . Column ( db . String ( 50 ) )
 f_Onduty2 = db . Column ( db . DateTime )
 f_Onduty2Desc = db . Column ( db . String ( 50 ) )
 f_Offduty2 = db . Column ( db . DateTime )
 f_Offduty2Desc = db . Column ( db . String ( 50 ) )
 f_LateTime = db . Column ( db . Integer , nullable = False , server_default = db . FetchedValue ( ) )
 f_LeaveEarlyTime = db . Column ( db . Integer , nullable = False , server_default = db . FetchedValue ( ) )
 f_OvertimeTime = db . Column ( db . BigInteger , nullable = False , server_default = db . FetchedValue ( ) )
 f_AbsenceDay = db . Column ( db . BigInteger , nullable = False , server_default = db . FetchedValue ( ) )
 if 84 - 84: I1I % iI1iII1I1I1i - Ooo0Ooo / iI1iII1I1I1i + Ooo0Ooo - Oo
 if 41 - 41: ooOOO + OooOoo + IIiIIiIi11I1 * i1i1i1111I
 if 12 - 12: i1i1i1111I
class TDAttstatistic ( db . Model ) :
 __tablename__ = 't_d_attstatistic'
 if 56 - 56: IiIIii11Ii
 f_RecID = db . Column ( db . Integer , primary_key = True )
 f_ConsumerID = db . Column ( db . Integer , server_default = db . FetchedValue ( ) )
 f_AttDateStart = db . Column ( db . DateTime )
 f_AttDateEnd = db . Column ( db . DateTime )
 f_DayShouldWork = db . Column ( db . Integer , nullable = False , server_default = db . FetchedValue ( ) )
 f_DayRealWork = db . Column ( db . Integer , server_default = db . FetchedValue ( ) )
 f_TotalLate = db . Column ( db . Integer , nullable = False , server_default = db . FetchedValue ( ) )
 f_TotalLeaveEarly = db . Column ( db . Integer , nullable = False , server_default = db . FetchedValue ( ) )
 f_TotalOvertime = db . Column ( db . BigInteger , nullable = False , server_default = db . FetchedValue ( ) )
 f_TotalAbsenceDay = db . Column ( db . BigInteger , nullable = False , server_default = db . FetchedValue ( ) )
 f_TotalNotReadCard = db . Column ( db . Integer , server_default = db . FetchedValue ( ) )
 f_SpecialType1 = db . Column ( db . String ( 50 ) )
 f_SpecialType2 = db . Column ( db . String ( 50 ) )
 f_SpecialType3 = db . Column ( db . String ( 50 ) )
 f_SpecialType4 = db . Column ( db . String ( 50 ) )
 f_SpecialType5 = db . Column ( db . String ( 50 ) )
 f_SpecialType6 = db . Column ( db . String ( 50 ) )
 f_SpecialType7 = db . Column ( db . String ( 50 ) )
 f_SpecialType8 = db . Column ( db . String ( 50 ) )
 f_SpecialType9 = db . Column ( db . String ( 50 ) )
 f_SpecialType10 = db . Column ( db . String ( 50 ) )
 f_SpecialType11 = db . Column ( db . String ( 50 ) )
 f_SpecialType12 = db . Column ( db . String ( 50 ) )
 f_SpecialType13 = db . Column ( db . String ( 50 ) )
 f_SpecialType14 = db . Column ( db . String ( 50 ) )
 f_SpecialType15 = db . Column ( db . String ( 50 ) )
 f_SpecialType16 = db . Column ( db . String ( 50 ) )
 f_SpecialType17 = db . Column ( db . String ( 50 ) )
 f_SpecialType18 = db . Column ( db . String ( 50 ) )
 f_SpecialType19 = db . Column ( db . String ( 50 ) )
 f_SpecialType20 = db . Column ( db . String ( 50 ) )
 f_SpecialType21 = db . Column ( db . String ( 50 ) )
 f_SpecialType22 = db . Column ( db . String ( 50 ) )
 f_SpecialType23 = db . Column ( db . String ( 50 ) )
 f_SpecialType24 = db . Column ( db . String ( 50 ) )
 f_SpecialType25 = db . Column ( db . String ( 50 ) )
 f_SpecialType26 = db . Column ( db . String ( 50 ) )
 f_SpecialType27 = db . Column ( db . String ( 50 ) )
 f_SpecialType28 = db . Column ( db . String ( 50 ) )
 f_SpecialType29 = db . Column ( db . String ( 50 ) )
 f_SpecialType30 = db . Column ( db . String ( 50 ) )
 f_SpecialType31 = db . Column ( db . String ( 50 ) )
 f_SpecialType32 = db . Column ( db . String ( 50 ) )
 f_LateMinutes = db . Column ( db . BigInteger , nullable = False , server_default = db . FetchedValue ( ) )
 f_LeaveEarlyMinutes = db . Column ( db . BigInteger , nullable = False , server_default = db . FetchedValue ( ) )
 f_ManualReadTimesCount = db . Column ( db . Integer , nullable = False , server_default = db . FetchedValue ( ) )
 f_Notes = db . Column ( db . Text )
 if 17 - 17: i1I . oOO % Oo + IiIIii11Ii - Ooo0Ooo
 if 93 - 93: oOo0O00
 if 77 - 77: Oo + I11iiIi11i1I % I1I
class TDDoorfirstcarduser ( db . Model ) :
 __tablename__ = 't_d_doorfirstcardusers'
 if 20 - 20: i1 - IiIIii11Ii . IiIIii11Ii % ooOOO . i1 % Ooo0Ooo
 f_doorFirstCardUsersId = db . Column ( db . Integer , primary_key = True )
 f_DoorID = db . Column ( db . Integer , nullable = False , server_default = db . FetchedValue ( ) )
 f_ConsumerID = db . Column ( db . Integer , nullable = False , server_default = db . FetchedValue ( ) )
 if 72 - 72: oOO % IiI11Ii111 . ooOOO * I1Ii1I1 . ooOOO
 if 90 - 90: IiIIii11Ii + I1Ii1I1 . OooOoo
 if 73 - 73: i1i1i1111I - Iii1i / I11iiIi11i1I . ooo000 / iI1iII1I1I1i - i1iiIII111
class TDDoormorecardsuser ( db . Model ) :
 __tablename__ = 't_d_doormorecardsusers'
 if 21 - 21: i1iiIII111 + IiI11Ii111 % i1i1i1111I
 f_doorMoreCardsUsersId = db . Column ( db . Integer , primary_key = True )
 f_DoorID = db . Column ( db . Integer , nullable = False , server_default = db . FetchedValue ( ) )
 f_MoreCards_GrpID = db . Column ( db . Integer , nullable = False , server_default = db . FetchedValue ( ) )
 f_ConsumerID = db . Column ( db . Integer , nullable = False , server_default = db . FetchedValue ( ) )
 if 7 - 7: IiI11Ii111 / Ii
 if 87 - 87: ooOOO
 if 57 - 57: IIiIIiIi11I1 - iI1iII1I1I1i % ooOOO - I11iiIi11i1I / IiIIii11Ii . Ooo0Ooo
class TDLeave ( db . Model ) :
 __tablename__ = 't_d_leave'
 if 15 - 15: i1I * I11iiIi11i1I - oOo0O00
 f_NO = db . Column ( db . Integer , primary_key = True )
 f_ConsumerID = db . Column ( db . Integer , server_default = db . FetchedValue ( ) )
 f_Value = db . Column ( db . String ( 50 ) )
 f_Value1 = db . Column ( db . String ( 50 ) )
 f_Value2 = db . Column ( db . String ( 50 ) )
 f_Value3 = db . Column ( db . String ( 50 ) )
 f_HolidayType = db . Column ( db . String ( 50 ) )
 f_Notes = db . Column ( db . Text )
 if 6 - 6: IiI11Ii111 - Ii
 if 1 - 1: I1I + OooOoo
 if 98 - 98: i1iiIII111 + Iii1i . IIiIIiIi11I1
class TDManualcardrecord ( db . Model ) :
 __tablename__ = 't_d_manualcardrecord'
 if 96 - 96: OooOoo / oOO - i1 * I11iiIi11i1I
 f_ManualCardRecordID = db . Column ( db . Integer , primary_key = True )
 f_CardNO = db . Column ( db . BigInteger , server_default = db . FetchedValue ( ) )
 f_ReadDate = db . Column ( db . DateTime )
 f_Character = db . Column ( db . SmallInteger , server_default = db . FetchedValue ( ) )
 f_ControllerSN = db . Column ( db . String ( 8 ) )
 f_ReaderID = db . Column ( db . Integer , server_default = db . FetchedValue ( ) )
 f_ConsumerID = db . Column ( db . Integer , server_default = db . FetchedValue ( ) )
 f_Note = db . Column ( db . Text )
 f_DutyOnOff = db . Column ( db . Integer , nullable = False , server_default = db . FetchedValue ( ) )
 if 72 - 72: i1i1i1111I + Ii - Iii1i - i1i1i1111I - i1I + Ooo0Ooo
 if 74 - 74: Ooo0Ooo * Oo + Iii1i - i1iiIII111
 if 22 - 22: IiIIii11Ii - Ooo0Ooo . i1 . i1I - ooo000
class TDMapdoor ( db . Model ) :
 __tablename__ = 't_d_mapdoors'
 if 68 - 68: ooo000
 f_MapDoorId = db . Column ( db . Integer , primary_key = True )
 f_DoorID = db . Column ( db . Integer , nullable = False , server_default = db . FetchedValue ( ) )
 f_MapId = db . Column ( db . Integer , nullable = False , server_default = db . FetchedValue ( ) )
 f_DoorLocationX = db . Column ( db . Integer , nullable = False , server_default = db . FetchedValue ( ) )
 f_DoorLocationY = db . Column ( db . Integer , nullable = False , server_default = db . FetchedValue ( ) )
 f_Notes = db . Column ( db . Text )
 if 40 - 40: i1 + I1Ii1I1 + I11iiIi11i1I . Oo * I11iiIi11i1I % I1I
 if 100 - 100: OooOoo + Oo / OooOoo
 if 33 - 33: IiI11Ii111 / OooOoo
class TDMap ( db . Model ) :
 __tablename__ = 't_d_maps'
 if 98 - 98: I1Ii1I1 . IIiIIiIi11I1 * i1I - iI1iII1I1I1i % i1I * IiI11Ii111
 f_MapId = db . Column ( db . Integer , primary_key = True )
 f_MapName = db . Column ( db . String ( 255 ) , nullable = False , server_default = db . FetchedValue ( ) )
 f_MapPageIndex = db . Column ( db . Integer , nullable = False , server_default = db . FetchedValue ( ) )
 f_MapFile = db . Column ( db . String ( 255 ) , nullable = False , server_default = db . FetchedValue ( ) )
 f_Notes = db . Column ( db . Text )
 if 42 - 42: OooOoo + i1i1i1111I - iI1iII1I1I1i - oOo0O00 * i1I + Ii
 if 46 - 46: oOo0O00 . iI1iII1I1I1i - Ii . oOo0O00 + i1i1i1111I
 if 83 - 83: IiI11Ii111
class TDMeeting ( db . Model ) :
 __tablename__ = 't_d_meeting'
 if 77 - 77: iI1iII1I1I1i - oOO % Ii * i1I - I1I
 f_MeetingNO = db . Column ( db . String ( 15 ) , primary_key = True )
 f_MeetingName = db . Column ( db . String ( 255 ) )
 f_MeetingAdr = db . Column ( db . String ( 255 ) )
 f_MeetingDateTime = db . Column ( db . DateTime , nullable = False )
 f_SignStartTime = db . Column ( db . DateTime , nullable = False )
 f_SignEndTime = db . Column ( db . DateTime , nullable = False )
 f_Content = db . Column ( db . String ( 255 ) )
 f_Notes = db . Column ( db . Text )
 if 42 - 42: I11iiIi11i1I - Ii / Oo - i1i1i1111I + I11iiIi11i1I
 if 83 - 83: i1 . iI1iII1I1I1i
 if 57 - 57: IiI11Ii111 % IiIIii11Ii / oOo0O00 + Ooo0Ooo - i1iiIII111
IIi = db . Table (
 't_d_meetingadr' ,
 db . Column ( 'f_MeetingAdr' , db . String ( 255 ) , nullable = False ) ,
 db . Column ( 'f_ReaderID' , db . Integer , nullable = False , server_default = db . FetchedValue ( ) ) ,
 db . Column ( 'f_Notes' , db . Text )
 )
if 72 - 72: oOo0O00 - IiI11Ii111 + i1iiIII111 / i1I . OooOoo * IiIIii11Ii
if 40 - 40: ooo000 * IiI11Ii111 / i1i1i1111I * oOO + i1iiIII111 - OooOoo
if 86 - 86: I11iiIi11i1I * Ooo0Ooo . IiIIii11Ii % IiIIii11Ii . I1Ii1I1 + I1I
Ooooo = db . Table (
 't_d_meetingconsumer' ,
 db . Column ( 'f_Id' , db . Integer , nullable = False ) ,
 db . Column ( 'f_MeetingNO' , db . String ( 15 ) , nullable = False ) ,
 db . Column ( 'f_ConsumerID' , db . Integer , nullable = False , server_default = db . FetchedValue ( ) ) ,
 db . Column ( 'f_MeetingIdentity' , db . Integer , nullable = False , server_default = db . FetchedValue ( ) ) ,
 db . Column ( 'f_Seat' , db . String ( 255 ) ) ,
 db . Column ( 'f_SignWay' , db . Integer , nullable = False , server_default = db . FetchedValue ( ) ) ,
 db . Column ( 'f_SignRealTime' , db . DateTime ) ,
 db . Column ( 'f_RecID' , db . Integer , nullable = False , server_default = db . FetchedValue ( ) ) ,
 db . Column ( 'f_Notes' , db . Text )
 )
if 38 - 38: I11iiIi11i1I
if 99 - 99: I11iiIi11i1I * i1iiIII111 . OooOoo % ooo000 % OooOoo
if 21 - 21: IiI11Ii111 * I1Ii1I1
class TDPatroldetaildatum ( db . Model ) :
 __tablename__ = 't_d_patroldetaildata'
 if 93 - 93: Ooo0Ooo . i1 + IiI11Ii111 - oOo0O00
 f_RecId = db . Column ( db . Integer , primary_key = True )
 f_ConsumerID = db . Column ( db . Integer )
 f_PatrolDate = db . Column ( db . DateTime )
 f_RouteID = db . Column ( db . Integer )
 f_ReaderID = db . Column ( db . Integer )
 f_PlanPatrolTime = db . Column ( db . DateTime )
 f_RealPatrolTime = db . Column ( db . DateTime )
 f_EventDesc = db . Column ( db . Integer )
 if 97 - 97: i1 - i1 % IIiIIiIi11I1 + IiIIii11Ii / i1I * iI1iII1I1I1i
 if 60 - 60: I11iiIi11i1I - Ooo0Ooo % I1Ii1I1
 if 26 - 26: ooOOO / IIiIIiIi11I1 . oOO + I11iiIi11i1I . Oo
oOO0 = db . Table (
 't_d_patrolplandata' ,
 db . Column ( 'f_RecID' , db . Integer , nullable = False ) ,
 db . Column ( 'f_ConsumerID' , db . Integer ) ,
 db . Column ( 'f_DateYM' , db . String ( 10 ) ) ,
 db . Column ( 'f_RouteID_01' , db . Integer , server_default = db . FetchedValue ( ) ) ,
 db . Column ( 'f_RouteID_02' , db . Integer , server_default = db . FetchedValue ( ) ) ,
 db . Column ( 'f_RouteID_03' , db . Integer , server_default = db . FetchedValue ( ) ) ,
 db . Column ( 'f_RouteID_04' , db . Integer , server_default = db . FetchedValue ( ) ) ,
 db . Column ( 'f_RouteID_05' , db . Integer , server_default = db . FetchedValue ( ) ) ,
 db . Column ( 'f_RouteID_06' , db . Integer , server_default = db . FetchedValue ( ) ) ,
 db . Column ( 'f_RouteID_07' , db . Integer , server_default = db . FetchedValue ( ) ) ,
 db . Column ( 'f_RouteID_08' , db . Integer , server_default = db . FetchedValue ( ) ) ,
 db . Column ( 'f_RouteID_09' , db . Integer , server_default = db . FetchedValue ( ) ) ,
 db . Column ( 'f_RouteID_10' , db . Integer , server_default = db . FetchedValue ( ) ) ,
 db . Column ( 'f_RouteID_11' , db . Integer , server_default = db . FetchedValue ( ) ) ,
 db . Column ( 'f_RouteID_12' , db . Integer , server_default = db . FetchedValue ( ) ) ,
 db . Column ( 'f_RouteID_13' , db . Integer , server_default = db . FetchedValue ( ) ) ,
 db . Column ( 'f_RouteID_14' , db . Integer , server_default = db . FetchedValue ( ) ) ,
 db . Column ( 'f_RouteID_15' , db . Integer , server_default = db . FetchedValue ( ) ) ,
 db . Column ( 'f_RouteID_16' , db . Integer , server_default = db . FetchedValue ( ) ) ,
 db . Column ( 'f_RouteID_17' , db . Integer , server_default = db . FetchedValue ( ) ) ,
 db . Column ( 'f_RouteID_18' , db . Integer , server_default = db . FetchedValue ( ) ) ,
 db . Column ( 'f_RouteID_19' , db . Integer , server_default = db . FetchedValue ( ) ) ,
 db . Column ( 'f_RouteID_20' , db . Integer , server_default = db . FetchedValue ( ) ) ,
 db . Column ( 'f_RouteID_21' , db . Integer , server_default = db . FetchedValue ( ) ) ,
 db . Column ( 'f_RouteID_22' , db . Integer , server_default = db . FetchedValue ( ) ) ,
 db . Column ( 'f_RouteID_23' , db . Integer , server_default = db . FetchedValue ( ) ) ,
 db . Column ( 'f_RouteID_24' , db . Integer , server_default = db . FetchedValue ( ) ) ,
 db . Column ( 'f_RouteID_25' , db . Integer , server_default = db . FetchedValue ( ) ) ,
 db . Column ( 'f_RouteID_26' , db . Integer , server_default = db . FetchedValue ( ) ) ,
 db . Column ( 'f_RouteID_27' , db . Integer , server_default = db . FetchedValue ( ) ) ,
 db . Column ( 'f_RouteID_28' , db . Integer , server_default = db . FetchedValue ( ) ) ,
 db . Column ( 'f_RouteID_29' , db . Integer , server_default = db . FetchedValue ( ) ) ,
 db . Column ( 'f_RouteID_30' , db . Integer , server_default = db . FetchedValue ( ) ) ,
 db . Column ( 'f_RouteID_31' , db . Integer , server_default = db . FetchedValue ( ) ) ,
 db . Column ( 'f_LogDate' , db . DateTime ) ,
 db . Column ( 'f_Notes' , db . Text )
 )
if 19 - 19: i1 . IiIIii11Ii - Ooo0Ooo . Ii
if 51 - 51: i1 + i1i1i1111I - i1 + i1iiIII111 . Oo
if 92 - 92: OooOoo + Ii / IIiIIiIi11I1 + OooOoo * IIiIIiIi11I1 * iI1iII1I1I1i
class TDPatrolroutedetail ( db . Model ) :
 __tablename__ = 't_d_patrolroutedetail'
 if 79 - 79: i1i1i1111I
 f_RecId = db . Column ( db . Integer , nullable = False )
 f_RouteID = db . Column ( db . Integer , primary_key = True , nullable = False )
 f_Sn = db . Column ( db . Integer , primary_key = True , nullable = False )
 f_ReaderID = db . Column ( db . Integer )
 f_patroltime = db . Column ( db . String ( 5 ) )
 f_NextDay = db . Column ( db . Integer )
 if 3 - 3: OooOoo / IiI11Ii111 % I11iiIi11i1I
 if 55 - 55: oOo0O00
 if 31 - 31: Ii . Ooo0Ooo / IiI11Ii111
class TDPatrolroutelist ( db . Model ) :
 __tablename__ = 't_d_patrolroutelist'
 if 59 - 59: Oo
 f_RouteID = db . Column ( db . Integer , primary_key = True )
 f_RouteName = db . Column ( db . String ( 50 ) , nullable = False , unique = True )
 f_Description = db . Column ( db . Text )
 if 64 - 64: Iii1i % I11iiIi11i1I * i1 % OooOoo * oOo0O00
 if 55 - 55: IiI11Ii111
 if 46 - 46: Ooo0Ooo % I1Ii1I1
class TDPatrolstatistic ( db . Model ) :
 __tablename__ = 't_d_patrolstatistic'
 if 86 - 86: I11iiIi11i1I . i1i1i1111I + oOO % I11iiIi11i1I % Iii1i % ooo000
 f_RecId = db . Column ( db . Integer , primary_key = True )
 f_ConsumerID = db . Column ( db . Integer )
 f_PatrolDateStart = db . Column ( db . DateTime )
 f_PatrolDateEnd = db . Column ( db . DateTime )
 f_TotalLate = db . Column ( db . Integer )
 f_TotalEarly = db . Column ( db . Integer )
 f_TotalAbsence = db . Column ( db . Integer )
 f_TotalNormal = db . Column ( db . Integer )
 if 61 - 61: ooo000
 if 48 - 48: Iii1i * i1i1i1111I + IiIIii11Ii
 if 31 - 31: Oo * i1iiIII111 % Ii / oOO + I1Ii1I1 + iI1iII1I1I1i
oo0O = db . Table (
 't_d_patrolusers' ,
 db . Column ( 'f_ConsumerID' , db . Integer )
 )
if 5 - 5: Ii / Ii / i1iiIII111
if 40 - 40: oOO - ooOOO - I1I . IiIIii11Ii + Ii
if 84 - 84: Oo + Ooo0Ooo + ooo000
class TDPrivilege ( db . Model ) :
 __tablename__ = 't_d_privilege'
 if 96 - 96: i1iiIII111 - IIiIIiIi11I1 / IIiIIiIi11I1 * IiIIii11Ii
 f_PrivilegeRecID = db . Column ( db . Integer , primary_key = True )
 f_DoorID = db . Column ( db . Integer , nullable = False )
 f_ControlSegID = db . Column ( db . Integer , nullable = False )
 f_ConsumerID = db . Column ( db . Integer , nullable = False , index = True )
 f_ControllerID = db . Column ( db . Integer , nullable = False )
 f_DoorNO = db . Column ( db . SmallInteger , nullable = False )
 if 67 - 67: Ooo0Ooo . Ooo0Ooo . IiI11Ii111
 if 24 - 24: i1iiIII111 + i1i1i1111I . oOo0O00 + iI1iII1I1I1i + IiI11Ii111
 if 92 - 92: iI1iII1I1I1i / iI1iII1I1I1i + IiIIii11Ii . IiI11Ii111
class TDPrivilegeOfPrivilegetype ( db . Model ) :
 __tablename__ = 't_d_privilege_of_privilegetype'
 if 56 - 56: Ii * ooo000 . IiIIii11Ii
 f_PrivilegeRecID = db . Column ( db . Integer , primary_key = True , nullable = False )
 f_DoorID = db . Column ( db . Integer )
 f_ControlSegID = db . Column ( db . Integer )
 f_ConsumerID = db . Column ( db . Integer )
 f_ControllerID = db . Column ( db . Integer , primary_key = True , nullable = False )
 f_DoorNO = db . Column ( db . Integer )
 if 66 - 66: I1Ii1I1 * OooOoo . iI1iII1I1I1i % OooOoo . i1 . IiIIii11Ii
 if 47 - 47: Ii % OooOoo % iI1iII1I1I1i * IiIIii11Ii
 if 48 - 48: i1I . I11iiIi11i1I / ooo000 + i1iiIII111
class TDPrivilegetype ( db . Model ) :
 __tablename__ = 't_d_privilegetype'
 if 84 - 84: Oo / I1Ii1I1 . IIiIIiIi11I1
 f_PrivilegeTypeID = db . Column ( db . Integer , primary_key = True )
 f_PrivilegeTypeName = db . Column ( db . String ( 50 ) , nullable = False )
 f_Note = db . Column ( db . Text )
 if 67 - 67: Oo % ooOOO + iI1iII1I1I1i * I1I
 if 79 - 79: IIiIIiIi11I1 * Oo / OooOoo
 if 10 - 10: iI1iII1I1I1i / i1iiIII111 . IiIIii11Ii * i1i1i1111I
O000 = db . Table (
 't_d_reader4meal' ,
 db . Column ( 'f_ReaderID' , db . Integer ) ,
 db . Column ( 'f_CostMorning' , db . BigInteger , nullable = False , server_default = db . FetchedValue ( ) ) ,
 db . Column ( 'f_CostLunch' , db . BigInteger , nullable = False , server_default = db . FetchedValue ( ) ) ,
 db . Column ( 'f_CostEvening' , db . BigInteger , nullable = False , server_default = db . FetchedValue ( ) ) ,
 db . Column ( 'f_CostOther' , db . BigInteger , nullable = False , server_default = db . FetchedValue ( ) )
 )
if 82 - 82: I11iiIi11i1I + i1
if 16 - 16: i1 / IIiIIiIi11I1
if 4 - 4: i1I % iI1iII1I1I1i + oOO
iII = db . Table (
 't_d_reader4meeting' ,
 db . Column ( 'f_MeetingNO' , db . String ( 15 ) , nullable = False ) ,
 db . Column ( 'f_ReaderID' , db . Integer )
 )
if 92 - 92: I11iiIi11i1I - Ooo0Ooo - i1i1i1111I % i1iiIII111 / i1i1i1111I * iI1iII1I1I1i
if 60 - 60: IiIIii11Ii % oOO / i1I * OooOoo / I11iiIi11i1I - Ii
if 16 - 16: oOo0O00 / I1Ii1I1 / i1 + I11iiIi11i1I + oOo0O00
class TDShiftAttreport ( db . Model ) :
 __tablename__ = 't_d_shift_attreport'
 if 11 - 11: oOO / OooOoo + oOo0O00
 f_RecID = db . Column ( db . Integer , primary_key = True )
 f_ConsumerID = db . Column ( db . Integer , index = True , server_default = db . FetchedValue ( ) )
 f_ShiftDate = db . Column ( db . DateTime )
 f_ShiftID = db . Column ( db . Integer , server_default = db . FetchedValue ( ) )
 f_ReadTimes = db . Column ( db . Integer , server_default = db . FetchedValue ( ) )
 f_OnDuty1 = db . Column ( db . DateTime )
 f_OnDuty1AttDesc = db . Column ( db . String ( 50 ) )
 f_OnDuty1CardRecordDesc = db . Column ( db . String ( 50 ) )
 f_OffDuty1 = db . Column ( db . DateTime )
 f_OffDuty1AttDesc = db . Column ( db . String ( 50 ) )
 f_OffDuty1CardRecordDesc = db . Column ( db . String ( 50 ) )
 f_OnDuty2 = db . Column ( db . DateTime )
 f_OnDuty2AttDesc = db . Column ( db . String ( 50 ) )
 f_OnDuty2CardRecordDesc = db . Column ( db . String ( 50 ) )
 f_OffDuty2 = db . Column ( db . DateTime )
 f_OffDuty2AttDesc = db . Column ( db . String ( 50 ) )
 f_OffDuty2CardRecordDesc = db . Column ( db . String ( 50 ) )
 f_OnDuty3 = db . Column ( db . DateTime )
 f_OnDuty3AttDesc = db . Column ( db . String ( 50 ) )
 f_OnDuty3CardRecordDesc = db . Column ( db . String ( 50 ) )
 f_OffDuty3 = db . Column ( db . DateTime )
 f_OffDuty3AttDesc = db . Column ( db . String ( 50 ) )
 f_OffDuty3CardRecordDesc = db . Column ( db . String ( 50 ) )
 f_OnDuty4 = db . Column ( db . DateTime )
 f_OnDuty4AttDesc = db . Column ( db . String ( 50 ) )
 f_OnDuty4CardRecordDesc = db . Column ( db . String ( 50 ) )
 f_OffDuty4 = db . Column ( db . DateTime )
 f_OffDuty4AttDesc = db . Column ( db . String ( 50 ) )
 f_OffDuty4CardRecordDesc = db . Column ( db . String ( 50 ) )
 f_LateMinutes = db . Column ( db . BigInteger , server_default = db . FetchedValue ( ) )
 f_LeaveEarlyMinutes = db . Column ( db . BigInteger , server_default = db . FetchedValue ( ) )
 f_OvertimeHours = db . Column ( db . BigInteger , server_default = db . FetchedValue ( ) )
 f_AbsenceDays = db . Column ( db . BigInteger , server_default = db . FetchedValue ( ) )
 f_NotReadCardCount = db . Column ( db . Integer , server_default = db . FetchedValue ( ) )
 f_bOvertimeShift = db . Column ( db . Integer , server_default = db . FetchedValue ( ) )
 if 79 - 79: I11iiIi11i1I . I1Ii1I1 * i1I % I1Ii1I1 / IiI11Ii111
 if 93 - 93: i1I + Iii1i . Ii . i1I * ooOOO
 if 84 - 84: Ooo0Ooo % IiI11Ii111
class TDShiftAttstatistic ( db . Model ) :
 __tablename__ = 't_d_shift_attstatistic'
 if 82 - 82: IIiIIiIi11I1
 f_RecID = db . Column ( db . Integer , primary_key = True )
 f_ConsumerID = db . Column ( db . Integer , index = True , server_default = db . FetchedValue ( ) )
 f_AttDateStart = db . Column ( db . DateTime )
 f_AttDateEnd = db . Column ( db . DateTime )
 f_DayShouldWork = db . Column ( db . Integer , server_default = db . FetchedValue ( ) )
 f_LateMinutes = db . Column ( db . BigInteger , server_default = db . FetchedValue ( ) )
 f_LateCount = db . Column ( db . Integer , server_default = db . FetchedValue ( ) )
 f_LeaveEarlyMinutes = db . Column ( db . BigInteger , server_default = db . FetchedValue ( ) )
 f_LeaveEarlyCount = db . Column ( db . Integer , server_default = db . FetchedValue ( ) )
 f_OvertimeHours = db . Column ( db . BigInteger , server_default = db . FetchedValue ( ) )
 f_AbsenceDays = db . Column ( db . BigInteger , server_default = db . FetchedValue ( ) )
 f_NotReadCardCount = db . Column ( db . Integer , server_default = db . FetchedValue ( ) )
 f_ManualReadTimesCount = db . Column ( db . Integer , server_default = db . FetchedValue ( ) )
 f_SpecialType1 = db . Column ( db . String ( 50 ) )
 f_SpecialType2 = db . Column ( db . String ( 50 ) )
 f_SpecialType3 = db . Column ( db . String ( 50 ) )
 f_SpecialType4 = db . Column ( db . String ( 50 ) )
 f_SpecialType5 = db . Column ( db . String ( 50 ) )
 f_SpecialType6 = db . Column ( db . String ( 50 ) )
 f_SpecialType7 = db . Column ( db . String ( 50 ) )
 f_SpecialType8 = db . Column ( db . String ( 50 ) )
 f_SpecialType9 = db . Column ( db . String ( 50 ) )
 f_SpecialType10 = db . Column ( db . String ( 50 ) )
 f_SpecialType11 = db . Column ( db . String ( 50 ) )
 f_SpecialType12 = db . Column ( db . String ( 50 ) )
 f_SpecialType13 = db . Column ( db . String ( 50 ) )
 f_SpecialType14 = db . Column ( db . String ( 50 ) )
 f_SpecialType15 = db . Column ( db . String ( 50 ) )
 f_SpecialType16 = db . Column ( db . String ( 50 ) )
 f_SpecialType17 = db . Column ( db . String ( 50 ) )
 f_SpecialType18 = db . Column ( db . String ( 50 ) )
 f_SpecialType19 = db . Column ( db . String ( 50 ) )
 f_SpecialType20 = db . Column ( db . String ( 50 ) )
 f_SpecialType21 = db . Column ( db . String ( 50 ) )
 f_SpecialType22 = db . Column ( db . String ( 50 ) )
 f_SpecialType23 = db . Column ( db . String ( 50 ) )
 f_SpecialType24 = db . Column ( db . String ( 50 ) )
 f_SpecialType25 = db . Column ( db . String ( 50 ) )
 f_SpecialType26 = db . Column ( db . String ( 50 ) )
 f_SpecialType27 = db . Column ( db . String ( 50 ) )
 f_SpecialType28 = db . Column ( db . String ( 50 ) )
 f_SpecialType29 = db . Column ( db . String ( 50 ) )
 f_SpecialType30 = db . Column ( db . String ( 50 ) )
 f_SpecialType31 = db . Column ( db . String ( 50 ) )
 f_SpecialType32 = db . Column ( db . String ( 50 ) )
 f_DayRealWork = db . Column ( db . Integer , nullable = False , server_default = db . FetchedValue ( ) )
 f_Notes = db . Column ( db . Text )
 if 81 - 81: oOo0O00 + i1 - ooo000 * iI1iII1I1I1i + i1i1i1111I
 if 89 - 89: I1Ii1I1
 if 57 - 57: iI1iII1I1I1i - i1iiIII111 / OooOoo % i1iiIII111
class TDShiftWorkSchedule ( db . Model ) :
 __tablename__ = 't_d_shift_work_schedule'
 if 92 - 92: IiIIii11Ii * OooOoo - IiIIii11Ii
 f_RecID = db . Column ( db . Integer , primary_key = True )
 f_ConsumerID = db . Column ( db . Integer , index = True , server_default = db . FetchedValue ( ) )
 f_ShiftDate = db . Column ( db . DateTime )
 f_ShiftID = db . Column ( db . Integer )
 f_ReadTimes = db . Column ( db . Integer )
 f_PlanTime = db . Column ( db . DateTime )
 f_TimeSeg = db . Column ( db . Integer , server_default = db . FetchedValue ( ) )
 f_WorkTime = db . Column ( db . DateTime )
 f_AttDesc = db . Column ( db . String ( 20 ) )
 f_CardRecordDesc = db . Column ( db . String ( 20 ) )
 f_Duration = db . Column ( db . Integer , server_default = db . FetchedValue ( ) )
 f_bOvertimeShift = db . Column ( db . Integer , server_default = db . FetchedValue ( ) )
 if 66 - 66: i1iiIII111 . iI1iII1I1I1i / ooOOO . i1 - OooOoo
 if 13 - 13: oOo0O00
 if 50 - 50: i1 - i1iiIII111 / i1iiIII111 % I1Ii1I1 / IIiIIiIi11I1
class TDShiftdatum ( db . Model ) :
 __tablename__ = 't_d_shiftdata'
 if 66 - 66: oOo0O00 - Iii1i - ooo000 . I11iiIi11i1I
 f_RecID = db . Column ( db . Integer , primary_key = True )
 f_ConsumerID = db . Column ( db . Integer , index = True , server_default = db . FetchedValue ( ) )
 f_DateYM = db . Column ( db . String ( 10 ) )
 f_ShiftID_01 = db . Column ( db . Integer , server_default = db . FetchedValue ( ) )
 f_ShiftID_02 = db . Column ( db . Integer , server_default = db . FetchedValue ( ) )
 f_ShiftID_03 = db . Column ( db . Integer , server_default = db . FetchedValue ( ) )
 f_ShiftID_04 = db . Column ( db . Integer , server_default = db . FetchedValue ( ) )
 f_ShiftID_05 = db . Column ( db . Integer , server_default = db . FetchedValue ( ) )
 f_ShiftID_06 = db . Column ( db . Integer , server_default = db . FetchedValue ( ) )
 f_ShiftID_07 = db . Column ( db . Integer , server_default = db . FetchedValue ( ) )
 f_ShiftID_08 = db . Column ( db . Integer , server_default = db . FetchedValue ( ) )
 f_ShiftID_09 = db . Column ( db . Integer , server_default = db . FetchedValue ( ) )
 f_ShiftID_10 = db . Column ( db . Integer , server_default = db . FetchedValue ( ) )
 f_ShiftID_11 = db . Column ( db . Integer , server_default = db . FetchedValue ( ) )
 f_ShiftID_12 = db . Column ( db . Integer , server_default = db . FetchedValue ( ) )
 f_ShiftID_13 = db . Column ( db . Integer , server_default = db . FetchedValue ( ) )
 f_ShiftID_14 = db . Column ( db . Integer , server_default = db . FetchedValue ( ) )
 f_ShiftID_15 = db . Column ( db . Integer , server_default = db . FetchedValue ( ) )
 f_ShiftID_16 = db . Column ( db . Integer , server_default = db . FetchedValue ( ) )
 f_ShiftID_17 = db . Column ( db . Integer , server_default = db . FetchedValue ( ) )
 f_ShiftID_18 = db . Column ( db . Integer , server_default = db . FetchedValue ( ) )
 f_ShiftID_19 = db . Column ( db . Integer , server_default = db . FetchedValue ( ) )
 f_ShiftID_20 = db . Column ( db . Integer , server_default = db . FetchedValue ( ) )
 f_ShiftID_21 = db . Column ( db . Integer , server_default = db . FetchedValue ( ) )
 f_ShiftID_22 = db . Column ( db . Integer , server_default = db . FetchedValue ( ) )
 f_ShiftID_23 = db . Column ( db . Integer , server_default = db . FetchedValue ( ) )
 f_ShiftID_24 = db . Column ( db . Integer , server_default = db . FetchedValue ( ) )
 f_ShiftID_25 = db . Column ( db . Integer , server_default = db . FetchedValue ( ) )
 f_ShiftID_26 = db . Column ( db . Integer , server_default = db . FetchedValue ( ) )
 f_ShiftID_27 = db . Column ( db . Integer , server_default = db . FetchedValue ( ) )
 f_ShiftID_28 = db . Column ( db . Integer , server_default = db . FetchedValue ( ) )
 f_ShiftID_29 = db . Column ( db . Integer , server_default = db . FetchedValue ( ) )
 f_ShiftID_30 = db . Column ( db . Integer , server_default = db . FetchedValue ( ) )
 f_ShiftID_31 = db . Column ( db . Integer , server_default = db . FetchedValue ( ) )
 f_LogDate = db . Column ( db . DateTime , server_default = db . FetchedValue ( ) )
 f_Notes = db . Column ( db . Text )
 if 59 - 59: i1I / IiIIii11Ii
 if 7 - 7: oOo0O00
 if 64 - 64: IIiIIiIi11I1 * oOO + Oo . OooOoo - ooOOO
class TDSwiperecord ( db . Model ) :
 __tablename__ = 't_d_swiperecord'
 __table_args__ = (
 db . Index ( 't_d_SwipeRecord_IX_t_d_SwipeRecord' , 'f_ReadDate' , 'f_ConsumerID' , 'f_ReaderID' ) ,
 )
 if 94 - 94: IiIIii11Ii - ooo000 . Ii
 f_RecID = db . Column ( db . Integer , primary_key = True )
 f_ReadDate = db . Column ( db . DateTime , nullable = False )
 f_CardNO = db . Column ( db . BigInteger , nullable = False )
 f_ConsumerID = db . Column ( db . Integer , nullable = False , server_default = db . FetchedValue ( ) )
 f_Character = db . Column ( db . SmallInteger , nullable = False )
 f_InOut = db . Column ( db . SmallInteger , nullable = False )
 f_Status = db . Column ( db . SmallInteger , nullable = False )
 f_RecOption = db . Column ( db . SmallInteger , nullable = False )
 f_ControllerSN = db . Column ( db . Integer , nullable = False )
 f_ReaderID = db . Column ( db . Integer , nullable = False )
 f_ReaderNO = db . Column ( db . SmallInteger , nullable = False )
 f_RecordFlashLoc = db . Column ( db . Integer , nullable = False )
 f_RecordAll = db . Column ( db . String ( 48 ) , nullable = False )
 f_Modified = db . Column ( db . DateTime , nullable = False , server_default = db . FetchedValue ( ) )
 f_ExtValue = db . Column ( db . Integer , nullable = False , server_default = db . FetchedValue ( ) )
 if 73 - 73: IiIIii11Ii / oOo0O00 % ooo000 . iI1iII1I1I1i % oOO
 if 36 - 36: IiI11Ii111 * OooOoo . ooo000 . i1iiIII111 + oOO
 if 47 - 47: IiI11Ii111 / I11iiIi11i1I
class TDSwiperecord2022 ( db . Model ) :
 __tablename__ = 't_d_swiperecord2022'
 __table_args__ = (
 db . Index ( 't_d_SwipeRecord2022_IX_t_d_SwipeRecord2022' , 'f_ReadDate' , 'f_ConsumerID' , 'f_DoorID' ) ,
 )
 if 52 - 52: Ii . OooOoo . i1iiIII111 * I11iiIi11i1I - iI1iII1I1I1i
 f_RecID = db . Column ( db . Integer , primary_key = True )
 f_ReadDate = db . Column ( db . DateTime , nullable = False )
 f_CardNO = db . Column ( db . BigInteger , nullable = False )
 f_ControllerSN = db . Column ( db . Integer , nullable = False )
 f_DoorNO = db . Column ( db . SmallInteger , nullable = False )
 f_InOut = db . Column ( db . SmallInteger , nullable = False )
 f_Character = db . Column ( db . SmallInteger , nullable = False )
 f_Desc = db . Column ( db . String ( 128 ) , nullable = False )
 f_ConsumerID = db . Column ( db . Integer , nullable = False , server_default = db . FetchedValue ( ) )
 f_DoorID = db . Column ( db . Integer , nullable = False )
 f_RecordFlashLoc = db . Column ( db . Integer , nullable = False )
 f_Modified = db . Column ( db . DateTime , nullable = False , server_default = db . FetchedValue ( ) )
 f_ExtValue = db . Column ( db . Integer , nullable = False , server_default = db . FetchedValue ( ) )
 if 20 - 20: OooOoo % IiI11Ii111 + I1Ii1I1 + IiI11Ii111 - oOo0O00
 if 76 - 76: I11iiIi11i1I % IIiIIiIi11I1 % i1I
 if 39 - 39: IiIIii11Ii . Oo + i1I - oOo0O00
class TSOperator ( db . Model ) :
 __tablename__ = 't_s_operator'
 if 93 - 93: Iii1i * IIiIIiIi11I1 % i1I + i1 % Ii * i1I
 f_OperatorID = db . Column ( db . Integer , primary_key = True )
 f_OperatorName = db . Column ( db . String ( 50 ) , nullable = False , unique = True )
 f_Password = db . Column ( db . String ( 255 ) , nullable = False , server_default = db . FetchedValue ( ) )
 f_OperatePrivilege = db . Column ( db . Text )
 f_Notes = db . Column ( db . String ( 50 ) )
 if 62 - 62: IiI11Ii111 % ooo000
 if 19 - 19: Ii / Oo % Iii1i / i1iiIII111 - OooOoo - Ooo0Ooo
 if 89 - 89: I11iiIi11i1I - IiI11Ii111
class TSOperatorprivilege ( db . Model ) :
 __tablename__ = 't_s_operatorprivilege'
 if 61 - 61: Ii * OooOoo * I1I % i1iiIII111 % IIiIIiIi11I1 * I11iiIi11i1I
 f_OperatorID = db . Column ( db . Integer , primary_key = True , nullable = False )
 f_FunctionID = db . Column ( db . Integer , primary_key = True , nullable = False )
 f_FunctionName = db . Column ( db . String ( 50 ) , nullable = False )
 f_FunctionDisplayName = db . Column ( db . String ( 50 ) , nullable = False )
 f_ReadOnly = db . Column ( db . Integer , nullable = False , server_default = db . FetchedValue ( ) )
 f_FullControl = db . Column ( db . Integer , nullable = False , server_default = db . FetchedValue ( ) )
 if 49 - 49: iI1iII1I1I1i / i1iiIII111 % oOO
 if 46 - 46: ooOOO * IIiIIiIi11I1 % i1 / oOO + i1 + oOo0O00
 if 99 - 99: I1I * IIiIIiIi11I1 * i1iiIII111
class TSWglog ( db . Model ) :
 __tablename__ = 't_s_wglog'
 if 62 - 62: ooOOO % Oo + i1I
 f_RecID = db . Column ( db . Integer , primary_key = True )
 f_EventType = db . Column ( db . String ( 50 ) )
 f_EventDesc = db . Column ( db . Text )
 f_UserID = db . Column ( db . Integer , server_default = db . FetchedValue ( ) )
 f_UserName = db . Column ( db . String ( 50 ) )
 f_LogDateTime = db . Column ( db . DateTime , server_default = db . FetchedValue ( ) )
 if 87 - 87: ooo000 - OooOoo + Ii + i1i1i1111I + IiIIii11Ii
 if 57 - 57: IIiIIiIi11I1 + I1I / ooOOO % ooOOO % Oo / IiI11Ii111
 if 95 - 95: i1 / I11iiIi11i1I . i1 / Oo . Ooo0Ooo
class TSWglog4dooropentoolongwarn ( db . Model ) :
 __tablename__ = 't_s_wglog4dooropentoolongwarn'
 if 43 - 43: Oo - OooOoo * oOO . Ooo0Ooo / IIiIIiIi11I1 * IIiIIiIi11I1
 f_RecID = db . Column ( db . Integer , primary_key = True )
 f_EventType = db . Column ( db . String ( 50 ) )
 f_EventDesc = db . Column ( db . Text )
 f_UserID = db . Column ( db . Integer , nullable = False , server_default = db . FetchedValue ( ) )
 f_UserName = db . Column ( db . String ( 50 ) )
 f_LogDateTime = db . Column ( db . DateTime )
# dd678faae9ac167bc83abf78e5cb2f3f0688d3a3
