class Finance(EntityModel):
profit_ability = db.Column(db.String(100))
debtpay_ability = db.Column(db.String(100))
cashflow_ability = db.Column(db.String(100))
company_id = db.Column(db.Integer)
user_id = db.Column(db.Integer)
class User(EntityWithNameModel):
password = db.Column(db.String(120),
default='a13f7d4051bfcd2280f8848be893dc10')
role_id = db.Column(db.Integer)
real_name = db.Column(db.String(300))
@classmethod
def gen_password(cls, origin_password):
return md5("{}{}".format(SALT, origin_password)).hexdigest()
class UserModel(UserMixin, db.Model):
__tablename__ = "rookie"
id_ = db.column(db.Integer, primary_key=True)
rookie_name = db.Column(db.Unicode(20))
rookie_family = db.Column(db.Unicode(30))
rookie_contact = db.Column(db.Unicode(30))
@classmethod
def set_user_model(cls, name, family, contact):
return cls(rookie_name=name, rookie_family=family, rookie_contact=contact)
class User(db.Model, BaseModel):
__tablename__ = 'user'
id = db.Column(db.Integer, primary_key=True, autoincrement=True)
name = db.Column(db.String(50),
nullable=False,
server_default='',
comment='姓名')
create_time = db.Column(db.TIMESTAMP,
nullable=False,
server_default=func.now())
update_time = db.Column(
db.TIMESTAMP,
nullable=False,
server_default=text('CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP'))
class Company(EntityModel):
name = db.Column(db.String(120))
credit_code = db.Column(db.Integer)
register_addr = db.Column(db.String(120))
register_capital = db.Column(db.String(120))
representative = db.Column(db.String(120))
establish_time = db.Column(db.String(120))
business_scope = db.Column(db.Text)
user_id = db.Column(db.Integer)
class EntityModel(db.Model):
__abstract__ = True
__table_args__ = (dict(
mysql_engine='InnoDB',
mysql_charset='utf8',
))
id = db.Column(db.Integer, primary_key=True)
creation_time = db.Column(db.DateTime, default=datetime.now)
modified_time = db.Column(db.TIMESTAMP,
nullable=False,
default=db.func.current_timestamp())
@classmethod
def gets(cls, ids):
return cls.query.filter(cls.id.in_(ids)).all()
class ShareHolder(EntityModel):
name = db.Column(db.String(120))
id_num = db.Column(db.String(120))
investment_method = db.Column(db.String(120))
money = db.Column(db.Float)
shareholding_ratio = db.Column(db.Float)
relationship = db.Column(db.String(120))
company_id = db.Column(db.Integer)
class EntityWithNameModel(EntityModel):
__abstract__ = True
name = db.Column(db.String(100), nullable=False)
def __repr__(self):
return self.name
def __unicode__(self):
return self.name
class Revenue(EntityModel):
year = db.Column(db.String(10))
product_name = db.Column(db.String(100))
income = db.Column(db.Float)
percentage = db.Column(db.Float)
gross = db.Column(db.Float)
company_id = db.Column(db.Integer)
class Supply(EntityModel):
product_name = db.Column(db.String(100))
supplier_name = db.Column(db.String(100))
corporate_year = db.Column(db.Float)
purchase_money = db.Column(db.Float)
purchase_percentage = db.Column(db.Float)
company_id = db.Column(db.Integer)
class Sales(EntityModel):
product_name = db.Column(db.String(100))
buyer_name = db.Column(db.String(100))
corporate_year = db.Column(db.Float)
sales_money = db.Column(db.Float)
sales_percentage = db.Column(db.Float)
company_id = db.Column(db.Integer)
class Operate(EntityModel):
operate_statement = db.Column(db.String(500))
purchase_statement = db.Column(db.String(500))
production_statement = db.Column(db.String(500))
market_statement = db.Column(db.String(500))
company_id = db.Column(db.Integer)
user_id = db.Column(db.Integer)
class Order(db.Model, BaseModel):
__tablename__ = 'order'
id = db.Column(db.Integer, primary_key=True, autoincrement=True)
user_id = db.Column(db.Integer,
nullable=False,
server_default='0',
index=True,
comment='user_id')
create_time = db.Column(db.TIMESTAMP,
nullable=False,
server_default=func.now())
update_time = db.Column(
db.TIMESTAMP,
nullable=False,
server_default=text('CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP'))
def __getattr__(self, item):
return getattr(self.user, item)
@property
def user(self):
return User.get(self.user_id)
class History(EntityModel):
content = db.Column(db.Text)
user_id = db.Column(db.Integer)
class Industry(EntityModel):
first_industry = db.Column(db.String(50))
second_industry = db.Column(db.String(50))
major_product = db.Column(db.String(100))
technical_factor = db.Column(db.String(500))
supdem_factor = db.Column(db.String(500))
government_factor = db.Column(db.String(500))
humanity_factor = db.Column(db.String(500))
international_factor = db.Column(db.String(500))
profit_factor = db.Column(db.String(500))
other_factor = db.Column(db.String(500))
company_id = db.Column(db.Integer)
user_id = db.Column(db.Integer)
class Credit(EntityModel):
credict_info = db.Column(db.String(300))
lawsuit_info = db.Column(db.String(300))
company_id = db.Column(db.Integer)
user_id = db.Column(db.Integer)
class Role(EntityWithNameModel):
commit = db.Column(db.String(120))
