object

Relationships

erDiagram
    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

Schema

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