ningjian@freegodly:~/code/py/django/logcloud$ catlogcloude_model.py
# coding: utf-8from sqlalchemy import BigInteger, Column, DateTime, Float, ForeignKey, Integer, LargeBinary, T able, Unicode, text
from sqlalchemy.dialects.mssql.base import BIT
from sqlalchemy.orm import relationship
from sqlalchemy.ext.declarative import declarative_base
Base=declarative_base()
metadata=Base.metadata
class AuthorityInfo(Base):
__tablename__= 'AuthorityInfo'ID= Column(BigInteger, primary_key=True)
Description= Column(Unicode('max'), nullable=False)
IsDelete= Column(BIT, nullable=False)
AuthorityIndex= Column(Integer, nullable=False)
AuthorityName= Column(Unicode('max'), nullable=False)
class CPKInfoHistory(Base):
__tablename__= 'CPKInfoHistory'PO= Column(Unicode(10), primary_key=True)
ProcessName= Column(Unicode(50), nullable=False)
Result= Column(Unicode('max'), nullable=False)
LastLogID= Column(BigInteger, nullable=False)
class ComputerState(Base):
__tablename__= 'ComputerState'Name= Column(Unicode(50), primary_key=True)
Ip= Column(Unicode(50), nullable=False)
IsDelete= Column(BIT, nullable=False)
LastDate= Column(DateTime, nullable=False)
IsProceted= Column(BIT, nullable=False)
class DeviceInfo(Base):
__tablename__= 'DeviceInfo'ID= Column(BigInteger, primary_key=True)
ClientName= Column(Unicode(50), nullable=False)
Description= Column(Unicode(1024))
IsDelete= Column(BIT, nullable=False)
LinesInfo_ID= Column(ForeignKey(u'LinesInfo.ID'), nullable=False, index=True)
LinesInfo= relationship(u'LinesInfo')
class DisposeErrorCodeInfo(Base):
__tablename__= 'DisposeErrorCodeInfo'ID= Column(BigInteger, primary_key=True)
NewOperation= Column(Unicode('max'), nullable=False)
Status= Column(Unicode('max'), nullable=False)
DisposeInfo_ID= Column(ForeignKey(u'DisposeInfo.ID'), nullable=False, index=True)
ErrorCode_Info_ID= Column(ForeignKey(u'ErrorCode_Info.ID'), nullable=False, index=True)
ErrorCode_OperationID= Column(BigInteger, nullable=False)
WeightValue= Column(Integer, nullable=False)
DisposeInfo= relationship(u'DisposeInfo')
ErrorCode_Info= relationship(u'ErrorCodeInfo')
class DisposeErrorCodeInfoHistory(Base):
__tablename__= 'DisposeErrorCodeInfoHistory'ID= Column(BigInteger, primary_key=True)
OperateTime= Column(DateTime, nullable=False)
OldStatus= Column(Unicode('max'), nullable=False)
NewStatus= Column(Unicode('max'), nullable=False)
IsDelete= Column(BIT, nullable=False)
WeightValue= Column(Integer, nullable=False)
UserInfo_ID= Column(ForeignKey(u'UserInfo.ID'), nullable=False, index=True)
DisposeErrorCodeInfo_ID= Column(ForeignKey(u'DisposeErrorCodeInfo.ID'), nullable=False, in dex=True)
DisposeErrorCodeInfo= relationship(u'DisposeErrorCodeInfo')
UserInfo= relationship(u'UserInfo')
class DisposeInfo(Base):
__tablename__= 'DisposeInfo'ID= Column(BigInteger, primary_key=True)
Operation= Column(Unicode('max'), nullable=False)
IsOK= Column(BIT, nullable=False)
Description= Column(Unicode(1024))
TouchTime= Column(DateTime, nullable=False)
NoticeInfo_ID= Column(ForeignKey(u'NoticeInfo.ID'), nullable=False, index=True)
UserTask_ID= Column(ForeignKey(u'UserTask.ID'), nullable=False, index=True)
NoticeInfo= relationship(u'NoticeInfo')
UserTask= relationship(u'UserTask')
class ErrorCodeInfo(Base):
__tablename__= 'ErrorCode_Info'ID= Column(BigInteger, primary_key=True)
ErrorCode= Column(Unicode(10), nullable=False)
Description= Column(Unicode(1024))
IsDelete= Column(BIT, nullable=False)
class ErrorCodeOperation(Base):
__tablename__= 'ErrorCode_Operation'ID= Column(BigInteger, primary_key=True)
Operation= Column(Unicode('max'), nullable=False)
WeightValue= Column(Integer, nullable=False)
IsEnable= Column(BIT, nullable=False)
ErrorCode_Info_ID= Column(ForeignKey(u'ErrorCode_Info.ID'), nullable=False, index=True)
ErrorCode_Info= relationship(u'ErrorCodeInfo')
class FilesManage(Base):
__tablename__= 'FilesManage'ID= Column(BigInteger, primary_key=True)
ClassName= Column(Unicode(50), nullable=False, index=True)
Md5= Column(Unicode(32), nullable=False)
Data= Column(LargeBinary, nullable=False)
Ver= Column(Integer, nullable=False)
DateCreated= Column(Unicode(50), nullable=False)
UpLoadUserName= Column(Unicode(50), nullable=False)
Remarks= Column(Unicode('max'))
Catagory= Column(Unicode(50), nullable=False)
LocalFileName= Column(Unicode(50))
class LOGInfo(Base):
__tablename__= 'LOG_Info'ID= Column(BigInteger, primary_key=True)
Po= Column(Unicode(10), nullable=False, index=True)
ProcessName= Column(Unicode(10), nullable=False, index=True)
User= Column(Unicode(10), nullable=False)
ErrorCode= Column(Unicode(10))
Log= Column(Unicode('max'), nullable=False)
Barcode= Column(Unicode(50))
Isn= Column(Unicode(50))
Shift= Column(Unicode(10), nullable=False)
TestResult= Column(Unicode(10), nullable=False, index=True)
LastDate= Column(DateTime, nullable=False)
ClientName= Column(Unicode(50), nullable=False, index=True)
class LinesInfo(Base):
__tablename__= 'LinesInfo'ID= Column(BigInteger, primary_key=True)
Name= Column(Unicode(50), nullable=False)
Description= Column(Unicode(1024))
IsDelete= Column(BIT, nullable=False)
class NoticeInfo(Base):
__tablename__= 'NoticeInfo'ID= Column(BigInteger, primary_key=True)
Top1_ErrorCodeID= Column(BigInteger, nullable=False)
Top2_ErrorCodeID=Column(BigInteger)
Top3_ErrorCodeID=Column(BigInteger)
TouchTime= Column(DateTime, nullable=False)
IsDispose= Column(BIT, nullable=False)
TaskLavel= Column(Integer, nullable=False)
Responsibility_ID= Column(ForeignKey(u'Responsibility.ID'), nullable=False, index=True)
UserTask_ID= Column(ForeignKey(u'UserTask.ID'), nullable=False, index=True)
DeviceInfo_ID= Column(ForeignKey(u'DeviceInfo.ID'), nullable=False, index=True)
StatisticsInfo_ID= Column(BigInteger, nullable=False)
DeviceInfo= relationship(u'DeviceInfo')
Responsibility= relationship(u'Responsibility')
UserTask= relationship(u'UserTask')
class POInfo(Base):
__tablename__= 'POInfo'ID= Column(BigInteger, primary_key=True)
Po= Column(Unicode(10), nullable=False)
Plm= Column(Unicode(20))
ProductName= Column(Unicode(50))
Description= Column(Unicode(1024))
IsDelete= Column(BIT, nullable=False)
Customer= Column(Unicode(50))
class Responsibility(Base):
__tablename__= 'Responsibility'ID= Column(BigInteger, primary_key=True)
ProcessName= Column(Unicode(10), nullable=False)
BaseNumber= Column(Integer, nullable=False)
ErrorRate= Column(Float(53), nullable=False)
Description= Column(Unicode(1024))
OverTime= Column(Integer, nullable=False)
POInfo_ID= Column(ForeignKey(u'POInfo.ID'), nullable=False, index=True)
UserInfo_ID= Column(ForeignKey(u'UserInfo.ID'), nullable=False, index=True)
POInfo= relationship(u'POInfo')
UserInfo= relationship(u'UserInfo')
class RoleAuthority(Base):
__tablename__= 'RoleAuthority'ID= Column(BigInteger, primary_key=True)
IsDelete= Column(BIT, nullable=False)
RoleInfo_ID= Column(ForeignKey(u'RoleInfo.ID'), nullable=False, index=True)
AuthorityInfo_ID= Column(ForeignKey(u'AuthorityInfo.ID'), nullable=False, index=True)
AuthorityInfo= relationship(u'AuthorityInfo')
RoleInfo= relationship(u'RoleInfo')
class RoleInfo(Base):
__tablename__= 'RoleInfo'ID= Column(BigInteger, primary_key=True)
RoleName= Column(Unicode(256), nullable=False)
Description= Column(Unicode(1024))
IsDelete= Column(BIT, nullable=False)
RoleLevel= Column(Integer, nullable=False)
class SettingInfo(Base):
__tablename__= 'SettingInfo'ID= Column(BigInteger, primary_key=True, nullable=False)
Key= Column(Unicode(50), primary_key=True, nullable=False)
Value= Column(Unicode('max'), nullable=False)
Description= Column(Unicode(1024))
class StatisticsInfo(Base):
__tablename__= 'StatisticsInfo'ID= Column(BigInteger, primary_key=True)
ProcessName= Column(Unicode(10), nullable=False)
BeginTime= Column(DateTime, nullable=False)
NowErrorRate= Column(Float(53), nullable=False)
Times= Column(Integer, nullable=False)
IsOutmoded= Column(BIT, nullable=False)
POInfo_ID= Column(ForeignKey(u'POInfo.ID'), nullable=False, index=True)
DeviceInfo_ID= Column(ForeignKey(u'DeviceInfo.ID'), nullable=False, index=True)
DeviceInfo= relationship(u'DeviceInfo')
POInfo= relationship(u'POInfo')
class UserInfo(Base):
__tablename__= 'UserInfo'ID= Column(BigInteger, primary_key=True)
Name= Column(Unicode(10), nullable=False)
JobNumber= Column(Unicode(10), nullable=False)
Phone= Column(Unicode(20))
Emil= Column(Unicode(30), nullable=False)
Department= Column(Unicode(20))
Duties= Column(Unicode(20))
Description= Column(Unicode(1024))
Group= Column(Unicode(20), nullable=False)
IsDelete= Column(BIT, nullable=False)
Password= Column(Unicode(32))
CreateDateTime= Column(DateTime, nullable=False)
class UserProfile(Base):
__tablename__= 'UserProfile'UserId= Column(Integer, primary_key=True)
UserName= Column(Unicode(56), nullable=False, unique=True)
class UserRoleInfo(Base):
__tablename__= 'UserRoleInfo'ID= Column(BigInteger, primary_key=True)
IsDelete= Column(BIT, nullable=False)
UserInfo_ID= Column(ForeignKey(u'UserInfo.ID'), nullable=False, index=True)
RoleInfo_ID= Column(ForeignKey(u'RoleInfo.ID'), nullable=False, index=True)
RoleInfo= relationship(u'RoleInfo')
UserInfo= relationship(u'UserInfo')
class UserTask(Base):
__tablename__= 'UserTask'ID= Column(BigInteger, primary_key=True)
TaskLavel= Column(Integer, nullable=False)
Shift= Column(Unicode(10), nullable=False)
Description= Column(Unicode(1024))
IsDelete= Column(BIT, nullable=False)
UserInfo_ID= Column(ForeignKey(u'UserInfo.ID'), nullable=False, index=True)
LinesInfo_ID= Column(ForeignKey(u'LinesInfo.ID'), nullable=False, index=True)
LinesInfo= relationship(u'LinesInfo')
UserInfo= relationship(u'UserInfo')
t_view_LinesState=Table('view_LinesState', metadata,
Column('ID', BigInteger, nullable=False),
Column('ClientName', Unicode(50), nullable=False),
Column('LinesInfo_ID', BigInteger, nullable=False),
Column('count', Integer)
)
t_view_LogState=Table('view_LogState', metadata,
Column('Po', Unicode(10), nullable=False),
Column('ProcessName', Unicode(10), nullable=False),
Column('ErrorCode', Unicode(10)),
Column('ClientName', Unicode(50), nullable=False),
Column('ID', BigInteger),
Column('count', Integer)
)
t_view_NoticeInfo=Table('view_NoticeInfo', metadata,
Column('ID', BigInteger, nullable=False),
Column('TouchTime', DateTime, nullable=False),
Column('Top1_ErrorCodeID', BigInteger, nullable=False),
Column('Top2_ErrorCodeID', BigInteger),
Column('Top3_ErrorCodeID', BigInteger),
Column('IsDispose', BIT, nullable=False),
Column('TaskLavel', Integer, nullable=False),
Column('ClientName', Unicode(50)),
Column('ProcessName', Unicode(10)),
Column('BeginTime', DateTime),
Column('NowErrorRate', Float(53)),
Column('Times', Integer),
Column('IsOutmoded', BIT),
Column('Po', Unicode(10))
)
t_view_Top1_error=Table('view_Top1_error', metadata,
Column('Top1_ErrorCodeID', BigInteger, nullable=False),
Column('count', Integer),
Column('ID', BigInteger, nullable=False),
Column('ErrorCode', Unicode(10), nullable=False),
Column('Description', Unicode(1024))
)
class WebpagesMembership(Base):
__tablename__= 'webpages_Membership'UserId= Column(Integer, primary_key=True)
CreateDate=Column(DateTime)
ConfirmationToken= Column(Unicode(128))
IsConfirmed= Column(BIT, server_default=text("((0))"))
LastPasswordFailureDate=Column(DateTime)
PasswordFailuresSinceLastSuccess= Column(Integer, nullable=False, server_default=text("((0 ))"))
Password= Column(Unicode(128), nullable=False)
PasswordChangedDate=Column(DateTime)
PasswordSalt= Column(Unicode(128), nullable=False)
PasswordVerificationToken= Column(Unicode(128))
PasswordVerificationTokenExpirationDate=Column(DateTime)
class WebpagesOAuthMembership(Base):
__tablename__= 'webpages_OAuthMembership'Provider= Column(Unicode(30), primary_key=True, nullable=False)
ProviderUserId= Column(Unicode(100), primary_key=True, nullable=False)
UserId= Column(Integer, nullable=False)
class WebpagesRole(Base):
__tablename__= 'webpages_Roles'RoleId= Column(Integer, primary_key=True)
RoleName= Column(Unicode(256), nullable=False, unique=True)
UserProfile= relationship(u'UserProfile', secondary='webpages_UsersInRoles')
t_webpages_UsersInRoles=Table('webpages_UsersInRoles', metadata,
Column('UserId', ForeignKey(u'UserProfile.UserId'), primary_key=True, nullable=False),
Column('RoleId', ForeignKey(u'webpages_Roles.RoleId'), primary_key=True, nullable=False)
)
ningjian@freegodly:~/code/py/django/logcloud$