1、在線電影購票系統設計文檔第 X 組 XX一、 數據庫設計“在線電影購票系統“是面向用戶的一款系統， 旨在讓用戶方便的在某個電影院在線購票，特此本系統的數據庫設計如下：1. .“在線電影購票系統”的ER圖和實體：ER圖：實體：用戶 (Customer) 、座位 (Seat) 、電影 (Movie) 、訂單 (Ordered)2. ”在線電影購票系統”的表：序號寧氏有稱君能古力三缺有默認值訓叨施注1CustomerCflowlineintNOT NULL流水線Cidchar(11)NOT NULL用戶賬三，用手機三表小紅色為王鍵，藍色為固7E長度Ckeyvarchar(10)NOT NULL用戶密

2、碼Cnamevarchar(20)NOT NULL用戶昵稱Csexvarchar(10)性別Cageint年齡2CstatuscharNOT NULL0刪除標志，1為已刪除Cwill1varchar(100)binary備用1Cwill2varchar(100)binary備用2SeatSflowlineintNOT NULL流水線Sidchar(3)NOT NULL座位編號編號局位為A-F,低位為物位數形式Midchar(6)NOT NULL電影編號一部電影只放映一場，只有一種座位狀態Sflagchar(1)NOT NULL0座位是否已選擇的狀態1表示已選擇will1varchar(100)

3、binary備用1will2varchar(100)binary備用23MovieCflowlineintNOT NULL流水線Midchar(6)NOI NULL電影編號Mnamevarchar(30)NOT NULL電影名稱MoutdatedatetimeNOT NULL上映日期MoffdatedatetimeNOT NULL下架日期MpictureNOT NULL海報Mbriefvarchar(500)NOT NULL簡介MshowtimedatetimeNOT NULL放映時間4MpricefloatNOT NULL價格MstatuscharNOT NULL0刪除標志，1為已刪除Mwi

4、ll1varchar(100)binary備用1Mwill2varchar(100)binary備用2OrderedOflowlineintNOT NULL流水線Oidchar(6)NOT NULL訂單編號Cidchar(11)NOT NULL用尸賬號Midchar(6)NOT NULL電影編號Sidchar(3)NOT NULL座位編號OdatetimestampNOT NULL為單生成日期通過讀取系統時間，精確到分鐘MshowtimedatetimeNOT NULL電影放映時間OffcharNOT NULL0訂單關閉狀態為1,則U單關閉OrevokecharNOT NULL0訂單撤銷（退款

5、）狀態為1,則訂單已撤銷PaidcharNOT NULL0訂單支付狀態為1,則已付款Owill1varchar(100)binary備用1Owill2varchar(100)binary備用2主要涉及上述四個表。3. ”在線電影購票系統“的數據庫實現 建立數據庫的SQL語句：CREATBDATABASE132312 IF NOTEXISTS*/'cin_ticksystem' /*!40100 DEFAULTCHARACTER SET utf8 */;USE 'cin_ticksystem'建立表和插入數據的SQL語句：/*Table structure for

6、 table 'customer' */DROP TABLE IF EXISTS 'customer'CREATE TABLE 'customer' ('Cflowline' int(11) NOT NULL AUTO_INCREMENT,'Cid' char(11) CHARACTER SET utf8 NOT NULL,'Ckey' varchar(10) CHARACTER SET utf8 NOT NULL,'Cname' varchar(100) CHARACTER SET

7、 utf8 NOT NULL,'Csex' varchar(100) CHARACTER SET utf8 DEFAULT NULL,'Cage' varchar(10) CHARACTER SET utf8 DEFAULT NULL,'Cstatus' varchar(10) CHARACTER SET utf8 NOT NULL DEFAULT '0','Cwill1' varchar(100) CHARACTER SET utf8 DEFAULT NULL,'Cwill2' varchar(1

8、00) CHARACTER SET utf8 DEFAULT NULL,PRIMARY KEY ('Cid'), KEY 'Cflowline' ('Cflowline') ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=gbk;/*Data for the table 'customer' */insert into'customer'('Cflowline','Cid','Ckey','Cname',

9、'Csex','Cage','Cstatus','Cwill1','Cwill2') values (3,'123','123','易禮書 ',' 女','50','0',NULL,NULL),(11,'1234','1234','你好 ',' 女','18','0',NULL,NULL),(9,'1777',

10、'11','哈哈 ',' 男','','0',NULL,NULL),(10,'','123','生氣果凍 ',' 男','19','0',NULL,NULL),(2,'admin','admin','admin','男 ','19','0',NULL,NULL);/*Table structure for table '

11、;movie' */DROP TABLE IF EXISTS 'movie'CREATE TABLE 'movie' ('Mflowline' int(11) NOT NULL AUTO_INCREMENT,'Mid' char(6) NOT NULL DEFAULT ”， 'Mname' varchar(50) NOT NULL DEFAULT , 'Moutdte' char(20) NOT NULL, 'Moffdate' char(20) NOT NULL, '

12、;Mpicture' char(1) NOT NULL DEFAULT '', 'Mbrief' varchar(500) NOT NULL DEFAULT '', 'Mshowtime' char(20) NOT NULL, 'Mprice' varchar(10) NOT NULL, 'Mstatus' char(10) DEFAULT '0', 'Cwill1' varchar(100) DEFAULT NULL, 'Cwill2' va

13、rchar(100) DEFAULT NULL, PRIMARY KEY ('Mid'), KEY 'Mflowline' ('Mflowline') ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;/*Data for the table 'movie' */insert into'movie'('Mflowline','Mid','Mname','Moutdte','Moffdate

14、','Mpicture','Mbrief','Msh owtime','Mprice','Mstatus','Cwill1','Cwill2') values (1,'001','大魚海棠','','','','','2016-07-31 19:30','30','0',NULL,NULL),(2,'002','

15、;忍者神龜2','','','','','2016-07-28 13:35','25','0',NULL,NULL),(3,'003',' 時空戀旅人 ','','','','','2016-07-25 17:00','40','0',NULL,NULL),(4,'004','Superman',

16、9;','','','','2016-08-03 15:20','25','0',NULL,NULL),(9,'005','魔獸 ','','','','','2016-8-519:30','50','0',NULL,NULL);/*Table structure for table 'ordered' */DROP TABLE IF

17、 EXISTS 'ordered'CREATE TABLE 'ordered' ('Oid' int(6) unsigned zerofill NOT NULL AUTO_INCREMENT,'Cid' char(11) NOT NULL,'Mid' char(6) NOT NULL, 'Sid' char(3) NOT NULL, 'Odate' timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, 'Mshowtime' ch

18、ar(20) NOT NULL, 'Off' char(1) NOT NULL DEFAULT '0', 'Orevoke' char(1) DEFAULT '0', 'Paid' char(10) NOT NULL DEFAULT '0', 'Owill1' varchar(100) DEFAULT NULL, 'Owill2' varchar(100) DEFAULT NULL, PRIMARY KEY ('Oid') ENGINE=InnoDB

19、AUTO_INCREMENT=33 DEFAULT CHARSET=utf8;/*Data for the table 'ordered' */insert into'ordered'('Oid','Cid','Mid','Sid','Odate','Mshowtime','Off','Orevoke','Paid','O will1','Owill2') values (000023,&

20、#39;123','001','12','2016-07-21 16: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','2016-07-2209:10:42','2016-07-3119:30','0','0','30',NULL,NULL),(000027,'',&#