My favorites | Sign in
Project Home Wiki Issues Source
READ-ONLY: This project has been archived. For more information see this post.
Search
for
  Advanced search   Search tips   Subscriptions

Issue 4 attachment: CSDLNHOM4.sql (4.1 KB)

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
Create DATABASE If not exists CSDLNHOM4;

use CSDLNHOM4;

Create TABLE Loainhanvien
(
Maloainhanvien char(10) NOT NULL,
Tenloainhanvien varchar(20) NOT NULL,
Primary key(Maloainhanvien)
)ENGINE=InnoDB
CHARACTER SET 'utf8'
COLLATE 'utf8_general_ci';

Create TABLE NHANVIEN
(
MANHANVIEN CHAR(10) NOT NULL,
TENNHANVIEN VARCHAR(50) NOT NULL,
NGAYSINH DATETIME NOT NULL,
DIACHI VARCHAR(50) NOT NULL,
SODIENTHOAI CHAR(15) NOT NULL,
MALOAINHANVIEN CHAR(10) NOT NULL,
PRIMARY KEY(MANHANVIEN),
FOREIGN KEY(MALOAINHANVIEN) REFERENCES LOAINHANVIEN(MALOAINHANVIEN)
)ENGINE=InnoDB
CHARACTER SET 'utf8'
COLLATE 'utf8_general_ci';

CREATE TABLE THANHVIEN
(
MATHANHVIEN INT NOT NULL,
HOTEN VARCHAR(50) NOT NULL,
DIACHI VARCHAR(50) NOT NULL,
TENTRUYCAP VARCHAR(50) NOT NULL,
MATKHAU VARCHAR(50) NOT NULL,
EMAIL VARCHAR(50) NOT NULL,
PRIMARY KEY(MATHANHVIEN)
)ENGINE=InnoDB
CHARACTER SET 'utf8'
COLLATE 'utf8_general_ci';

CREATE TABLE KHACHHANG
(
MAKHACHHANG CHAR(10) NOT NULL,
TENKHACHHANG VARCHAR(20) NOT NULL,
DIACHI VARCHAR(50) NOT NULL,
SODIENTHOAI CHAR(15) NOT NULL,
PRIMARY KEY(MAKHACHHANG)
)ENGINE=InnoDB
CHARACTER SET 'utf8'
COLLATE 'utf8_general_ci';



CREATE TABLE DONHANG
(
MADONHANG CHAR(10) NOT NULL,
NGAYMUA DATETIME NOT NULL,
MAKHACHHANG CHAR(10) NOT NULL,
TONGTIEN DECIMAL(10,0) NOT NULL,
DIACHIGIAOHANG VARCHAR(50) NOT NULL,
HINHTHUCTHANHTOAN TEXT NOT NULL,
GHICHU TEXT,
PRIMARY KEY(MADONHANG),
FOREIGN KEY(MAKHACHHANG) REFERENCES KHACHHANG(MAKHACHHANG)
)ENGINE=InnoDB
CHARACTER SET 'utf8'
COLLATE 'utf8_general_ci';

CREATE TABLE HOADONCHITIET
(
MAHOADON CHAR(10) NOT NULL,
MADONHANG CHAR(10) NOT NULL,
SOLUONG INT NOT NULL,
PRIMARY KEY(MAHOADON),
FOREIGN KEY(MADONHANG) REFERENCES DONHANG(MADONHANG)
)ENGINE=InnoDB
CHARACTER SET 'utf8'
COLLATE 'utf8_general_ci';

CREATE TABLE TINHTRANGHANG
(
MATINHTRANG CHAR(10) NOT NULL,
TENTINHTRANG TEXT NOT NULL,
PRIMARY KEY(MATINHTRANG)
)ENGINE=InnoDB
CHARACTER SET 'utf8'
COLLATE 'utf8_general_ci';

---thiếu bảng phiếu xuất, chi tiết xuất, phiếu nhập, chi tiết nhập, và tồn kho

CREATE TABLE DAILI ---bảng đại lý này dùng ở đâu? để làm gì??
(
MADAILI CHAR(10) NOT NULL,
TENDAILI VARCHAR(20) NOT NULL,
DIACHI VARCHAR(50) NOT NULL,
PRIMARY KEY(MADAILI)
)ENGINE=InnoDB
CHARACTER SET 'utf8'
COLLATE 'utf8_general_ci';

CREATE TABLE CAUHOITHACMAC
(
MACAUHOI CHAR(10) NOT NULL,
NOIDUNG TEXT NOT NULL,
MATHANHVIEN INT NOT NULL,
CAUTRALOI TEXT,
PRIMARY KEY(MACAUHOI),
FOREIGN KEY(MATHANHVIEN) REFERENCES THANHVIEN(MATHANHVIEN)
)ENGINE=InnoDB
CHARACTER SET 'utf8'
COLLATE 'utf8_general_ci';

CREATE TABLE BINHLUAN
(
MABINHLUAN CHAR(10) NOT NULL,
NOIDUNG TEXT NOT NULL,
MATHANHVIEN INT NOT NULL,
PRIMARY KEY(MABINHLUAN),
FOREIGN KEY(MATHANHVIEN) REFERENCES THANHVIEN(MATHANHVIEN)
)ENGINE=InnoDB
CHARACTER SET 'utf8'
COLLATE 'utf8_general_ci';

CREATE TABLE KHUYENMAI
(MAKHUYENMAI CHAR(10) NOT NULL,
NGAYBATDAU DATETIME NOT NULL,
NGAYKETTHUC DATETIME NOT NULL,
PHANTRAMGIABAN INT NOT NULL,
PRIMARY KEY(MAKHUYENMAI)
)ENGINE=InnoDB
CHARACTER SET 'utf8'
COLLATE 'utf8_general_ci';

--- thiếu bảng sàn phẩm khuyến mại
create table SanPhamKhuyenMai
{
MaSP char()/...
MaKhuyenMai char()...
primary key(MaSP, MaKhuyenMai).......
}
CREATE TABLE TINTUC
(MATINTUC INT NOT NULL,
TENTINTUC TINYTEXT NOT NULL,
NOIDUNG Longblob NOT NULL,
ANH TEXT NOT NULL,
TACGIA VARCHAR(30),
NGAYDANG DATETIME,
PRIMARY KEY(MATINTUC)
)ENGINE=InnoDB
CHARACTER SET 'utf8'
COLLATE 'utf8_general_ci';

CREATE TABLE SANPHAM
(
MASANPHAM CHAR(10) NOT NULL,
MOTA LONGBLOB NOT NULL,
SOPHIEUBAUCHON INT NOT NULL,
GIABAN FLOAT NOT NULL,
LOAIHANG CHAR(10) NOT NULL, --- có trường loại hàng thì phải có bảng loại hàng nhỉ??
MATINHTRANG CHAR(10) NOT NULL,
SOLUONGCON INT
MAKHUYENMAI CHAR(10) NOT NULL,
PRIMARY KEY(MASANPHAM),
FOREIGN KEY(MATINHTRANG) REFERENCES TINHTRANGHANG(MATINHTRANG),
FOREIGN KEY(MAKHUYENMAI) REFERENCES KHUYENMAI(MAKHUYENMAI)
)ENGINE=InnoDB
CHARACTER SET 'utf8'
COLLATE 'utf8_general_ci';
Powered by Google Project Hosting