object

Info

This page was last generated 2023.07.15

Relationship Diagram(s)

Diagram Edit

Relationships

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
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