IPAllocator

Tables (7)

CommuniationInterface (Untitled5)

  • interface_id (Key) — Primary key — NOT NULL
  • interface_type (Key2) — Foreign key → interface_type.interface_type — NOT NULL

Device (Untitled4)

  • id (Key) — Primary key — NOT NULL
  • interface_id (Key2) — Foreign key → CommuniationInterface.interface_id — NOT NULL
  • device_type_id (Key3) — Foreign key → DeviceType.device_type_id — NOT NULL
  • name (Field)

DeviceType (Untitled)

  • device_type_id (Key) — int — Primary key — NOT NULL
  • device_type_name (Field) — boolean

IP (Untitled6)

  • interface_id (Key) — Foreign key → CommuniationInterface.interface_id — NOT NULL
  • protocol (Key2) — varchar — Foreign key → ip_protocol_type.protocol — NOT NULL
  • ip (Field)
  • port (Field2)

Serial (Untitled7)

  • interface_id (Key) — Foreign key → CommuniationInterface.interface_id — NOT NULL
  • port (Field)
  • baudrate (Field2)

interface_type (Untitled8)

  • interface_type (Key) — Primary key — NOT NULL

ip_protocol_type (Untitled2)

  • protocol (Key) — Primary key — NOT NULL