p_body_part_202505291606.sql 12 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748
  1. INSERT INTO public.p_body_part (body_part_id,body_part_name,body_part_local,body_part_description,patient_type,category,sort,is_enabled,product,is_pre_install) VALUES ('Human_SKULL','颅骨',NULL,'Skull','Human','DX',1,true,'DROC',true);
  2. INSERT INTO public.p_body_part (body_part_id,body_part_name,body_part_local,body_part_description,patient_type,category,sort,is_enabled,product,is_pre_install) VALUES ('Human_NECK','颈部',NULL,'Neck','Human','DX',2,true,'DROC',true);
  3. INSERT INTO public.p_body_part (body_part_id,body_part_name,body_part_local,body_part_description,patient_type,category,sort,is_enabled,product,is_pre_install) VALUES ('Human_SHOULDER','肩关节',NULL,'Shoulder','Human','DX',3,true,'DROC',true);
  4. INSERT INTO public.p_body_part (body_part_id,body_part_name,body_part_local,body_part_description,patient_type,category,sort,is_enabled,product,is_pre_install) VALUES ('Human_SPINE','脊柱',NULL,'Spine','Human','DX',4,true,'DROC',true);
  5. INSERT INTO public.p_body_part (body_part_id,body_part_name,body_part_local,body_part_description,patient_type,category,sort,is_enabled,product,is_pre_install) VALUES ('Human_THORAX','胸部',NULL,'Thorax','Human','DX',5,true,'DROC',true);
  6. INSERT INTO public.p_body_part (body_part_id,body_part_name,body_part_local,body_part_description,patient_type,category,sort,is_enabled,product,is_pre_install) VALUES ('Human_ABDOMEN','腹部',NULL,'Abdomen','Human','DX',6,true,'DROC',true);
  7. INSERT INTO public.p_body_part (body_part_id,body_part_name,body_part_local,body_part_description,patient_type,category,sort,is_enabled,product,is_pre_install) VALUES ('Human_PELVIS','骨盆',NULL,'Pelvis','Human','DX',7,true,'DROC',true);
  8. INSERT INTO public.p_body_part (body_part_id,body_part_name,body_part_local,body_part_description,patient_type,category,sort,is_enabled,product,is_pre_install) VALUES ('Human_UPPER LIMB','上肢',NULL,'UpperLimb','Human','DX',8,true,'DROC',true);
  9. INSERT INTO public.p_body_part (body_part_id,body_part_name,body_part_local,body_part_description,patient_type,category,sort,is_enabled,product,is_pre_install) VALUES ('Human_HAND','手部',NULL,'Hand','Human','DX',9,true,'DROC',true);
  10. INSERT INTO public.p_body_part (body_part_id,body_part_name,body_part_local,body_part_description,patient_type,category,sort,is_enabled,product,is_pre_install) VALUES ('Human_LOWER LIMB','下肢',NULL,'LowerLimb','Human','DX',10,true,'DROC',true);
  11. INSERT INTO public.p_body_part (body_part_id,body_part_name,body_part_local,body_part_description,patient_type,category,sort,is_enabled,product,is_pre_install) VALUES ('Human_FOOT','足部',NULL,'Foot','Human','DX',11,true,'DROC',true);
  12. INSERT INTO public.p_body_part (body_part_id,body_part_name,body_part_local,body_part_description,patient_type,category,sort,is_enabled,product,is_pre_install) VALUES ('Human_TOMO','TOMO',NULL,'TOMO','Human','DX',12,true,'DROC',true);
  13. INSERT INTO public.p_body_part (body_part_id,body_part_name,body_part_local,body_part_description,patient_type,category,sort,is_enabled,product,is_pre_install) VALUES ('Human_DUAL ENERGY','双能',NULL,'Human_DUAL ENERGY','Human','DX',13,true,'DROC',true);
  14. INSERT INTO public.p_body_part (body_part_id,body_part_name,body_part_local,body_part_description,patient_type,category,sort,is_enabled,product,is_pre_install) VALUES ('Human_QC','QC',NULL,'QC','Human','DX',14,true,'DROC',true);
  15. INSERT INTO public.p_body_part (body_part_id,body_part_name,body_part_local,body_part_description,patient_type,category,sort,is_enabled,product,is_pre_install) VALUES ('Calibration','校准',NULL,'Calibration','SpecialType','DX',15,true,'DROC',true);
  16. INSERT INTO public.p_body_part (body_part_id,body_part_name,body_part_local,body_part_description,patient_type,category,sort,is_enabled,product,is_pre_install) VALUES ('IQAP','IQAP',NULL,'IQAP','SpecialType','DX',16,true,'DROC',true);
  17. INSERT INTO public.p_body_part (body_part_id,body_part_name,body_part_local,body_part_description,patient_type,category,sort,is_enabled,product,is_pre_install) VALUES ('ThicknessRange','厚度范围',NULL,'ThicknessRange','SpecialType','DX',17,true,'DROC',true);
  18. INSERT INTO public.p_body_part (body_part_id,body_part_name,body_part_local,body_part_description,patient_type,category,sort,is_enabled,product,is_pre_install) VALUES ('Cat_Skull','猫 头骨',NULL,'Skull','Cat','DX',1,true,'VETDROC',true);
  19. INSERT INTO public.p_body_part (body_part_id,body_part_name,body_part_local,body_part_description,patient_type,category,sort,is_enabled,product,is_pre_install) VALUES ('Cat_Spine','猫 脊椎',NULL,'Spine','Cat','DX',2,true,'VETDROC',true);
  20. INSERT INTO public.p_body_part (body_part_id,body_part_name,body_part_local,body_part_description,patient_type,category,sort,is_enabled,product,is_pre_install) VALUES ('Cat_Thorax','猫 胸部',NULL,'Thorax','Cat','DX',3,true,'VETDROC',true);
  21. INSERT INTO public.p_body_part (body_part_id,body_part_name,body_part_local,body_part_description,patient_type,category,sort,is_enabled,product,is_pre_install) VALUES ('Cat_FrontExtremities','猫 前肢',NULL,'Forelimb','Cat','DX',4,true,'VETDROC',true);
  22. INSERT INTO public.p_body_part (body_part_id,body_part_name,body_part_local,body_part_description,patient_type,category,sort,is_enabled,product,is_pre_install) VALUES ('Cat_Abdomen','猫 腹部',NULL,'Abdomen','Cat','DX',5,true,'VETDROC',true);
  23. INSERT INTO public.p_body_part (body_part_id,body_part_name,body_part_local,body_part_description,patient_type,category,sort,is_enabled,product,is_pre_install) VALUES ('Cat_Hip','猫 臀部',NULL,'Hip','Cat','DX',6,true,'VETDROC',true);
  24. INSERT INTO public.p_body_part (body_part_id,body_part_name,body_part_local,body_part_description,patient_type,category,sort,is_enabled,product,is_pre_install) VALUES ('Cat_RearExtremities','猫 后肢',NULL,'Hindlimb','Cat','DX',7,true,'VETDROC',true);
  25. INSERT INTO public.p_body_part (body_part_id,body_part_name,body_part_local,body_part_description,patient_type,category,sort,is_enabled,product,is_pre_install) VALUES ('Dog_Skull','狗 头骨',NULL,'Skull','Dog','DX',8,true,'VETDROC',true);
  26. INSERT INTO public.p_body_part (body_part_id,body_part_name,body_part_local,body_part_description,patient_type,category,sort,is_enabled,product,is_pre_install) VALUES ('Dog_Spine','狗 脊椎',NULL,'Spine','Dog','DX',9,true,'VETDROC',true);
  27. INSERT INTO public.p_body_part (body_part_id,body_part_name,body_part_local,body_part_description,patient_type,category,sort,is_enabled,product,is_pre_install) VALUES ('Dog_Thorax','狗 胸部',NULL,'Thorax','Dog','DX',10,true,'VETDROC',true);
  28. INSERT INTO public.p_body_part (body_part_id,body_part_name,body_part_local,body_part_description,patient_type,category,sort,is_enabled,product,is_pre_install) VALUES ('Dog_FrontExtremities','狗 前肢',NULL,'Forelimb','Dog','DX',11,true,'VETDROC',true);
  29. INSERT INTO public.p_body_part (body_part_id,body_part_name,body_part_local,body_part_description,patient_type,category,sort,is_enabled,product,is_pre_install) VALUES ('Dog_Abdomen','狗 腹部',NULL,'Abdomen','Dog','DX',12,true,'VETDROC',true);
  30. INSERT INTO public.p_body_part (body_part_id,body_part_name,body_part_local,body_part_description,patient_type,category,sort,is_enabled,product,is_pre_install) VALUES ('Dog_Hip','狗 臀部',NULL,'Hip','Dog','DX',13,true,'VETDROC',true);
  31. INSERT INTO public.p_body_part (body_part_id,body_part_name,body_part_local,body_part_description,patient_type,category,sort,is_enabled,product,is_pre_install) VALUES ('Dog_RearExtremities','狗 后肢',NULL,'Hindlimb','Dog','DX',14,true,'VETDROC',true);
  32. INSERT INTO public.p_body_part (body_part_id,body_part_name,body_part_local,body_part_description,patient_type,category,sort,is_enabled,product,is_pre_install) VALUES ('Equine_Head','马 头',NULL,'Head','Equine','DX',15,true,'VETDROC',true);
  33. INSERT INTO public.p_body_part (body_part_id,body_part_name,body_part_local,body_part_description,patient_type,category,sort,is_enabled,product,is_pre_install) VALUES ('Equine_Spine','马 脊椎',NULL,'Spine','Equine','DX',16,true,'VETDROC',true);
  34. INSERT INTO public.p_body_part (body_part_id,body_part_name,body_part_local,body_part_description,patient_type,category,sort,is_enabled,product,is_pre_install) VALUES ('Equine_THORAX','马 胸腔',NULL,'Thorax & Abdomen','Equine','DX',17,true,'VETDROC',true);
  35. INSERT INTO public.p_body_part (body_part_id,body_part_name,body_part_local,body_part_description,patient_type,category,sort,is_enabled,product,is_pre_install) VALUES ('Equine_Left_Forelimb','马 左前肢',NULL,'Left Forelimb','Equine','DX',18,true,'VETDROC',true);
  36. INSERT INTO public.p_body_part (body_part_id,body_part_name,body_part_local,body_part_description,patient_type,category,sort,is_enabled,product,is_pre_install) VALUES ('Equine_Right_Forelimb','马 右前肢',NULL,'Right Forelimb','Equine','DX',19,true,'VETDROC',true);
  37. INSERT INTO public.p_body_part (body_part_id,body_part_name,body_part_local,body_part_description,patient_type,category,sort,is_enabled,product,is_pre_install) VALUES ('Equine_Left_Hindlimb','马 左后肢',NULL,'Left Hindlimb','Equine','DX',20,true,'VETDROC',true);
  38. INSERT INTO public.p_body_part (body_part_id,body_part_name,body_part_local,body_part_description,patient_type,category,sort,is_enabled,product,is_pre_install) VALUES ('Equine_Right_Hindlimb','马 右后肢',NULL,'Right Hindlimb','Equine','DX',21,true,'VETDROC',true);
  39. INSERT INTO public.p_body_part (body_part_id,body_part_name,body_part_local,body_part_description,patient_type,category,sort,is_enabled,product,is_pre_install) VALUES ('Exotic_Birds','啮齿类 鸟',NULL,'Avian Species','Birds','DX',22,true,'VETDROC',true);
  40. INSERT INTO public.p_body_part (body_part_id,body_part_name,body_part_local,body_part_description,patient_type,category,sort,is_enabled,product,is_pre_install) VALUES ('Exotic_Fish','啮齿类 鱼',NULL,'Fish Species','Fish','DX',23,true,'VETDROC',true);
  41. INSERT INTO public.p_body_part (body_part_id,body_part_name,body_part_local,body_part_description,patient_type,category,sort,is_enabled,product,is_pre_install) VALUES ('Exotic_Gnawer','啮齿类 鼠类',NULL,'Rat & Hamster','Gnawer','DX',24,true,'VETDROC',true);
  42. INSERT INTO public.p_body_part (body_part_id,body_part_name,body_part_local,body_part_description,patient_type,category,sort,is_enabled,product,is_pre_install) VALUES ('Exotic_Lizard','啮齿类 蜥蜴',NULL,'Lizard Species','Lizard','DX',25,true,'VETDROC',true);
  43. INSERT INTO public.p_body_part (body_part_id,body_part_name,body_part_local,body_part_description,patient_type,category,sort,is_enabled,product,is_pre_install) VALUES ('Exotic_Rabbit','啮齿类 兔子',NULL,'Rabbit Species','Rabbit','DX',26,true,'VETDROC',true);
  44. INSERT INTO public.p_body_part (body_part_id,body_part_name,body_part_local,body_part_description,patient_type,category,sort,is_enabled,product,is_pre_install) VALUES ('Exotic_Snake','啮齿类 蛇',NULL,'Snake Species','Snake','DX',27,true,'VETDROC',true);
  45. INSERT INTO public.p_body_part (body_part_id,body_part_name,body_part_local,body_part_description,patient_type,category,sort,is_enabled,product,is_pre_install) VALUES ('Exotic_Turtle','啮齿类 龟',NULL,'Chelonian Species','Turtle','DX',28,true,'VETDROC',true);
  46. INSERT INTO public.p_body_part (body_part_id,body_part_name,body_part_local,body_part_description,patient_type,category,sort,is_enabled,product,is_pre_install) VALUES ('Calibration','校准',NULL,'Calibration','Other','DX',29,true,'VETDROC',true);
  47. INSERT INTO public.p_body_part (body_part_id,body_part_name,body_part_local,body_part_description,patient_type,category,sort,is_enabled,product,is_pre_install) VALUES ('ThicknessRange','厚度范围',NULL,'ThicknessRange','Other','DX',30,true,'VETDROC',true);
  48. INSERT INTO public.p_body_part (body_part_id,body_part_name,body_part_local,body_part_description,patient_type,category,sort,is_enabled,product,is_pre_install) VALUES ('QC','QC',NULL,'QC','Other','DX',31,true,'VETDROC',true);