class Artikal(db.Model):
 __tablename__ = "artikal"
 id = db.Column(db.Integer,primary_key=True)
 naziv = db.Column(db.String(80),unique=True)
 datum_unosa = db.Column(db.DateTime)
 cijena = db.Column(db.Integer)
 ikona = db.Column(db.String(200))
 proizvodjac_id = db.Column(db.Integer, db.ForeignKey('proizvodjac.id'))
 kategorija_id = db.Column(db.Integer, db.ForeignKey('kategorija.id'))
 recenzija = relationship("Recenzija", cascade="all,delete", backref="artikal")


class Recenzija(db.Model):
 __tablename__ = "recenzija"
 id = db.Column(db.Integer,primary_key=True)
 tekst = db.Column(db.String(80))
 ocjena = db.Column(db.Integer)
 korisnik_id = db.Column(db.Integer, db.ForeignKey('user.id'))
 artikal_id = db.Column(db.Integer, db.ForeignKey('artikal.id'))