Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| id | serial | 10 | √ | nextval('mail_link_preview_id_seq'::regclass) |
|
|
|||||
| message_id | int4 | 10 | null |
|
|
Message |
|||||
| create_uid | int4 | 10 | √ | null |
|
|
Created by |
||||
| write_uid | int4 | 10 | √ | null |
|
|
Last Updated by |
||||
| source_url | varchar | 2147483647 | null |
|
|
URL |
|||||
| og_type | varchar | 2147483647 | √ | null |
|
|
Type |
||||
| og_title | varchar | 2147483647 | √ | null |
|
|
Title |
||||
| og_site_name | varchar | 2147483647 | √ | null |
|
|
Site name |
||||
| og_image | varchar | 2147483647 | √ | null |
|
|
Image |
||||
| og_mimetype | varchar | 2147483647 | √ | null |
|
|
MIME type |
||||
| image_mimetype | varchar | 2147483647 | √ | null |
|
|
Image MIME type |
||||
| og_description | text | 2147483647 | √ | null |
|
|
Description |
||||
| create_date | timestamp | 29,6 | √ | null |
|
|
Create Date |
||||
| write_date | timestamp | 29,6 | √ | null |
|
|
Last Updated on |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| mail_link_preview_pkey | Primary key | Asc | id |
| mail_link_preview__create_date_index | Performance | Asc | create_date |
| mail_link_preview__message_id_index | Performance | Asc | message_id |
Relationships
Close relationships within degrees of separation
