chi_nhanh
{
  "_id":  ObjectId(""),
  "chi_nhanh": "Chi Nhanh Quan 12"
}

vai_tro
{
  "_id" :  ObjectId(""),
  "vai_tro": "bác sĩ thú y"     
}

nhan_vien
{
  "_id": ObjectId(""),
  "id_vai_tro": ObjectId("VAT_TRO"),
  "ho_ten" : "Nguyễn Văn B",
  "sđt" : "0799698318",
  "ten_dang_nhap" : "a246610",
  "mat_khau" : "1234567890", 
  "phan_quyen": [],
  "id_chi_nhanh": ObjectID("CN_Quan_12")
}

khach_hang
{
  "_id": ObjectId("64c12e3f8c7a2f0c58d95b12"),
  "ten": "Nguyen Van A",
  "so_dien_thoai": "0987654321",
  "ngay_tao": ISODate("2025-07-07"),
  "ngay_sinh": ISODate("1990-05-15"),
  "dia_chi": "123 Le Loi, Quan 1, TP.HCM",
  "ghi_chu": "Khách VIP",
  "tich_diem": 250,
  "du_no": 1000000,
  "pets": [ ObjectId("64c12f578c7a2f0c58d95b20")],
  "invoices": [ ObjectId("HD_07_07_2025") ]
}

bill
[
  {
    "_id": ObjectId("64d0000000000000000000a1"),
    "type": "bill_dich_vu",
    "is_luu_tru": 0,
    "san_pham" :[
      
      {"id_san_pham": ObjectId("SP_THUOC_GIUN"), "so_luong": 5, "lieu_luong": 2, "ghi_chu":"Uống sau khi ăn"}.
      {"id_san_pham": ObjectId("SP_KHANG_SINH"), "so_luong": 2, "ghi_chu":"Hoà chung với thức ăn" }
    ],
    "phu_thu": 100000,
    "ly_do_phu_thu":"trong luong pet qua lon"
  },
  {
    "_id": ObjectId("64d0000000000000000000a2"),
    "type": "bill_dich_vu",
    "is_luu_tru":0,
    "san_pham": [{ "id_san_pham": ObjectId("SP_KEM_DUONG_DA"), "so_luong": 5, "lieu_luong": 2, "ghi_chu":"không tha lên mặt" }]
  },
  {
    "_id": ObjectId("64d0000000000000000000e1"),
    "type": "bill_dich_vu",
    "is_luu_tru": 1,
    "san_pham": 
      [{ ngay:"2025-07-07", "id_san_pham": ObjectId("SP_KHANG_SINH"), "so_luong": 2, "ghi_chu":"Hoà chung với thức ăn"  }]
  },
  {
    "_id": ObjectId("64d0000000000000000000g1"),
    "type": "bill_dich_vu",
    "is_luu_tru":1,
    "san_pham": 
      [{ngay:"2025-08-01", id_san_pham: ObjectId("SP_GOI_MEO"), so_luong: 1, ghi_chu":"Dùng quá liều do thể trạng" }]            
  },
  {
    "_id": ObjectId("BILL_SAN_PHAM"),
    "type": "bill_san_pham",
    "san_pham" :
      ["id_san_pham": ObjectId("SP_GOI_MEO"), "so_luong": 2],
      ["id_san_pham": ObjectId("SP_AO_BAO_HO"), "so_luong": 1]
  }
]


thu_cung
{
  "_id": ObjectId("64c12f578c7a2f0c58d95b20"),
  "khach_hang": ObjectId("64c12e3f8c7a2f0c58d95b12"),
  "ten": "Mimi",
  "loai": "Meo",
  "can_nang": 3.2,
  "gioi_tinh": "Cai",
  "giong": "Munchkin",
  "tuoi": 2,
  "benh_nen": "cao huyet ap"
}

"pet_visit": [
  {
    "_id": ObjectId(""),
    "id_thu_cung": ObjectId("64c12f578c7a2f0c58d95b20"),
    "type_pet_visit": "kham_trong_ngay",
    "ngay": ISODate("2025-07-15T09:30:00Z"),
    "id_benh_an": { /* ... */ },
    "id_bill": ObjectId("64d0000000000000000000a1"),
    "nhan_vien": ObjectID("NHAN_VIEN"),
    "chi_nhanh": ObjectID("CN_Quan_12")
  },
  {
    "_id": ObjectId(""),
    "id_thu_cung": ObjectId("64c12f578c7a2f0c58d95b20"),
    "type_pet_visit": "spa",
    "ngay": ISODate("2025-07-20T14:00:00Z"),
    "id_benh_an": { /* ... */ },
    "nhan_vien": ObjectID("NHAN_VIEN"),
    "chi_nhanh": ObjectID("CN_Quan_12"),
    "id_bill": ObjectId("64d0000000000000000000a2")
  },
  {
    "_id": ObjectId("TK_0"),
    "id_thu_cung": ObjectId("64c12f578c7a2f0c58d95b20"),
    "type_pet_visit": "tai_kham",
    "nhan_vien": ObjectID("NHAN_VIEN"),
    "chi_nhanh": ObjectID("CN_Quan_12"),
    "id_bill": ObjectId(""),
    "id_benh_an": { /* ... */ },
    "pre_id": 0 
  },
  {
    "_id": ObjectId("TK_1"),
    "id_thu_cung": ObjectId("64c12f578c7a2f0c58d95b20"),
    "type_pet_visit": "tai_kham",
    "nhan_vien": ObjectID("NHAN_VIEN"),
    "chi_nhanh": ObjectID("CN_Quan_12"),
    "id_bill": ObjectId(""),
    "id_benh_an": { /* ... */ },
    "pre_id": ObjectId("TK_0")
  },
  {
    "_id": ObjectId("TK_2"),
    "id_thu_cung": ObjectId("64c12f578c7a2f0c58d95b20"),
    "type_pet_visit": "tai_kham",
    "nhan_vien": ObjectID("NHAN_VIEN"),
    "chi_nhanh": ObjectID("CN_Quan_12"),
    "id_bill": ObjectId(""),
    "id_benh_an": { /* ... */ },
    "pre_id": ObjectId("TK_1")
  },
  {
    "_id": ObjectId("64d000000000000000000004"),
    "id_thu_cung": ObjectId("64c12f578c7a2f0c58d95b20"),
    "type_pet_visit": "nhap_vien",
    "dieu_tri_xong:0",
    "id_benh_an": { /* ... */ },
    "chi_nhanh": ObjectID("CN_Quan_12"),
    "ngay_dieu_tri": [
      {
        "_id": ObjectId("64d0000000000000000000d1"),
        "ngay_nhap": ISODate("2025-07-07"),
        "ngay_xuat": ISODate("2025-07-10T16:00:00Z"),
        "nhan_vien": ObjectID("NHAN_VIEN"),
        "tinh_trang_suc_khoe_theo_ngay": [ /* ... */ ],
      }
    ],
      "id_bill": ObjectId("64d0000000000000000000e1") 
  },
  {
    "_id": ObjectId("64d000000000000000000005"),
    "type_pet_visit": "hotel",
    "chi_nhanh": ObjectID("CN_Quan_12"),
    "ngay": [
      {
        "_id": ObjectId("64d0000000000000000000f1"),
        "ngay_nhan": ISODate("2025-08-01"),
        "ngay_tra": ISODate("2025-08-03"),
        "tinh_trang_suc_khoe_theo_ngay": [ /* ... */ ],
        "nhan_vien": ObjectID("NHAN_VIEN"),
        "id_bill": ObjectId("64d0000000000000000000g1")
          
      }
    ]
  }
]

lich_hen
{
  "_id": ObjectId("LICH_HEN_KHAM"),
  "khach_hang": ObjectId("64c12e3f8c7a2f0c58d95b12"),
  "thu_cung": ObjectId("64c12f578c7a2f0c58d95b20"),
  "lich_hen": ISODate("2025-08-01 - 10:20"),
  "dich_vu": 
  [
    "dich_vu": ObjectId("DV_Sieu_Am"),
    "dich_vu": ObjectId("DV_Tam_Cho")
  ],
  "ghi_chu": "Khám Định kỳ"
}



nha_san_xuat 
{
  "_id": ObjectId("CTY_MEO_O"),
  "ten_nha_san_xuat": "Công ty THNH MEO_O",
  "ten_viet_tat": "Cty MEO",
  "sdt": "02743782770", 
  "dia_chi": "35 thống nhất",
  "emai": "abc-xyz@gmail.com"
}

cach_dung
{
    "_id": ObjectId("CD_TRON_DO_AN"),
    "cach_dung": "Trộn đồ ăn"
}
  

don_vi
{
    "_id": ObjectId("DV_THUOC"),
    "don_vi": "Viên"
}

phan_loai_dich_vu
{
    "_id": ObjectID("PL_DV_dieu_tri"),
    "loai_dich_vu": "Điều trị"  
}


hang_hoa
[
  {
    "_id": ObjectId("SP_GOI_MEO"),
    "is_thuoc":0,
    "ma_vach": "abcxyz2",
    "ten_hang_hoa": "Gói đồ ăn cho mèo MEO-0 1kg",
    "ten_viet_tat": "MEO-O 1kg",
    "nha_san_xuat": ObjectId("CTY_MEO_O"), 
    "gia": 12000,
    "gia_goc": 8000,
    "ton_toi_thieu": 5, 
  },
  {
    "_id": ObjectId("THUOC_GIUN"),
    "is_thuoc":1,
    "ma_vach": "abcxyz35",
    "ten_hang_hoa": "Thuốc xổ giun cho chó con",
    "ten_viet_tat": "xổ giun chó",
    "cach_dung": ObjectId("CD_TRON_DO_AN"), 
    "don_vi": ObjectId("DV_VIEN"),
    "gia": 15000,
    "gia_goc": 9000,
    "ton_toi_thieu": 5,
    "lieu_luong": [
      {
        "trong_luong_min": 1,
        "trong_luong_max": 5,
        "lieu_luong": 3,
        "lieu_luong_toi_da": 5  
      },
      {
        "trong_luong_min": 5,
        "lieu_luong": 7,
        "lieu_luong_toi_da": 10  
      }
    ],
    "lieu_luong_enable": 1,
    "lieu_luong_ty_trong": 0.6,
    "lieu_luong_ty_trong_enable": 0
  }
]

lo_hang_hoa
[
  {
    _id: ObjectId("L_H_H_GOI_MEO"),
    id_san_pham: ObjectId("SP_GOI_MEO"),
    is_chuyen_kho: 0,
    ngay_nhap_hang: ISODate("2025-08-05"),
    han_su_dung: ISODate("2026-08-05"),
    so_luong: 100,
    nha_vien_nhap_hang: ObjectID("NV_Nguyen"),
    chi_nhanh: ObjectID("CN_Quan_12")
  }
]


dich_vu
[
  {
    _id: ObjectId("DV_Sieu_Am"),
    phan_loai: ObjectID("PL_DV_dieu_tri"),
    ten_dich_vu: "Siêu Âm",
    tien_dich_vu: 220000,
    san_pham: [
      {
        id_hang_hoa : ObjectId("THUOC_GIUN"),
        in_tren_bill: 1,
        so_luong: 5 
      },
      {
        id_hang_hoa : ObjectId("THUOC_KHANG_SINH"),
        in_tren_bill: 0,
        so_luong: 7 
      }
    ]
  },
  {
    _id: ObjectId("DV_TAM_CHO"),
    phan_loai: ObjectID("PL_DV_spa"),
    ten_dich_vu: "Tắm cho chó",
    gia: 220000,
    san_pham: [
      {
        id_hang_hoa : ObjectId("DUNG_DICH_VE_SINH"),
        in_tren_bill: 1,
        so_luong: 1 
      },
      {
        id_hang_hoa : ObjectId("THUOC_TRI_VE"),
        in_tren_bill: 0,
        so_luong: 2 
      }
    ]
  }
]

combo
[
  {
    _id: ObjectID("Combo_KM_phau_thuat"),
    ten_combo: "Phẩu thuật cho chó",
    gia: 1000000,
    ngay_ket_thuc: null || ISODate("2025-07-07"),
    san_pham: [
      {
        id_dich_vu: ObjectId("DV_Sieu_Am"),
        in_tren_bill: 1
      },
      {
        id_dich_vu: ObjectId("SP_GOI_MEO"),
        in_tren_bill: 1
      }
    ] 
    chi_nhanh: ObjectID("CN_Quan_12")
  }
]
    


hoa_don
{
  "_id": ObjectId("HD_07_07_2025"),
  "khach_hang": ObjectId("64c12e3f8c7a2f0c58d95b12"),
  "ngay_lap": ISODate("2025-07-07"),
  "tien_ung": 1000000,
  "ghi_chu_tien_ung": "ứng trước spa",
  "bills": [
    "id_bill" : ObjectId("64d0000000000000000000a1"),
    "id_bill" : ObjectId("64d0000000000000000000g1"),
    "id_bill" : ObjectId("BILL_SAN_PHAM")
  ],
  "tong_thanh_toan": 2250000,
  "con_phai_thanh_toan": 1250000,
  "chiet_khau" : 5000,
  "ly_do_chiet_khau": "giam gia cho khach hang quen",
  "ghi_chu": "Thanh toán sau 3 ngày",
  "hinh_thuc_thanh_toan": "chuyển khoản"
}