Ylbtech-cnblogs ()-Database Design-1, Passport (account)

Ylbtech-DatabaseDesgin: ylbtech-cnblogs (blog)-Database Design-1, Accounts (account) DatabaseName: cnblogs (blog) Model: Passport Account module database design Type: professional Technical website Url: 1.a, database relationship diagram (databasedi.pdf) 1. B, Database Design script (DatabaseDesignScript

Ylbtech-DatabaseDesgin: ylbtech-cnblogs (blog)-Database Design-1, Accounts (account) DatabaseName: cnblogs (blog) Model: Passport Account module database design Type: professional Technical website Url: 1.a, Database digraph 1. B, Database Design Script

Ylbtech-DatabaseDesgin: ylbtech-cnblogs (blog)-Database Design-1, Accounts (account)

DatabaseName: cnblogs (blog)

Model: Passport account Module Database Design

Type: professional technical website

Url:

1. A. Database digraphs)

1. B. Database Design Script)

1, sql-basic-account. SQL

-- ===================================================== ====== -- DatabaseName: blog garden -- pubdate: 21: 42 2013/5/29 -- author: YuanBo, gangYuanGong -- ======================================== ======= USE master (SELECT nameFROM sys. databases) drop database cnblogs cnblogsGOuse cnblogs -- ylb: 1, user table _ Account settings -- Account (accountId (Region, 1), -- number [PK] loginName, -- logon username [UQ] pwd displayName, -- display name [UQ] email varchar (60), -- email replyy y smallImg varchar (50), largeImg varchar (50 ), blogApp varchar (50), -- Blog address blogSkin varchar (50), -- Blog skin flag) -- ylb: 2, user table _ basic info -- Account_Profile (profileId (, 1 ), -- No. [PK] name varchar (40), -- name see_name varchar (4), -- who can see [repeater] isHome_name bit, -- displayed on the homepage [repeater] N .. another solution is gender varchar (6), -- gender see_gender varchar (4), isHome_gender bit, birthday datetime, -- Date of birth, full storage, see_birthday varchar (4), isHome_birthday, home varchar (100), -- home, full storage, Hong Kong server, see_home varchar (4), isHome_home bit, reside varchar (100), -- current residence see_reside varchar (4 ), isHome_reside bit, marriage varchar (4), -- marriage see_marriage varchar (4), isHome_marriage bit, position varchar (30), -- position see_position varchar (4), isHome_position, company varchar (30), -- unit: see_company varchar (4), isHome_company bit, (4), -- working condition: see_status varchar (4), isHome_status bit, accountId) -- ylb: 3, user table _ personal information -- Account_Intro (introId (, 1), -- number [PK] techArray varchar (40), -- technology of interest, use ", "Separate otherTech varchar (20), -- technology of interest (Others), Hong Kong virtual hosts. Separate see_techArray varchar (4), isHome_techArray bit, wish varchar (20), -- latest target see_wish varchar (4), isHome_wish bit, mow.varchar (20), -- motto see_mow.varchar (4), ishome_mow.bit, intro varchar (400), -- self-introduction see_intro varchar (4), isHome_intro bit, accountId) -- ylb: 4, user table _ contact information -- Account_Contact (contactId (, 1 ), -- No. [PK] gtalk varchar (40), -- Gtalk account see_gtalk varchar (4), -- who can see [repeater] isHome_gtalk bit, -- displayed on the homepage [repeater] N .. another solution is msn varchar (40), -- MSMsee_msn varchar (4), isHome_msn bit, qq varchar (40), -- QQsee_qq varchar (4), isHome_qq bit, phone varchar (20), -- mobile phone number see_phone varchar (4), isHome_phone bit, accountId) -- ylb: 5, blog Application Form -- BlogApply (blogApplyId (), -- no. [PK, ID: reason varchar (400), -- reason realName varchar (40), -- real name position varchar (40), -- position unit varchar (40 ), -- unit techs varchar (100), -- state varchar (3) of the technology you are interested in, -- Application Status 1: Application in progress; 2: application passed; 3: application rejected pubdate accountId) -- ylb: 6, retrieve password -- GetAccountPwd (pwdId (100, 1), -- number [PK, ID] accountId (), -- guid pubdate) -- ylb: 7, email verification -- EmailCheck (100), -- guidemail varchar (100), -- emialpubdate)

1. C. server space and Function Implementation Code (Function Implementation Code)