Table: Feed_Channel_Item | |||
Columns | |||
Name | Type | Constraints | Description |
feed_channel_item_KEY | int | NOT NULL | |
update__staff_KEY | int | NOT NULL | |
update_date_utc | datetime | NOT NULL | |
create_date_utc | datetime | NOT NULL | |
feed_channel_KEY | int | NOT NULL | |
feed_channel_item_guid | uniqueidentifier | NOT NULL | |
title | nvarchar (500) | NOT NULL | |
url | nvarchar (2048) | NOT NULL | |
content | nvarchar (-1) | NOT NULL | |
original_publication_date | datetime |
Primary key | |||
Name | Columns | Description | |
PK_Feed_Channel_Item$feed_channel_item_KEY | feed_channel_item_KEY | CLUSTERED | |
Indexes | |||
Name | Columns | Description | |
IX_Feed_Channel_Item$feed_channel_KEY | feed_channel_KEY | Index supports foreign key FK_Feed_Channel_Item__Feed_Channel__feed_channel_KEY |
Foreign keys | |||
Name | Columns | Referenced table | Description |
FK_Feed_Channel_Item__Feed_Channel__feed_channel_KEY | feed_channel_KEY | Feed_Channel |
Incoming foreign keys | |||
Name | Columns | Referencing table | Description |
FK_Feed_Channel_Item_Enclosure__Feed_Channel_Item__feed_channel_item_KEY | feed_channel_item_KEY | Feed_Channel_Item_Enclosure | |
FK_Feed_Channel_Item_Staff_Read__Feed_Channel_Item__feed_channel_item_KEY | feed_channel_item_KEY | Feed_Channel_Item_Staff_Read | on delete cascade; |