Skip to content

gm_ips

Relationships

erDiagram
    gm_ips {
        int account_id
        varchar ip_address
    }
    account {
        int id
        varchar name
    }
    account_ip {
        int accid
        varchar ip
    }
    gm_ips ||--o{ account : "One-to-One"
    gm_ips ||--o{ account_ip : "Has-Many"
Relationship Type Local Key Relates to Table Foreign Key
One-to-One account_id account id
Has-Many ip_address account_ip ip

Schema

Column Data Type Description
name varchar Character Name
account_id int Account Identifier
ip_address varchar IP Address