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

msisdn char(32),
serviceidInt ,
userstateInt ,
userlevelInt ,
balanceInt ,
totalconsumeInt ,
startdatechar(8),
stopdatechar(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(
serviceidInt ,
servicenamechar(32) ,
discountInt ,
daycostInt ,
cancelpercentInt ,
consumelimitInt ,
primary key (serviceid));