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

Table sahebkhabar.entity_audit_log | 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 |  | √ |  |  |  |
date | datetime | 19 |  |  |  |  |  |
action_code | tinyint unsigned | 3 |  |  |  |  |  |
user_id | int unsigned | 10 | √ |  | null |  |

user_profile.id | FK_8yd4jgtdnd2x6waxx0w9hospr R

entity_class | varchar | 30 |  |  |  |  |  |
entity_id | int unsigned | 10 |  |  |  |  |  |
entity_title | varchar | 200 | √ |  | null |  |  |

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

Indexes:

Column(s) | Type | Sort | Constraint Name
--- | --- | --- | ---
id | Primary key | Asc | PRIMARY
date + user_id | Performance | Asc/Asc | date_user_id
entity_class + entity_id | Performance | Asc/Asc | entity_class_entity_id
user_id | Performance | Asc | FK_8yd4jgtdnd2x6waxx0w9hospr

Close relationships within one two degrees of separation: