Skip to content



    object {
        varchar content_flags
        varchar content_flags_disabled
        int itemid
        int id
        smallint version
        intunsigned zoneid
    content_flags {
        varchar flag_name
    object_contents {
        intunsigned itemid
        intunsigned parentid
        mediumintunsigned augslot1
        mediumintunsigned augslot2
        mediumintunsigned augslot3
        mediumintunsigned augslot4
        mediumintunsigned augslot5
        mediumint augslot6
        intunsigned zoneid
    items {
        int id
        int book
        varchar name
        int recasttype
        int icon
        mediumint bardeffect
        int clickeffect
        int focuseffect
        int proceffect
        int scrolleffect
        int worneffect
    zone {
        int zoneidnumber
        varchar short_name
        tinyintunsigned version
        varchar content_flags
        varchar content_flags_disabled
    object ||--o{ content_flags : "One-to-One"
    object ||--o{ content_flags : "One-to-One"
    object ||--o{ object_contents : "Has-Many"
    object ||--o{ items : "One-to-One"
    object ||--o{ zone : "One-to-One"
    object ||--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
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
size_percentage float
unknown24 int Unknown
unknown20 int Unknown
unknown64 int Unknown
unknown68 int Unknown
unknown72 int Unknown
unknown76 int Unknown
unknown84 int Unknown
size float Size
solid_type mediumint
incline int
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