22 lines
931 B
Python
22 lines
931 B
Python
from extensions import db
|
|
from sqlalchemy import Column, Integer, String, DateTime, Float, ForeignKey
|
|
from sqlalchemy.orm import relationship
|
|
from datetime import datetime
|
|
|
|
class Employee(db.Model):
|
|
__tablename__ = 'employee'
|
|
|
|
id = db.Column(db.Integer, primary_key=True, autoincrement=True)
|
|
username = db.Column(db.String(80), unique=True, nullable=True)
|
|
email = db.Column(db.String(120), unique=True, nullable=False)
|
|
group = db.Column(db.String(80), unique=True, nullable=True)
|
|
contract_type = db.Column(db.String(80), unique=True, nullable=False)
|
|
date = db.Column(db.Date, nullable=True)
|
|
expected_entry_time = db.Column(db.DateTime, nullable=False)
|
|
expected_exit_time = db.Column(db.DateTime, nullable=False)
|
|
|
|
# Relacionamento hierárquico
|
|
parent_id = db.Column(db.Integer, db.ForeignKey('user.id'), nullable=True)
|
|
|
|
def __repr__(self):
|
|
return f"<Employee {self.name}>" |