class supplier(db.Model):
__tablename__ = 'supplier'
supplier_id = db.Column(db.Integer, primary_key=True)
supplier_name = db.Column(db.String(100), unique=True)
supplier_addre = db.Column(db.String(100))
supplier_credit = db.Column(db.Integer)
class goods(db.Model):
__tablename__ = 'goods'
goods_id = db.Column(db.Integer, primary_key=True)
goods_name = db.Column(db.String(100), unique=True)
goods_price = db.Column(db.String(100))
goods_intro = db.Column(db.String(255))
class client(db.Model):
__tablename__ = 'client'
client_id = db.Column(db.Integer, primary_key=True)
client_name = db.Column(db.String(100))
client_addre = db.Column(db.String(100))
client_phone = db.Column(db.String(100))
client_credit = db.Column(db.Integer)
class returngoods(db.Model):
__tablename__ = 'returngoods'
returngoods_id = db.Column(db.Integer, primary_key=True)
returngoods_count = db.Column(db.Integer)
returngoods_price = db.Column(db.String(100))
returngoods_addtime = db.Column(db.DateTime, index=True)
returngoods_goods = db.Column(db.String(100))
returngoods_supplier = db.Column(db.String(100))
returngoods_user_name = db.Column(db.String(100))
returngoods_num = db.Column(db.ForeignKey('purchase.purchase_num'), index=True)
purchase = db.relationship('Purchase', primaryjoin='returngoods.returngoods_num == Purchase.purchase_num', backref='returngoods')
class inwarehouse(db.Model):
__tablename__ = 'inwarehouse'
inwarehouse_id = db.Column(db.Integer, primary_key=True)
inwarehouse_count = db.Column(db.Integer)
inwarehouse_price = db.Column(db.String(100))
inwarehouse_addtime = db.Column(db.DateTime, index=True)
inwarehouse_goods = db.Column(db.String(100))
inwarehouse_supplier = db.Column(db.String(100))
inwarehouse_user_name = db.Column(db.String(100))
inwarehouse_num = db.Column(db.ForeignKey('purchase.purchase_num'), index=True)
purchase = db.relationship('Purchase', primaryjoin='inwarehouse.inwarehouse_num == Purchase.purchase_num', backref='inwarehouses')
class stock(db.Model):
__tablename__ = 'stock'
stock_id = db.Column(db.Integer, primary_key=True)
stock_count = db.Column(db.Integer)
stock_price = db.Column(db.String(100))
stock_addtime = db.Column(db.DateTime, index=True)
stock_goods = db.Column(db.String(100))
stock_supplier = db.Column(db.String(100))
stock_user_name = db.Column(db.String(100))
stock_num = db.Column(db.ForeignKey('sales.sales_num'), index=True)
sale = db.relationship('sales', primaryjoin='stock.stock_num == sales.sales_num', backref='stocks')
class Purchase(db.Model):
__tablename__ = 'purchase'
purchase_id = db.Column(db.Integer, primary_key=True)
purchase_num = db.Column(db.String(100), unique=True)
purchase_count = db.Column(db.Integer)
purchase_price = db.Column(db.String(100))
purchase_addtime = db.Column(db.DateTime, index=True)
purchase_goods = db.Column(db.ForeignKey('goods.goods_name'), index=True)
purchase_supplier = db.Column(db.ForeignKey('supplier.supplier_name'), index=True)
purchase_user_name = db.Column(db.ForeignKey('user.user_name'), index=True)
good = db.relationship('goods', primaryjoin='Purchase.purchase_goods == goods.goods_name', backref='purchases')
supplier = db.relationship('supplier', primaryjoin='Purchase.purchase_supplier == supplier.supplier_name', backref='purchases')
user = db.relationship('User', primaryjoin='Purchase.purchase_user_name == User.user_name', backref='purchases')
class sales(db.Model):
__tablename__ = 'sales'
sales_id = db.Column(db.Integer, primary_key=True)
sales_num = db.Column(db.String(100), unique=True)
sales_count = db.Column(db.Integer)
sales_price = db.Column(db.String(100))
sales_addtime = db.Column(db.DateTime, index=True)
sales_user_name = db.Column(db.ForeignKey('user.user_name'), index=True)
sales_client_id = db.Column(db.ForeignKey('client.client_id'), index=True)
sales_goods_name = db.Column(db.ForeignKey('goods.goods_name'), index=True)
sales_client = db.relationship('client', primaryjoin='sales.sales_client_id == client.client_id', backref='sales')
good = db.relationship('goods', primaryjoin='sales.sales_goods_name == goods.goods_name', backref='sales')
user = db.relationship('User', primaryjoin='sales.sales_user_name == User.user_name', backref='sales')
class duty(db.Model):
__tablename__ = 'duty'
duty_id = db.Column(db.Integer, primary_key=True)
duty_name = db.Column(db.String(100), unique=True)
duty_addtime = db.Column(db.DateTime, index=True)
duty_is_true = db.Column(db.Integer)
class section(db.Model):
__tablename__ = 'section'
section_id = db.Column(db.Integer, primary_key=True)
section_name = db.Column(db.String(100), unique=True)
section_addtime = db.Column(db.DateTime, index=True)
section_is_true = db.Column(db.Integer)
class User(db.Model):
__tablename__ = 'user'
user_id = db.Column(db.Integer, primary_key=True)
user_count = db.Column(db.String(100), unique=True)
user_name = db.Column(db.String(100), unique=True)
user_sex = db.Column(db.String(100))
user_pwd = db.Column(db.String(100))
user_mail = db.Column(db.String(100))
user_phone = db.Column(db.String(100))
user_addtime = db.Column(db.DateTime, index=True)
user_photo = db.Column(db.String(100))
user_ispass = db.Column(db.Integer)
user_section = db.Column(db.ForeignKey('section.section_name'), index=True)
user_duty = db.Column(db.ForeignKey('duty.duty_name'), index=True)
user_power = db.Column(db.ForeignKey('power.power_name'), index=True)
user_salary = db.Column(db.ForeignKey('salary.salary_id'), index=True)
duty = db.relationship('duty', primaryjoin='User.user_duty == duty.duty_name', backref='users')
power = db.relationship('power', primaryjoin='User.user_power == power.power_name', backref='users')
salary = db.relationship('Salary', primaryjoin='User.user_salary == Salary.salary_id', backref='users')
section = db.relationship('section', primaryjoin='User.user_section == section.section_name', backref='users')
def check_pwd(self,pwd):
from werkzeug.security import check_password_hash
return check_password_hash(self.user_pwd,pwd)
class power(db.Model):
__tablename__ = 'power'
power_id = db.Column(db.Integer, primary_key=True, index=True)
power_name = db.Column(db.String(100), unique=True)
power_addtime = db.Column(db.DateTime, index=True)