+---------------+ | npc_dialogue | +---------------+ | dialogue_id | | npc_id | | dialgoue_text | +---------------+ +-------------------+ | npc_responses | +-------------------+ | response_id | | dialogue_id | | response_text | | response_action | +-------------------+ // NPC data +-------------------+ | npc_template | +-------------------+ | npc_id | | npc_type | | npc_location | | npc_faction | | npc_level | | npc_dexterity | | npc_strength | | npc_constitution | | npc_intelligence | | npc_charisma | | npc_health | +-------------------+ // Will store instance // data for npcs that // will need to be instanced. // Examples would be mobs that // players will be fighting. +-------------------+ | npc_instnace | +-------------------+ | instance_id | | npc_id | | instance_health | +-------------------+ // Stores loot drops // for npcs. +-------------------+ | npc_loot | +-------------------+ | npc_id | | item_id | | chance_to_drop | | quest_chance | +-------------------+