/
CBeredIOk
/
AvitoTech
Обзор
Документация
Войти
/
CBeredIOk
/
AvitoTech
Код
Запросы
0
Задачи
Пакеты
0
Релизы
0
Аналитика
Безопасность
master
app/user/models.py
25 строк
943 B
CBeredIOk
initial commit
13 сен 2024, 22:22
13 сен 2024, 22:22
9e56d4f
Код
Авторство
О чём код?
import uuid from sqlalchemy.dialects.postgresql import UUID from sqlalchemy import Column, String, TIMESTAMP, func, ForeignKey from app.database import Base class User(Base): __tablename__ = "employee" id = Column(UUID(as_uuid=True), primary_key=True, default=uuid.uuid4) username = Column(String(50), unique=True, nullable=False) first_name = Column(String(50), nullable=True) last_name = Column(String(50), nullable=True) created_at = Column(TIMESTAMP, server_default=func.now()) updated_at = Column(TIMESTAMP, server_default=func.now(), onupdate=func.now()) class OrganizationResponsible(Base): __tablename__ = "organization_responsible" id = Column(UUID(as_uuid=True), primary_key=True, default=uuid.uuid4) organization_id = Column(UUID(as_uuid=True), ForeignKey("organization.id", ondelete="CASCADE")) user_id = Column(UUID(as_uuid=True), ForeignKey("employee.id", ondelete="CASCADE"))