hackers

Relationships

erDiagram
    hackers {
        varchar account
        varchar name
        varchar zone
    }
    account {
        int id
        varchar name
    }
    character_data {
        intunsigned id
        varchar name
        varchar nane
        intunsigned zone_instance
        intunsigned zone_id
    }
    zone {
        int zoneidnumber
        varchar short_name
        tinyintunsigned version
        varchar content_flags
        varchar content_flags_disabled
    }
    hackers ||--o{ account : "One-to-One"
    hackers ||--o{ character_data : "One-to-One"
    hackers ||--o{ zone : "One-to-One"

Relationship Type	Local Key	Relates to Table	Foreign Key
One-to-One	account	account	name
One-to-One	name	character_data	name
One-to-One	zone	zone	short_name

Schema

Column	Data Type	Description
id	int	Unique Hacker Identifier
account	text	Account Identifier
name	text	Character Name
hacked	text	Hacked
zone	text	Zone Short Name
date	timestamp	Date Timestamp