[ad_1]
create database clothingstore; create table customer( CMobile_no int , Customer_id int, Customer_Address varchar(20), constraint customer_pk primary key (Customer_id), ); create table customer_Name( Fname varchar(20), Minit varchar(20), Lname varchar(20), Customer_id int, constraint customer_name_pk primary key (Customer_id), ); create table Branch( Branch_id int, Branch_Name varchar(20), Branch_Location varchar(20), Branch_Address varchar(20), constraint Branch_pk primary key (Branch_id), ); create table Buysfrom( Cid int Bid int Hrs int CONSTRAINT buys_pk primary key (Cid,Bid) Constraint customer_Buys_pk foreign key (Cid) references customer(Customer_id) constraint Branch_Buys_fk foreign key (Bid)references Branch(Branch_id) );
私が試したこと:
スピーリングという言葉を変えようとした
解決策 1
コンマ区切りの項目:
SQL
create table Buysfrom( Cid int Bid int Hrs int CONSTRAINT buys_pk primary key (Cid,Bid) Constraint customer_Buys_pk foreign key (Cid) references customer(Customer_id) constraint Branch_Buys_fk foreign key (Bid)references Branch(Branch_id) );
最終的なテーブル定義には何もありません。
[ad_2]
コメント