Scribd
Upload
4 views2 pages

Database for Donation Management

The document contains SQL insert statements for various tables related to a fundraising system, including donor information, support requests, and transaction details. It details the individuals and organizations involved in the fundraising efforts, the items being donated, and the specific fundraising campaigns. Additionally, it includes transaction records showing contributions and the associated amounts for each campaign.

Uploaded by

gugugaga
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
4 views2 pages

Database for Donation Management

The document contains SQL insert statements for various tables related to a fundraising system, including donor information, support requests, and transaction details. It details the individuals and organizations involved in the fundraising efforts, the items being donated, and the specific fundraising campaigns. Additionally, it includes transaction records showing contributions and the associated amounts for each campaign.

Uploaded by

gugugaga
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd

SET DATEFORMAT DMY;

INSERT INTO NGUOIKEUGOI VALUES


('NKG01', 'Nguyen Van An', '012345678901', '0909123456', '[Link]@[Link]',
'Quan 1, [Link]', 'Ca nhan'),
('NKG02', 'Tran Thi Binh', '023456789012', '0912233445', '[Link]@[Link]',
'Quan Ninh Kieu, Can Tho', 'Ca nhan'),
('NKG03', 'Hoi Chu Thap Do', '034567890123', '02838381234', '[Link]@[Link]',
'Quan 3, [Link]', 'To chuc'),
('NKG04', 'Cau lac bo Thien Nguyen', '045678901234', '0933445566',
'thiennguyen@[Link]', 'TP Thu Duc, [Link]', 'CLB');

INSERT INTO NGUOIUNGHO VALUES


('NUH01', 'Le Minh Hoang', '0903344556', '123456789', 'Ca nhan'),
('NUH02', 'Pham Thi Lan', '0914455667', '234567891', 'Ca nhan'),
('NUH03', 'Cong ty ABC', '0283999888', '345678912', 'To chuc'),
('NUH04', 'Nguyen Quoc Khanh', '0935566778', '456789123', 'Ca nhan'),
('NUH05', 'Nhom Thien Tam', '0986677889', '567891234', 'To chuc');

INSERT INTO VATPHAM VALUES


('VP01', 'Tien mat', 'VND', 1),
('VP02', 'Mi tom', 'Thung', 250000),
('VP03', 'Nuoc suoi', 'Thung', 140000),
('VP04', 'Gao', 'Kg', 30000),
('VP05', 'Thuoc men', 'Bo', 1050000);

INSERT INTO DOTKEUGOI VALUES


('DUH01', 'NKG01', 'Keu goi mien Trung', '1709821', '29/09/2024', '20/11/2024',
2000000000, 'Ket thuc'),
('DUH02', 'NKG02', 'Ho tro tre em ngheo', '2739172', '15/11/2024', '15/12/2024',
2500000000, 'Ket thuc'),
('DUH03', 'NKG03', 'Cuu tro lu lut', '1723691', '20/03/2025', '05/04/2025',
1500000000, 'Ket thuc'),
('DUH04', 'NKG02', 'He yeu thuong', '2178399', '10/04/2025', '10/07/2025',
1500000000, 'Dang keu goi'),
('DUH05', 'NKG04', 'Cac em den truong', '3718291', '15/05/2025', '05/07/2025',
2100000000, 'Dang keu goi');

INSERT INTO GDUNGHO


(MaGD, MaDot, MaNUH, NgayUngHo, HinhThuc, TongTien, NoiDung, TrangThaiGD)
VALUES
('GD01', 'DUH01', 'NUH01', '05/06/2024', 'Chuyen khoan', 155000000, 'Ung ho bang
chuyen khoan', 'Da xac nhan'),
('GD02', 'DUH01', 'NUH02', '10/06/2024', 'Tien mat', 15000000, 'Ung ho tien mat',
'Da xac nhan'),
('GD03', 'DUH02', 'NUH03', '13/06/2024', 'Chuyen khoan', 25000000, 'Ung ho bang
chuyen khoan', 'Da xac nhan'),
('GD04', 'DUH02', 'NUH03', '14/06/2024', 'Chuyen khoan', 112500000, 'Ung ho tien
va vat pham', 'Da xac nhan'),
('GD05', 'DUH03', 'NUH04', '21/06/2024', 'Chuyen khoan', 300000000, 'Ung ho bang
chuyen khoan', 'Da xac nhan'),
('GD06', 'DUH03', 'NUH03', '23/06/2024', 'Tien mat', 39500000, 'Ung ho tien mat va
vat pham', 'Da xac nhan'),
('GD07', 'DUH01', 'NUH02', '24/06/2024', 'Tien mat', 17000000, 'Ung ho tien mat bo
sung', 'Da xac nhan'),
('GD08', 'DUH01', 'NUH04', '25/06/2024', 'Chuyen khoan', 2000000, 'Ung ho bang
chuyen khoan', 'Da xac nhan'),
('GD09', 'DUH02', 'NUH04', '25/06/2024', 'Chuyen khoan', 300000000, 'Ung ho bang
chuyen khoan', 'Da xac nhan'),
('GD010', 'DUH04', 'NUH03', '15/04/2025', 'Tien mat', 28000000, 'Ung ho tien mat',
'Da xac nhan'),
('GD011', 'DUH05', 'NUH04', '20/05/2025', 'Tien mat', 1000000, 'Ung ho tien mat',
'Da xac nhan'),
('GD012', 'DUH04', 'NUH04', '25/05/2025', 'Chuyen khoan', 2000000, 'Ung ho bang
chuyen khoan', 'Da xac nhan'),
('GD013', 'DUH05', 'NUH05', '26/05/2025', 'Chuyen khoan', 40500000, 'Ung ho tien va
vat pham', 'Chua xac nhan');

INSERT INTO CT_GDUNGHO (MaGD, MaVP, SoLuong, ThanhTien)


VALUES
('GD01', 'VP01', 100000000, 100000000),
('GD07', 'VP01', 10000000, 10000000),
('GD010', 'VP01', 3000000, 3000000),
('GD011', 'VP01', 1000000, 1000000),
('GD02', 'VP01', 1000000, 1000000),
('GD04', 'VP01', 1000000, 1000000),
('GD06', 'VP01', 2000000, 2000000),
('GD05', 'VP01', 300000000, 300000000),
('GD08', 'VP01', 2000000, 2000000),
('GD09', 'VP01', 300000000, 300000000),
('GD012', 'VP01', 2000000, 2000000);
INSERT INTO CT_GDUNGHO (MaGD, MaVP, SoLuong, ThanhTien)
VALUES
('GD01', 'VP02', 100, 25000000),
('GD03', 'VP02', 100, 25000000),
('GD06', 'VP02', 150, 37500000),
('GD010', 'VP02', 100, 25000000),
('GD04', 'VP02', 150, 37500000);
INSERT INTO CT_GDUNGHO (MaGD, MaVP, SoLuong, ThanhTien)
VALUES
('GD02', 'VP03', 100, 14000000),
('GD04', 'VP03', 100, 14000000),
('GD07', 'VP03', 50, 7000000);
INSERT INTO CT_GDUNGHO (MaGD, MaVP, SoLuong, ThanhTien)
VALUES
('GD01', 'VP04', 1000, 30000000),
('GD04', 'VP04', 2000, 60000000),
('GD013', 'VP04', 1000, 30000000);
INSERT INTO CT_GDUNGHO (MaGD, MaVP, SoLuong, ThanhTien)
VALUES
('GD013', 'VP05', 10, 10500000);

You might also like