mobile.sql

这是中国移动的一个管理系统

#
drop database mobile;
#
create database mobile;
#
use mobile;

#操作员表;;
create table TOperator(
Operator_ID   varchar(15) primary key,
Operator_Name varchar(20) not null,
Operator_Pwd  varchar(20) not null,
Is_Admin varchar(1) default 'N'); 

create table TMobiles(
mobile_number varchar(11) primary key,
mobile_type char(3) not null,
card_number varchar(13),
is_available char(1));


 create table TCharge(
 Charge_Code char(1) primary key,
 Charge_Name varchar(10) not null,
 Charge double(6,2) );

 create table TCharge_Rule(
 Func_ID char(1) not null,
 Charge_Code varchar(1) references TCharge(Charge_Code),
 Func_Name varchar(10) not null,
 primary key(Func_ID,Charge_Code));

#D 身份证
#A 军
#P 护照
create table TCustomer(
Customer_ID int(8) auto_increment primary key,
ID_Type char(1) not null,
ID_Number varchar(20) not null,
Customer_Name varchar(20) not null,
Customer_Birthday date,
Customer_Sex char(2) default '男',
Customer_Address varchar(50)
); 







insert into TOperator values('1001','管理员','admin','Y');
insert into TOperator values('1002','tom','tom','N');

insert into TMobiles values('1390000001','SIM','234fdasd234','N');

 insert into TCharge values('A','开户费',10.00);
 insert into TCharge values('B','漫游费',5.00);
 insert into TCharge values('C','压金',100.00);
 insert into TCharge values('D','入网费',50.00);
 insert into TCharge values('E','选号费',10.00);

 insert into tcustomer values(null,'D','100859','jerry',now(),'F','daoyuan');

commit;