adventure_details

Relationships

erDiagram
    adventure_details {
        intunsigned id
        smallintunsigned adventure_id
        int instance_id
    }
    adventure_members {
        intunsigned id
        intunsigned charid
    }
    adventure_template {
        intunsigned id
        intunsigned graveyard_zone_id
        varchar zone
        smallintunsigned zone_in_zone_id
        tinyintunsigned zone_version
        varchar version
    }
    adventure_template_entry {
        intunsigned id
        intunsigned template_id
    }
    adventure_template_entry_flavor {
        intunsigned id
    }
    instance_list {
        int id
        tinyintunsigned version
        intunsigned zone
    }
    adventure_details ||--o{ adventure_members : "Has-Many"
    adventure_details ||--o{ adventure_template : "One-to-One"
    adventure_details ||--o{ adventure_template_entry : "Has-Many"
    adventure_details ||--o{ adventure_template_entry_flavor : "Has-Many"
    adventure_details ||--o{ adventure_template : "One-to-One"
    adventure_details ||--o{ instance_list : "One-to-One"

Relationship Type	Local Key	Relates to Table	Foreign Key
Has-Many	id	adventure_members	id
One-to-One	id	adventure_template	id
Has-Many	id	adventure_template_entry	id
Has-Many	id	adventure_template_entry_flavor	id
One-to-One	adventure_id	adventure_template	id
One-to-One	instance_id	instance_list	id

Schema

Column	Data Type	Description
id	int	Unique Entry Identifier
adventure_id	smallint	Unique Adventure Identifier
instance_id	int	Instance Identifier
count	smallint	Count
assassinate_count	smallint	Assassinate Count
status	tinyint	Status
time_created	int	Time Created UNIX Timestamp
time_zoned	int	Time Zoned UNIX Timestamp
time_completed	int	Time Completed UNIX Timestamp