[Spleb] Database Design

I would like to discuss with you how to design a database. More specifically, it is not about the principles of database design, but about the design of a database in Engineering. I am a beginner. I have never participated in standard projects. I have worked on a micro-project that I have chosen by myself. I have been exploring for a while. The following is a database design for spleb. Please criticize and advise me.

My Database Design Methods
I. data entities: list all data entities
Ii. Data clarification: what data objects should contain
3. Data entity relationship diagram: Relationship between data entities
4. Data Table: database schema table

Example: (the database is small, there are very few data entities, and no relational diagram is made)

SplebDatabase Design

I,Data entity

1,System settings (Config)

2,Data Source, database (Database)

3,Template (Template)

4,Template information (Templateinf)

II,Data entity details

1,System settings (Config)

(1)Business Data: namespace (Namespace)

(2)Logical Data: Primary Key (Configid)

2,Data Source, database (Database)

(1)Business Data: Database Name (Databasename), Connection string (Connectionstring), Database Type (Databasetype), Ing information file name (Classmapfilename), The Last Time (Lasttime)

(2)Logical Data: Primary Key (Databaseid)

3,Template (Template)

(1)Business Data: Template Name (Templatename), GenerateCodeLanguage (Language), The main template file name (Mainfilename), Description (Description), Template usage (Buildtimes), The Last Time (Lasttime)

(2)Logical Data: Primary Key (Templateid)

(3)Associated data entity: Template Information

4,Template information (Templateinf)

(1)Business Data: Template content (Content), Template file name (Filename)

(2)Logical Data: Primary Key (Templateinfid)

(3)Link data: Corresponding template primary key (Templateid)

(4)Associated data entity: Template

III,Data Table

1,System settings (Config)

Data name	Field name	Data Type	Remarks
Primary Key	Configid	Primary Key
Namespace	Namespace	Text

2,Data Source, database (Database)

Data name	Field name	Data Type	Remarks
Primary Key	Databaseid	Primary Key
Database Name	Databasename	Text	Not empty
Connection string	Connectionstring	Long text
Database Type	Databasetype	Text	Optional values: MSSQLServer,Msaccess, Oracle
Ing information file name	Classmapfilename	Text	Not empty
Last use time	Lasttime	Time

3,Template (Template)

Data name	Field name	Data Type	Remarks
Primary Key	Templateid	Primary Key
Template Name	Templatename	Text	Not empty
Code language generation	Language	Text	Non-empty, possible values C #,VB
Main template file name	Mainfilename	Text	Not empty
Description	Description	Long text
Template usage	Buildtimes	Integer	Not blank, default0
Last use time	Lasttime	Date

4,Template information (Templateinf)

Data name	Field name	Data Type	Remarks
Primary Key	Templateinfid	Primary Key
Template	Tmplateid	Foreign key	Not empty
Template content	Content	Long text
File Name	Filename	Text	Not empty

 

 

Yuandong

2006-1-31