#from . import db
"""
from . import mysql
from flask_login import UserMixin
from sqlalchemy.sql import func


class UserTable(mysql.Model, UserMixin):
    UT_UserID = mysql.Column(mysql.Integer, primary_key=True)
    UT_IDNo = mysql.Column(mysql.String(10), unique=True)
    UT_LastName = mysql.Column(mysql.String(100))
    UT_FirstName = mysql.Column(mysql.String(150))
    UT_Contact = mysql.Column(mysql.String(50))
    UT_Email = mysql.Column(mysql.String(50), unique=True)
    
    UT_Username = mysql.Column(mysql.String(20), unique=True)
    UT_Password = mysql.Column(mysql.String(150))
    UT_UserType = mysql.Column(mysql.String(50))
    UT_Designation = mysql.Column(mysql.String(100))
    UT_Department = mysql.Column(mysql.Integer, default = 0)
    #IS = db.relationship('ItemSetup')
    
class ItemSetup(mysql.Model):
    IS_ItemNo = mysql.Column(mysql.Integer, primary_key=True)
    IS_SerialNo = mysql.Column(mysql.Integer)
    IS_ItemName = mysql.Column(mysql.String(200))
    IS_ItemDesc = mysql.Column(mysql.String(500))
    IS_CategoryNo = mysql.Column(mysql.Integer, mysql.ForeignKey('category.cat_id'))
    IS_Brand = mysql.Column(mysql.String(200))
    IS_Model = mysql.Column(mysql.String(200))
    IS_Location = mysql.Column(mysql.Integer, mysql.ForeignKey('location.loc_no'))
    IS_Department = mysql.Column(mysql.Integer, mysql.ForeignKey('department.dept_no'))
    IS_Owner = mysql.Column(mysql.String(200))
    
    IS_DateAdded = mysql.Column(mysql.DateTime(timezone=True), default =func.now())
    IS_BegStock = mysql.Column(mysql.Float)
    IS_Unit = mysql.Column(mysql.String(50))
    IS_UserNo = mysql.Column(mysql.Integer, mysql.ForeignKey('user.ut_userid'))
"""