adventure_template

Relationships

erDiagram
    adventure_template {
        intunsigned id
        intunsigned graveyard_zone_id
        varchar zone
        smallintunsigned zone_in_zone_id
        tinyintunsigned zone_version
        varchar version
    }
    zone {
        int zoneidnumber
        varchar short_name
        tinyintunsigned version
        varchar content_flags
        varchar content_flags_disabled
    }
    adventure_details {
        intunsigned id
        smallintunsigned adventure_id
        int instance_id
    }
    adventure_template ||--o{ zone : "One-to-One"
    adventure_template ||--o{ adventure_details : "One-to-One"
    adventure_template ||--o{ zone : "One-to-One"
    adventure_template ||--o{ zone : "One-to-One"
    adventure_template ||--o{ zone : "One-to-One"

Relationship Type	Local Key	Relates to Table	Foreign Key
One-to-One	graveyard_zone_id	zone	zoneidnumber
One-to-One	id	adventure_details	id
One-to-One	zone	zone	short_name
One-to-One	zone_in_zone_id	zone	zoneidnumber
One-to-One	zone_version	zone	version

Schema

Column	Data Type	Description
id	int	Adventure Identifier
zone	varchar	Zone Short Name
zone_version	tinyint	Zone Version
is_hard	tinyint	Hard: 0 = False, 1 = True
is_raid	tinyint	Raid: 0 = False, 1 = True
min_level	tinyint	Minimum Level
max_level	tinyint	Maximum Level
type	tinyint	Type
type_data	int	Type Data
type_count	smallint	Type Count
assa_x	float	Assassination X Coordinate
assa_y	float	Assassination Y Coordinate
assa_z	float	Assassination Z Coordinate
assa_h	float	Assassination Heading Coordinate
text	varchar	Text
duration	int	Duration
zone_in_time	int	Zone In Duration
win_points	smallint	LDoN Points for Winning
lose_points	smallint	LDoN Points for Losing
theme	tinyint	LDoN Theme
zone_in_zone_id	smallint	Zone In Zone Identifier
zone_in_x	float	Zone In X Coordinate
zone_in_y	float	Zone In Y Coordinate
zone_in_object_id	smallint	Zone In Object Identifier
dest_x	float	Destination X Coordinate
dest_y	float	Destination Y Coordinate
dest_z	float	Destination Z Coordinate
dest_h	float	Destination Heading Coordinate
graveyard_zone_id	int	Zone Identifier
graveyard_x	float	Graveyard X Coordinate
graveyard_y	float	Graveyard Y Coordinate
graveyard_z	float	Graveyard Z Coordinate
graveyard_radius	float	Graveyard Radius