starting_items

Relationships

erDiagram
    starting_items {
        varchar content_flags
        varchar content_flags_disabled
        varchar itemid
        varchar zone_id
        varchar zoneid
    }
    content_flags {
        varchar flag_name
    }
    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
    }
    starting_items ||--o{ content_flags : "One-to-One"
    starting_items ||--o{ content_flags : "One-to-One"
    starting_items ||--o{ items : "One-to-One"
    starting_items ||--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	itemid	items	id
One-to-One	zone_id	zone	zoneidnumber

Schema

Column	Data Type	Description
id	int	Unique Starting Items Entry Identifier
class_list	text
class	int	Class: 0 = All
deityid	int	Deity: 0 = Alll
zone_id_list	text
itemid	int	Item Identifier
item_charges	tinyint	Item Charges
status	mediumint
slot	mediumint	Slot
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