/
Goshanskyi
/
microservices_course
Обзор
Документация
Войти
/
Goshanskyi
/
microservices_course
Код
Запросы
0
Задачи
Вики
Пакеты
0
Релизы
0
Аналитика
Безопасность
master
app/models/models.py
42 строки
2 KB
Гошанский
CORRECT: Изменил структуру проекта, а также добавил README.md и requirements.txt
17 окт 2024, 02:33
17 окт 2024, 02:33
a53d839
Код
Авторство
О чём код?
from sqlalchemy import Table, Column, Integer, String, DateTime, ARRAY, ForeignKey from sqlalchemy.sql import func from app.database.database import metadata clients = Table( "clients", metadata, Column("id", Integer, primary_key=True, autoincrement=True), Column("last_name", String, nullable=False), Column("first_name", String, nullable=False), Column("middle_name", String, nullable=True), Column("email", String, nullable=False, unique=True), Column("phone_number", String, nullable=False, unique=True), Column("password", String, nullable=False), Column("timestamp", DateTime, default=func.now(), nullable=False), ) specialists = Table( "specialists", metadata, Column("id", Integer, primary_key=True, autoincrement=True), Column("last_name", String, nullable=False), Column("first_name", String, nullable=False), Column("middle_name", String, nullable=True), Column("email", String, nullable=False, unique=True), Column("phone_number", String, nullable=False, unique=True), Column("password", String, nullable=False), Column("specialization", ARRAY(String), nullable=False), Column("timestamp", DateTime, default=func.now(), nullable=False), ) orders = Table( "orders", metadata, Column("id", Integer, primary_key=True, autoincrement=True), Column("client_pk", Integer, ForeignKey("clients.id"), nullable=False), Column("specialist_pk", Integer, ForeignKey("specialists.id"), nullable=False), Column("specialization", String, nullable=False), Column("status", String, nullable=False), Column("comment", String, nullable=True), Column("timestamp", DateTime, default=func.now(), nullable=False), )