# coding: utf-8
from sqlalchemy import Column, DateTime, Integer, Numeric, String
from flask_sqlalchemy import SQLAlchemy


#與當前項目相關的模型文件，即所有的實體類在此編寫
from manage import db


#管理者表
class User(db.Model):
    __tablename__ = 'user'

    sn = db.Column(db.Integer, primary_key=True)
    username = db.Column(db.String(30), nullable=False, unique=True)
    password = db.Column(db.Text, nullable=False)




#db.create_all()