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 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' 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 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 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 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 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 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 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 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 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 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 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 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 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_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 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)