create database QLGH; use QLGH; create table khachhang (maKH char(10) primary key, tenCT varchar(10), tenGD varchar(10), diachi varchar(10), email varchar(10), dienthoai int, fax int) create table nhanvien (maNV char(10) primary key, ho varchar(10), ten varchar(10), ngaysinh datetime, ngaylamviec datetime, diachi varchar(10), dienthoai int, luongCB int, phucap int) create table dondathang (soHD char(10) primary key, maKH char(10), maNV char(10), ngaydathang datetime, ngaygiaohang datetime, ngaychuyenhang datetime, noigiaohang varchar(10)) alter table dondathang add constraint fk_khachhang_dondathang foreign key (maKH) references khachhang(maKH) alter table dondathang add constraint fk_nhanvien_dondathang foreign key (maNV) references nhanvien(maNV) create table nhacungcap (maCT char(10) primary key, tenCT varchar(10), tenGD varchar(10), diachi varchar(10), email varchar(10), dienthoai int, fax int) create table loaihang (maLH char(10) primary key, tenloaihang varchar(10)) create table mathang (mahang char(10) primary key, tenhang varchar(10), maCT char(10), maLH char(10), SL int, donvitinh varchar(10), giahang int) alter table mathang add constraint fk_nhacungcap_mathang foreign key (maCT) references nhacungcap(maCT) alter table mathang add constraint fk_loaihang_mathang foreign key (maLH) references loaihang(maLH) create table chitietdathang (soHD char(10), mahang char(10), giaban int, soluong int, mucgiamgia int) alter table chitietdathang add constraint fk_dondathang_chitietdathang foreign key (soHD) references dondathang(soHD) alter table chitietdathang add constraint fk_mathang_chitietdathang foreign key (mahang) references mathang(mahang)
Posted on: Thu, 15 Aug 2013 11:36:00 +0000
Trending Topics
Recently Viewed Topics
© 2015