/* Table: Product */ 這裏改成BUS
/*==============================================================*/
create table Product
(
ID int not null, --變量名稱 變量類型
TYPE_ID int,
Product_Name varchar(200),
Description varchar(500),
Color varchar(20),
Price decimal(12,2),
PublishOn timestamp,
Remark varchar(100),
primary key (ID) -----主鍵信息
);
id
bus
station_name
buslines
tation_per_line
類別上面示例即可