在线电影售票系统设计文档

1、在线电影购票系统设计文档第X组XX数据库设计旨在让用户方便的在某个电影院在“在线电影购票系统“是面向用户的一款系统,线购票，特此本系统的数据库设计如下：用户(Customer)、座位(Seat)、电影(Movie)、订单(Ordered)1.“在线电影购票系统”的ER图和实体:2.”在线电影购票系统”的表:序号宁氏有称君能古力三缺有默认值训叨备注1CustomerCflowlineintNOTNULL流水线Cidchar(11)NOTNULL用户账三，用手机三表小红色为王键，蓝色为固7E长度Ckeyvarchar(10)NOTNULL用户密码Cnamevarchar(20)NOTNULL用户昵

2、称Csexvarchar(10)性别Cageint年龄2CstatuscharNOTNULL0删除标志，1为已删除Cwill1varchar(100)binary备用1Cwill2varchar(100)binary备用2SeatSflowlineintNOTNULL流水线Sidchar(3)NOTNULL座位编号编号局位为A-F,低位为物位数形式Midchar(6)NOTNULL电影编号一部电影只放映一场，只侣一种座位状态Sflagchar(1)NOTNULL0座位是否已选择的状态1表示已选择will1varchar(100)binary备用1will2varchar(100)binary备

3、用23MovieCflowlineintNOTNULL流水线Midchar(6)NOINULL电影编号Mnamevarchar(30)NOTNULL电影名称MoutdatedatetimeNOTNULL上映日期MoffdatedatetimeNOTNULL下架日期MpictureNOTNULL海报Mbriefvarchar(500)NOTNULL简介MshowtimedatetimeNOTNULL放映时间4MpricefloatNOTNULL价格MstatuscharNOTNULL0删除标志，1为已删除Mwill1varchar(100)binary备用1Mwill2varchar(100)b

4、inary备用2OrderedOflowlineintNOTNULL流水线Oidchar(6)NOTNULL订单编号Cidchar(11)NOTNULL用尸账号Midchar(6)NOTNULL电影编号Sidchar(3)NOTNULL座位编号OdatetimestampNOTNULL为单生成日期通过读取系统时间，精确到分钟MshowtimedatetimeNOTNULL电影放映时间OffcharNOTNULL0订单关闭状态为1,则U单关闭OrevokecharNOTNULL0订单撤销（退款）状态为1,则订单已撤销PaidcharNOTNULL0订单支付状态为1,则已付款Owill1varch

5、ar(100)binary备用1Owill2varchar(100)binary备用2主要涉及上述四个表。3.”在线电影购票系统"的数据库实现建立数据库的SQL语句：CREATEDATABASE/*!32312IFNOTEXISTS*/'cin_ticksystem'/*!40100DEFAULTCHARACTERSETutf8*/;USE'cin_ticksystem'建立表和插入数据的SQL语句：/*Tablestructurefortable'customer'*/DROPTABLEIFEXISTS'customer

