eventlog

Relationships

erDiagram
    eventlog {
        varchar accountid
        varchar accountname
        varchar charname
    }
    account {
        int id
        varchar name
    }
    character_data {
        intunsigned id
        varchar name
        varchar nane
        intunsigned zone_instance
        intunsigned zone_id
    }
    eventlog ||--o{ account : "One-to-One"
    eventlog ||--o{ account : "One-to-One"
    eventlog ||--o{ character_data : "One-to-One"

Relationship Type	Local Key	Relates to Table	Foreign Key
One-to-One	accountid	account	id
One-to-One	accountname	account	name
One-to-One	charname	character_data	name

Schema

Column	Data Type	Description
id	int	Unique Event Identifier
accountname	varchar	Account Name
accountid	int	Account Identifier
status	int	Status
charname	varchar	Character Name
target	varchar	Target
time	timestamp	TIme Timestamp
descriptiontype	varchar	Description Type
description	text	Description
event_nid	int	Event Identifier