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

Table sahebkhabar.newsletter | 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 |  | √ |  |

messaging_log.newsletter_id | FK_messaging_log_newsletter N
subscription.newsletter_id | FK_subscription_newsletter R

title | varchar | 100 |  |  |  |  |  |
news_count | int | 10 |  |  | 1 |  |  |
place_id | int unsigned | 10 |  |  |  |  |

place.id | FK_newsletter_place R

start_date | datetime | 19 |  |  |  |  |  |
last_publish | datetime | 19 | √ |  | null |  |  |
time_interval | int | 10 |  |  | 1440 |  |  | interval between two alerts (in minute)
publish_strategy | tinyint | 3 |  |  | 1 |  |  | 1: automatic, 2: manual
medium | tinyint | 3 |  |  | 1 |  |  | 1: email, 2: sms
api_key | varchar | 500 | √ |  | null |  |  |
customizable | bit | 0 | √ |  | 0 |  |  |
creator | int | 10 |  |  |  |  |  |
created | datetime | 19 |  |  |  |  |  |
modifier | int | 10 | √ |  | null |  |  |
modified | datetime | 19 | √ |  | null |  |  |
site_id | smallint unsigned | 5 | √ |  | 1 |  |  |
active | bit | 0 |  |  | 1 |  |  |
visible | bit | 0 |  |  | 1 |  |  |

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

Indexes:

Column(s) | Type | Sort | Constraint Name
--- | --- | --- | ---
id | Primary key | Asc | PRIMARY
place_id | Performance | Asc | FK_newsletter_place
medium + publish_strategy + active | Performance | Asc/Asc/Asc | nl_med_pubs_act_idx

Close relationships within one two degrees of separation: