doors

Relationships

erDiagram
    doors {
        varchar content_flags
        varchar content_flags_disabled
        int dz_switch_id
        int keyitem
        varchar zone
        varchar dest_zone
        intunsigned dest_instance
        smallint version
    }
    content_flags {
        varchar flag_name
    }
    dynamic_zones {
        int dz_switch_id
        intunsigned id
        intunsigned compass_zone_id
        int instance_id
        intunsigned safe_return_zone_id
    }
    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
    }
    doors ||--o{ content_flags : "One-to-One"
    doors ||--o{ content_flags : "One-to-One"
    doors ||--o{ dynamic_zones : "One-to-One"
    doors ||--o{ items : "One-to-One"
    doors ||--o{ zone : "One-to-One"
    doors ||--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
One-to-One	dz_switch_id	dynamic_zones	dz_switch_id
One-to-One	keyitem	items	id
One-to-One	zone	zone	short_name
One-to-One	dest_zone	zone	short_name

Schema

Column	Data Type	Description
id	int	Unique Entry Identifier
doorid	smallint	Unique Door Identifier
zone	varchar	Zone Short Name
version	smallint	Zone Version: -1 For All
name	varchar	This is the name of the door, such as 'IT11161' or 'POPCREATE501', for names of objects you can see.
pos_y	float	Door Y Coordinate
pos_x	float	Door X Coordinate
pos_z	float	Door Z Coordinate
heading	float	Door Heading Coordinate
opentype	smallint	Door Open Type
guild	smallint	Guild Identifier
lockpick	smallint	Lockpicking Skill Required: -1 = Unpickable
keyitem	int	Item Identifier
nokeyring	tinyint	No Key Ring: 0 = False, 1 = True
triggerdoor	smallint	Trigger Door: 0 For Current Door or use a Unique Door Identifier
triggertype	smallint	Trigger Type: 1 = Open a Type 255 door, 255 = Will Not Open
disable_timer	tinyint	Disable Timer
doorisopen	smallint	Door Is Open: 0 = False, 1 = True
door_param	int	Door Parameter
dest_zone	varchar	Zone Short Name
dest_instance	int	Destination Instance
dest_x	float	Destination X Coordinate
dest_y	float	Destination Y Coordinate
dest_z	float	Destination Z Coordinate
dest_heading	float	Destination Heading Coordinate
invert_state	int	This column will basically behave like such: if the door has a click type and it is to raise up like a door, it will be raised on spawn of the door. Meaning it is inverted. Another example: If a Door Open Type is set to a spinning object on click, you could set this to 1 to have the door be spinning on spawn.
incline	int	Incline
size	smallint	Size
buffer	float	Unused
client_version_mask	int	Client Version Mask
is_ldon_door	smallint	Is LDoN Door: 0 = False, 1 = True
dz_switch_id	int	Dynamic Zone Switch Identifier
min_expansion	tinyint	Minimum Expansion](../../../../server/operation/expansion-list)
max_expansion	tinyint	Maximum Expansion](../../../../server/operation/expansion-list)
content_flags	varchar	Content Flags Required to be Enabled
content_flags_disabled	varchar	Content Flags Required to be Disabled