0% found this document useful (0 votes)
4 views7 pages

E-commerce Data Model Overview

Uploaded by

tientoan2626
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
4 views7 pages

E-commerce Data Model Overview

Uploaded by

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

public class LichSuHoaDon

{
[Key]
public int IDLichSuHoaDon { get; set; }
public string TrangThai { get; set; }
public DateTime NgayDatHang { get; set; }
public DateTime? NgayNhanHang { get; set; }
[ForeignKey("HoaDon")]
public int ID_HoaDon { get; set; }

public virtual HoaDon HoaDon { get; set; }


}

public class HoaDon


{
[Key]
public int ID_HoaDon { get; set; }
public int SoLuong { get; set; }
public decimal Gia { get; set; }
public decimal TongTien { get; set; }
public string TrangThai { get; set; }
public DateTime NgayVanChuyen { get; set; }
public DateTime NgayGiaoHangDuKien { get; set; }
public string PhieuVanChuyen { get; set; }
public string GhiChu { get; set; }
[ForeignKey("NguoiDung")]
public int IDNguoiDung { get; set; }
[ForeignKey("PhuongThucThanhToan")]
public int IDPhuongThucThanhToan { get; set; }
[ForeignKey("ThongTinVanChuyen")]
public int IDHTVC { get; set; }
[ForeignKey("PhieuGiamGia")]
public int? IDPhieuGiamGia { get; set; }

public virtual NguoiDung NguoiDung { get; set; }


public virtual ThongTinVanChuyen ThongTinVanChuyen { get; set; }
public virtual PhieuGiamGia PhieuGiamGia { get; set; }
public virtual ICollection<LichSuHoaDon> LichSuHoaDons { get; set; }
public virtual ICollection<HoaDonChiTiet> HoaDonChiTiets { get; set; }
}

public class PhieuGiamGia


{
[Key]
public int IDPhieuGiamGia { get; set; }
public string TenPhieuGiamGia { get; set; }
public decimal MucGiamGia { get; set; }
public string DieuKien { get; set; }
public DateTime NgayBatDau { get; set; }
public DateTime NgayKetThuc { get; set; }
public int SoLuong { get; set; }
[ForeignKey("KieuGiamGia")]
public int IdKieuGiamGia { get; set; }

public virtual KieuGiamGia KieuGiamGia { get; set; }


public virtual ICollection<HoaDon> HoaDons { get; set; }
}

public class KieuGiamGia


{
[Key]
public int IdKieuGiamGia { get; set; }
public string TenKieuGiamGia { get; set; }
public decimal SoTienGiamGia { get; set; }

public virtual ICollection<PhieuGiamGia> PhieuGiamGias { get; set; }


}

public class NguoiDung


{
[Key]
public int IDNguoiDung { get; set; }
public string TenNguoiDung { get; set; }
public string Email { get; set; }
public string MatKhau { get; set; }
public string HoTen { get; set; }
public string SoDienThoai { get; set; }
public string GioiTinh { get; set; }
public DateTime NgaySinh { get; set; }
public string CCCD { get; set; }
public string Avatar { get; set; }
[ForeignKey("VaiTro")]
public int IDVaiTro { get; set; }

public virtual VaiTro VaiTro { get; set; }


public virtual ICollection<HoaDon> HoaDons { get; set; }
}

public class VaiTro


{
[Key]
public int IDVaiTro { get; set; }
public string TenVaiTro { get; set; }

public virtual ICollection<NguoiDung> NguoiDungs { get; set; }


}
public class ThongTinVanChuyen
{
[Key]
public int IDTTC { get; set; }
public string DiaChi { get; set; }
public string TenNguoiNhan { get; set; }
public string SDT { get; set; }
public string TrangThai { get; set; }
public string Tinh { get; set; }
public string Huyen { get; set; }
public string Xa { get; set; }
[ForeignKey("NguoiDung")]
public int IDNguoiDung { get; set; }

public virtual NguoiDung NguoiDung { get; set; }


}

public class SanPham


{
[Key]
public int IdSanPham { get; set; }
public string TenSanPham { get; set; }
public string MoTa { get; set; }
public string TrangThai { get; set; }
[ForeignKey("LoaiSanPham")]
public int IdLoaiSP { get; set; }

public virtual LoaiSanPham LoaiSanPham { get; set; }


public virtual ICollection<SanPhamChiTiet> SanPhamChiTiets { get; set; }
public virtual ICollection<SanPhamKhuyenMai> SanPhamKhuyenMais { get; set; }
}

public class LoaiSanPham


{
[Key]
public int IdLoaiSP { get; set; }
public string TenLoaiSP { get; set; }
public string TrangThai { get; set; }

public virtual ICollection<SanPham> SanPhams { get; set; }


}

