Table SIEM.public.esec_port_reference
Industry standard assigned port numbers

Generated by
SchemaSpy
Legend:
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
port_number int4 10 Per http://www.iana.org/assignments/port-numbers, the numerical representation of the port. This port number is typically associated with the Transport Protocol level in the TCP/IP stack.
protocol_number int4 10
esec_protocol_reference.protocol_number esec_protocol_esec_port_fk R
Per http://www.iana.org/assignments/protocol-numbers, the numerical identifiers used to represent protocols that are encapsulated in an IP packet.
port_keyword varchar 64  √  null Per http://www.iana.org/assignments/port-numbers, the keyword representation of the port.
port_description varchar 512  √  null Port description.
date_created timestamptz 35,6 Date the entry was created
date_modified timestamptz 35,6 Date the entry was modified
created_by int4 10  √  null User who created object
modified_by int4 10  √  null User who last modified object

Table contained 0 rows at Mon Mar 26 23:24 EDT 2012

Indexes:
Column(s) Type Sort Constraint Name
port_number + protocol_number Primary key Asc/Asc esec_port_reference_pk
protocol_number Performance Asc esec_port_ref_protocol_nbr_idx

Close relationships: