圖書管理系統用例圖 圖書管理程式（一）

本級程式所用的資料表結構：
# ------------------------------------- -------------------
#
# 資料表的結構'author'
#
CREATE TABLE author (
   author_id int (6) DEFAULT '0' NOT NULL auto_increment,
   first_name varchar(20) binary NOT NULL,
   last_name varchar(20) NOT NULL,
   last_name varchar(20) NOT NULL,
   last_name varchar(20) NOT NULL,
   last_name varchar(20) NOT NULL,
ipcode varchar(10) NOT NULL,
   telephone varchar(10) NOT NULL,
   email varchar(50) NOT NULL,
   comment varchar(25aut5) NN NULL 🎜>   KEY first_name (first_name),
   KEY last_name (last_name),
   KEY address (address),
;
# ------------------------------------------------ --------
#
# 資料表的結構'books'
#
CREATE TABLE books (
   books_id int(6) DEFAULT '0' NOT NULL auto_increment,
   books_name varchar(100) binary NOT NULL,
   publisher_id varchar(6) NOT NULL,
   date_pub datetime DEFAULT '000-000 varchar( 6) NOT NULL,
   pages varchar(4) NOT NULL,
   price float(6,2) DEFAULT '0.00' NOT NULL,
   comment vari555 (25) NOT NULL,
   PRIMARY KEY (books_id),
   KEY name (books_name),
   KEY publisher (publisher_id),
   KEY publisher (publisher_id),
   KEY publisher (publisher_id),
(price) ,
   KEY pages (pages),
   KEY type (type),
   KEY ISBN (ISBN)
);
# -------------- ------------------------------------------
#
#資料表的結構'books_author'
#
CREATE TABLE books_author (
   id int(6) DEFAULT '0' NOT NULL auto_increment,
(6) NOT NULL,
   author_type varchar(6) NOT NULL,
   PRIMARY KEY (id)
);
# ---------------- ----------------------------------------
#
# 資料表的結構'publisher'
#
CREATE TABLE publisher (
   publisher_id int(6) DEFAULT '0' NOT NULL auto_increment, 100) NOT NULL,
   zipcode varchar(10) NOT NULL,
   telephone varchar(10) NOT NULL,
   telefax varchar(10) NOT NULL,
   telefax varchar(10) NOT NULL,
   PRIMARY KEY (publisher_id),
   KEY name (publisher_name),
   KEY address (address),
  
以上就介紹了圖書管理系統用例圖 圖書管理程序（一），包括了圖書管理系統用例圖方面的內容，希望對PHP教程有興趣的朋友有所幫助。