- Tables
- Relationships
- Utility Tables
- Constraints
- Anomalies
- Columns
- Donate

Table sahebkhabar.site_domain | Generated by SchemaSpy

Related columns Constraints Comments Legend |

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
--- | --- | --- | --- | --- | --- | --- | --- | ---
id | int unsigned | 10 |  |  |  |  |  |
site_id | int unsigned | 10 |  |  |  |  |

site.id | fk_site_domain_site_id R

domain_name | varchar | 50 |  |  |  |  |  |
protocol | varchar | 10 |  |  | * |  |  | Could be * for all protocols
port_number | smallint unsigned | 5 |  |  |  |  |  |

Table contained 20 rows at Wed Jan 20 16:28 IRST 2016

Indexes:

Column(s) | Type | Sort | Constraint Name
--- | --- | --- | ---
id | Primary key | Asc | PRIMARY
site_id | Performance | Asc | fk_site_domain_site_id
domain_name + protocol + port_number | Must be unique | Asc/Asc/Asc | Idx_unique

Close relationships within one two degrees of separation: