Skip to content



    login_accounts {
        varchar account_name
        varchar last_ip_address
    account {
        int id
        varchar name
    account_ip {
        int accid
        varchar ip
    login_accounts ||--o{ account : "One-to-One"
    login_accounts ||--o{ account_ip : "Has-Many"

Relationship Type Local Key Relates to Table Foreign Key
One-to-One account_name account name
Has-Many last_ip_address account_ip ip


Column Data Type Description
id int Unique Account Identifier
account_name varchar Account Name
account_password text Account Password
account_email varchar Account Email
source_loginserver varchar Source Loginserver
last_ip_address varchar Last IP Address
last_login_date datetime Last Login Date
created_at datetime Created At Date
updated_at datetime Updated At Date