PoLZy_Showcase/models/cancel_activity.py

from polzybackend import db
from polzybackend.auth import get_uuid
from datetime import datetime, date
import uuid


class CancelActivity(db.Model):
    __tablename__ = 'cancelActivities'
    id = db.Column(db.LargeBinary, primary_key=True, default=get_uuid)
    creator_id = db.Column(db.LargeBinary, db.ForeignKey('users.id'), nullable=False)
    created = db.Column(db.DateTime, nullable=False, default=datetime.utcnow)
    policy_number = db.Column(db.String(64), nullable=False)
    effective_date = db.Column(db.Date, nullable=False, default=date.today)
    type_id = db.Column(db.Integer, db.ForeignKey('activity_types.id'), nullable=False)
    is_finished = db.Column(db.Boolean, nullable=False, default=False)
    
    # relationships
    creator = db.relationship(
        'User',
        backref=db.backref('created_activities', order_by='desc(Activity.created)'),
        foreign_keys=[creator_id],
    )
    type = db.relationship(
        'ActivityType',
        foreign_keys=[type_id],
    )

    def __str__(self):
        return str(uuid.UUID(bytes=self.id))