Community Learning--Database structure 3

Data | database | database structure (one) community_emails
Number of columns:???????? 10

Number of indexes:???? 0

Number of foreign keys:???? 0

Primary key:???????? e_id

Code:???????? 0

Column
Data type
Allow NULL
Value/Range

e_id
Int
Not allowed
?
E_communityid
Int
Not allowed
?
E_from
nvarchar (250)
Not allowed
?
E_to
nvarchar (250)
Not allowed
?
E_subject
nvarchar (250)
Not allowed
?
E_body
ntext
Not allowed
?
E_ishtml
Bit
Not allowed
?
E_sendpriority
Int
Not allowed
?
E_entrydate
Datetime
Not allowed
?
E_sentdate
Datetime
Allow
?

(12) Community_events
Number of columns:???????? 6

Number of indexes:???? 0

Number of foreign keys:???? 1

Primary key:???????? Event_contentpageid

Code:???????? 0

Column
Data type
Allow NULL
Value/Range

Event_contentpageid
Int
Not allowed
?
Event_link
nvarchar (250)
Not allowed
?
Event_fulldescription
ntext
Allow
?
Event_location
nvarchar (100)
Not allowed
?
Event_speaker
nvarchar (100)
Not allowed
?
Event_speakerbiography
nvarchar (500)
Not allowed
?

Foreign key details (child)

Fk_community_events_community_contentpages

Defined:???????? Child???? Father
Event_contentpageid?????? community_contentpages.contentpage_id

Allow NULL:????? Not allowed

Referential integrity when updated:?????? No action

Referential integrity when deleted:?????? Cascade

(13) Community_hasread
Number of columns:???????? 4

Number of indexes:???? 0

Number of foreign keys:???? 1

Primary key:???????? 1.? Hr_userid
?????????????????? 2.? Hr_contentpageid

Code:???????? 0

Column
Data type
Allow NULL
Value/Range

Hr_userid
Int
Not allowed
?
Hr_contentpageid
Int
Not allowed
?
Hr_datefirstread
Datetime
Not allowed
?
Hr_datelastread
Datetime
Not allowed
?

Foreign key details (child)

Fk_community_hasread_community_contentpages

Defined:???????? Child???? ?????????????????? Father
Hr_contentpageid???? community_contentpages.contentpage_id

Allow NULL:????? Not allowed

Referential integrity when updated:?????? No action

Referential integrity when deleted:?????? Cascade

(14) Community_htmlpages
Number of columns:???????? 2

Number of indexes:???? 0

Number of foreign keys:???? 1

Primary key:???????? Htmlpage_sectionid

Code:???????? 0

Column
Data type
Allow NULL
Value/Range

Htmlpage_sectionid
Int
Not allowed
?
Htmlpage_page
ntext
Not allowed
?

Foreign key details (child)

Fk_community_htmlpages_community_sections

Defined:???????? Child???? ??????????????????????????? Father
Htmlpage_sectionid community_sections.section_id

Allow NULL:????? Not allowed

Referential integrity when updated:?????? No action

Referential integrity when deleted:?????? Cascade

(15) Community_links
Number of columns:???????? 4

Number of indexes:???? 0

Number of foreign keys:???? 1

Primary key:???????? Link_contentpageid

Code:???????? 0

Column
Data type
Allow NULL
Value/Range

Link_contentpageid
Int
Not allowed
?
Link_url
nvarchar (255)
Not allowed
?
Link_sortorder
Int
Not allowed
?
Link_clickcount
Int
Not allowed
?

Foreign key details (child)

Fk_community_links_community_contentpages

Defined:???????? Child???? ???????????????????????????????????? Father
Link_contentpageid????????? community_contentpages.contentpage_id

Allow NULL:????? Not allowed

Referential integrity when updated:?????? No action

Referential integrity when deleted:?????? Cascade