chapter1_ibmdb2_db_creation.txt

sql的原代码可以供学习sql的人提供好的学习材料

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 
);