数据库/银行取号系统.sql

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

-- 顾客信息表
create table customer_tbl(
   id number primary key,
   nextId number not null unique,
   takeDate date not null,
   type number not null,
   flag number not null
)
comment on table customer_tbl  is  '顾客信息表';
comment on column customer_tbl.id is '唯一标示';
comment on column customer_tbl.nextId is '顾客排号';
comment on column customer_tbl.takeDate is '取票日期';
comment on column customer_tbl.type is '服务类型';
comment on column customer_tbl.flag is '处理标记';

-- 业务端信息表
create table work_tbl(
 id number primary key,
 processDate date not null,
 workId number not null,
 type number not null,
 nextId number unique not null
)
comment on table work_tbl  is  '业务端信息表';
comment on column work_tbl.id is '唯一标示';
comment on column work_tbl.processDate is '处理日期';
comment on column work_tbl.workId is '服务台编号';
comment on column work_tbl.type is '服务类型';
comment on column work_tbl.nextId is '顾客排号';

-- 业务员信息表
create table workmen_tbl(
 id number primary key,
 name varchar2(20) not null,
 password varchar2(20) not null
)
comment on table workmen_tbl  is  '业务员信息表';
comment on column workmen_tbl.id is '唯一标示';
comment on column workmen_tbl.name is '用户名';
comment on column workmen_tbl.password is '密码';
-- 初始数据
insert into workmen_tbl
values(1,'kallen','123');

insert into workmen_tbl
values(2,'scott','123');


-- 自动出号信息
create table srt_tbl(
 nextId number(20) not null,
 type number(7) not null unique
)
comment on table srt_tbl  is  '自动出号信息';
comment on column srt_tbl.nextId is '顾客排号';
comment on column srt_tbl.type is '服务类型';
-- 初始数据
--vip业务
insert into srt_tbl
values(1,1);