Open main menu

UESPWiki β

UESPWiki:Oblivion Map Design/Database Table

< UESPWiki:Oblivion Map Design
  +---------------+------------------+------+-----+---------+----------------+
  | Field         | Type             | Null | Key | Default | Extra          |
  +---------------+------------------+------+-----+---------+----------------+
  | ID            | int(11)          | NO   | PRI | NULL    | auto_increment |
  | FormID        | int(10) unsigned | NO   |     | 0       |                |
  | EditorID      | tinytext         | NO   |     | NULL    |                |
  | WorldSpace    | tinytext         | NO   |     | NULL    |                |
  | ObLocX        | int(11)          | NO   |     | 0       |                |
  | ObLocY        | int(11)          | NO   |     | 0       |                |
  | ObLocZ        | int(11)          | NO   |     | 0       |                |
  | DestFormID    | int(10) unsigned | NO   |     | 0       |                |
  | Name          | tinytext         | NO   | MUL | NULL    |                |
  | MarkerType    | tinyint(4)       | NO   |     | 0       |                |
  | DisplayLevel  | tinyint(4)       | NO   |     | 16      |                |
  | Enable        | tinyint(4)       | NO   |     | 1       |                |
  | WikiPage      | tinytext         | NO   |     | NULL    |                |
  | LabelPosition | tinyint(4)       | NO   |     | 8       |                |
  | SearchTags    | tinytext         | NO   |     | NULL    |                |
  +---------------+------------------+------+-----+---------+----------------+