login_server_admins

Relationships

erDiagram
    login_server_admins {
        intunsigned id
        varchar account_name
        varchar registration_ip_address
    }
    login_world_servers {
        int login_server_admin_id
        int login_server_list_type_id
        varchar last_ip_address
    }
    account {
        int id
        varchar name
    }
    account_ip {
        int accid
        varchar ip
    }
    login_server_admins ||--o{ login_world_servers : "Has-Many"
    login_server_admins ||--o{ account : "One-to-One"
    login_server_admins ||--o{ account_ip : "Has-Many"

Relationship Type	Local Key	Relates to Table	Foreign Key
Has-Many	id	login_world_servers	login_server_admin_id
One-to-One	account_name	account	name
Has-Many	registration_ip_address	account_ip	ip

Schema

Column	Data Type	Description
id	int	Unique Account Identifier
account_name	varchar	Account Name
account_password	varchar	Account Password
first_name	varchar	First Name
last_name	varchar	Last Name
email	varchar	Email
registration_date	datetime	Registration Date
registration_ip_address	varchar	Registration IP Address