24 lines
784 B
Python
24 lines
784 B
Python
from sqlalchemy import Column, Integer, String, Date, DateTime, Float, Boolean, Text, ForeignKey, Enum as SQLEnum
|
|
from sqlalchemy.sql import func
|
|
from sqlalchemy.orm import relationship
|
|
from database import Base
|
|
|
|
import enum
|
|
|
|
|
|
class Invoices(Base):
|
|
__tablename__ = "invoices"
|
|
|
|
id = Column(Integer, primary_key=True, nullable=False, autoincrement=True)
|
|
emisor = Column(String(100), nullable=False)
|
|
receptor = Column(String(110), nullable=False)
|
|
uuid = Column(String(255), nullable=False)
|
|
total = Column(Integer, nullable=False)
|
|
tipo = Column(String(50), nullable=True)
|
|
date = Column(DateTime, nullable=True)
|
|
|
|
verified_at = Column(DateTime(timezone=True), server_default=func.now(), nullable=False)
|
|
verified_by = Column(Integer, nullable=True)
|
|
|
|
|