login_world_servers

Relationships

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

Relationship Type	Local Key	Relates to Table	Foreign Key
Has-Many	last_ip_address	account_ip	ip
One-to-One	login_server_admin_id	login_server_admins	id
One-to-One	login_server_list_type_id	login_server_list_types	id

Schema

Column	Data Type	Description
id	int	Unique World Server Identifier
long_name	varchar	Long Name
short_name	varchar	Short Name
tag_description	varchar	Tag Description
login_server_list_type_id	int	List Type Identifier (1 Legends, 2 Preferred, 3 Standard)
last_login_date	datetime	Last Login Date
last_ip_address	varchar	Last IP Address
login_server_admin_id	int	Login Server Admin Identifier
is_server_trusted	int	Is Server Trusted: 0 = False, 1 = True
note	varchar	Note