traps

Relationships

erDiagram
    traps {
        varchar content_flags
        varchar content_flags_disabled
        smallintunsigned version
        varchar zone
    }
    content_flags {
        varchar flag_name
    }
    zone {
        int zoneidnumber
        varchar short_name
        tinyintunsigned version
        varchar content_flags
        varchar content_flags_disabled
    }
    traps ||--o{ content_flags : "One-to-One"
    traps ||--o{ content_flags : "One-to-One"
    traps ||--o{ zone : "One-to-One"
    traps ||--o{ zone : "One-to-One"

Relationship Type	Local Key	Relates to Table	Foreign Key
One-to-One	content_flags	content_flags	flag_name
One-to-One	content_flags_disabled	content_flags	flag_name
One-to-One	version	zone	version
One-to-One	zone	zone	short_name

Schema

Column	Data Type	Description
id	int	Unique Trap Identifier
zone	varchar	Zone Short Name
version	smallint	Version: -1 For All
x	int	X Coordinate
y	int	Y Coordinate
z	int	Z Coordinate
chance	tinyint	Chance: 0 = None, 100 = Always
maxzdiff	float	Max Z Difference
radius	float	Trap Radius
effect	int	Trap Type
effectvalue	int	Effect Value: (Based on Trap Type) 0 = Spell Identifier, 1 = Radius, 2 = NPC Type Identifier, 3 = NPC Type Identifier, 4 = Minimum Damage
effectvalue2	int	Effect Value 2: (Based on Trap Type) 0 = Unused, 1 = (0 = Everything Will Aggro, 1 = Only KoS Will Agro), 2 = Number of NPCs, 3 = Number of NPCs, 4 = Maximum Damage
message	varchar	Message
skill	int	Skill Required
level	mediumint	Level
respawn_time	int	Respawn Timer in Seconds
respawn_var	int	Random Respawn Timer Variance in Seconds
triggered_number	tinyint	Triggered Member
group	tinyint	Group
despawn_when_triggered	tinyint	Despawn When Triggered: 0 = False, 1 = True
undetectable	tinyint	Undetectable: 0 = False, 1= True
min_expansion	tinyint	Minimum Expansion
max_expansion	tinyint	Maximum Expansion
content_flags	varchar	Content Flags Required to be Enabled
content_flags_disabled	varchar	Content Flags Required to be Disabled