6、9;CREATETABLE'customer'('Cflowline'int(11)NOTNULLAUTO_INCREMENT,'Cid'char(11)CHARACTERSETutf8NOTNULL,'Ckey'varchar(10)CHARACTERSETutf8NOTNULL,'Cname'varchar(100)CHARACTERSETutf8NOTNULL,'Csex'varchar(100)CHARACTERSETutf8DEFAULTNULL,'Cage'varchar

7、(10)CHARACTERSETutf8DEFAULTNULL,'Cstatus'varchar(10)CHARACTERSETutf8NOTNULLDEFAULT'0','Cwill1'varchar(100)CHARACTERSETutf8DEFAULTNULL,'Cwill2'varchar(100)CHARACTERSETutf8DEFAULTNULL,PRIMARYKEY('Cid'),KEY'Cflowline'('Cflowline')ENGINE=InnoDBAUTO

8、_INCREMENT=12DEFAULTCHARSET=gbk;/*Dataforthetable'customer'*/insertinto'customer'('Cflowline','Cid','Ckey','Cname','Csex','Cage','Cstatus','Cwill1','Cwill2')values(3,'123','123','易礼书','

9、;女','50','0',NULL,NULL),(11,'1234','1234',你好','女','18','0',NULL,NULL),(9,'1777','11',哈哈','男','','0',NULL,NULL),(10,'','123','生气果冻','男','19','0',

10、NULL,NULL),(2,'admin','admin','admin','男','19','0',NULL,NULL);/*Tablestructurefortable'movie'*/DROPTABLEIFEXISTS'movie'CREATETABLE'movie'('Mflowline'int(11)NOTNULLAUTO_INCREMENT,'Mid'char(6)NOTNULLDEFAULT'

11、9;,'Mname'varchar(50)NOTNULLDEFAULT'','Moutdte'char(20)NOTNULL,'Moffdate'char(20)NOTNULL,'Mpicture'char(1)NOTNULLDEFAULT'','Mbrief'varchar(500)NOTNULLDEFAULT'','Mshowtime'char(20)NOTNULL,'Mprice'varchar(10)NOTNULL,'M

12、status'char(10)DEFAULT'0','Cwilll'varchar(100)DEFAULTNULL,'Cwill2'varchar(100)DEFAULTNULL,PRIMARYKEY('Mid'),KEY'Mflowline'('Mflowline')ENGINE=InnoDBAUTO_INCREMENT=10DEFAULTCHARSET=utf8;/*Dataforthetable'movie'*/insertintomovie'('Mfl

13、owline','Mid','Mname','Moutdte','Moffdate','Mpicture','Mbrief,'Mshowtime','Mprice','Mstatus','Cwill1','Cwill2')values(1,'001','','','','','','2016-07-3119:30

14、9;,'30','0',NULL,NULL),(2,'002','2','','','','','2016-07-2813:35','25','0',NULL,NULL),(3,'003','','','','','','2016-07-2517:00','40','0',NUL

15、L,NULL),(4,'004','Superman','','','','','2016-08-0315:20','25','0',NULL,NULL),(9,'005','魔兽',“,”,",",'2016-8-519:30','50','0',NULL,NULL);大鱼海棠忍者神龟时空恋旅人/*Tablestructurefortable'

16、ordered'*/DROPTABLEIFEXISTS'ordered'CREATETABLE'ordered'('Oid'int(6)unsignedzerofillNOTNULLAUTO_INCREMENT,'Cid'char(11)NOTNULL,'Mid'char(6)NOTNULL,'Sid'char(3)NOTNULL,'Odate'timestampNOTNULLDEFAULTCURRENT_TIMESTAMP,'Mshowtime'char(2

17、0)NOTNULL,'Off'char(1)NOTNULLDEFAULT'0','Orevoke'charDEFAULT'0','Paid'char(10)NOTNULLDEFAULT'0','Owill1'varchar(100)DEFAULTNULL,'Owill2'varchar(100)DEFAULTNULL,PRIMARYKEY('Oid')ENGINE=InnoDBAUTO_INCREMENT=33DEFAULTCHARSET=utf8;/

18、*Dataforthetable'ordered'*/insertinto'ordered'('Oid','Cid','Mid','Sid','Odate','Mshowtime','Off','Orevoke','Paid','Owill1','Owill2')values(000023,'123','001','12','2016

19、-07-2116:59:12','2016-07-3119:30','0','0','30',NULL,NULL),(000025,'123','001','13','2016-07-2209:04:57','2016-07-3119:30','0','0','30',NULL,NULL),(000026,'123','001','22','

20、2016-07-2209:10:42','2016-07-3119:30','0','0','30',NULL,NULL),(000027,”,002','12','2016-07-2209:14:42','2016-07-2813:35','0','0','25',NULL,NULL);/*Tablestructurefortable'seat'*/DROPTABLEIFEXISTS'seat&

21、#39;CREATETABLE'seat'('Sfloeline'int(11)NOTNULLAUTO_INCREMENT,'Sid'char(3)NOTNULL,数据库实现截图:数据库:WWTS过器G。且图储数发a视存的触Customer：cric-ime匚二安丘Ca-geCSiaLLlEICWLLL1CW11L23|12312.三艮礼书女50皿卬1112341224女0fUIE11与KOLl)际&185*013907;隹工守0（曲盯阿曲idmn.aJbdffiLFi19网卬tSLLf»>WLL.<加H日2次制霸星

22、，芸曲也鼬|至直更Y0白后制节-TT：402%目Seat:远喝，密街1区宝电I正亘I司|T®EritKiiae3iaMLJ5"lagswim5W11LZ1ii0011fWLLJfNULI；17110021fKULLj雨皿3311OOJ1fKUR网皿212001c瓯口f2（仇工）ia12GO-20fKUH|（KUL工？3412CD31fKUl口(liUZL)3130010际“rwLij1913002QUIHW由3IMsh-zvme2C-16-07-S1.13:302Cl-07-<a1J;35Movie:CU1-1.aflE&IJ电脚;口Spjroxifa陷卬：o津1QOrdered:pI-匚二。Kid.Sl-1)iiHI5*rWZLSE工七DrenroifT-Ft-d1FL111CX1二;.,£2.123-Cl12-21上-dt-311!=:33<630gLL心”!oc:aw115Ml1309:04;9?之汕-m-3上Utm45.!0限afML0134024illMl33加工口,：MM则相34M-01-31LVtlOflW|TOI口rvnijQWQAH3BCJilZtQ7l!W312Rmi-M7Q*：14T4J291C-DT-1V13：