nazwadi / peqquery Goto Github PK

Implement the database schema ORM for the peq database described at the docs: https://docs.eqemu.io/schema/aas/aa_ability/

• AAs
• Account
• Admin
• Adventures
• Alternate Currency
• Books
• Bots
• Buyers
• Characters
• Client Files
• Data Storage
• Doors
• Dynamic Zones
• Expeditions
• Factions
• Flagging
• Graveyards
• Ground Spawns
• Groups
• Guilds
• Grids
• Horses
• Instances
• Inventory
• Items
• Loginserver
• Loot
• Mercenaries
• Merchants
• NPCs
• Objects
• Pets
• Query Server
• Scheduler
• Raids
• Rules
• Spawns
• Spells
• Tasks
• Timers
• Titles
• Tools
• Trader
• Tradeskills
• Traps
• Tributes
• Zone

• alternate_currency
• char_recipe_list
• character_activities
• character_alt_currency
• character_alternate_abilities
• character_auras
• character_bandolier
• character_bind
• character_buffs
• character_corpse_items
• character_corpses
• character_currency
• character_data
• character_disciplines
• character_enabledtasks
• character_exp_modifiers
• character_expedition_lockouts
• character_inspect_messages
• character_instance_safereturns
• character_item_recast
• character_languages
• character_leadership_abilities
• character_material
• character_memmed_spells
• character_pet_buffs
• character_pet_info
• character_pet_inventory
• character_potionbelt
• character_skills
• character_spells
• character_task_timers
• character_tasks
• character_tribute
• completed_shared_task_activity_state
• completed_shared_task_members
• completed_shared_tasks
• completed_tasks
• data_buckets
• discovered_items
• dynamic_zone_members
• faction_values
• friends
• group_id
• group_leaders
• guild_bank
• guild_members
• guilds
• instance_list
• instance_list_player
• inventory
• inventory_snapshots
• ip_exemptions
• keyring
• lfguild
• mail
• petitions
• player_titlesets
• quest_globals
• raid_details
• raid_members
• reports
• shared_task_members
• shared_tasks
• sharedbank
• spell_buckets
• spell_globals
• timers
• titles
• trader
• trader_audit
• veteran_reward_templates
• zone_flags

Could not determine join condition between parent/child tables on relationship InstanceList.zone_relationship - there are no foreign keys linking these tables. Ensure that referencing columns are associated with a ForeignKey or ForeignKeyConstraint, or specify a 'primaryjoin'
expression.

Currently commented out this line

Could not determine join condition between parent/child tables on relationship Doors.zone - there are no foreign keys linking these tables. Ensure that referencing columns are associated with a ForeignKey or ForeignKeyConstraint, or specify a 'primaryjoin' expression.

Currently I have this relationship commented out.

Currently unable to establish join conditions for the following relationships (which I've commented out in the Items table):

• alternate_currency
• object
• object_contents
• starting_items
• tradeskill_recipe_entries
• tribute_levels