chapter1_ibmdb2_db_creation.txt

来自「SQL Server入门经典源码」· 文本 代码 · 共 44 行

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