object¶
Info
This page was last generated 2023.04.23
Relationship Diagram(s)¶
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 |