领域建模与数据库建模

1. 领域建模

2. 数据库建模

a. ER模型

b. SQL脚本

-- +---------------------------------------------------------
-- | MODEL       : Reserver
-- | AUTHOR      : liangtj
-- | GENERATED BY: Open System Architect
-- +---------------------------------------------------------
-- | WARNING     : Review before execution
-- +---------------------------------------------------------

-- +---------------------------------------------------------
-- | CREATE
-- +---------------------------------------------------------
CREATE TABLE `reservation`
(
  id BIGINT NOT NULL,
  cityName VARCHAR(255),
  cityName VARCHAR(255),
  checkInDate DATE,
  checkOutDate DATE,
  roomType BIGINT NOT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `hotel`
(
  id BIGINT NOT NULL,
  name VARCHAR(255) NOT NULL,
  address VARCHAR(255) NOT NULL,
  level BIGINT NOT NULL,
  averagePrice BIGINT NOT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `room`
(
  id BIGINT NOT NULL,
  type VARCHAR(255) NOT NULL,
  price BIGINT NOT NULL,
  PRIMARY KEY (id)
);

CREATE TABLE `customer`
(
  id BIGINT NOT NULL,
  userName VARCHAR(255) NOT NULL,
  telephone CHAR(11) NOT NULL,
  PRIMARY KEY (id)
) COMMENT="customer info";

CREATE TABLE `payment`
(
  type VARCHAR(20) NOT NULL,
  value BIGINT NOT NULL,
  securityCode BIGINT NOT NULL
);

c. 数据逻辑模型与领域模型的异同

领域模型从总体上更能反映出各个实体之间的关系，但是不能很好反映出实体内部的数据结构和约束，而数据库逻辑模型则反了过来，能细致地描述表内部的数据结构和逻辑约束，但是不能直观看出表之间的逻辑关系