createadmin.sql

电信计费项目 该系统在Sun Solaris下开发,运行于Apache Tomcat平台,采用J2EE架构

drop table t_right_wdd;
drop table t_model_wdd;
drop table t_admin_wdd;
create table t_admin_wdd(
    amd_id          number(19) primary key,				-- 管理员编码
    amd_name        varchar2(60),                   -- 管理员姓名
    login_name      varchar2(10) unique not null,	-- 登录名
    login_password  varchar2(32),                   -- 登录密码
    amd_phone       varchar2(32),                   -- 联系电话
    amd_email       varchar2(32),                   -- E-Mail
    enroll_date     date,                           -- 注册日期
    close_date      date                           
);

create table t_model_wdd(
    oid         number(19) primary key, 
    name        varchar2(32) not null unique,
    model_number number(2) not null unique        
);
create table t_right_wdd(
    admin_fid			number(19) references t_admin_wdd(amd_id) on delete cascade,
    m_fid   			number(19) references t_model_wdd(oid) on delete cascade,  
    primary key(admin_fid, m_fid)
);