Community Learning--Database structure 1

Data | database | Database Structure 1 database structure
1.1 Naming rules
All community_sample+name tables are sample data

1.1.1 Database Detail Structure
The Sample data table is not listed

(1) Database summary
Target DBMS:?? Microsoft SQL Server

Number of tables:??????? 41

Number of views:???? 0

Number of columns:??????? 302

Number of indexes:???? 8s

Number of foreign keys:???? 36

(2) Community_activitylog
Number of columns:???????? 7

Number of indexes:???? 0

Number of foreign keys:???? 1

Primary key:???????? activity_id

Code:???????? 0

Column
Data type
Allow NULL
Value/Range

activity_id
int identity
Not allowed
?
Activity_communityid
Int
Not allowed
?
Activity_sectionid
Int
Not allowed
?
Activity_url
nvarchar (250)
Not allowed
?
Activity_briefentry
nvarchar (250)
Not allowed
?
Activity_fullentry
ntext
Allow
?
activity_datecreated
Datetime
Not allowed
?

Foreign key details (child)

Fk_community_errors_community_communities

Defined:???????? Zi Activity_communityid

????????? ???????? Father community_communities.community_id

Allow NULL:????? Not allowed

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

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

(3) Community_articles
Number of columns:???????? 2

Number of indexes:???? 0

Number of foreign keys:???? 1

Primary key:???????? Article_contentpageid

Code:???????? 0

Column
Data type
Allow NULL
Value/Range

Article_contentpageid
Int
Not allowed
?
Article_article
ntext
Not allowed
?

Foreign key details (child)

Fk_community_articles_community_contentpages

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

Allow NULL:????? Not allowed

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

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

(4) Community_books
Number of columns:???????? 9

Number of indexes:???? 0

Number of foreign keys:???? 1

Primary key:???????? Book_contentpageid

Code:???????? 0

Column
Data type
Allow NULL
Value/Range

Book_contentpageid
Int
Not allowed
?
Book_isbn
nvarchar (50)
Allow
?
Book_author
nvarchar (100)
Allow
?
Book_price
Money
Allow
?
Book_fulldescription
ntext
Allow
?
Book_purchaselink
nvarchar (250)
Not allowed
?
Book_publisher
nvarchar (100)
Allow
?
Book_publisherlink
nvarchar (250)
Allow
?
Book_publicationdate
Datetime
Not allowed
?

Foreign key details (child)

Fk_community_books_community_contentpages

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

Allow NULL:????? Not allowed

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

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

(5) Community_comments
Number of columns:???????? 2

Number of indexes:???? 0

Number of foreign keys:???? 1

Primary key:???????? Comment_contentpageid

Code:???????? 0

Column
Data type
Allow NULL
Value/Range

Comment_contentpageid
Int
Not allowed
?
Comment_text
ntext
Not allowed
?

Foreign key details (child)

Fk_community_comments_community_contentpages

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

Allow NULL:????? Not allowed

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

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