login_accounts

Relationships

erDiagram
    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

Schema

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