mmo-ref/eqemu-docs
1
0
Fork 0
mirror of https://github.com/EQEmu/eqemu-docs-v2.git synced 2026-08-08 17:45:09 -04:00
Code Issues Projects Releases Packages Wiki Activity Actions
eqemu-docs/docs/schema/admin/discovered_items.md

1.3 KiB
Raw Permalink Blame History

discovered_items

Relationships

erDiagram
    discovered_items {
        varchar char_name
        intunsigned item_id
    }
    character_data {
        intunsigned id
        varchar name
        varchar nane
        intunsigned zone_instance
        intunsigned 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
    }
    discovered_items ||--o{ character_data : "One-to-One"
    discovered_items ||--o{ items : "One-to-One"
Relationship Type Local Key Relates to Table Foreign Key
One-to-One char_name character_data name
One-to-One item_id items id

Schema

Column Data Type Description
item_id int Item Identifier
char_name varchar Character Name
discovered_date int Discovered Date UNIX Timestamp
account_status int Account Status