用户关系通讯录数据库设计

现阶段在为自己设计一个用户关系通讯录小程序，谈不上系统。数据库设计如下：

详细设计如下：

sql生成的脚本代码：

USE [master]
GO
/****** Object:  Database [db_contacts]    Script Date: 09/24/2014 13:17:15 ******/
CREATE DATABASE [db_contacts] ON  PRIMARY 
( NAME = N'db_contacts', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\db_contacts.mdf' , SIZE = 3072KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB )
 LOG ON 
( NAME = N'db_contacts_log', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\db_contacts_log.ldf' , SIZE = 1024KB , MAXSIZE = 2048GB , FILEGROWTH = 10%)
GO
ALTER DATABASE [db_contacts] SET COMPATIBILITY_LEVEL = 100
GO
IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled'))
begin
EXEC [db_contacts].[dbo].[sp_fulltext_database] @action = 'enable'
end
GO
ALTER DATABASE [db_contacts] SET ANSI_NULL_DEFAULT OFF
GO
ALTER DATABASE [db_contacts] SET ANSI_NULLS OFF
GO
ALTER DATABASE [db_contacts] SET ANSI_PADDING OFF
GO
ALTER DATABASE [db_contacts] SET ANSI_WARNINGS OFF
GO
ALTER DATABASE [db_contacts] SET ARITHABORT OFF
GO
ALTER DATABASE [db_contacts] SET AUTO_CLOSE OFF
GO
ALTER DATABASE [db_contacts] SET AUTO_CREATE_STATISTICS ON
GO
ALTER DATABASE [db_contacts] SET AUTO_SHRINK OFF
GO
ALTER DATABASE [db_contacts] SET AUTO_UPDATE_STATISTICS ON
GO
ALTER DATABASE [db_contacts] SET CURSOR_CLOSE_ON_COMMIT OFF
GO
ALTER DATABASE [db_contacts] SET CURSOR_DEFAULT  GLOBAL
GO
ALTER DATABASE [db_contacts] SET CONCAT_NULL_YIELDS_NULL OFF
GO
ALTER DATABASE [db_contacts] SET NUMERIC_ROUNDABORT OFF
GO
ALTER DATABASE [db_contacts] SET QUOTED_IDENTIFIER OFF
GO
ALTER DATABASE [db_contacts] SET RECURSIVE_TRIGGERS OFF
GO
ALTER DATABASE [db_contacts] SET  DISABLE_BROKER
GO
ALTER DATABASE [db_contacts] SET AUTO_UPDATE_STATISTICS_ASYNC OFF
GO
ALTER DATABASE [db_contacts] SET DATE_CORRELATION_OPTIMIZATION OFF
GO
ALTER DATABASE [db_contacts] SET TRUSTWORTHY OFF
GO
ALTER DATABASE [db_contacts] SET ALLOW_SNAPSHOT_ISOLATION OFF
GO
ALTER DATABASE [db_contacts] SET PARAMETERIZATION SIMPLE
GO
ALTER DATABASE [db_contacts] SET READ_COMMITTED_SNAPSHOT OFF
GO
ALTER DATABASE [db_contacts] SET HONOR_BROKER_PRIORITY OFF
GO
ALTER DATABASE [db_contacts] SET  READ_WRITE
GO
ALTER DATABASE [db_contacts] SET RECOVERY FULL
GO
ALTER DATABASE [db_contacts] SET  MULTI_USER
GO
ALTER DATABASE [db_contacts] SET PAGE_VERIFY CHECKSUM
GO
ALTER DATABASE [db_contacts] SET DB_CHAINING OFF
GO
EXEC sys.sp_db_vardecimal_storage_format N'db_contacts', N'ON'
GO
USE [db_contacts]
GO
/****** Object:  Table [dbo].[t_user]    Script Date: 09/24/2014 13:17:16 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[t_user](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[userName] [varchar](50) NOT NULL,
	[passWord] [varchar](50) NOT NULL,
	[tips] [varchar](500) NULL,
 CONSTRAINT [PK_t_user] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[t_relationship]    Script Date: 09/24/2014 13:17:16 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[t_relationship](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[relation] [varchar](10) NOT NULL,
 CONSTRAINT [PK_t_relationship] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[t_contact]    Script Date: 09/24/2014 13:17:16 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[t_contact](
	[id] [int] IDENTITY(1,1) NOT NULL,
	[xingMing] [varchar](50) NULL,
	[gender] [varchar](4) NULL,
	[birthday] [date] NULL,
	[iidentityNumber] [char](18) NULL,
	[nickName] [varchar](20) NULL,
	[photo] [varchar](100) NULL,
	[originalPlace] [varchar](50) NULL,
	[email] [varchar](100) NULL,
	[mobileNumber] [char](11) NULL,
	[address] [varchar](500) NULL,
	[education] [varchar](50) NULL,
	[company] [varchar](100) NULL,
	[QQ] [varchar](20) NULL,
	[wechat] [varchar](50) NULL,
	[weibo] [varchar](50) NULL,
	[twitter] [varchar](50) NULL,
	[facebook] [varchar](50) NULL,
	[contactOf] [int] NOT NULL,
	[relationship] [int] NOT NULL,
 CONSTRAINT [PK_t_contact] PRIMARY KEY CLUSTERED 
(
	[id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  ForeignKey [FK_t_contact_t_relationship]    Script Date: 09/24/2014 13:17:16 ******/
ALTER TABLE [dbo].[t_contact]  WITH CHECK ADD  CONSTRAINT [FK_t_contact_t_relationship] FOREIGN KEY([relationship])
REFERENCES [dbo].[t_relationship] ([id])
GO
ALTER TABLE [dbo].[t_contact] CHECK CONSTRAINT [FK_t_contact_t_relationship]
GO
/****** Object:  ForeignKey [FK_t_contact_t_user1]    Script Date: 09/24/2014 13:17:16 ******/
ALTER TABLE [dbo].[t_contact]  WITH CHECK ADD  CONSTRAINT [FK_t_contact_t_user1] FOREIGN KEY([contactOf])
REFERENCES [dbo].[t_user] ([id])
GO
ALTER TABLE [dbo].[t_contact] CHECK CONSTRAINT [FK_t_contact_t_user1]
GO

下一个阶段就准备用Java Swing做出一个demo版本。一个星期完成吧。10月1日续写博客。