quản lý đặt tour
Tables (11)
AP_DUNG_KHUYEN_MAI
- MaKhuyenMai — VARCHAR2(50)
- MaTour — VARCHAR2(20)
CHI_TIET_DAT_TOUR
- MaHoaDon — VARCHAR2(20)
- MaTour — VARCHAR2(20)
- NgayDat — DATE
- SoLuongNguoiLon — NUMBER
- SoLuongTreEm — NUMBER
- ThanhTienTour — NUMBER(12,2)
CHI_TIET_DICH_VU
- MaHoaDon — VARCHAR2(20)
- MaDichVu — VARCHAR2(20)
- SoLuong — NUMBER
- ThanhTienDichVu — NUMBER(12,2)
DANH_GIA
- MaDanhGia — VARCHAR2(20)
- ThoiGianDanhGia — DATE
- DiemDanhGia — NUMBER(2,1)
- MaKhachHang — VARCHAR2(20)
- MaTour — VARCHAR2(20)
DICH_VU
- MaDichVu — VARCHAR2(20)
- TenDichVu — VARCHAR2(200)
- DonGia — NUMBER(12,2)
HOA_DON
- MaHoaDon — VARCHAR2(20)
- MaKhachHang — VARCHAR2(20)
- ThanhTien — NUMBER(12,2)
- MaKhuyenMai — VARCHAR2(50)
- TongTien — NUMBER(12,2)
- NgayThanhToan — DATE
KHACH_HANG
- MaKhachHang — VARCHAR2(20)
- HoTen — VARCHAR2(200) — NOT NULL
- Email — VARCHAR2(200)
- SoDienThoai — VARCHAR2(20)
- DiaChi — VARCHAR2(300)
KHUYEN_MAI
- MaKhuyenMai — VARCHAR2(50)
- PhanTramKhuyenMai — NUMBER(5,2)
- SoLuong — NUMBER
- NgayBatDau — DATE
- NgayKetThuc — DATE
LOAI_TOUR
- MaLoaiTour — VARCHAR2(20)
- TenLoaiTour — VARCHAR2(200) — NOT NULL
NHAN_VIEN
- MaNhanVien — VARCHAR2(20)
- HoTenNV — VARCHAR2(200) — NOT NULL
- ChucVu — VARCHAR2(100)
- SoDienThoai — VARCHAR2(20)
- Email — VARCHAR2(200)
- NgayVaoLam — DATE
TOUR
- MaTour — VARCHAR2(20)
- TenTour — VARCHAR2(200) — NOT NULL
- MoTa — VARCHAR2(1000)
- DiemDen — VARCHAR2(200)
- GiaNguoiLon — NUMBER(12,2)
- GiaTreEm — NUMBER(12,2)
- NgayBatDau — DATE
- NgayKetThuc — DATE
- SoLuong — NUMBER
- MaNVQuanLy — VARCHAR2(20)
- MaLoaiTour — VARCHAR2(20)