from app.extensions import db

class MaterialBase(db.Model):
    __tablename__ = 'material_base'

    id = db.Column(db.Integer, primary_key=True)
    sku_code = db.Column(db.String(100), unique=True, nullable=False)
    name = db.Column(db.String(255), nullable=False)
    spec_model = db.Column(db.String(255))
    unit = db.Column(db.String(50))
    # 其他字段按需添加，入库时主要是为了外键关联