character_tasks

Relationships

erDiagram
    character_tasks {
        intunsigned charid
        intunsigned taskid
        tinyint type
    }
    character_data {
        intunsigned id
        varchar name
        varchar nane
        intunsigned zone_instance
        intunsigned zone_id
    }
    tasks {
        intunsigned id
        tinyint type
        intunsigned dz_template_id
    }
    character_tasks ||--o{ character_data : "One-to-One"
    character_tasks ||--o{ tasks : "One-to-One"
    character_tasks ||--o{ tasks : "One-to-One"

Relationship Type	Local Key	Relates to Table	Foreign Key
One-to-One	charid	character_data	id
One-to-One	taskid	tasks	id
One-to-One	type	tasks	type

Schema

Column	Data Type	Description
charid	int	Character Identifier
taskid	int	Task Identifier
slot	int	Slot
type	tinyint	Task Type
acceptedtime	int	Accepted Time UNIX Timestamp
was_rewarded	tinyint	Was Rewarded: 0 = False, 1 = True