class HallSchedule(db.Model): hsid = db.Column(db.Integer, primary_key=True) original_price = db.Column(db.Numeric(6, 2)) # 原价 dis_price = db.Column(db.Numeric(6, 2)) # 折扣价 start_time = db.Column(db.DateTime) starus = db.Column(db.Integer, default=1) is_delete = db.Column(db.Boolean, default=False) # 关联外键 电影、影厅、影院 movie_id = db.Column(db.Integer, db.ForeignKey('movies.mid')) hid = db.Column(db.Integer, db.ForeignKey('hall.hid')) cid = db.Column(db.Integer, db.ForeignKey('cinemas.mid'))
class HallSchedule(db.Model): hs_id = db.Column(db.Integer, primary_key=True) original_price = db.Column(db.Numeric(10, 2)) dis_price = db.Column(db.Numeric(10, 2)) start_time = db.Column(db.DateTime) # 1未开始 2 正在放映 status = db.Column(db.Boolean, default=False) is_delete = db.Column(db.Boolean, default=False) # 关联影院外键 movie_id = db.Column(db.Integer, db.ForeignKey('movies.id')) hid = db.Column(db.Integer, db.ForeignKey('hall.hid')) cid = db.Column(db.Integer, db.ForeignKey('cinemas.id'))
class Shop(db.Model): sid = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(64), index=True) price = db.Column(db.Numeric(10, 2)) create_time = db.Column(db.DateTime, default=datetime.datetime.now()) expiration_date = db.Column(db.String(64)) status = db.Column(db.Integer)
class HallSchedule(db.Model): hsid = db.Column(db.Integer, primary_key=True) #原价 or_price = db.Column(db.Numeric(10, 2)) #折扣价 dis_price = db.Column(db.Numeric(10, 2)) # 开始时间 start_time = db.Column(db.DateTime) #1未开始 2正在放映 status = db.Column(db.Integer, default=False) is_delete = db.Column(db.Boolean, default=False) # 电影的外键 mid = db.Column(db.Integer, db.ForeignKey('movies.id')) # 影厅的外键 hid = db.Column(db.Integer, db.ForeignKey('hall.hid')) # 影院的外键 cid = db.Column(db.Integer, db.ForeignKey('cinemas.cid'))
class Organization(db.Model): __tablename__ = 'organization' id = db.Column(db.String(24), default=objectid, primary_key=True) name = db.Column(db.String(50)) address = db.Column(db.String(255)) picture = db.Column(db.String(200)) telephone = db.Column(db.String(20)) admin_user_id = db.Column(db.String(24), db.ForeignKey('user.id')) longitude = db.Column(db.Numeric(10, 7)) latitude = db.Column(db.Numeric(10, 7)) note = db.Column(db.Text) users = db.relationship('User', secondary='user_org', backref=db.backref('f_org_user', lazy='dynamic'), lazy='dynamic')
class User(db.Model): # __tablename__ = 't_user' uid = db.Column(db.Integer, primary_key=True) name = db.Column(db.String(64), index=True, unique=True, nullable=True) weight = db.Column(db.Float(10, 2)) # # decimal money = db.Column(db.Numeric(10, 2)) create_date = db.Column(db.DateTime, default=datetime.datetime.now()) # # 不要在text字段上面加索引 msg = db.Column(db.Text())
class Document(BaseDocument, db.Model): __table_args__ = {'schema': "twitter"} __tablename__ = "Document" stored_tweets = db.Column(db.Integer()) first = db.Column(db.Numeric()) last = db.Column(db.Numeric()) def __init__(self, id): self.id = id self.text = "" self.stored_tweets = None self.first = None self.last = None @property def json(self): return { "text": self.text, "features": self.features, "stored_tweets": self.stored_tweets, "first": self.first, "last": self.last }
class Detail(db.Model): did = db.Column(db.Integer, primary_key=True) price = db.Column(db.Numeric(10, 2)) sid = db.Column(db.Integer, db.ForeignKey(Shop.sid, ondelete='CASCADE'))