class User(db.Model): __tablename__ = "user" id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(20)) password = db.Column(db.String(100), nullable=False) roles = db.relationship("Role", secondary=user_role, back_populates="users") role_names = key_ids = association_proxy("roles", "name")
class Article(db.Model): __tablename__ = "article" id = db.Column(db.Integer, primary_key=True) title = db.Column(db.String(255), nullable=False) description = db.Column(db.String(255)) author_id = db.Column(db.Integer, db.ForeignKey("user.id"), nullable=False) tags = db.Column(db.String(255)) text = db.Column(db.Text(), nullable=False) create_time = db.Column(db.DateTime, default=func.now()) update_time = db.Column( db.DateTime, default=func.now(), onupdate=func.now(), doc=u"更新时间" )
class Project(db.Model): __tablename__ = 'project' id = db.Column(UUID(as_uuid=True), primary_key=True) c_project_id = db.Column(db.String(255)) project_name = db.Column(db.String(255)) signature_date = db.Column(db.DateTime()) service_commencement = db.Column(db.DateTime()) contract_duration_month = db.Column(db.Integer) contract_value_usd = db.Column(db.Numeric) projected_margin_usd = db.Column(db.Numeric) component_of_bespoke = db.Column(db.Integer) often_provide_services = db.Column(db.Integer) is_transition_plan = db.Column(db.Integer) transition_plan_date = db.Column(db.DateTime(255)) is_transition_charges = db.Column(db.Integer) transition_charges = db.Column(db.Numeric) milestones = db.Column(db.Integer) payment_milestones = db.Column(db.Integer) service_levels_without_credit = db.Column(db.Integer) service_credit_cap = db.Column(db.Integer) is_transformation_plan = db.Column(db.Integer) transformation_plan_start = db.Column(db.DateTime(255)) transformation_plan_end = db.Column(db.DateTime(255)) service_levels_with_credit = db.Column(db.Integer) is_earn_back = db.Column(db.Integer) is_customer_satisfaction_report = db.Column(db.Integer) customer_satisfaction_form = db.Column(db.Integer) governance_type = db.Column(db.Integer) governance_often = db.Column(db.Integer) key_personnel = db.Column(db.Integer) supplier_personnel = db.Column(db.Integer) customer_personnel = db.Column(db.Integer) planned_negotiation_month = db.Column(db.Integer) negotiations_month = db.Column(db.Integer) sole_sourced = db.Column(db.Integer) proposed_period_weeks = db.Column(db.Integer) actual_period_weeks = db.Column(db.Integer) is_due_diligence_completed = db.Column(db.Integer) agreement_party = db.Column(db.Integer) type_of_service = db.Column(db.Integer) currency = db.Column(db.Integer) service_credit_cap_type = db.Column(db.Integer) service_level_cap_percentage = db.Column(db.Numeric) CREATED_BY = db.Column(db.Integer) UPDATED_BY = db.Column(db.Integer) UPDATED_AT = db.Column(db.DateTime, server_default=db.func.now()) CREATED_AT = db.Column(db.DateTime, server_default=db.func.now(), server_onupdate=db.func.now())
class User(db.Model): __tablename__ = "user" id = db.Column(UUID(as_uuid=True), primary_key=True) username = db.Column(db.String(255)) email = db.Column(db.String(255), nullable=False) phone = db.Column(db.String(16)) ccode = db.Column(db.String(8)) CREATED_BY = db.Column(db.Integer) UPDATED_BY = db.Column(db.Integer) UPDATED_AT = db.Column(db.DateTime, server_default=db.func.now()) CREATED_AT = db.Column(db.DateTime, server_default=db.func.now(), server_onupdate=db.func.now())
class User(db.Model): __tablename__ = "user" id = db.Column(db.Integer, primary_key=True) # name = db.Column(db.String(20)) # password = db.Column(db.String(100), nullable=False) # roles = db.relationship("Role", secondary=user_role, back_populates="users") # role_names = key_ids = association_proxy("roles", "name") username = db.Column(db.String(255)) email = db.Column(db.String(255), nullable=False) phone = db.Column(db.String(16)) ccode = db.Column(db.String(8)) CREATED_BY = db.Column(db.Integer) UPDATED_BY = db.Column(db.Integer) UPDATED_AT = db.Column(db.DateTime, server_default=db.func.now()) CREATED_AT = db.Column( db.DateTime, server_default=db.func.now(), server_onupdate=db.func.now())
class Role(db.Model): __tablename__ = "role" id = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(255)) users = db.relationship("User", secondary=user_role, back_populates="roles")