from sqlalchemy import (INTEGER,VARCHAR,)
from sqlalchemy.orm import (Mapped,mapped_column,relationship)
from app.models.main import Base

class TblSeafarerIdType(Base):
    
    __tablename__ = "tbl_seafarer_id_type"

    id_type: Mapped[int] = mapped_column("id_type", INTEGER, primary_key=True, autoincrement=True)
    sf_id_type: Mapped[str] = mapped_column("sf_id_type", VARCHAR(255), nullable=True, server_default=None)

    seafarers = relationship("TblSeafarers", back_populates="seafarer_id_type")

    def __init__(self, id_type: int, sf_id_type: str):
        self.id_type = id_type
        self.sf_id_type = sf_id_type