class ZoneItem(db.Model): __tablename__ = "zone_item" Id = db.Column(db.BIGINT, primary_key=True) DomainId = db.Column(db.BIGINT, db.ForeignKey('domain.Id')) ObjectId = db.Column(db.BIGINT, db.ForeignKey('object.Id')) Intro = db.Column(db.VARCHAR(255)) Price = db.Column(db.FLOAT) Weight = db.Column(db.FLOAT) Type = db.Column(db.INT) Classical = db.Column(db.INT) Favorite = db.Column(db.INT) Portrait = db.Column(db.VARCHAR(255)) ReferPrice = db.Column(db.FLOAT) BasePrice = db.Column(db.FLOAT) SchemePrice = db.Column(db.FLOAT) ShotPrice = db.Column(db.FLOAT) MusicPrice = db.Column(db.FLOAT) ActorPrice = db.Column(db.FLOAT) AEPrice = db.Column(db.FLOAT) ClassicalWeight = db.Column(db.FLOAT) ViewCount = db.Column(db.INT) Boutique = db.Column(db.BOOLEAN) Object = db.relation('Object', lazy="joined", foreign_keys='ZoneItem.ObjectId') Domain = db.relation('Domain', lazy="joined", foreign_keys='ZoneItem.DomainId') def __init__(self, domain_id, object_id, intro): self.DomainId = domain_id self.ObjectId = object_id self.Intro = intro self.Favorite = 0 self.ClassicalWeight = 0 self.ViewCount = 0 self.Boutique = 0
class ShareUserCache(db.Model): __tablename__ = "shareusercache" Id = db.Column(db.Integer, primary_key=True) ShareObjectId = db.Column(db.Integer, db.ForeignKey("share.Id")) UserId = db.Column(db.Integer, db.ForeignKey("user.Id")) UserRead = db.Column(db.BOOLEAN) UserWrite = db.Column(db.BOOLEAN) UserCreate = db.Column(db.BOOLEAN) UserDelete = db.Column(db.BOOLEAN) UserDownload = db.Column(db.BOOLEAN) CreateTime = db.Column(db.TIMESTAMP) User = db.relationship('User', lazy='joined', backref=db.backref('ShareCache', lazy='dynamic')) ShareObject = db.relationship('Share', uselist=False, backref=db.backref('ShareUserCache', lazy='dynamic')) def __init__(self, UserId, UserRead, UserWrite, UserCreate, UserDelete, UserDownload): self.UserId = UserId self.UserRead = UserRead self.UserWrite = UserWrite self.UserCreate = UserCreate self.UserDelete = UserDelete self.UserDownload = UserDownload # self.CreateTime='current_timestamp()' def __repr__(self): return '<Domain %r>' % {'Id': self.Id, 'UserId': self.UserId}
class StorageShare(db.Model): __tablename__ = 'storage_share' Id = db.Column(db.BIGINT, primary_key=True) ObjectId = db.Column(db.BIGINT, db.ForeignKey('object.Id')) DomainId = db.Column(db.BIGINT, db.ForeignKey('domain.Id')) DownloadPermission = db.Column(db.BOOLEAN) WritePermission = db.Column(db.BOOLEAN) ObjectOwnerDomainId = db.Column(db.BIGINT, db.ForeignKey('domain.Id')) CreateTime = db.Column(db.DATETIME) Domain = db.relation('Domain', lazy='joined', foreign_keys='StorageShare.DomainId') OwnerDomain = db.relation('Domain', lazy='joined', foreign_keys='StorageShare.ObjectOwnerDomainId') Object = db.relation('Object', lazy='joined', foreign_keys='StorageShare.ObjectId') def __init__(self, object_id, domain_id, downloadPermission, writePermission, owner_domain_id): self.ObjectId = object_id self.DomainId = domain_id self.DownloadPermission = downloadPermission self.WritePermission = writePermission self.ObjectOwnerDomainId = owner_domain_id
class Contract(db.Model): __tablename__ = "contract" Id = db.Column(db.BIGINT, primary_key=True) RequirementId = db.Column(db.BIGINT, db.ForeignKey('requirement.Id')) Version = db.Column(db.BIGINT) Title = db.Column(db.VARCHAR(255)) Detail = db.Column(db.TEXT) ServiceUserId = db.Column(db.BIGINT, db.ForeignKey('user.Id')) CustomerUserId = db.Column(db.BIGINT, db.ForeignKey('user.Id')) Status = db.Column(db.BIGINT) Amount = db.Column(db.FLOAT) CreateTime = db.Column(db.TIMESTAMP) PayState = db.Column(db.INTEGER) Scheme = db.Column(db.TEXT) Script = db.Column(db.TEXT) DepositPercent = db.Column(db.FLOAT) Procedure = db.Column(db.VARCHAR(20)) # active, applyAbort, abort Requirement = db.relation('Requirement', backref=db.backref('Contract', lazy='joined'), foreign_keys='Contract.RequirementId', lazy='joined') ServiceUser = db.relation('User', backref=db.backref('AsServiceContract', lazy='dynamic'), foreign_keys='Contract.ServiceUserId', lazy='joined') CustomerUser = db.relation('User', backref=db.backref('AsCustomerContract', lazy='dynamic'), foreign_keys='Contract.CustomerUserId', lazy='joined') # ContractSegmentDynamic = db.relation('ContractSegment', lazy='dynamic') def __init__(self): self.DepositPercent = 50.0 self.Procedure = 'active'
class Share(db.Model): __tablename__ = "share" Id = db.Column(db.Integer, primary_key=True) ObjectId = db.Column(db.Integer, db.ForeignKey("object.Id")) CreatorUserId = db.Column(db.Integer, db.ForeignKey("user.Id")) Name = db.Column(db.VARCHAR(255)) CreateTime = db.Column(db.TIMESTAMP) Users = db.relationship("ShareUser", backref=db.backref("Share", uselist=False), lazy="dynamic", foreign_keys="ShareUser.ShareObjectId") CreatorUser = db.relationship("User", backref=db.backref("Shares", lazy="dynamic"), uselist=False, foreign_keys="Share.CreatorUserId") Object = db.relationship("Object", uselist=False, backref=db.backref("Shares")) UsersCache = db.relationship("ShareUserCache", backref=db.backref("Share", uselist=False), lazy="dynamic", foreign_keys="ShareUserCache.ShareObjectId") def __init__(self, Name, CreatorUserId, ObjectId): self.Name = Name self.CreatorUserId = CreatorUserId self.ObjectId = ObjectId # self.CreateTime='current_timestamp()' def __repr__(self): return '<Share %r>' % { 'Id': self.Id, 'CreatorUserId': self.CreatorUserId }
class Order(db.Model): __tablename__ = "order" Id = db.Column(db.BIGINT, primary_key=True) SerialNumber = db.Column(db.VARCHAR(255)) Subject = db.Column(db.VARCHAR(100)) Description = db.Column(db.VARCHAR(255)) Amount = db.Column(db.FLOAT) UseAccount = db.Column(db.FLOAT) State = db.Column(db.INT) PayUserId = db.Column(db.BIGINT, db.ForeignKey('user.Id')) ReceiverId = db.Column(db.BIGINT, db.ForeignKey('user.Id')) CreateTime = db.Column(db.TIMESTAMP) PayUser = db.relation('User', foreign_keys='Order.PayUserId', lazy="joined") Receiver = db.relation('User', foreign_keys='Order.ReceiverId', lazy="joined") def __init__(self, SerialNumber, Subject, Description, Amount, PayUserId, ReceiverId): self.SerialNumber = SerialNumber self.Subject = Subject self.Description = Description self.Amount = Amount self.UseAccount = 0 self.PayUserId = PayUserId self.ReceiverId = ReceiverId self.State = OrderState.UnPay
class ProjectSegment(db.Model): __tablename__ = "projectsegment" Id = db.Column(db.BIGINT, primary_key=True) ProjectId = db.Column(db.BIGINT, db.ForeignKey('project.Id')) ContractSegmentId = db.Column(db.BIGINT, db.ForeignKey('contractsegment.Id')) PrincipalUserId = db.Column(db.BIGINT, db.ForeignKey('user.Id')) Segment = db.Column(db.BIGINT) Deadline = db.Column(db.DATETIME) Remark = db.Column(db.VARCHAR(2000)) ApplyUserId = db.Column(db.BIGINT, db.ForeignKey('user.Id')) ApplyTime = db.Column(db.DATETIME) ApplyRemark = db.Column(db.VARCHAR(2000)) ConfirmUserId = db.Column(db.BIGINT, db.ForeignKey('user.Id')) ConfirmTime = db.Column(db.DATETIME) ConfirmRemark = db.Column(db.VARCHAR(2000)) Status = db.Column(db.BIGINT) CreateTime = db.Column(db.TIMESTAMP) ContractSegment = db.relation('ContractSegment', backref=db.backref('ProjectSegment', lazy='dynamic')) Project = db.relation('Project', backref=db.backref('ProjectSegment', lazy='joined')) ApplyUser = db.relation('User', foreign_keys='ProjectSegment.ApplyUserId', lazy='joined') ConfirmUser = db.relation('User', foreign_keys='ProjectSegment.ConfirmUserId', lazy='joined')
class ContractAbortRecord(db.Model): __tablename__ = 'contract_abort_record' ContractId = db.Column(db.BIGINT, db.ForeignKey('contract.Id'), primary_key=True) ApplyRemark = db.Column(db.VARCHAR(255)) ConfirmRemark = db.Column(db.VARCHAR(255)) ApplyUserId = db.Column(db.BIGINT, db.ForeignKey('user.Id')) ApplyTime = db.Column(db.DATETIME) ConfirmTime = db.Column(db.DATETIME) ApplyDomainId = db.Column(db.BIGINT) Status = db.Column(db.VARCHAR(20)) ApplyUser = db.relation('User', lazy='joined', foreign_keys='ContractAbortRecord.ApplyUserId') Contract = db.relation('Contract', lazy='joined', foreign_keys='ContractAbortRecord.ContractId') def __init__(self, cid, apply_remark, apply_userid, apply_domainid, apply_time): self.ContractId = cid self.ApplyRemark = apply_remark self.ApplyUserId = apply_userid self.ApplyDomainId = apply_domainid self.ApplyTime = apply_time self.Status = 'apply'
class Project(db.Model): __tablename__ = "project" Id = db.Column(db.BIGINT, primary_key=True) PrincipalUserId = db.Column(db.BIGINT, db.ForeignKey('user.Id')) ContractId = db.Column(db.BIGINT, db.ForeignKey('contract.Id')) RequirementId = db.Column(db.BIGINT, db.ForeignKey('requirement.Id')) Title = db.Column(db.VARCHAR(255)) Detail = db.Column(db.TEXT) CreateTime = db.Column(db.TIMESTAMP)
class GroupUser(db.Model): __tablename__ = "groupuser" Id = db.Column(db.BIGINT, primary_key=True) GroupId = db.Column(db.BIGINT, db.ForeignKey('group.Id')) UserId = db.Column(db.BIGINT, db.ForeignKey('user.Id')) Group = db.relationship('Group', uselist=False) def __init__(self, GroupId, UserId): self.GroupId = GroupId self.UserId = UserId
class RequirementFollower(db.Model): __tablename__ = 'requirement_follower' Id = db.Column(db.BIGINT, primary_key=True) RequirementId = db.Column(db.BIGINT, db.ForeignKey('requirement.Id')) FollowerProducerId = db.Column(db.BIGINT, db.ForeignKey('user.Id')) Scheme = db.Column(db.TEXT) Script = db.Column(db.TEXT) CreateTime = db.Column(db.TIMESTAMP) FollowerDomainId = db.Column(db.BIGINT) IsDeny = db.Column(db.BOOLEAN) Long = db.Column(db.VARCHAR(100)) Format = db.Column(db.VARCHAR(100)) Subtitle = db.Column(db.VARCHAR(2048)) Voice = db.Column(db.VARCHAR(2048)) Gbm = db.Column(db.VARCHAR(2048)) Amount = db.Column(db.FLOAT) DepositPercent = db.Column(db.FLOAT) Remark = db.Column(db.TEXT) Status = db.Column(db.INT) # 是否申请方案确认,0为未申请,1为申请中 BasePrice = db.Column(db.FLOAT) SchemePrice = db.Column(db.FLOAT) ShotPrice = db.Column(db.FLOAT) ActorPrice = db.Column(db.FLOAT) MusicPrice = db.Column(db.FLOAT) AEPrice = db.Column(db.FLOAT) Follower = db.relation( 'User', foreign_keys='RequirementFollower.FollowerProducerId', lazy='joined') Requirement = db.relation('Requirement', backref=db.backref('RequirementFollower', lazy='joined')) def __init__(self, req_id, followerproducer_id, domain_id): self.RequirementId = req_id self.FollowerProducerId = followerproducer_id self.FollowerDomainId = domain_id self.IsDeny = 0 self.Long = '' self.Format = '' self.Subtitle = '' self.Voice = '' self.Gbm = '' self.Amount = 0 self.Script = '' self.Remark = '' self.DepositPercent = 50 self.Status = 0 self.BasePrice = 0 self.SchemePrice = 0 self.ShotPrice = 0 self.ActorPrice = 0 self.MusicPrice = 0 self.AEPrice = 0
class ProjectEventLog(db.Model): __tablename__ = "projecteventlog" Id = db.Column(db.BIGINT, primary_key=True) ProjectId = db.Column(db.BIGINT, db.ForeignKey('project.Id')) UserId = db.Column(db.BIGINT, db.ForeignKey('user.Id')) Action = db.Column(db.BIGINT) Segment = db.Column(db.BIGINT) Detail = db.Column(db.TEXT) CreateTime = db.Column(db.TIMESTAMP) Project = db.relation('Project', backref=db.backref('ProjectEventLog', lazy='dynamic')) ApplyUser = db.relation('User', backref=db.backref('ProjectEventLog', lazy='dynamic'))
class RoleRight(db.Model): __tablename__ = "roleright" Id = db.Column(db.BIGINT, primary_key=True) RightId = db.Column(db.BIGINT, db.ForeignKey('right.Id')) RoleId = db.Column(db.BIGINT, db.ForeignKey('role.Id')) Checked = db.Column(db.BOOLEAN) def __init__(self, rightId, roleId, checked): self.RightId = rightId self.RoleId = roleId self.Checked = checked
class RequirementReply(db.Model): __tablename__ = "requirementreply" Id = db.Column(db.BIGINT, primary_key=True) RequirementId = db.Column(db.BIGINT, db.ForeignKey('requirement.Id')) PublisherId = db.Column(db.BIGINT, db.ForeignKey('user.Id')) Reply = db.Column(db.Text) Status = db.Column(db.BIGINT) CreateTime = db.Column(db.TIMESTAMP) ReplyGroup = db.Column(db.BIGINT) Requirement = db.relation('Requirement', backref=db.backref('RequirementReply', lazy='dynamic')) Publisher = db.relation('User', backref=db.backref('RequirementReply', lazy='dynamic'))
class RequirementSegment(db.Model): __tablename__ = 'requirement_segment' Id = db.Column(db.BIGINT, primary_key=True) RequirementId = db.Column(db.BIGINT, db.ForeignKey('requirement.Id')) SegmentId = db.Column(db.INT, db.ForeignKey('segment.Id')) Segment = db.relation('Segment', lazy='joined') Requirement = db.relation('Requirement', backref=db.backref('Segments', lazy='joined'), lazy='joined') def __init__(self, req_id, seg_id): self.RequirementId = req_id self.SegmentId = seg_id
class ContractReply(db.Model): __tablename__ = "contractreply" Id = db.Column(db.BIGINT, primary_key=True) ContractId = db.Column(db.BIGINT, db.ForeignKey('contract.Id')) PublisherId = db.Column(db.BIGINT, db.ForeignKey('user.Id')) Reply = db.Column(db.Text) Status = db.Column(db.BIGINT) CreateTime = db.Column(db.TIMESTAMP) DestUserId = db.Column(db.BIGINT) Contract = db.relation('Contract') Publisher = db.relation('User')
class RequirementAttachment(db.Model): __tablename__ = "requirementattachment" Id = db.Column(db.BIGINT, primary_key=True) RequirementId = db.Column(db.BIGINT, db.ForeignKey('requirement.Id')) OperateUserId = db.Column(db.BIGINT, db.ForeignKey('user.Id')) ObjectId = db.Column(db.BIGINT, db.ForeignKey('object.Id')) CreateTime = db.Column(db.TIMESTAMP) Description = db.Column(db.VARCHAR(255)) Requirement = db.relation('Requirement', backref=db.backref('RequirementAttachment', lazy='dynamic')) Object = db.relation('Object', lazy='joined') OperateUser = db.relation('User', lazy='joined')
class CollectionVideo(db.Model): __tablename__ = "collection_video" Id = db.Column(db.BIGINT, primary_key=True) ZoneItemId = db.Column(db.BIGINT, db.ForeignKey("zone_item.Id")) UserId = db.Column(db.BIGINT, db.ForeignKey("user.Id")) ZoneItem = db.relation('ZoneItem', lazy="joined") User = db.relation('User', lazy="joined") def __init__(self, item_id, user_id): self.ZoneItemId = item_id self.UserId = user_id
class FinalVideoHistory(db.Model): __tablename__ = "finalvideohistory" Id = db.Column(db.BIGINT, primary_key=True) ContractId = db.Column(db.BIGINT, db.ForeignKey('contract.Id')) FinalVideoId = db.Column(db.BIGINT, db.ForeignKey('finalvideo.Id')) Version = db.Column(db.BIGINT) RejectReason = db.Column(db.VARCHAR(1024)) RejectTime = db.Column(db.DATETIME) ApplyRemark = db.Column(db.VARCHAR(1024)) ApplyTime = db.Column(db.DATETIME) CreateTime = db.Column(db.TIMESTAMP) Detail = db.Column(db.TEXT)
class ContractAttachment(db.Model): __tablename__ = "contractattachment" Id = db.Column(db.BIGINT, primary_key=True) ContractId = db.Column(db.BIGINT, db.ForeignKey('contract.Id')) ProviderUserId = db.Column(db.BIGINT, db.ForeignKey('user.Id')) ObjectId = db.Column(db.BIGINT, db.ForeignKey('object.Id')) CreateTime = db.Column(db.TIMESTAMP) Type = db.Column(db.INT) Status = db.Column(db.INT) Contract = db.relation('Contract', backref=db.backref('ContractAttachment', lazy='dynamic')) ProviderUser = db.relation('User', backref=db.backref('ContractAttachment', lazy='dynamic')) Object = db.relation('Object', lazy='joined')
class FollowerAttachment(db.Model): __tablename__ = 'followerattachment' Id = db.Column(db.BIGINT, primary_key=True) FollowerId = db.Column(db.BIGINT, db.ForeignKey('requirement_follower.Id')) ObjectId = db.Column(db.BIGINT, db.ForeignKey('object.Id')) CreateTime = db.Column(db.TIMESTAMP) Follower = db.relation('RequirementFollower', backref=db.backref('FollowerAttachment', lazy='joined')) Object = db.relation('Object', lazy='joined') def __init__(self, follower_id, object_id): self.FollowerId = follower_id self.ObjectId = object_id self.CreateTime = datetime.datetime.now()
class ContractOrder(db.Model): __tablename__ = "contract_order" Id = db.Column(db.BIGINT, primary_key=True) ContractId = db.Column(db.BIGINT, db.ForeignKey("contract.Id")) OrderId = db.Column(db.BIGINT, db.ForeignKey("order.Id")) OrderType = db.Column(db.INT) Contract = db.relation('Contract', lazy="joined", backref=db.backref('ContractOrder', lazy='dynamic')) Order = db.relation('Order', lazy="joined") def __init__(self, ContractId, OrderId, OrderType): self.ContractId = ContractId self.OrderId = OrderId self.OrderType = OrderType
class ReferenceTaxon(db.Model): __table_args__ = (PrimaryKeyConstraint('reference_id', 'taxon_id'), ) reference_id = db.Column(db.Integer, db.ForeignKey("reference.id")) taxon_id = db.Column(db.Integer, db.ForeignKey("taxon.id")) def __init__(self, reference_id, taxon_id): self.reference_id = reference_id self.taxon_id = taxon_id # custom init for the sampleList def __init__(self, reference_id, taxon, wew_value): self.reference_id = reference_id self.taxon = taxon self.wew_value = wew_value def json(self): """Returns the models data converted to JSON""" return {"ReferenceId": self.reference_id, "TaxonId": self.taxon_id} def jsonValue(self): """Returns the models data converted to JSON""" return { "reference_id": self.reference_id, "taxon": self.taxon, "wew_value": self.wew_value } @classmethod def findTaxonListBySampleId(cls, id): """Returns the data of all taxa chosen by sample id""" query = db.session.query(cls, Taxon, WewValue) \ .join(Taxon).filter(cls.reference_id == id) \ .join(WewValue, WewValue.taxon_id == Taxon.id) \ .all() return query @classmethod def findReferenceById(cls, reference_id): """Returns the data of a specific reference chosen by id""" return cls.query.all() def save(self): """Saves the object to the table specified in the model""" db.session.add(self) db.session.commit() def delete(self): """Deletes the object from the table specified in the model""" db.session.delete(self) db.session.commit()
class ContractUserGroup(db.Model): __tablename__ = "contractusergroup" Id = db.Column(db.BIGINT, primary_key=True) ContractId = db.Column(db.BIGINT, db.ForeignKey('contract.Id')) UserId = db.Column(db.BIGINT, db.ForeignKey('user.Id')) DomainId = db.Column(db.BIGINT) CreateTime = db.Column(db.TIMESTAMP) Description = db.Column(db.VARCHAR(255)) User = db.relation('User', lazy='joined') def __init__(self, con_id, user_id, domain_id, description): self.ContractId = con_id self.UserId = user_id self.DomainId = domain_id self.Description = description
class Group(db.Model): __tablename__ = "group" Id = db.Column(db.Integer, primary_key=True) GroupName = db.Column(db.String(50)) ShareObjectId = db.Column(db.Integer, db.ForeignKey("share.Id")) GroupRead = db.Column(db.BOOLEAN) GroupWrite = db.Column(db.BOOLEAN) GroupCreate = db.Column(db.BOOLEAN) GroupDelete = db.Column(db.BOOLEAN) GroupDownload = db.Column(db.BOOLEAN) CreateTime = db.Column(db.TIMESTAMP) ShareObject = db.relationship('Share', backref=db.backref('Groups', lazy='dynamic'), lazy='select', uselist=False) Users = db.relationship('User', secondary=groupusers, backref=db.backref('Group', uselist=False)) UsersQuery = db.relationship('User', secondary=groupusers, lazy='dynamic') def __init__(self, GroupName, GroupRead, GroupWrite, GroupCreate, GroupDelete, GroupDownload): self.GroupName = GroupName self.GroupRead = GroupRead self.GroupWrite = GroupWrite self.GroupCreate = GroupCreate self.GroupDelete = GroupDelete self.GroupDownload = GroupDownload # self.CreateTime='current_timestamp()' def __repr__(self): return '<Group %r>' % {'Id': self.Id, 'OwnerUserId': self.OwnerUserId}
class Post(db.Model): id = db.Column(db.Integer, primary_key=True) body = db.Column(db.String(140)) timestamp = db.Column(db.DateTime, index=True, default=datetime.utcnow) user_id = db.Column(db.Integer, db.ForeignKey('user.id')) def __repr__(self): return '<Post {}>'.format(self.body)
class ContractEventLog(db.Model): __tablename__ = "contracteventlog" Id = db.Column(db.BIGINT, primary_key=True) ContractId = db.Column(db.BIGINT, db.ForeignKey('contract.Id')) UserId = db.Column(db.BIGINT, db.ForeignKey('user.Id')) Action = db.Column(db.BIGINT) Segment = db.Column(db.BIGINT) Detail = db.Column(db.TEXT) CreateTime = db.Column(db.TIMESTAMP) Contract = db.relation('Contract', backref=db.backref('ContractEventLog', lazy='dynamic')) User = db.relation('User', backref=db.backref('ContractEventLog', lazy='dynamic')) def __init__(self, con_id, user_id, action, segment, detail): self.ContractId = con_id self.UserId = user_id self.Action = action self.Segment = segment self.Detail = detail
class Requirement(db.Model): __tablename__ = "requirement" Id = db.Column(db.BIGINT, primary_key=True) PublisherId = db.Column(db.BIGINT, db.ForeignKey('user.Id')) ServiceUserId = db.Column(db.BIGINT, db.ForeignKey('user.Id')) Title = db.Column(db.VARCHAR(255)) Detail = db.Column(db.TEXT) Amount = db.Column(db.FLOAT) Status = db.Column(db.INT, db.ForeignKey('segment.Id')) CreateTime = db.Column(db.TIMESTAMP) Publisher = db.relation('User', backref=db.backref('Requirements', lazy='dynamic'), foreign_keys='Requirement.PublisherId', lazy='joined') Deadline = db.Column(db.VARCHAR(20)) Type = db.Column(db.VARCHAR(20)) Long = db.Column(db.VARCHAR(100)) Format = db.Column(db.VARCHAR(100)) Voice = db.Column(db.VARCHAR(2048)) Gbm = db.Column(db.VARCHAR(2048)) Place = db.Column(db.VARCHAR(20)) Refer = db.Column(db.VARCHAR(100)) ReferName = db.Column(db.VARCHAR(100)) Symbol = db.Column(db.VARCHAR(20)) Subtitle = db.Column(db.VARCHAR(2048)) Category_1 = db.Column(db.INT) Category_2 = db.Column(db.INT) Scheme = db.Column(db.TEXT) ContractId = db.Column(db.INT) DepositPercent = db.Column(db.FLOAT) Star = db.Column(db.INT) Comment = db.Column(db.VARCHAR(255)) Remark = db.Column(db.TEXT) ApplyStatus = db.Column(db.INT) IsFinalPay = db.Column(db.INT) IsAdvancePay = db.Column(db.INT) ServiceUser = db.relation('User', foreign_keys='Requirement.ServiceUserId', lazy='joined') CurSegment = db.relation('Segment', lazy='joined') def __init__(self): self.DepositPercent = 50.0 self.ApplyStatus = 0 self.IsFinalPay = 0 self.IsAdvancePay = 0
class CollectionProducer(db.Model): __tablename__ = "collection_producer" Id = db.Column(db.BIGINT, primary_key=True) DomainId = db.Column(db.BIGINT, db.ForeignKey("domain.Id")) UserId = db.Column(db.BIGINT) Domain = db.relation('Domain', lazy="joined") def __init__(self, domain_id, user_id): self.DomainId = domain_id self.UserId = user_id
class ProducerSetting(db.Model): __tablename__ = "setting_producer" DomainId = db.Column(db.BIGINT, db.ForeignKey('domain.Id'), primary_key=True) Position = db.Column(db.INT) Domain = db.relation('Domain', foreign_keys='ProducerSetting.DomainId') def __init__(self, did, position): self.DomainId = did self.Position = position