Skip to content

adventure_template

Info

This page was last generated 2022.09.16

Relationship Diagram(s)

Diagram Edit

Relationships

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