You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
55 lines
2.2 KiB
55 lines
2.2 KiB
from app import db
|
|
|
|
class Provider(db.Model):
|
|
ID=db.Column(db.Integer,primary_key=True,autoincrement=True)
|
|
name=db.Column(db.String(255),unique=True)
|
|
address=db.Column(db.String(255))
|
|
telephone=db.Column(db.String(255))
|
|
|
|
class Materials(db.Model):
|
|
ID=db.Column(db.Integer,primary_key=True,autoincrement=True)
|
|
name=db.Column(db.String(255),nullable=False,unique=True)
|
|
type=db.Column(db.String(255),nullable=False)
|
|
|
|
class Provide(db.Model):
|
|
provider_ID=db.Column(db.Integer,db.ForeignKey('provider.ID'),primary_key=True)
|
|
materials_ID=db.Column(db.Integer,db.ForeignKey('materials.ID'),primary_key=True)
|
|
time=db.Column(db.DateTime,primary_key=True)
|
|
quantity=db.Column(db.Integer)
|
|
verification=db.Column(db.Boolean,default=False)
|
|
|
|
class Demander(db.Model):
|
|
ID=db.Column(db.Integer,primary_key=True,autoincrement=True)
|
|
name=db.Column(db.String(255),unique=True)
|
|
address=db.Column(db.String(255))
|
|
telephone=db.Column(db.String(255))
|
|
|
|
class Order_Form(db.Model):
|
|
__tablename__='order_form'
|
|
demander_ID=db.Column(db.Integer,db.ForeignKey('demander.ID'))
|
|
ID=db.Column(db.Integer,primary_key=True,autoincrement=True)
|
|
type=db.Column(db.String(255),nullable=False)
|
|
emergency=db.Column(db.String(255))
|
|
remark=db.Column(db.String(255))
|
|
|
|
class Warehouse(db.Model):
|
|
ID=db.Column(db.Integer,primary_key=True,autoincrement=True)
|
|
address=db.Column(db.String(255),nullable=False)
|
|
|
|
class Stockpile(db.Model):
|
|
warehouse_ID=db.Column(db.Integer,db.ForeignKey('warehouse.ID'),primary_key=True)
|
|
materials_ID=db.Column(db.Integer,db.ForeignKey('materials.ID'),primary_key=True)
|
|
quantity=db.Column(db.Integer)
|
|
|
|
class Send(db.Model):
|
|
warehouse_ID=db.Column(db.Integer,db.ForeignKey('warehouse.ID'),primary_key=True)
|
|
materials_ID=db.Column(db.Integer,db.ForeignKey('materials.ID'),primary_key=True)
|
|
demander_ID=db.Column(db.Integer,db.ForeignKey('demander.ID'),primary_key=True)
|
|
time=db.Column(db.DateTime)
|
|
quantity=db.Column(db.Integer)
|
|
verification=db.Column(db.Boolean,default=False)
|
|
|
|
class Users(db.Model):
|
|
ID=db.Column(db.Integer,primary_key=True)
|
|
password=db.Column(db.String(255))
|
|
type=db.Column(db.String(255),primary_key=True) |