Skip to content



This page was last generated 2023.07.15

Relationship Diagram(s)

Diagram Edit


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
Has-Many id object_contents parentid
One-to-One itemid items id
One-to-One version zone version
One-to-One zoneid zone zoneidnumber


Column Data Type Description
id int Unique Object Identifier
zoneid int Zone Identifier
version smallint Version: -1 For All
xpos float X Coordinate
ypos float Y Coordinate
zpos float Z Coordinate
heading float Heading Coordinate
itemid int Item Identifier
charges smallint Charges
objectname varchar Object Name
type int Type
icon int Icon
unknown08 mediumint Unknown
unknown10 mediumint Unknown
unknown20 int Unknown
unknown24 int Unknown
unknown60 int Unknown
unknown64 int Unknown
unknown68 int Unknown
unknown72 int Unknown
unknown76 int Unknown
unknown84 int Unknown
size float Size
tilt_x float Tilt X
tilt_y float Tilt Y
display_name varchar Display Name
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