sms.sql

企业内部的短信交流管理平台。 设计详细

use SMSDB
go

create table Users
(
userId	Int primary key identity(1,1),
userName	Varchar(50),
userPwd	Varchar(50),
userBir	DateTime,
userTel	Varchar(50),
userSex	Char(2),
userAge	int,
userEmail	Varchar(50)

)
go

create table AddressBooks
(
AddressBookId	Int primary key identity(1,1),
userId	int,
AddressBookName	Varchar(50),
bz	Varchar(100)

)
go

create table AddressBookDetail
(
AddressBookDetailId	Int primary key identity(1,1),
AddressBookId	int,
userId	int

)
go

create table SendBox
(
sendId	Int primary key identity(1,1),
senderId	int,
conId	int,
SendTime	datetime,
ReciveUsers	varchar(140)

)
go

create table UserAndPopedom
(
uapId	Int primary key identity(1,1),
userId	int,
pdId	int

)
go

create table ReciveBox
(
ReciveId	Int primary key identity(1,1),
ReciveuserId	int,
conId	int,
senduserId	int,
isDel	bit,
isRead	bit

)
go

create table Contents
(
conId	Int primary key identity(1,1),
Content	varchar(140)

)
go

create table Messages
(
msgId	Int primary key identity(1,1),
Content	varchar(140),
sender	Varchar(30),
recive	Varchar(30),
sendTime	datetime

)
go

create table AlbumType
(
abtId	Int primary key identity(1,1),
typeName	varchar(140)

)
go

create table Album
(
abId	Int primary key identity(1,1),
alName	varchar(50),
typeId	int,
userId	int,
alFace	Varchar(100)

)
go

create table Photos
(
pId	Int primary key identity(1,1),
pPath	varchar(100),
pDesc	Varchar(100),
abId	int,
isPublic	bit

)
go

create table Popedom
(
pdId	Int primary key identity(1,1),
pdName	varchar(100),
pdPath	Varchar(500)

)
go