📄 chapter1_ibmdb2_db_creation.txt
字号:
CREATE TABLE MemberDetails
(
MemberId integer,
FirstName vargraphic(50),
LastName vargraphic(50),
DateOfBirth date,
Street varchar(100),
City varchar(75),
State varchar(75),
ZipCode varchar(12),
Email varchar(200),
DateOfJoining date
);
CREATE TABLE Attendance
(
MeetingDate date,
Location varchar(200),
MemberAttended char(1),
MemberId integer
);
CREATE TABLE Films
(
FilmId integer,
FilmName varchar(100),
YearReleased integer,
PlotSummary varchar(2000),
AvailableOnDVD char(1),
Rating integer,
CategoryId integer
);
CREATE TABLE Category
(
CategoryId integer,
Category varchar(100)
);
CREATE TABLE FavCategory
(
CategoryId integer,
MemberId integer
);
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -