西南交通大学数据库原理与设计实验文件

--Manager insert into Manager values ('000001','000001','林羽','女','13519865535'), ('000002','000001','孙芝','女','13603932082'), ('000003','000001','谢然','男','13803939928'), ('000004','000002','李玲','女','18303936821'), ('000005','000002','王龙','男','13403937562') --Supply insert into Supply values ('100001','美u'), ('100002','哈m'), ('100003','清j') --Firm insert into Firm values ('000001','木叶','北京','110','100001'), ('000002','晓','上海','119','100002'), ('000003','美团','深圳','120','100003') --Worker insert into Worker values ('100000','朱群','男','11059778212','000001'), ('100001','王小川','男','11076543233','000001'), ('100002','秦悦','女','11967885731','000002'), ('100003','陈小飞','男','11055897651','000001'), ('100004','胡小丽','女','11067334622','000001'), ('100005','张维','女','11954673392','000002'), ('100006','李勇','男','12087416711','000003'), ('100007','罗勇','女','12087914751','000003'), ('100008','陈悦','女','11987914751','000002'), ('100009','罗小飞','女','12087914751','000003'), ('100010','王悦','女','11087914751','000001'), ('100011','朱悦','女','11087914751','000001') --Manager insert into Manager values ('100001','100000','林琳霖','男','11076543233'), ('100002','100005','蒋健健','女','11967885731'), ('100003','100010','王悟空','男','11055897651'), ('100004','100000','唐森森','女','11067334622'), ('100005','100005','赵照兆','女','11954673392'), ('100006','100010','廖亦凡','男','11087416711'), ('100007','100005','陈晨辰','女','11987914751'), ('100008','100000','唐辰','女','11087914751'), ('100009','100007','照兆','女','12087914751'), ('100010','100010','朱程','女','11087914751'), ('100011','100007','唐亦凡','女','12087914751'), ('100012','100004','林凡','男','11059778212'), ('100013','100005','唐森','男','11976543233'), ('100014','100007','明哲','女','12067334624'), ('100015','100004','耀杰','女','11054673392'), ('100016','100011','瑞霖','男','11087416711'), ('100017','100004','子涵','女','11087914751'), ('100018','100002','智辉','女','11987914751'), ('100019','100011','烨磊','男','11087914751'), ('100020','100003','致远','女','11087914751'), ('100021','100008','李子涵','女','11987914751'), ('100022','100009','健雄','女','12067885731'), ('100023','100011','修洁','男','11055897651'), ('100024','100003','远航','女','11067334622'), ('100025','100008','黎昕','女','11954673392'), ('100026','100009','伟祺','男','12087416711') --验证外键约束 insert into Manager values ('100027','100011','伟祺','男','12087416711') --Leaseinfo insert into Leaseinfo values ('100001','2022-02-12 03:18:04','2022-03-12 03:18:04','uni001'), ('100002','2022-02-12 03:18:04','2022-04-15 03:18:04','uni001'), ('100003','2022-01-12 03:18:04','2022-05-12 03:18:04','uni002'), ('100004','2022-01-12 03:18:04','2022-05-12 03:18:04','uni001'), ('100005','2022-02-12 03:18:04','2022-05-12 03:18:04','uni003'), ('100006','2022-02-14 03:18:04','2022-05-12 03:18:04','uni002'), ('100007','2021-03-12 03:18:04','2021-08-15 03:18:04','uni002'), ('100008','2022-04-16 03:18:04','2022-07-10 03:18:04','uni003'), ('100009','2022-01-12 03:18:04','2022-07-11 03:18:04','uni001'), ('100010','2022-01-22 03:18:04','2022-05-12 03:18:04','uni001') --Bike insert into Bike values ('100001','uni001',800,2.0,'2020-09-12 03:18:04','100001','100001','000001','100001'), ('100002','uni001',800,2.0,'2021-05-26 02:19:04','100005','100002','000002','100002'), ('100003','uni002',1500,3.0,'2020-09-12 03:18:04','100008','100003','000001','100001'), ('100004','uni001',800,2.0,'2021-08-12 08:18:00','100006','100004','000003','100003'), ('100005','uni003',2000,4.0,'2020-09-12 03:18:04','100004','100005','000001','100001'), ('100006','uni002',1500,3.0,'2021-08-12 08:18:00','100006','100006','000003','100003'), ('100007','uni002',1500,3.0,'2020-09-12 03:18:04','100012','100007','000001','100001'), ('100008','uni003',2000,4.0,'2021-05-26 02:19:04','100013','100008','000002','100002'), ('100009','uni001',800,2.0,'2021-08-12 08:18:00','100021','100009','000003','100003'), ('100010','uni001',800,2.0,'2021-08-12 08:18:00','100016','100010','000003','100003') --一个单车公司可以向一个公司提供多钟类型的自行车 --MLFS 000001 uni001 800 2 2022-05-11 03:33:15 100001 100001 000002 100002 --Customer insert into Customer values ('100001','100001','100002','林取','男','1116543233',200), ('100002','100002','100002','蒋啊','女','11167885731',200), ('100003','100003','100007','王老三','男','1115897651',200), ('100004','100004','100004','唐森二','女','11167334622',200), ('100005','100005','100008','赵照','女','11154673392',200), ('100006','100006','100006','廖左','男','11187416711',200), ('100007','100007','100007','陈辰','女','11187914751',200), ('100008','100008','100005','余辰','女','1117914751',200)