item_tick
Relationships
erDiagram
item_tick {
varchar it_itemid
varchar it_qglobal
}
items {
int id
int book
varchar name
int recasttype
int icon
mediumint bardeffect
int clickeffect
int focuseffect
int proceffect
int scrolleffect
int worneffect
}
quest_globals {
int charid
varchar name
int npcid
int zoneid
}
item_tick ||--o{ items : "One-to-One"
item_tick ||--o{ quest_globals : "Has-Many"
| Relationship Type |
Local Key |
Relates to Table |
Foreign Key |
| One-to-One |
it_itemid |
items |
id |
| Has-Many |
it_qglobal |
quest_globals |
name |
Schema