Ylbtech-Model-Account (General Account module design)

Ylbtech-DatabaseDesgin: ylbtech-Model-Account (General Account module design) 1.a, database relationship diagram (databasedi#) 1. B, Database Design script (DatabaseDesignScript) ---- user

Ylbtech-DatabaseDesgin: ylbtech-Model-Account (General Account module design) 1.a, Database relationship Diagram (Database digoal) 1. B, Database Design Script) -- ===================================================== ====== -- User

Ylbtech-DatabaseDesgin: ylbtech-Model-Account (General Account module design)

Ylbtech-Model-Account (General Account module design)

1. A. Database digraphs)

1. B. Database Design Script)

-- ===================================================== ========-- User Module Design -- 2013-8-24 -- author: yuanbo -- =============================================== ======= USE master (SELECT nameFROM sys. databases) drop database ylbtech_account ylbtech_accountGOUSE ylbtech_account -- ylb: 1. The account table [master table] -- desc -- 1. Only accounts with successful email verification can use -- 2.0, register [fill in information] --- system [Send verification information email to registration mailbox] -- 2.1, Hong Kong server, --- User Logon email [click Verify connection] --- email verification succeeded [enable account] -- account (account_id (, 1), -- number [PK, ID] pwd email, -- verify email email_enabled login_enabled) -- ylb: 1.2-3, account table [affiliated table] -- desc ---- ylb: 2, permission project table [role table] -- desc -- account_role_project (project_id, -- No. [PK] project_name project_desc varchar (200), -- project description project_enabled) -- ylb: 2, user and permission project table [role table] -- desc -- account_role (role_id, project_id account_role_project (project_id), -- [FK] account_id role_enabled) -- ylb: 7, mailbox verification [Mailbox verification | password retrieval] -- account_emailcheck (, -- guidemail (pubdate account_id) -- ylb: 1, -- desc -- =============================================== ==========

View Code

1. C. U.S. server, Function Implementation Code (Function Implementation Code)

Author: ylbtech
Source:
The copyright of this article is shared by the author and the blog Park, Hong Kong server. You are welcome to reprint it. However, you must keep this statement without the author's consent and provide a connection to the original article on the article page, otherwise, you are entitled to pursue legal liability.