Preface
I've got a db design job about meeting room booking system last week.There're many suitable tools which can be used to handle this kind of job such as power designer,ERwin,HeidiSQL,dbschema,etc.Today,I'm gonna demonstrate the last one —— dbschema.This is the official website:
https://www.dbschema.com
Introduce
dbschema is a rather simply used tool even you're a novice in designing db system.The dbschema which is downloaded on official website only free for 15 days,then you have to pay for license for later useage but there's no limit in function at all.It provide two modes in designing layout of your system.One is offline mode and the other one is connecting to db servers.You can easily synchronize tables of database with your designed tables as soon as possible by refreshing them from time to time.It also supports almost all popular rdbms such as oracle,db2,MySQL,postgreSQL.There're many key features which you can found in the homepage of official website.I'm not going to describe each one of them.
Procedure
The meeting room booking system(I'll call it "mrbs" .) I contains four tables:employee,department,conference_room,room_reservation.The detail of tables shows below.
employee table
1 id 自增id int(11) 2 user_id 工号 int(11) 3 user_name 用户名称 varchar(20) 4 user_phone 用户手机号 bigint 5 user_email 用户邮箱 varchar(50) 6 user_dept_id 用户所在部门id int(11) 7 user_status 在职、离职等 tinyint(4) 8 create_time 用户创建时间 datetime 9 update_time 用户信息修改时间 datetime
department table
1 id 自增id int(11) 2 dept_id 部门id int(11) 3 dept_name 部门名称 varchar(30) 4 parent_id 父级id tinyint(4) 5 tlevel 层级id tinyint(4) 6 create_time 部门创建时间 datetime 7 update_time 部门信息修改时间 datetime
conference_room table
<