class Goods(db.Model):
id = db.Column('型号编号', db.Integer, primary_key=True)
goods_id = db.Column(db.String(255))
SN = db.Column(db.String(255))
model_id = db.Column(db.String(255))
in_time = db.Column(db.DateTime)
out_time = db.Column(db.DateTime)
price_get = db.Column(db.String(255))
price_sall = db.Column(db.String(255))
status = db.Column(db.String(255))
sts = db.Column(db.String(255))
def __init__(self, id, goods_id, SN, model_id, in_time, out_time,
price_get, price_sall, status, sts):
self.id = id
self.goods_id = goods_id
self.SN = SN
self.model_id = model_id
self.in_time = in_time
self.out_time = out_time
self.price_get = price_get
self.price_sall = price_sall
self.status = status
self.sts = sts
def __repr__(self):
return '<Goods %r>' % self.id
class Employee(db.Model):
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(80), unique=False, nullable=False)
email = db.Column(db.String(120), unique=True, nullable=False)
schedule = db.relationship('EmployeeSchedule', backref=backref("employee"))
def __init__(self, name, email):
self.name = name
self.email = email
class UserMenu(db.Model):
__tablename__ = 'UserMenu'
id = db.Column(db.Integer, primary_key=True)
name = db.Column(db.String(20))
menus = db.Column(db.String(2000))
city = db.Column(db.String(20))
feedback = db.Column(db.String(2000))
def __repr__(self):
return '<UserMenu %r>' % self.name
class CandidateSchedule(db.Model):
id = db.Column(db.Integer, primary_key=True)
day = db.Column(db.String(10), nullable=False)
start_time = db.Column(db.String(5), nullable=False)
end_time = db.Column(db.String(5), nullable=False)
candidate_id = db.Column(db.Integer, db.ForeignKey('candidate.id'))
def __init__(self, day, start_time, end_time, candidate_id):
self.day = day
self.start_time = start_time
self.end_time = end_time
self.candidate_id = candidate_id
class EmployeeSchedule(db.Model):
id = db.Column(db.Integer, primary_key=True)
day = db.Column(db.String(10), nullable=False)
start_time = db.Column(db.String(5), nullable=False)
end_time = db.Column(db.String(5), nullable=False)
emp_id = db.Column(db.Integer, db.ForeignKey('employee.id'))
def __init__(self, day, start_time, end_time, emp_id):
self.day = day
self.start_time = start_time
self.end_time = end_time
self.emp_id = emp_id
class Results(db.Model):
__tablename__ = "results"
question = db.Column(db.String(64), primary_key=True)
create_date = db.Column(db.DateTime, default=datetime.now)
select1 = db.Column(db.String(64))
select2 = db.Column(db.String(64))
select3 = db.Column(db.String(64))
select4 = db.Column(db.String(64))
count_select1 = db.Column(db.Integer, default=0)
count_select2 = db.Column(db.Integer, default=0)
count_select3 = db.Column(db.Integer, default=0)
count_select4 = db.Column(db.Integer, default=0)
class Todo(db.Model):
__tablename__ = 'todos'
id = db.Column('todo_id', db.Integer, primary_key=True)
title = db.Column(db.String(60))
text = db.Column(db.String)
done = db.Column(db.Boolean)
pub_date = db.Column(db.DateTime)
def __init__(self, title, text):
self.title = title
self.text = text
self.done = False
self.pub_date = datetime.utcnow()
class Role(db.Model):
id = db.Column(db.Integer,
nullable=False,
primary_key=True,
autoincrement=True)
name = db.Column(db.String(16),
nullable=False,
server_default='',
unique=True)
def __init__(self, name):
self.name = name
def __repr__(self):
return '<Role %r>' % self.name
class Result(db.Model):
__tablename__ = 'results'
id = db.Column(db.Integer, primary_key=True)
url = db.Column(db.String())
result_all = db.Column(JSON)
result_no_stop_words = db.Column(JSON)
def __init__(self, url, result_all, result_no_stop_words):
self.url = url
self.result_all = result_all
self.result_no_stop_words = result_no_stop_words
def __repr__(self):
return '<id {}>'.format(self.id)
class Jewelrys(db.Model):
__tablename__ = 'jewelrys'
key = db.Column(db.Integer, primary_key=True, autoincrement=True)
name = db.Column(db.String(64))
size = db.Column(db.String(64), default=0)
price = db.Column(db.String(64), default=0)
credit = db.Column(db.Integer, default=0)
catagory = db.Column(db.String(64))
image = db.Column(db.Text, nullable=True)
status = db.Column(db.Boolean, default=True)
uid = db.Column(db.String(64), db.ForeignKey("users.id",
ondelete='cascade'))
class Coupon(db.Model):
__tablename__ = "coupon"
key = db.Column(db.Integer, primary_key=True, autoincrement=True)
id = db.Column(db.String(64), unique=True)
name = db.Column(db.String(64))
active_state = db.Column(db.Boolean, default=True)
create_date = db.Column(db.DateTime, default=datetime.now)
use_date = db.Column(db.DateTime,
default=datetime.now,
onupdate=datetime.now)
user_name = db.Column(db.String(64))
user_phone = db.Column(db.Integer, default=0)
used = db.Column(db.Boolean, default=False)
class User(db.Model):
id = db.Column(db.Integer,
nullable=False,
primary_key=True,
autoincrement=True)
username = db.Column(db.String(32),
nullable=False,
unique=True,
server_default='',
index=True)
role_id = db.Column(db.Integer, nullable=False, server_default='0')
def __init__(self, username, role_id):
self.username = username
self.role_id = role_id
def __repr__(self):
return '<User %r, Role id %r>' % (self.username, self.role_id)
class Questions(db.Model):
__tablename__ = "questions"
id = db.Column(db.Integer, default=1)
question = db.Column(db.String(64), primary_key=True)
select1 = db.Column(db.String(64))
select2 = db.Column(db.String(64))
select3 = db.Column(db.String(64))
select4 = db.Column(db.String(64))
class Users(db.Model):
__tablename__ = 'users'
phone = db.Column(db.String(15), primary_key=True)
name = db.Column(db.String(10))
schoolCode = db.Column(db.String(15))
birthDay = db.Column(db.String(6))
region = db.Column(db.String(9))
time = db.Column(db.Integer)
class InterviewSchedule(db.Model):
id = db.Column(db.Integer, primary_key=True)
day = db.Column(db.String(10), nullable=False)
start_time = db.Column(db.String(5), nullable=False)
end_time = db.Column(db.String(5), nullable=False)
candidate_email = db.Column(db.String(120), unique=True, nullable=False)
interviewers_emails = db.Column(db.String(420), nullable=False)
class Users(db.Model):
__tablename__ = 'users'
key = db.Column(db.Integer, primary_key=True, autoincrement=True)
id = db.Column(db.String(64), unique=True)
password = db.Column(db.String(64))
#active_state = db.Column(db.Boolean, default=True)
address = db.Column(db.String(64))
discount = db.Column(db.String(64))
credit = db.Column(db.Integer, default=0)
jewelry = db.relationship('Jewelrys', backref='users', lazy='dynamic')
class Good_supplier(db.Model):
gs_code = db.Column(db.Integer, primary_key=True)
supplier = db.Column(db.String(255))
short_name = db.Column(db.String(255))
linkman = db.Column(db.String(255))
telephone = db.Column(db.String(255))
address = db.Column(db.String(255))
other = db.Column(db.String(255))
sts = db.Column(db.String(255))
def __init__(self, supplier, short_name, linkman, telephone, address,
other, sts):
self.supplier = supplier
self.short_name = short_name
self.linkman = linkman
self.telephone = telephone
self.address = address
self.other = other
self.sts = sts
def __repr__(self):
return '<Good_supplier %r>' % self.supplier
class Good_log(db.Model):
id = db.Column(db.Integer, primary_key=True)
goods_id = db.Column(db.String(255))
create_time = db.Column(db.DateTime)
status = db.Column(db.String(255))
sts = db.Column(db.String(255))
tag = db.Column(db.String(255))
man_register = db.Column(db.String(255))
def __init__(self, goods_id, create_time, status, sts, tag, man_register):
self.goods_id = goods_id
self.create_time = create_time
self.status = status
self.sts = sts
self.tag = tag
self.man_register = man_register
def __repr__(self):
return '<Good_log %r>' % self.supplier
class Good_model(db.Model):
model_id = db.Column(db.String(255), primary_key=True)
model_name = db.Column(db.String(255))
model_number = db.Column(db.String(255))
nuture = db.Column(db.String(255))
other = db.Column(db.String(255))
gs_code = db.Column(db.Integer)
sts = db.Column(db.String(255))
def __init__(self, model_id, model_name, model_number, nuture, other,
gs_code, sts):
self.model_id = model_id
self.model_name = model_name
self.model_number = model_number
self.nuture = nuture
self.other = other
self.gs_code = gs_code
self.sts = sts
def __repr__(self):
return '<Good_model %r>' % self.model_name
class User(db.Model):
user = db.Column(db.String(255))
code = db.Column(db.String(255), primary_key=True)
password = db.Column(db.String(255))
telephone = db.Column(db.String(255))
create_time = db.Column(db.DateTime)
sts = db.Column(db.Integer)
def __init__(self, user, code, password, telephone, create_time, sts):
self.user = user
self.code = code
self.password = password
self.telephone = telephone
self.create_time = create_time
self.sts = sts
def __repr__(self):
return '<User %r>' % self.user
class User(db.Model):
__tablename__ = 'user'
id = db.Column(db.Integer, primary_key=True)
# name = db.Column(db.String(128))
balance = db.Column(db.Integer)
class Errors(db.Model):
__tablename__ = 'errors'
id = db.Column(db.Integer, primary_key=True, autoincrement=True)
data = db.Column(db.Text)
class Jewelrys_Photos(db.Model):
__tablename__ = 'jewelry_info'
key = db.Column(db.Integer, primary_key=True, autoincrement=True)
number = db.Column(db.String(64))
image = db.Column(db.Text(64), nullable=True)
class Transactions(db.Model):
__tablename__ = 'transactions'
id = db.Column(db.Integer, primary_key=True, autoincrement=True)
phone = db.Column(db.String(15))
data = db.Column(db.Text)
class notification(db.Model):
__tablename__ = 'notifications'
id = db.Column(db.Integer, primary_key=True, autoincrement=True)
data = db.Column(db.Text)