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

Table sahebkhabar.subscription | 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.subscription_id | FK_messaging_log_subscription N

name | varchar | 40 |  |  |  |  |  |
cell | varchar | 40 | √ |  | null |  |  |
email | varchar | 70 |  |  |  |  |  |
created | datetime | 19 | √ |  | null |  |  |
creator | int unsigned | 10 | √ |  | null |  |  | only appliable when an authenticated user creates one
modified | datetime | 19 | √ |  | null |  |  |
modifier | int unsigned | 10 | √ |  | null |  |  | only appliable when an authenticated user modifies one
status | int | 10 |  |  |  |  |  |
active | tinyint unsigned | 3 | √ |  | null |  |  | reserved. use status to disable a subscription
news_count | smallint unsigned | 5 | √ |  | null |  |  | if null, will use newsletter.news_count
newsletter_id | int unsigned | 10 |  |  |  |  |

newsletter.id | FK_subscription_newsletter R

topic_id | int unsigned | 10 | √ |  | null |  |  |
source_id | mediumint unsigned | 8 | √ |  | null |  |  |
keyword_id | int unsigned | 10 | √ |  | null |  |  |
site_id | smallint unsigned | 5 | √ |  | 1 |  |  |
country_code | varchar | 2 | √ |  | null |  |  |
user_ip | varchar | 50 | √ |  | null |  |  |

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

Indexes:

Column(s) | Type | Sort | Constraint Name
--- | --- | --- | ---
id | Primary key | Asc | PRIMARY
newsletter_id | Performance | Asc | subscription_newsletter_idx

Close relationships within one two degrees of separation: