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")