21 lines
572 B
Python
21 lines
572 B
Python
from flask_sqlalchemy import SQLAlchemy
|
|
import sqlalchemy as sa
|
|
|
|
db = SQLAlchemy()
|
|
|
|
|
|
class User(db.Model):
|
|
id = sa.Column(sa.Integer, primary_key=True)
|
|
name = sa.Column(sa.String)
|
|
email = sa.Column(sa.String)
|
|
personal_number = sa.Column(sa.String, unique=True)
|
|
rfid_number = sa.Column(sa.String, unique=True)
|
|
active = sa.Column(sa.Boolean)
|
|
|
|
|
|
class TimeStamp(db.Model):
|
|
id = sa.Column(sa.Integer, primary_key=True)
|
|
id_user = sa.Column(sa.ForeignKey(User.id))
|
|
create_time = sa.Column(sa.TIMESTAMP)
|
|
timestamp = sa.Column(sa.TIMESTAMP)
|