from sqlalchemy import ForeignKey
from sqlalchemy.orm import Mapped, mapped_column

from . import BaseDAO


class SetItem(BaseDAO):
	filename = "SetItems.txt"
	__tablename__ = "set_item"

	id: Mapped[int] = mapped_column(primary_key=True)
	index: Mapped[str]   # string reference, often also human-readable
	item = mapped_column(ForeignKey("base.code"))  # note inconsistency with everything else...
	rarity: Mapped[int]  # drop frequency, relative to other sets on this base
	lvl: Mapped[int]     # minimum drop level