Skip to content

lfguild

Relationships

erDiagram
    lfguild {
        varchar name
    }
    character_data {
        intunsigned id
        varchar name
        varchar nane
        intunsigned zone_instance
        intunsigned zone_id
    }
    lfguild ||--o{ character_data : "One-to-One"

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

Schema

Column Data Type Description
type tinyint Type
name varchar Name
comment varchar Comment
fromlevel tinyint From Level
tolevel tinyint To Level
classes int Classes
aacount int AA Count
timezone int Time Zone
timeposted int Time Posted UNIX Timestamp