第一頁 返回 繼續 最後一頁 概覽 影像

主鍵與外鍵實例

create table car

(cid character (10) primary key,

model character(10),

price integer

);

create table service

(sid integer primary key,

name character (20),

area character (6),

tel character (16),

addr character (50)

);

create table sale

(mon integer,

sid integer references service(sid),

cid character (10) references car(cid),

num integer

);