hotelsystem.sql

来自「旅馆预订系统.采用jstl+oracle,jsp/servlet,,供初学者学习」· SQL 代码 · 共 69 行

-- 旅馆表
create table HOTEL
(
  ID           NUMBER,
  HOTELNAME    VARCHAR2(50) not null,
  CITY         VARCHAR2(50) not null,
  RCOUNT       NUMBER not null,
  RPRICE       NUMBER not null,
  RCANUSECOUNT NUMBER not null,
  DCOUNT       NUMBER not null,
  DPRICE       NUMBER not null,
  DCANUSECOUNT NUMBER not null
)
tablespace USERS
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64
    minextents 1
    maxextents unlimited
  );
  
  
-- 渡假村表
create table RESORT
(
  ID           NUMBER,
  RESORTNAME   VARCHAR2(50) not null,
  CITY         VARCHAR2(50) not null,
  CCOUNT       NUMBER not null,
  CPRICE       NUMBER not null,
  CCANUSECOUNT NUMBER not null
)
tablespace USERS
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64
    minextents 1
    maxextents unlimited
  );
  
 -- 订单表
create table ORDERS
(
  ORDERID    NUMBER,
  HOUSESTYLE VARCHAR2(20),
  ID         NUMBER,
  ROOMSTYLE  VARCHAR2(20),
  PRICE      NUMBER,
  NUM        NUMBER,
  DATETIME   VARCHAR2(30),
  STATE      NUMBER,
  CUSTOMID   NUMBER
)
tablespace USERS
  pctfree 10
  initrans 1
  maxtrans 255
  storage
  (
    initial 64
    minextents 1
    maxextents unlimited
  );