现阶段在为自己设计一个用户关系通讯录小程序,谈不上系统。数据库设计如下:
详细设计如下:
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日续写博客。