public class SanPhamChiTiet


{
[Key]
public int IdSPChiTiet { get; set; }
public decimal Gia { get; set; }
public int SoLuong { get; set; }
public string ThongTinThem { get; set; }
[ForeignKey("SanPham")]
public int IdSanPham { get; set; }
[ForeignKey("Mau")]
public int IdMau { get; set; }
[ForeignKey("Led")]
public int IdLed { get; set; }
[ForeignKey("LoaiSanPham")]
public int IdLoaiSP { get; set; }
[ForeignKey("Hang")]
public int IdHang { get; set; }
[ForeignKey("Keycap")]
public int IdKeycap { get; set; }

public virtual SanPham SanPham { get; set; }


public virtual Mau Mau { get; set; }
public virtual Led Led { get; set; }
public virtual LoaiSanPham LoaiSanPham { get; set; }
public virtual Hang Hang { get; set; }
public virtual Keycap Keycap { get; set; }
}

public class Mau


{
[Key]
public int IdMau { get; set; }
public string TenMau { get; set; }
public string TrangThai { get; set; }

public virtual ICollection<SanPhamChiTiet> SanPhamChiTiets { get; set; }


}

public class Led


{
[Key]
public int IdLed { get; set; }
public string TenLed { get; set; }
public string TrangThai { get; set; }

public virtual ICollection<SanPhamChiTiet> SanPhamChiTiets { get; set; }


}

public class Hang


{
[Key]
public int IdHang { get; set; }
public string TenHang { get; set; }
public string TrangThai { get; set; }

public virtual ICollection<SanPhamChiTiet> SanPhamChiTiets { get; set; }


}

public class Keycap


{
[Key]
public int IdKeycap { get; set; }
public string TenKeycap { get; set; }
public string TrangThai { get; set; }

public virtual ICollection<SanPhamChiTiet> SanPhamChiTiets { get; set; }


}

public class KhuyenMai


{
[Key]
public int IDKhuyenMai { get; set; }
public string TenKhuyenMai { get; set; }
public decimal MucGiamGia { get; set; }
public DateTime NgayBatDau { get; set; }
public DateTime NgayKetThuc { get; set; }
public string TrangThai { get; set; }

public virtual ICollection<SanPhamKhuyenMai> SanPhamKhuyenMais { get; set; }


}

public class SanPhamKhuyenMai


{
[Key]
public int IdSPKhuyenMai { get; set; }
[ForeignKey("SanPham")]
public int IdSanPham { get; set; }
[ForeignKey("KhuyenMai")]
public int IdKhuyenMai { get; set; }

public virtual SanPham SanPham { get; set; }


public virtual KhuyenMai KhuyenMai { get; set; }
}

public class HinhAnh


{
[Key]
public int IdHinhAnh { get; set; }
public string ImageUrl { get; set; }
[ForeignKey("SanPham")]
public int IdSanPham { get; set; }
public virtual SanPham SanPham { get; set; }
}

public class HoaDonChiTiet


{
[Key]
public int IDHoaDonChiTiet { get; set; }
[ForeignKey("HoaDon")]
public int ID_HoaDon { get; set; }
[ForeignKey("SanPhamChiTiet")]
public int IdSPChiTiet { get; set; }
public int SoLuong { get; set; }
public decimal Gia { get; set; }
public decimal TongTien { get; set; }

public virtual HoaDon HoaDon { get; set; }


public virtual SanPhamChiTiet SanPhamChiTiet { get; set; }
}

public class GioHang


{
[Key]
public int IDGioHang { get; set; }
[ForeignKey("NguoiDung")]
public int IDNguoiDung { get; set; }
public string TrangThai { get; set; }
public DateTime NgayTao { get; set; }

public virtual NguoiDung NguoiDung { get; set; }


public virtual ICollection<GioHangChiTiet> GioHangChiTiets { get; set; }
}

public class GioHangChiTiet


{
[Key]
public int IDGioHangChiTiet { get; set; }
[ForeignKey("GioHang")]
public int ID_GioHang { get; set; }
[ForeignKey("SanPhamChiTiet")]
public int IdSPChiTiet { get; set; }
public int SoLuong { get; set; }
public decimal Gia { get; set; }
public decimal TongTien { get; set; }

public virtual GioHang GioHang { get; set; }


public virtual SanPhamChiTiet SanPhamChiTiet { get; set; }
}
public class PhuongThucThanhToan
{
[Key]
public int IDPhuongThucThanhToan { get; set; }
public string TenPhuongThucThanhToan { get; set; }
public string TrangThai { get; set; }

public virtual ICollection<HoaDon> HoaDons { get; set; }


}

You might also like