from flask_sqlalchemy import SQLAlchemy

db = SQLAlchemy()


class User(db.Model):
    __tablename__ = 'users'
    id = db.Column(db.Integer, primary_key=True, comment='ID пользователя')

    login = db.Column(db.String, nullable=False, comment='Логин')
    password_hash = db.Column(db.String, nullable=False, comment='Пароль')

    sipro_id = db.Column(db.Integer, nullable=True, comment='ID пользователя в SIPRO')


class Barcode(db.Model):
    __tablename__ = 'barcodes'
    id = db.Column(db.Integer, primary_key=True, comment='ID пользователя')
    denco_article = db.Column(db.Integer, nullable=False, comment='Артикул', index=True)
    barcode = db.Column(db.String, nullable=False, comment='Баркод', index=True)