一点心得

reg_expr = ^1[3|4|5|8][0-9]\d{8}$

msisdn   char(32),
serviceid Int        ,
userstate Int        ,
userlevel Int        ,
balance Int          ,
totalconsume Int    ,
startdate char(8),
stopdate char(8),
primary key(msisdn), foreign key(serviceid) referenecs test_service

(serviceid)

create table test_user_data(
msisdn      char(32),
serviceid       Int        ,
userstate       Int        ,
userlevel       Int        ,
balance Int          ,
totalconsume    Int    ,
startdate       char(8),
stopdate        char(8),
primary key (msisdn) );

create table test_service(
serviceid Int        ,     
servicename char(32)   ,
discount Int           ,
daycost Int             ,
cancelpercent Int         , 
consumelimit Int         ,
primary key (serviceid));