models.py 146 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354135513561357135813591360136113621363136413651366136713681369137013711372137313741375137613771378137913801381138213831384138513861387138813891390139113921393139413951396139713981399140014011402140314041405140614071408140914101411141214131414141514161417141814191420142114221423142414251426142714281429143014311432143314341435143614371438143914401441144214431444144514461447144814491450145114521453145414551456145714581459146014611462146314641465146614671468146914701471147214731474147514761477147814791480148114821483148414851486148714881489149014911492149314941495149614971498149915001501150215031504150515061507150815091510151115121513151415151516151715181519152015211522152315241525152615271528152915301531153215331534153515361537153815391540154115421543154415451546154715481549155015511552155315541555155615571558155915601561156215631564156515661567156815691570157115721573157415751576157715781579158015811582158315841585158615871588158915901591159215931594159515961597159815991600160116021603160416051606160716081609161016111612161316141615161616171618161916201621162216231624162516261627162816291630163116321633163416351636163716381639164016411642164316441645164616471648164916501651165216531654165516561657165816591660166116621663166416651666166716681669167016711672167316741675167616771678167916801681168216831684168516861687168816891690169116921693169416951696169716981699170017011702170317041705170617071708170917101711171217131714171517161717171817191720172117221723172417251726172717281729173017311732173317341735173617371738173917401741174217431744174517461747174817491750175117521753175417551756175717581759176017611762176317641765176617671768176917701771177217731774177517761777177817791780178117821783178417851786178717881789179017911792179317941795179617971798179918001801180218031804180518061807180818091810181118121813181418151816181718181819182018211822182318241825182618271828182918301831183218331834183518361837183818391840184118421843184418451846184718481849185018511852185318541855185618571858185918601861186218631864186518661867186818691870187118721873187418751876187718781879188018811882188318841885188618871888188918901891189218931894189518961897189818991900190119021903190419051906190719081909191019111912191319141915191619171918191919201921192219231924192519261927192819291930193119321933193419351936193719381939194019411942194319441945194619471948194919501951195219531954195519561957195819591960196119621963196419651966196719681969197019711972197319741975197619771978197919801981198219831984198519861987198819891990199119921993199419951996199719981999200020012002200320042005200620072008200920102011201220132014201520162017201820192020202120222023202420252026202720282029203020312032203320342035203620372038203920402041204220432044204520462047204820492050205120522053205420552056205720582059206020612062206320642065206620672068206920702071207220732074207520762077207820792080208120822083208420852086208720882089209020912092209320942095209620972098209921002101210221032104210521062107210821092110211121122113211421152116211721182119212021212122212321242125212621272128212921302131213221332134213521362137213821392140214121422143214421452146214721482149215021512152215321542155215621572158215921602161216221632164216521662167216821692170217121722173217421752176217721782179218021812182218321842185218621872188218921902191219221932194219521962197219821992200220122022203220422052206220722082209221022112212221322142215221622172218221922202221222222232224222522262227222822292230223122322233223422352236223722382239224022412242224322442245224622472248224922502251225222532254225522562257225822592260226122622263226422652266226722682269227022712272227322742275227622772278227922802281228222832284228522862287228822892290229122922293229422952296229722982299230023012302230323042305230623072308230923102311231223132314231523162317231823192320232123222323232423252326232723282329233023312332233323342335233623372338233923402341234223432344234523462347234823492350235123522353235423552356235723582359236023612362236323642365236623672368236923702371237223732374
  1. """数据模型(与 docs/sql/zkxw.sql 全库导出基线对齐的核心系统表)"""
  2. from datetime import datetime
  3. import enum
  4. from sqlalchemy import Column, String, DateTime, Integer, Text, CHAR, SmallInteger, Numeric
  5. from app.core.database import Base
  6. class UserRole(str, enum.Enum):
  7. """Web 管理端约定角色(由 sys_role.role_name 映射而来,非数据库枚举)"""
  8. ADMIN = "admin"
  9. SUPER_ADMIN = "super_admin"
  10. # =============================================================================
  11. # V0.3 用户 / 角色 / 菜单(2.1.4 ~ 2.1.6)
  12. # =============================================================================
  13. class SysUser(Base):
  14. """用户表 sys_user(V0.3)"""
  15. __tablename__ = "sys_user"
  16. id = Column(String(64), primary_key=True, comment="主键ID")
  17. dept_id = Column(String(64), nullable=True, comment="部门ID")
  18. user_no = Column(String(30), nullable=False, comment="用户账号")
  19. nick_name = Column(String(30), nullable=False, comment="用户名")
  20. email = Column(String(50), nullable=False, default="", comment="用户邮箱")
  21. phone_no = Column(String(11), nullable=False, default="", comment="手机号码")
  22. sex = Column(CHAR(1), nullable=True, default="0", comment="用户性别")
  23. avatar = Column(String(512), nullable=True, comment="头像")
  24. password = Column("password", String(100), nullable=False, default="", comment="密码")
  25. status = Column(CHAR(1), nullable=False, default="1", comment="帐号状态 1正常 0停用")
  26. tenant_no = Column(String(64), nullable=False, default="zkxw", comment="租户编号")
  27. order_num = Column(Integer, nullable=True, comment="排序号")
  28. remark = Column(String(512), nullable=True, comment="备注")
  29. create_by = Column(String(64), nullable=True, comment="创建人id")
  30. create_dept_id = Column(String(64), nullable=False, default="", comment="创建人部门ID")
  31. create_time = Column(DateTime, nullable=False, default=datetime.now, comment="创建时间")
  32. update_by = Column(String(64), nullable=True, comment="更新人id")
  33. update_time = Column(DateTime, nullable=False, default=datetime.now, onupdate=datetime.now, comment="更新时间")
  34. del_flag = Column(SmallInteger, nullable=False, default=0, comment="删除标记 0正常 1已删除")
  35. class SysRole(Base):
  36. """角色表 sys_role(V0.3)"""
  37. __tablename__ = "sys_role"
  38. id = Column(String(64), primary_key=True, comment="主键ID")
  39. role_name = Column(String(30), nullable=False, comment="角色名称")
  40. data_scope = Column(CHAR(1), nullable=True, default="1", comment="数据权限")
  41. status = Column(CHAR(1), nullable=False, default="1", comment="角色状态")
  42. tenant_no = Column(String(64), nullable=False, default="zkxw", comment="租户编号")
  43. order_num = Column(Integer, nullable=True, comment="排序号")
  44. remark = Column(String(512), nullable=True, comment="备注")
  45. create_by = Column(String(64), nullable=True, comment="创建人id")
  46. create_dept_id = Column(String(64), nullable=False, default="", comment="创建人部门ID")
  47. create_time = Column(DateTime, nullable=False, default=datetime.now, comment="创建时间")
  48. update_by = Column(String(64), nullable=True, comment="更新人id")
  49. update_time = Column(DateTime, nullable=False, default=datetime.now, onupdate=datetime.now, comment="更新时间")
  50. del_flag = Column(SmallInteger, nullable=False, default=0, comment="删除标记")
  51. class SysUserRole(Base):
  52. """用户-角色关联 sys_user_role(V0.3)"""
  53. __tablename__ = "sys_user_role"
  54. id = Column(String(64), primary_key=True, comment="主键ID")
  55. user_id = Column(String(64), nullable=False, comment="用户ID")
  56. role_id = Column(String(64), nullable=False, comment="角色ID")
  57. tenant_no = Column(String(64), nullable=False, default="zkxw", comment="租户编号")
  58. order_num = Column(Integer, nullable=True, comment="排序号")
  59. remark = Column(String(512), nullable=True, comment="备注")
  60. create_by = Column(String(64), nullable=True, comment="创建人id")
  61. create_dept_id = Column(String(64), nullable=False, default="", comment="创建人部门ID")
  62. create_time = Column(DateTime, nullable=False, default=datetime.now, comment="创建时间")
  63. update_by = Column(String(64), nullable=True, comment="更新人id")
  64. update_time = Column(DateTime, nullable=False, default=datetime.now, onupdate=datetime.now, comment="更新时间")
  65. del_flag = Column(SmallInteger, nullable=False, default=0, comment="删除标记")
  66. class SysRoleMenu(Base):
  67. """角色-菜单关联 sys_role_menu(V0.3)"""
  68. __tablename__ = "sys_role_menu"
  69. id = Column(String(64), primary_key=True, comment="主键ID")
  70. role_id = Column(String(64), nullable=False, comment="角色ID")
  71. menu_id = Column(String(64), nullable=False, comment="菜单ID")
  72. tenant_no = Column(String(64), nullable=False, default="zkxw", comment="租户编号")
  73. order_num = Column(Integer, nullable=True, comment="排序号")
  74. remark = Column(String(512), nullable=True, comment="备注")
  75. create_by = Column(String(64), nullable=True, comment="创建人id")
  76. create_dept_id = Column(String(64), nullable=False, default="", comment="创建人部门ID")
  77. create_time = Column(DateTime, nullable=False, default=datetime.now, comment="创建时间")
  78. update_by = Column(String(64), nullable=True, comment="更新人id")
  79. update_time = Column(DateTime, nullable=False, default=datetime.now, onupdate=datetime.now, comment="更新时间")
  80. del_flag = Column(SmallInteger, nullable=False, default=0, comment="删除标记")
  81. class SysRoleDataScopeDetail(Base):
  82. """角色自定义数据权限明细 sys_role_data_scope_detail"""
  83. __tablename__ = "sys_role_data_scope_detail"
  84. id = Column(String(64), primary_key=True, comment="主键ID")
  85. role_id = Column(String(64), nullable=False, comment="角色ID")
  86. scope_type = Column(String(20), nullable=False, comment="范围类型:dept/user")
  87. scope_value = Column(String(100), nullable=False, comment="范围值:部门ID/用户ID")
  88. tenant_no = Column(String(64), nullable=False, default="zkxw", comment="租户编号")
  89. order_num = Column(Integer, nullable=True, comment="排序号")
  90. remark = Column(String(512), nullable=True, comment="备注")
  91. create_by = Column(String(64), nullable=True, comment="创建人id")
  92. create_dept_id = Column(String(64), nullable=False, default="", comment="创建人部门ID")
  93. create_time = Column(DateTime, nullable=False, default=datetime.now, comment="创建时间")
  94. update_by = Column(String(64), nullable=True, comment="更新人id")
  95. update_time = Column(DateTime, nullable=False, default=datetime.now, onupdate=datetime.now, comment="更新时间")
  96. del_flag = Column(SmallInteger, nullable=False, default=0, comment="删除标记")
  97. class SysMenu(Base):
  98. """菜单表 sys_menu(V0.3)"""
  99. __tablename__ = "sys_menu"
  100. id = Column(String(64), primary_key=True, comment="主键ID")
  101. menu_name = Column(String(50), nullable=False, comment="菜单名称")
  102. parent_id = Column(String(64), nullable=False, default="0", comment="父菜单ID")
  103. menu_type = Column(CHAR(1), nullable=True, default="M", comment="类型 M目录 C菜单 F按钮")
  104. path = Column(String(200), nullable=False, default="", comment="路由路径")
  105. component = Column(String(255), nullable=True, comment="组件路径")
  106. perms = Column(String(100), nullable=True, comment="权限标识")
  107. is_frame = Column(Integer, nullable=True, default=1, comment="是否外链")
  108. visible = Column(CHAR(1), nullable=True, default="1", comment="显示状态")
  109. status = Column(CHAR(1), nullable=False, default="1", comment="菜单状态")
  110. tenant_no = Column(String(64), nullable=False, default="zkxw", comment="租户编号")
  111. order_num = Column(Integer, nullable=True, comment="排序号")
  112. remark = Column(String(512), nullable=True, comment="备注")
  113. create_by = Column(String(64), nullable=True, comment="创建人id")
  114. create_dept_id = Column(String(64), nullable=False, default="", comment="创建人部门ID")
  115. create_time = Column(DateTime, nullable=False, default=datetime.now, comment="创建时间")
  116. update_by = Column(String(64), nullable=True, comment="更新人id")
  117. update_time = Column(DateTime, nullable=False, default=datetime.now, onupdate=datetime.now, comment="更新时间")
  118. del_flag = Column(SmallInteger, nullable=False, default=0, comment="删除标记")
  119. class SysDept(Base):
  120. """组织/部门 sys_dept"""
  121. __tablename__ = "sys_dept"
  122. id = Column(String(64), primary_key=True, comment="主键ID")
  123. parent_id = Column(String(64), nullable=False, default="0", comment="父组织id")
  124. dept_name = Column(String(200), nullable=False, comment="组织名称")
  125. dept_category_code = Column(String(64), nullable=True, comment="组织类别编码")
  126. status = Column(CHAR(1), nullable=False, default="1", comment="部门状态")
  127. leader = Column(String(100), nullable=True, comment="部门负责人")
  128. leader_phone = Column(String(32), nullable=True, comment="部门负责人联系电话")
  129. tenant_no = Column(String(64), nullable=False, default="zkxw", comment="租户编号")
  130. order_num = Column(Integer, nullable=True, comment="排序号")
  131. remark = Column(String(512), nullable=True, comment="备注")
  132. create_by = Column(String(64), nullable=True, comment="创建人id")
  133. create_dept_id = Column(String(64), nullable=False, default="", comment="创建人部门ID")
  134. create_time = Column(DateTime, nullable=False, default=datetime.now, comment="创建时间")
  135. update_by = Column(String(64), nullable=True, comment="更新人id")
  136. update_time = Column(DateTime, nullable=False, default=datetime.now, onupdate=datetime.now, comment="更新时间")
  137. del_flag = Column(SmallInteger, nullable=False, default=0, comment="删除标记")
  138. class SysTenant(Base):
  139. """租户表 sys_tenant(V0.3 2.1.1)"""
  140. __tablename__ = "sys_tenant"
  141. id = Column(String(64), primary_key=True, comment="主键ID")
  142. tenant_no = Column(String(64), nullable=False, comment="租户编号(业务编码)")
  143. tenant_name = Column(String(200), nullable=False, comment="租户名称")
  144. contact_name = Column(String(100), nullable=True, comment="联系人姓名")
  145. contact_phone = Column(String(32), nullable=True, comment="联系电话")
  146. order_num = Column(Integer, nullable=True, comment="排序号")
  147. remark = Column(String(512), nullable=True, comment="备注")
  148. create_by = Column(String(64), nullable=True, comment="创建人id")
  149. create_dept_id = Column(String(64), nullable=False, default="", comment="创建人部门ID")
  150. create_time = Column(DateTime, nullable=False, default=datetime.now, comment="创建时间")
  151. update_by = Column(String(64), nullable=True, comment="更新人id")
  152. update_time = Column(DateTime, nullable=False, default=datetime.now, onupdate=datetime.now, comment="更新时间")
  153. del_flag = Column(SmallInteger, nullable=False, default=0, comment="删除标记:0-正常 1-已删除")
  154. class SysSite(Base):
  155. """站点 sys_site"""
  156. __tablename__ = "sys_site"
  157. id = Column(String(64), primary_key=True, comment="主键ID")
  158. site_name = Column(String(200), nullable=False, comment="站点名称")
  159. site_code = Column(String(64), nullable=False, comment="站点编码")
  160. site_type = Column(String(64), nullable=True, comment="站点类型")
  161. status = Column(CHAR(1), nullable=False, default="1", comment="状态")
  162. address = Column(String(512), nullable=True, comment="详细地址")
  163. contact_name = Column(String(100), nullable=True, comment="联系人")
  164. contact_phone = Column(String(32), nullable=True, comment="联系电话")
  165. business_scope = Column(String(256), nullable=True, comment="业务范围")
  166. tenant_no = Column(String(64), nullable=False, default="zkxw", comment="租户编号")
  167. order_num = Column(Integer, nullable=True, comment="排序号")
  168. remark = Column(String(512), nullable=True, comment="备注")
  169. create_by = Column(String(64), nullable=True, comment="创建人id")
  170. create_dept_id = Column(String(64), nullable=False, default="", comment="创建人部门ID")
  171. create_time = Column(DateTime, nullable=False, default=datetime.now, comment="创建时间")
  172. update_by = Column(String(64), nullable=True, comment="更新人id")
  173. update_time = Column(DateTime, nullable=False, default=datetime.now, onupdate=datetime.now, comment="更新时间")
  174. del_flag = Column(SmallInteger, nullable=False, default=0, comment="删除标记")
  175. class SysPost(Base):
  176. """职位 sys_post"""
  177. __tablename__ = "sys_post"
  178. id = Column(String(64), primary_key=True, comment="主键ID")
  179. post_name = Column(String(100), nullable=False, comment="职位名称")
  180. post_code = Column(String(64), nullable=False, comment="职位编码")
  181. status = Column(CHAR(1), nullable=False, default="1", comment="状态")
  182. tenant_no = Column(String(64), nullable=False, default="zkxw", comment="租户编号")
  183. order_num = Column(Integer, nullable=True, comment="排序号")
  184. remark = Column(String(512), nullable=True, comment="备注")
  185. create_by = Column(String(64), nullable=True, comment="创建人id")
  186. create_dept_id = Column(String(64), nullable=False, default="", comment="创建人部门ID")
  187. create_time = Column(DateTime, nullable=False, default=datetime.now, comment="创建时间")
  188. update_by = Column(String(64), nullable=True, comment="更新人id")
  189. update_time = Column(DateTime, nullable=False, default=datetime.now, onupdate=datetime.now, comment="更新时间")
  190. del_flag = Column(SmallInteger, nullable=False, default=0, comment="删除标记")
  191. class SysUserPost(Base):
  192. """用户-职位关联 sys_user_post"""
  193. __tablename__ = "sys_user_post"
  194. id = Column(String(64), primary_key=True, comment="主键ID")
  195. user_id = Column(String(64), nullable=False, comment="用户ID")
  196. post_id = Column(String(64), nullable=False, comment="职位ID")
  197. tenant_no = Column(String(64), nullable=False, default="zkxw", comment="租户编号")
  198. order_num = Column(Integer, nullable=True, comment="排序号")
  199. remark = Column(String(512), nullable=True, comment="备注")
  200. create_by = Column(String(64), nullable=True, comment="创建人id")
  201. create_dept_id = Column(String(64), nullable=False, default="", comment="创建人部门ID")
  202. create_time = Column(DateTime, nullable=False, default=datetime.now, comment="创建时间")
  203. update_by = Column(String(64), nullable=True, comment="更新人id")
  204. update_time = Column(DateTime, nullable=False, default=datetime.now, onupdate=datetime.now, comment="更新时间")
  205. del_flag = Column(SmallInteger, nullable=False, default=0, comment="删除标记")
  206. class BizItemUnit(Base):
  207. """物品单位 biz_item_unit"""
  208. __tablename__ = "biz_item_unit"
  209. id = Column(String(64), primary_key=True, comment="主键ID")
  210. unit_code = Column(String(64), nullable=False, comment="单位编码")
  211. unit_name = Column(String(100), nullable=False, comment="单位名称")
  212. tenant_no = Column(String(64), nullable=False, default="zkxw", comment="租户编号")
  213. order_num = Column(Integer, nullable=True, comment="排序号")
  214. remark = Column(String(512), nullable=True, comment="备注")
  215. create_by = Column(String(64), nullable=True, comment="创建人id")
  216. create_dept_id = Column(String(64), nullable=False, default="", comment="创建人部门ID")
  217. create_time = Column(DateTime, nullable=False, default=datetime.now, comment="创建时间")
  218. update_by = Column(String(64), nullable=True, comment="更新人id")
  219. update_time = Column(DateTime, nullable=False, default=datetime.now, onupdate=datetime.now, comment="更新时间")
  220. del_flag = Column(SmallInteger, nullable=False, default=0, comment="删除标记")
  221. class BizExpressCompany(Base):
  222. """快递公司 biz_express_company"""
  223. __tablename__ = "biz_express_company"
  224. id = Column(String(64), primary_key=True, comment="主键ID")
  225. express_code = Column(String(64), nullable=False, comment="快递公司编码")
  226. express_name = Column(String(200), nullable=False, comment="快递公司名称")
  227. tenant_no = Column(String(64), nullable=False, default="zkxw", comment="租户编号")
  228. order_num = Column(Integer, nullable=True, comment="排序号")
  229. remark = Column(String(512), nullable=True, comment="备注")
  230. create_by = Column(String(64), nullable=True, comment="创建人id")
  231. create_dept_id = Column(String(64), nullable=False, default="", comment="创建人部门ID")
  232. create_time = Column(DateTime, nullable=False, default=datetime.now, comment="创建时间")
  233. update_by = Column(String(64), nullable=True, comment="更新人id")
  234. update_time = Column(DateTime, nullable=False, default=datetime.now, onupdate=datetime.now, comment="更新时间")
  235. del_flag = Column(SmallInteger, nullable=False, default=0, comment="删除标记")
  236. class BizCustomer(Base):
  237. """客户 biz_customer"""
  238. __tablename__ = "biz_customer"
  239. id = Column(String(64), primary_key=True, comment="主键ID")
  240. customer_name = Column(String(100), nullable=False, comment="客户姓名")
  241. sex = Column(CHAR(1), nullable=True, default="2", comment="性别(0男1女2未知)")
  242. id_card_no = Column(String(32), nullable=True, comment="身份证号")
  243. age = Column(Integer, nullable=True, comment="年龄")
  244. phone_no = Column(String(32), nullable=True, comment="联系电话")
  245. customer_tags = Column(String(512), nullable=True, comment="客户标签,逗号分隔")
  246. tenant_no = Column(String(64), nullable=False, default="zkxw", comment="租户编号")
  247. order_num = Column(Integer, nullable=True, comment="排序号")
  248. remark = Column(String(512), nullable=True, comment="备注")
  249. create_by = Column(String(64), nullable=True, comment="创建人id")
  250. create_dept_id = Column(String(64), nullable=False, default="", comment="创建人部门ID")
  251. create_time = Column(DateTime, nullable=False, default=datetime.now, comment="创建时间")
  252. update_by = Column(String(64), nullable=True, comment="更新人id")
  253. update_time = Column(DateTime, nullable=False, default=datetime.now, onupdate=datetime.now, comment="更新时间")
  254. del_flag = Column(SmallInteger, nullable=False, default=0, comment="删除标记")
  255. class BizCellSampleType(Base):
  256. """细胞样本类型 biz_cell_sample_type"""
  257. __tablename__ = "biz_cell_sample_type"
  258. id = Column(String(64), primary_key=True, comment="主键ID")
  259. type_code = Column(String(64), nullable=False, comment="样本类型编码")
  260. type_name = Column(String(200), nullable=False, comment="样本类型名称")
  261. storage_years = Column(Integer, nullable=True, comment="样本存储年份")
  262. storage_price = Column(Numeric(18, 2), nullable=True, comment="样本存储价格(元)")
  263. tenant_no = Column(String(64), nullable=False, default="zkxw", comment="租户编号")
  264. order_num = Column(Integer, nullable=True, comment="排序号")
  265. remark = Column(String(512), nullable=True, comment="备注")
  266. create_by = Column(String(64), nullable=True, comment="创建人id")
  267. create_dept_id = Column(String(64), nullable=False, default="", comment="创建人部门ID")
  268. create_time = Column(DateTime, nullable=False, default=datetime.now, comment="创建时间")
  269. update_by = Column(String(64), nullable=True, comment="更新人id")
  270. update_time = Column(DateTime, nullable=False, default=datetime.now, onupdate=datetime.now, comment="更新时间")
  271. del_flag = Column(SmallInteger, nullable=False, default=0, comment="删除标记")
  272. class BizCollectionRegion(Base):
  273. """采集地区 biz_collection_region"""
  274. __tablename__ = "biz_collection_region"
  275. id = Column(String(64), primary_key=True, comment="主键ID")
  276. region_name = Column(String(200), nullable=False, comment="地区名称")
  277. tenant_no = Column(String(64), nullable=False, default="zkxw", comment="租户编号")
  278. order_num = Column(Integer, nullable=True, comment="排序号")
  279. remark = Column(String(512), nullable=True, comment="备注")
  280. create_by = Column(String(64), nullable=True, comment="创建人id")
  281. create_dept_id = Column(String(64), nullable=False, default="", comment="创建人部门ID")
  282. create_time = Column(DateTime, nullable=False, default=datetime.now, comment="创建时间")
  283. update_by = Column(String(64), nullable=True, comment="更新人id")
  284. update_time = Column(DateTime, nullable=False, default=datetime.now, onupdate=datetime.now, comment="更新时间")
  285. del_flag = Column(SmallInteger, nullable=False, default=0, comment="删除标记")
  286. class BizCollectionHospital(Base):
  287. """采集地区下属医院 biz_collection_hospital"""
  288. __tablename__ = "biz_collection_hospital"
  289. id = Column(String(64), primary_key=True, comment="主键ID")
  290. region_id = Column(String(64), nullable=False, comment="采集地区ID")
  291. hospital_name = Column(String(200), nullable=False, comment="医院名称")
  292. tenant_no = Column(String(64), nullable=False, default="zkxw", comment="租户编号")
  293. order_num = Column(Integer, nullable=True, comment="排序号")
  294. remark = Column(String(512), nullable=True, comment="备注")
  295. create_by = Column(String(64), nullable=True, comment="创建人id")
  296. create_dept_id = Column(String(64), nullable=False, default="", comment="创建人部门ID")
  297. create_time = Column(DateTime, nullable=False, default=datetime.now, comment="创建时间")
  298. update_by = Column(String(64), nullable=True, comment="更新人id")
  299. update_time = Column(DateTime, nullable=False, default=datetime.now, onupdate=datetime.now, comment="更新时间")
  300. del_flag = Column(SmallInteger, nullable=False, default=0, comment="删除标记")
  301. class BizCollectionProtocolNo(Base):
  302. """采集协议号池 biz_collection_protocol_no"""
  303. __tablename__ = "biz_collection_protocol_no"
  304. id = Column(String(64), primary_key=True, comment="主键ID")
  305. protocol_no = Column(String(32), nullable=False, comment="采集协议号")
  306. issued = Column(SmallInteger, nullable=False, default=0, comment="是否下发(1是0否)")
  307. issued_user_id = Column(String(64), nullable=True, comment="下发用户ID")
  308. issued_user_name = Column(String(100), nullable=True, comment="下发用户姓名(冗余)")
  309. issued_time = Column(DateTime, nullable=True, comment="下发时间")
  310. tenant_no = Column(String(64), nullable=False, default="zkxw", comment="租户编号")
  311. order_num = Column(Integer, nullable=True, comment="排序号")
  312. remark = Column(String(512), nullable=True, comment="备注")
  313. create_by = Column(String(64), nullable=True, comment="创建人id")
  314. create_dept_id = Column(String(64), nullable=False, default="", comment="创建人部门ID")
  315. create_time = Column(DateTime, nullable=False, default=datetime.now, comment="创建时间")
  316. update_by = Column(String(64), nullable=True, comment="更新人id")
  317. update_time = Column(DateTime, nullable=False, default=datetime.now, onupdate=datetime.now, comment="更新时间")
  318. del_flag = Column(SmallInteger, nullable=False, default=0, comment="删除标记")
  319. class BizSampleCode(Base):
  320. """样本编码池 biz_sample_code"""
  321. __tablename__ = "biz_sample_code"
  322. id = Column(String(64), primary_key=True, comment="主键ID")
  323. sample_code = Column(String(32), nullable=False, comment="样本编码")
  324. sample_code_type = Column(String(16), nullable=True, comment="样本编码类型 zxbm造血编码 qdbm脐带编码")
  325. issued = Column(SmallInteger, nullable=False, default=0, comment="是否下发(1是0否)")
  326. issued_user_id = Column(String(64), nullable=True, comment="下发用户ID")
  327. issued_user_name = Column(String(100), nullable=True, comment="下发用户姓名(冗余)")
  328. issued_time = Column(DateTime, nullable=True, comment="下发时间")
  329. tenant_no = Column(String(64), nullable=False, default="zkxw", comment="租户编号")
  330. order_num = Column(Integer, nullable=True, comment="排序号")
  331. remark = Column(String(512), nullable=True, comment="备注")
  332. create_by = Column(String(64), nullable=True, comment="创建人id")
  333. create_dept_id = Column(String(64), nullable=False, default="", comment="创建人部门ID")
  334. create_time = Column(DateTime, nullable=False, default=datetime.now, comment="创建时间")
  335. update_by = Column(String(64), nullable=True, comment="更新人id")
  336. update_time = Column(DateTime, nullable=False, default=datetime.now, onupdate=datetime.now, comment="更新时间")
  337. del_flag = Column(SmallInteger, nullable=False, default=0, comment="删除标记")
  338. # =============================================================================
  339. # 字典管理(sys_dict_type / sys_dict_data)
  340. # =============================================================================
  341. class SysDictType(Base):
  342. """字典类型 sys_dict_type"""
  343. __tablename__ = "sys_dict_type"
  344. id = Column(String(64), primary_key=True, comment="主键ID")
  345. dict_name = Column(String(100), nullable=False, default="", comment="字典名称")
  346. dict_type = Column(String(100), nullable=False, default="", comment="字典类型编码")
  347. tenant_no = Column(String(64), nullable=False, default="zkxw", comment="租户编号")
  348. order_num = Column(Integer, nullable=True, comment="排序号")
  349. remark = Column(String(512), nullable=True, comment="备注")
  350. create_by = Column(String(64), nullable=True, comment="创建人id")
  351. create_dept_id = Column(String(64), nullable=False, default="", comment="创建人部门ID")
  352. create_time = Column(DateTime, nullable=False, default=datetime.now, comment="创建时间")
  353. update_by = Column(String(64), nullable=True, comment="更新人id")
  354. update_time = Column(DateTime, nullable=False, default=datetime.now, onupdate=datetime.now, comment="更新时间")
  355. del_flag = Column(SmallInteger, nullable=False, default=0, comment="删除标记")
  356. class SysEthnic(Base):
  357. """民族码表 sys_ethnic(国标 GB/T 3304,全局)"""
  358. __tablename__ = "sys_ethnic"
  359. id = Column(String(64), primary_key=True, comment="主键ID")
  360. ethnic_name = Column(String(64), nullable=False, default="", comment="民族名称")
  361. ethnic_code = Column(String(16), nullable=False, default="", comment="民族编码")
  362. tenant_no = Column(String(64), nullable=False, default="", comment="租户编号(空=全局)")
  363. order_num = Column(Integer, nullable=True, comment="排序号")
  364. remark = Column(String(512), nullable=True, comment="备注")
  365. create_by = Column(String(64), nullable=True, comment="创建人id")
  366. create_dept_id = Column(String(64), nullable=False, default="", comment="创建人部门ID")
  367. create_time = Column(DateTime, nullable=False, default=datetime.now, comment="创建时间")
  368. update_by = Column(String(64), nullable=True, comment="更新人id")
  369. update_time = Column(DateTime, nullable=False, default=datetime.now, onupdate=datetime.now, comment="更新时间")
  370. del_flag = Column(SmallInteger, nullable=False, default=0, comment="删除标记")
  371. class SysDictData(Base):
  372. """字典数据 sys_dict_data"""
  373. __tablename__ = "sys_dict_data"
  374. id = Column(String(64), primary_key=True, comment="主键ID")
  375. dict_label = Column(String(100), nullable=False, default="", comment="字典标签")
  376. dict_value = Column(String(100), nullable=False, default="", comment="字典键值")
  377. dict_type = Column(String(100), nullable=False, default="", comment="字典类型")
  378. tenant_no = Column(String(64), nullable=False, default="zkxw", comment="租户编号")
  379. order_num = Column(Integer, nullable=True, comment="排序号")
  380. remark = Column(String(512), nullable=True, comment="备注")
  381. create_by = Column(String(64), nullable=True, comment="创建人id")
  382. create_dept_id = Column(String(64), nullable=False, default="", comment="创建人部门ID")
  383. create_time = Column(DateTime, nullable=False, default=datetime.now, comment="创建时间")
  384. update_by = Column(String(64), nullable=True, comment="更新人id")
  385. update_time = Column(DateTime, nullable=False, default=datetime.now, onupdate=datetime.now, comment="更新时间")
  386. del_flag = Column(SmallInteger, nullable=False, default=0, comment="删除标记")
  387. # =============================================================================
  388. # 可选:API 请求日志(不在 V0.3 DDL 内;无表时中间件写入会失败并记录 warning)
  389. # =============================================================================
  390. class SysApiRequestLog(Base):
  391. """API 请求日志"""
  392. __tablename__ = "sys_api_request_log"
  393. id = Column(String(64), primary_key=True, comment="主键ID")
  394. http_method = Column(String(10), nullable=False, comment="HTTP 方法")
  395. path = Column(String(500), nullable=False, comment="请求路径")
  396. query_string = Column(String(2000), nullable=True, comment="Query 字符串")
  397. request_body = Column(Text, nullable=True, comment="请求体(截断)")
  398. response_body = Column(Text, nullable=True, comment="响应体(截断)")
  399. status_code = Column(Integer, nullable=False, comment="HTTP 状态码")
  400. duration_ms = Column(Integer, nullable=False, comment="耗时(ms)")
  401. user_id = Column(String(64), nullable=True, comment="用户ID(JWT 解析)")
  402. username = Column(String(100), nullable=True, comment="用户名")
  403. role = Column(String(64), nullable=True, comment="角色")
  404. ip_address = Column(String(50), nullable=True, comment="IP地址")
  405. user_agent = Column(String(500), nullable=True, comment="User-Agent")
  406. is_del = Column(Integer, default=0, comment="是否删除")
  407. create_at = Column(DateTime, default=datetime.now, comment="创建时间")
  408. create_by = Column(String(32), nullable=True, comment="创建人ID")
  409. create_name = Column(String(100), nullable=True, comment="创建人姓名")
  410. update_at = Column(DateTime, default=datetime.now, onupdate=datetime.now, comment="修改时间")
  411. update_by = Column(String(32), nullable=True, comment="修改人ID")
  412. class SysApiRequestLogHis(Base):
  413. """API 请求日志历史表"""
  414. __tablename__ = "sys_api_request_log_his"
  415. id = Column(String(64), primary_key=True, nullable=False, comment="主键ID")
  416. http_method = Column(String(10), nullable=False, comment="HTTP 方法")
  417. path = Column(String(500), nullable=False, comment="请求路径")
  418. query_string = Column(String(2000), nullable=True, comment="Query 字符串")
  419. request_body = Column(Text, nullable=True, comment="请求体(截断)")
  420. response_body = Column(Text, nullable=True, comment="响应体(截断)")
  421. status_code = Column(Integer, nullable=False, comment="HTTP 状态码")
  422. duration_ms = Column(Integer, nullable=False, comment="耗时(ms)")
  423. user_id = Column(String(64), nullable=True, comment="用户ID")
  424. username = Column(String(100), nullable=True, comment="用户名")
  425. role = Column(String(64), nullable=True, comment="角色")
  426. ip_address = Column(String(50), nullable=True, comment="IP地址")
  427. user_agent = Column(String(500), nullable=True, comment="User-Agent")
  428. create_at = Column(DateTime, default=datetime.now, comment="创建时间")
  429. create_by = Column(String(32), nullable=True, comment="创建人ID")
  430. create_name = Column(String(100), nullable=True, comment="创建人姓名")
  431. update_at = Column(DateTime, nullable=True, comment="修改时间")
  432. update_by = Column(String(32), nullable=True, comment="修改人ID")
  433. his_create_at = Column(DateTime, default=datetime.now, comment="历史记录创建时间")
  434. # =============================================================================
  435. # 业务表(biz_leave_request)
  436. # =============================================================================
  437. class BizLeaveRequest(Base):
  438. """请假申请 biz_leave_request"""
  439. __tablename__ = "biz_leave_request"
  440. id = Column(String(64), primary_key=True, comment="主键ID")
  441. leave_type = Column(String(32), nullable=False, default="personal", comment="请假类型: personal/sick/annual/other")
  442. start_date = Column(String(20), nullable=False, comment="开始日期")
  443. end_date = Column(String(20), nullable=False, comment="结束日期")
  444. days = Column(Integer, nullable=False, default=1, comment="请假天数")
  445. reason = Column(String(500), nullable=True, comment="请假原因")
  446. wf_instance_id = Column(String(64), nullable=True, comment="流程实例ID")
  447. status = Column(String(32), nullable=False, default="draft", comment="状态: draft/pending/approved/rejected/cancelled")
  448. tenant_no = Column(String(64), nullable=False, default="zkxw", comment="租户编号")
  449. order_num = Column(Integer, nullable=True, comment="排序号")
  450. remark = Column(String(512), nullable=True, comment="备注")
  451. create_by = Column(String(64), nullable=True, comment="创建人id")
  452. create_dept_id = Column(String(64), nullable=False, default="", comment="创建人部门ID")
  453. create_time = Column(DateTime, nullable=False, default=datetime.now, comment="创建时间")
  454. update_by = Column(String(64), nullable=True, comment="更新人id")
  455. update_time = Column(DateTime, nullable=False, default=datetime.now, onupdate=datetime.now, comment="更新时间")
  456. del_flag = Column(SmallInteger, nullable=False, default=0, comment="删除标记:0-正常 1-已删除")
  457. # =============================================================================
  458. # 工作流(wf_process_def / wf_process_version / wf_node / wf_transition / wf_process_instance / wf_task)
  459. # =============================================================================
  460. class WfProcessDef(Base):
  461. """流程定义 wf_process_def"""
  462. __tablename__ = "wf_process_def"
  463. id = Column(String(64), primary_key=True, comment="主键ID")
  464. process_code = Column(String(64), nullable=False, comment="流程编码")
  465. process_name = Column(String(200), nullable=False, comment="流程名称")
  466. status = Column(CHAR(1), nullable=False, default="1", comment="1启用 0停用")
  467. tenant_no = Column(String(64), nullable=False, default="zkxw", comment="租户编号")
  468. order_num = Column(Integer, nullable=True, comment="排序号")
  469. remark = Column(String(512), nullable=True, comment="备注")
  470. create_by = Column(String(64), nullable=True, comment="创建人id")
  471. create_dept_id = Column(String(64), nullable=False, default="", comment="创建人部门ID")
  472. create_time = Column(DateTime, nullable=False, default=datetime.now, comment="创建时间")
  473. update_by = Column(String(64), nullable=True, comment="更新人id")
  474. update_time = Column(DateTime, nullable=False, default=datetime.now, onupdate=datetime.now, comment="更新时间")
  475. del_flag = Column(SmallInteger, nullable=False, default=0, comment="删除标记:0-正常 1-已删除")
  476. class WfProcessVersion(Base):
  477. """流程定义版本 wf_process_version"""
  478. __tablename__ = "wf_process_version"
  479. id = Column(String(64), primary_key=True, comment="主键ID")
  480. process_def_id = Column(String(64), nullable=False, comment="流程定义ID")
  481. version_no = Column(Integer, nullable=False, comment="版本号,递增")
  482. graph_json = Column(Text, nullable=True, comment="节点与连线等配置(JSON 字符串)")
  483. is_latest = Column(CHAR(1), nullable=True, default="0", comment="是否最新版本(1是 0否)")
  484. tenant_no = Column(String(64), nullable=False, default="zkxw", comment="租户编号")
  485. order_num = Column(Integer, nullable=True, comment="排序号")
  486. remark = Column(String(512), nullable=True, comment="备注")
  487. create_by = Column(String(64), nullable=True, comment="创建人id")
  488. create_dept_id = Column(String(64), nullable=False, default="", comment="创建人部门ID")
  489. create_time = Column(DateTime, nullable=False, default=datetime.now, comment="创建时间")
  490. update_by = Column(String(64), nullable=True, comment="更新人id")
  491. update_time = Column(DateTime, nullable=False, default=datetime.now, onupdate=datetime.now, comment="更新时间")
  492. del_flag = Column(SmallInteger, nullable=False, default=0, comment="删除标记:0-正常 1-已删除")
  493. class WfNode(Base):
  494. """流程节点 wf_node"""
  495. __tablename__ = "wf_node"
  496. id = Column(String(64), primary_key=True, comment="主键ID")
  497. process_version_id = Column(String(64), nullable=False, comment="流程版本ID")
  498. node_key = Column(String(64), nullable=False, comment="节点唯一键(画布内)")
  499. node_type = Column(String(32), nullable=False, comment="start/end/approval/condition 等")
  500. node_name = Column(String(200), nullable=True, comment="节点名称")
  501. config_json = Column(Text, nullable=True, comment="审批人/SQL/会签策略等配置")
  502. tenant_no = Column(String(64), nullable=False, default="zkxw", comment="租户编号")
  503. order_num = Column(Integer, nullable=True, comment="排序号")
  504. remark = Column(String(512), nullable=True, comment="备注")
  505. create_by = Column(String(64), nullable=True, comment="创建人id")
  506. create_dept_id = Column(String(64), nullable=False, default="", comment="创建人部门ID")
  507. create_time = Column(DateTime, nullable=False, default=datetime.now, comment="创建时间")
  508. update_by = Column(String(64), nullable=True, comment="更新人id")
  509. update_time = Column(DateTime, nullable=False, default=datetime.now, onupdate=datetime.now, comment="更新时间")
  510. del_flag = Column(SmallInteger, nullable=False, default=0, comment="删除标记:0-正常 1-已删除")
  511. class WfTransition(Base):
  512. """流程连线/转移 wf_transition"""
  513. __tablename__ = "wf_transition"
  514. id = Column(String(64), primary_key=True, comment="主键ID")
  515. process_version_id = Column(String(64), nullable=False, comment="流程版本ID")
  516. from_node_key = Column(String(64), nullable=False, comment="起始节点key")
  517. to_node_key = Column(String(64), nullable=False, comment="目标节点key")
  518. condition_expr = Column(String(512), nullable=True, comment="条件表达式或分支说明")
  519. tenant_no = Column(String(64), nullable=False, default="zkxw", comment="租户编号")
  520. order_num = Column(Integer, nullable=True, comment="排序号")
  521. remark = Column(String(512), nullable=True, comment="备注")
  522. create_by = Column(String(64), nullable=True, comment="创建人id")
  523. create_dept_id = Column(String(64), nullable=False, default="", comment="创建人部门ID")
  524. create_time = Column(DateTime, nullable=False, default=datetime.now, comment="创建时间")
  525. update_by = Column(String(64), nullable=True, comment="更新人id")
  526. update_time = Column(DateTime, nullable=False, default=datetime.now, onupdate=datetime.now, comment="更新时间")
  527. del_flag = Column(SmallInteger, nullable=False, default=0, comment="删除标记:0-正常 1-已删除")
  528. class WfProcessInstance(Base):
  529. """流程实例 wf_process_instance"""
  530. __tablename__ = "wf_process_instance"
  531. id = Column(String(64), primary_key=True, comment="主键ID")
  532. process_version_id = Column(String(64), nullable=False, comment="发起时锁定的流程版本ID")
  533. business_type = Column(String(64), nullable=True, comment="业务类型")
  534. business_id = Column(String(64), nullable=True, comment="业务主键")
  535. starter_user_id = Column(String(64), nullable=True, comment="发起人")
  536. variables_json = Column(Text, nullable=True, comment="流程变量 JSON")
  537. status = Column(String(32), nullable=True, comment="running/completed/rejected 等")
  538. callback_url = Column(String(512), nullable=True, comment="业务回调地址")
  539. tenant_no = Column(String(64), nullable=False, default="zkxw", comment="租户编号")
  540. order_num = Column(Integer, nullable=True, comment="排序号")
  541. remark = Column(String(512), nullable=True, comment="备注")
  542. create_by = Column(String(64), nullable=True, comment="创建人id")
  543. create_dept_id = Column(String(64), nullable=False, default="", comment="创建人部门ID")
  544. create_time = Column(DateTime, nullable=False, default=datetime.now, comment="创建时间")
  545. update_by = Column(String(64), nullable=True, comment="更新人id")
  546. update_time = Column(DateTime, nullable=False, default=datetime.now, onupdate=datetime.now, comment="更新时间")
  547. del_flag = Column(SmallInteger, nullable=False, default=0, comment="删除标记:0-正常 1-已删除")
  548. class WfTask(Base):
  549. """流程任务/待办 wf_task"""
  550. __tablename__ = "wf_task"
  551. id = Column(String(64), primary_key=True, comment="主键ID")
  552. instance_id = Column(String(64), nullable=False, comment="流程实例ID")
  553. node_key = Column(String(64), nullable=True, comment="当前节点key")
  554. assignee_user_id = Column(String(64), nullable=True, comment="待办人")
  555. status = Column(String(32), nullable=True, comment="pending/approved/rejected 等")
  556. comment_text = Column(String(512), nullable=True, comment="审批意见")
  557. tenant_no = Column(String(64), nullable=False, default="zkxw", comment="租户编号")
  558. order_num = Column(Integer, nullable=True, comment="排序号")
  559. remark = Column(String(512), nullable=True, comment="备注")
  560. create_by = Column(String(64), nullable=True, comment="创建人id")
  561. create_dept_id = Column(String(64), nullable=False, default="", comment="创建人部门ID")
  562. create_time = Column(DateTime, nullable=False, default=datetime.now, comment="创建时间")
  563. update_by = Column(String(64), nullable=True, comment="更新人id")
  564. update_time = Column(DateTime, nullable=False, default=datetime.now, onupdate=datetime.now, comment="更新时间")
  565. del_flag = Column(SmallInteger, nullable=False, default=0, comment="删除标记:0-正常 1-已删除")
  566. # =============================================================================
  567. # 细胞存储 — 采集协议单(biz_collection_protocol / audit / payment)
  568. # =============================================================================
  569. class BizCollectionProtocol(Base):
  570. """采集协议单 biz_collection_protocol"""
  571. __tablename__ = "biz_collection_protocol"
  572. id = Column(String(64), primary_key=True, comment="主键ID")
  573. protocol_no_id = Column(String(64), nullable=True, comment="采集协议号表ID")
  574. protocol_no = Column(String(32), nullable=False, comment="采集协议号展示")
  575. protocol_status = Column(String(16), nullable=False, default="dsx", comment="协议状态")
  576. protocol_attachments = Column(String(4000), nullable=True, comment="协议附件")
  577. register_date = Column(CHAR(8), nullable=True, comment="登记日期YYYYMMDD")
  578. effective_time = Column(DateTime, nullable=True, comment="协议生效时间")
  579. effective_desc = Column(String(512), nullable=True, comment="协议生效描述")
  580. expire_time = Column(DateTime, nullable=True, comment="协议过期时间")
  581. expire_desc = Column(String(512), nullable=True, comment="协议过期描述")
  582. void_time = Column(DateTime, nullable=True, comment="协议作废时间")
  583. void_desc = Column(String(512), nullable=True, comment="协议作废描述")
  584. to_research_time = Column(DateTime, nullable=True, comment="协议转科研时间")
  585. to_research_desc = Column(String(512), nullable=True, comment="协议转科研描述")
  586. collector_user_id = Column(String(64), nullable=True, comment="采集专员用户ID")
  587. tenant_no = Column(String(64), nullable=False, default="zkxw", comment="租户编号")
  588. order_num = Column(Integer, nullable=True, comment="排序号")
  589. remark = Column(String(512), nullable=True, comment="备注信息")
  590. create_by = Column(String(64), nullable=True, comment="创建人id")
  591. create_dept_id = Column(String(64), nullable=False, default="", comment="创建人部门ID")
  592. create_time = Column(DateTime, nullable=False, default=datetime.now, comment="创建时间")
  593. update_by = Column(String(64), nullable=True, comment="更新人id")
  594. update_time = Column(DateTime, nullable=False, default=datetime.now, onupdate=datetime.now, comment="更新时间")
  595. del_flag = Column(SmallInteger, nullable=False, default=0, comment="删除标记")
  596. class BizProtocolAudit(Base):
  597. """采集协议单-审核记录 biz_protocol_audit"""
  598. __tablename__ = "biz_protocol_audit"
  599. id = Column(String(64), primary_key=True, comment="主键ID")
  600. collection_protocol_id = Column(String(64), nullable=False, comment="采集协议单ID")
  601. auditor_user_id = Column(String(64), nullable=True, comment="审核人")
  602. audit_remark = Column(String(1000), nullable=True, comment="审核备注")
  603. audit_status = Column(String(16), nullable=False, comment="审核状态 shtg/shth")
  604. tenant_no = Column(String(64), nullable=False, default="zkxw", comment="租户编号")
  605. order_num = Column(Integer, nullable=True, comment="排序号")
  606. remark = Column(String(512), nullable=True, comment="备注")
  607. create_by = Column(String(64), nullable=True, comment="创建人id")
  608. create_dept_id = Column(String(64), nullable=False, default="", comment="创建人部门ID")
  609. create_time = Column(DateTime, nullable=False, default=datetime.now, comment="创建时间")
  610. update_by = Column(String(64), nullable=True, comment="更新人id")
  611. update_time = Column(DateTime, nullable=False, default=datetime.now, onupdate=datetime.now, comment="更新时间")
  612. del_flag = Column(SmallInteger, nullable=False, default=0, comment="删除标记")
  613. class BizProtocolPayment(Base):
  614. """采集协议单-缴费主表 biz_protocol_payment"""
  615. __tablename__ = "biz_protocol_payment"
  616. id = Column(String(64), primary_key=True, comment="主键ID")
  617. collection_protocol_id = Column(String(64), nullable=False, comment="采集协议单ID")
  618. pay_mode = Column(String(8), nullable=False, comment="dj趸交 fq分期")
  619. contract_amount = Column(Numeric(18, 2), nullable=True, comment="合同金额")
  620. installment_count = Column(Integer, nullable=True, comment="分期期数")
  621. installment_interval_months = Column(Integer, nullable=True, comment="每期间隔(月)")
  622. lump_sum_deadline = Column(CHAR(8), nullable=True, comment="趸交截止时间YYYYMMDD")
  623. installment_start_date = Column(CHAR(8), nullable=True, comment="分期开始YYYYMMDD")
  624. tenant_no = Column(String(64), nullable=False, default="zkxw", comment="租户编号")
  625. order_num = Column(Integer, nullable=True, comment="排序号")
  626. remark = Column(String(512), nullable=True, comment="备注")
  627. create_by = Column(String(64), nullable=True, comment="创建人id")
  628. create_dept_id = Column(String(64), nullable=False, default="", comment="创建人部门ID")
  629. create_time = Column(DateTime, nullable=False, default=datetime.now, comment="创建时间")
  630. update_by = Column(String(64), nullable=True, comment="更新人id")
  631. update_time = Column(DateTime, nullable=False, default=datetime.now, onupdate=datetime.now, comment="更新时间")
  632. del_flag = Column(SmallInteger, nullable=False, default=0, comment="删除标记")
  633. class BizProtocolPaymentDetail(Base):
  634. """采集协议单-缴费明细 biz_protocol_payment_detail"""
  635. __tablename__ = "biz_protocol_payment_detail"
  636. id = Column(String(64), primary_key=True, comment="主键ID")
  637. payment_id = Column(String(64), nullable=False, comment="缴费主表ID")
  638. transfer_type = Column(String(16), nullable=True, comment="转账方式")
  639. due_amount = Column(Numeric(18, 2), nullable=True, comment="应缴费金额")
  640. transfer_amount = Column(Numeric(18, 2), nullable=True, comment="转账金额")
  641. transfer_time = Column(DateTime, nullable=True, comment="转账时间")
  642. transfer_attachments = Column(Text, nullable=True, comment="转账附件")
  643. finance_confirm_attachments = Column(Text, nullable=True, comment="缴费财务确认附件")
  644. finance_remark = Column(String(512), nullable=True, comment="缴费财务确认备注")
  645. refund_finance_confirm_attachments = Column(Text, nullable=True, comment="财务退费确认附件")
  646. refund_finance_remark = Column(String(512), nullable=True, comment="财务退费确认备注")
  647. pay_status = Column(String(32), nullable=False, default="dfj", comment="缴费状态")
  648. installment_no = Column(Integer, nullable=True, comment="分期期序号")
  649. installment_due_date = Column(CHAR(8), nullable=True, comment="分期应缴日期YYYYMMDD")
  650. refund_amount = Column(Numeric(18, 2), nullable=True, comment="退费金额")
  651. refund_remark = Column(String(512), nullable=True, comment="退费备注")
  652. refund_attachments = Column(Text, nullable=True, comment="退费附件逗号分隔")
  653. tenant_no = Column(String(64), nullable=False, default="zkxw", comment="租户编号")
  654. order_num = Column(Integer, nullable=True, comment="排序号")
  655. remark = Column(String(512), nullable=True, comment="备注")
  656. create_by = Column(String(64), nullable=True, comment="创建人id")
  657. create_dept_id = Column(String(64), nullable=False, default="", comment="创建人部门ID")
  658. create_time = Column(DateTime, nullable=False, default=datetime.now, comment="创建时间")
  659. update_by = Column(String(64), nullable=True, comment="更新人id")
  660. update_time = Column(DateTime, nullable=False, default=datetime.now, onupdate=datetime.now, comment="更新时间")
  661. del_flag = Column(SmallInteger, nullable=False, default=0, comment="删除标记")
  662. class BizProtocolPartyCustomer(Base):
  663. """采集协议单-当事人客户信息 biz_protocol_party_customer"""
  664. __tablename__ = "biz_protocol_party_customer"
  665. id = Column(String(64), primary_key=True, comment="主键ID")
  666. collection_protocol_id = Column(String(64), nullable=False, comment="采集协议单ID")
  667. customer_id = Column(String(64), nullable=True, comment="客户ID")
  668. mother_name = Column(String(100), nullable=True, comment="母亲姓名")
  669. mother_phone = Column(String(32), nullable=True, comment="母亲电话")
  670. mother_id_card = Column(String(32), nullable=True, comment="母亲身份证号")
  671. mother_birth_ym = Column(CHAR(6), nullable=True, comment="母亲出生年月YYYYMM")
  672. mother_ethnic = Column(String(32), nullable=True, comment="母亲民族")
  673. mother_address = Column(String(512), nullable=True, comment="母亲地址")
  674. father_name = Column(String(100), nullable=True, comment="父亲姓名")
  675. father_phone = Column(String(32), nullable=True, comment="父亲电话")
  676. father_id_card = Column(String(32), nullable=True, comment="父亲身份证号")
  677. newborn_name = Column(String(100), nullable=True, comment="新生儿姓名")
  678. newborn_id_card = Column(String(32), nullable=True, comment="新生儿身份证号")
  679. newborn_delivery_time = Column(DateTime, nullable=True, comment="新生儿分娩时间")
  680. newborn_sex = Column(CHAR(1), nullable=True, comment="新生儿性别")
  681. delivery_mode = Column(String(16), nullable=True, comment="分娩方式")
  682. birth_order = Column(Integer, nullable=True, comment="出生顺序")
  683. newborn_weight_gram = Column(Integer, nullable=True, comment="新生儿体重(克)")
  684. apgar_1min = Column(Numeric(4, 1), nullable=True, comment="Apgar 1分钟评分")
  685. apgar_5min = Column(Numeric(4, 1), nullable=True, comment="Apgar 5分钟评分")
  686. collector_user_id = Column(String(64), nullable=True, comment="采集专员用户ID")
  687. tenant_no = Column(String(64), nullable=False, default="zkxw", comment="租户编号")
  688. order_num = Column(Integer, nullable=True, comment="排序号")
  689. remark = Column(String(512), nullable=True, comment="备注")
  690. create_by = Column(String(64), nullable=True, comment="创建人id")
  691. create_dept_id = Column(String(64), nullable=False, default="", comment="创建人部门ID")
  692. create_time = Column(DateTime, nullable=False, default=datetime.now, comment="创建时间")
  693. update_by = Column(String(64), nullable=True, comment="更新人id")
  694. update_time = Column(DateTime, nullable=False, default=datetime.now, onupdate=datetime.now, comment="更新时间")
  695. del_flag = Column(SmallInteger, nullable=False, default=0, comment="删除标记")
  696. class BizProtocolCollectionInfo(Base):
  697. """采集协议单-采集信息 biz_protocol_collection_info"""
  698. __tablename__ = "biz_protocol_collection_info"
  699. id = Column(String(64), primary_key=True, comment="主键ID")
  700. collection_protocol_id = Column(String(64), nullable=False, comment="采集协议单ID")
  701. region_id = Column(String(64), nullable=True, comment="区域ID")
  702. hospital_id = Column(String(64), nullable=True, comment="医院ID")
  703. medical_staff = Column(String(200), nullable=True, comment="医护人员")
  704. sales_user_id = Column(String(64), nullable=True, comment="销售人员用户ID")
  705. sample_collect_time = Column(DateTime, nullable=True, comment="样本采集时间")
  706. maternal_blood_collect_time = Column(DateTime, nullable=True, comment="母血采集时间")
  707. tenant_no = Column(String(64), nullable=False, default="zkxw", comment="租户编号")
  708. order_num = Column(Integer, nullable=True, comment="排序号")
  709. remark = Column(String(512), nullable=True, comment="备注")
  710. create_by = Column(String(64), nullable=True, comment="创建人id")
  711. create_dept_id = Column(String(64), nullable=False, default="", comment="创建人部门ID")
  712. create_time = Column(DateTime, nullable=False, default=datetime.now, comment="创建时间")
  713. update_by = Column(String(64), nullable=True, comment="更新人id")
  714. update_time = Column(DateTime, nullable=False, default=datetime.now, onupdate=datetime.now, comment="更新时间")
  715. del_flag = Column(SmallInteger, nullable=False, default=0, comment="删除标记")
  716. class BizProtocolSample(Base):
  717. """采集协议单-样本信息 biz_protocol_sample"""
  718. __tablename__ = "biz_protocol_sample"
  719. id = Column(String(64), primary_key=True, comment="主键ID")
  720. collection_protocol_id = Column(String(64), nullable=False, comment="采集协议单ID")
  721. sample_type_id = Column(String(64), nullable=True, comment="样本类型ID")
  722. sample_code_id = Column(String(64), nullable=True, comment="样本编码ID")
  723. sample_code = Column(String(32), nullable=True, comment="样本编码")
  724. collect_amount = Column(Numeric(18, 4), nullable=True, comment="采集量")
  725. unit_id = Column(String(64), nullable=True, comment="单位ID")
  726. price = Column(Numeric(18, 2), nullable=True, comment="价格")
  727. storage_years = Column(Integer, nullable=True, comment="存储年限")
  728. sample_status = Column(String(16), nullable=True, comment="样本状态")
  729. storage_in_date = Column(CHAR(8), nullable=True, comment="入库日期YYYYMMDD")
  730. detect_start_date = Column(CHAR(8), nullable=True, comment="检测开始日期YYYYMMDD")
  731. void_date = Column(CHAR(8), nullable=True, comment="作废日期YYYYMMDD")
  732. storage_expire_date = Column(CHAR(8), nullable=True, comment="存储到期日期YYYYMMDD")
  733. tenant_no = Column(String(64), nullable=False, default="zkxw", comment="租户编号")
  734. order_num = Column(Integer, nullable=True, comment="排序号")
  735. remark = Column(String(512), nullable=True, comment="备注")
  736. create_by = Column(String(64), nullable=True, comment="创建人id")
  737. create_dept_id = Column(String(64), nullable=False, default="", comment="创建人部门ID")
  738. create_time = Column(DateTime, nullable=False, default=datetime.now, comment="创建时间")
  739. update_by = Column(String(64), nullable=True, comment="更新人id")
  740. update_time = Column(DateTime, nullable=False, default=datetime.now, onupdate=datetime.now, comment="更新时间")
  741. del_flag = Column(SmallInteger, nullable=False, default=0, comment="删除标记")
  742. class BizProtocolSampleTransport(Base):
  743. """采集协议单-样本运输 biz_protocol_sample_transport"""
  744. __tablename__ = "biz_protocol_sample_transport"
  745. id = Column(String(64), primary_key=True, comment="主键ID")
  746. collection_protocol_id = Column(String(64), nullable=False, comment="采集协议单ID")
  747. sample_id = Column(String(64), nullable=False, comment="样本ID")
  748. sample_code = Column(String(32), nullable=True, comment="样本编码快照")
  749. transport_type = Column(String(16), nullable=False, comment="kdys快递运输 ryxd人员携带")
  750. express_company_id = Column(String(64), nullable=True, comment="快递公司ID")
  751. waybill_no = Column(String(128), nullable=True, comment="快递单号")
  752. dest_site_id = Column(String(64), nullable=True, comment="目的站点ID")
  753. express_fee = Column(Numeric(18, 2), nullable=True, comment="快递费用(元)")
  754. eta_time = Column(DateTime, nullable=True, comment="预计到达时间")
  755. carrier_name = Column(String(100), nullable=True, comment="携带人员姓名")
  756. carrier_phone = Column(String(32), nullable=True, comment="携带人员联系电话")
  757. tenant_no = Column(String(64), nullable=False, default="zkxw", comment="租户编号")
  758. order_num = Column(Integer, nullable=True, comment="排序号")
  759. remark = Column(String(512), nullable=True, comment="备注")
  760. create_by = Column(String(64), nullable=True, comment="创建人id")
  761. create_dept_id = Column(String(64), nullable=False, default="", comment="创建人部门ID")
  762. create_time = Column(DateTime, nullable=False, default=datetime.now, comment="创建时间")
  763. update_by = Column(String(64), nullable=True, comment="更新人id")
  764. update_time = Column(DateTime, nullable=False, default=datetime.now, onupdate=datetime.now, comment="更新时间")
  765. del_flag = Column(SmallInteger, nullable=False, default=0, comment="删除标记")
  766. class BizAttachment(Base):
  767. """业务附件 biz_attachment"""
  768. __tablename__ = "biz_attachment"
  769. id = Column(String(64), primary_key=True, comment="主键ID")
  770. business_type = Column(String(50), nullable=True, comment="业务类型")
  771. business_id = Column(String(64), nullable=True, comment="业务主键ID")
  772. original_name = Column(String(200), nullable=False, comment="原始文件名")
  773. file_ext = Column(String(20), nullable=True, comment="文件后缀名")
  774. file_url = Column(String(500), nullable=False, comment="MinIO路径后缀")
  775. file_size = Column(Integer, nullable=True, comment="文件大小(字节)")
  776. file_type = Column(String(50), nullable=True, comment="MIME类型")
  777. tenant_no = Column(String(64), nullable=False, default="zkxw", comment="租户编号")
  778. order_num = Column(Integer, nullable=True, comment="排序号")
  779. remark = Column(String(512), nullable=True, comment="备注")
  780. create_by = Column(String(64), nullable=True, comment="创建人id")
  781. create_dept_id = Column(String(64), nullable=False, default="", comment="创建人部门ID")
  782. create_time = Column(DateTime, nullable=False, default=datetime.now, comment="创建时间")
  783. update_by = Column(String(64), nullable=True, comment="更新人id")
  784. update_time = Column(DateTime, nullable=False, default=datetime.now, onupdate=datetime.now, comment="更新时间")
  785. del_flag = Column(SmallInteger, nullable=False, default=0, comment="删除标记")
  786. class BizProtocolStorageCert(Base):
  787. """采集协议单-储存证书 biz_protocol_storage_cert"""
  788. __tablename__ = "biz_protocol_storage_cert"
  789. id = Column(String(64), primary_key=True, comment="主键ID")
  790. collection_protocol_id = Column(String(64), nullable=False, comment="采集协议单ID")
  791. make_status = Column(CHAR(1), nullable=True, default="0", comment="制作状态 0-未制作 1-已制作")
  792. cert_image_urls = Column(String(4000), nullable=True, comment="证书图片URLs")
  793. make_date = Column(CHAR(8), nullable=True, comment="制作日期YYYYMMDD")
  794. tenant_no = Column(String(64), nullable=False, default="zkxw", comment="租户编号")
  795. order_num = Column(Integer, nullable=True, comment="排序号")
  796. remark = Column(String(512), nullable=True, comment="备注")
  797. create_by = Column(String(64), nullable=True, comment="创建人id")
  798. create_dept_id = Column(String(64), nullable=False, default="", comment="创建人部门ID")
  799. create_time = Column(DateTime, nullable=False, default=datetime.now, comment="创建时间")
  800. update_by = Column(String(64), nullable=True, comment="更新人id")
  801. update_time = Column(DateTime, nullable=False, default=datetime.now, onupdate=datetime.now, comment="更新时间")
  802. del_flag = Column(SmallInteger, nullable=False, default=0, comment="删除标记")
  803. class BizSampleReceptionCheckItem(Base):
  804. """样本接收检查项配置 biz_sample_reception_check_item"""
  805. __tablename__ = "biz_sample_reception_check_item"
  806. id = Column(String(64), primary_key=True, comment="主键ID")
  807. item_code = Column(String(64), nullable=False, comment="检查项编码")
  808. item_name = Column(String(200), nullable=False, comment="检查项名称")
  809. status = Column(String(1), nullable=False, default="1", comment="1启用 0停用")
  810. tenant_no = Column(String(64), nullable=False, default="zkxw", comment="租户编号")
  811. order_num = Column(Integer, nullable=True, comment="排序号")
  812. remark = Column(String(512), nullable=True, comment="备注")
  813. create_by = Column(String(64), nullable=True, comment="创建人id")
  814. create_dept_id = Column(String(64), nullable=False, default="", comment="创建人部门ID")
  815. create_time = Column(DateTime, nullable=False, default=datetime.now, comment="创建时间")
  816. update_by = Column(String(64), nullable=True, comment="更新人id")
  817. update_time = Column(DateTime, nullable=False, default=datetime.now, onupdate=datetime.now, comment="更新时间")
  818. del_flag = Column(SmallInteger, nullable=False, default=0, comment="删除标记")
  819. class BizSampleReceptionCheckResult(Base):
  820. """样本接收检查项结果 biz_sample_reception_check_result"""
  821. __tablename__ = "biz_sample_reception_check_result"
  822. id = Column(String(64), primary_key=True, comment="主键ID")
  823. reception_id = Column(String(64), nullable=False, comment="接收记录ID")
  824. check_item_id = Column(String(64), nullable=False, comment="检查项配置ID")
  825. item_code = Column(String(64), nullable=False, comment="检查项编码快照")
  826. item_name = Column(String(200), nullable=False, comment="检查项名称快照")
  827. checked = Column(SmallInteger, nullable=False, default=0, comment="是否勾选")
  828. tenant_no = Column(String(64), nullable=False, default="zkxw", comment="租户编号")
  829. order_num = Column(Integer, nullable=True, comment="排序号快照")
  830. remark = Column(String(512), nullable=True, comment="备注")
  831. create_by = Column(String(64), nullable=True, comment="创建人id")
  832. create_dept_id = Column(String(64), nullable=False, default="", comment="创建人部门ID")
  833. create_time = Column(DateTime, nullable=False, default=datetime.now, comment="创建时间")
  834. update_by = Column(String(64), nullable=True, comment="更新人id")
  835. update_time = Column(DateTime, nullable=False, default=datetime.now, onupdate=datetime.now, comment="更新时间")
  836. del_flag = Column(SmallInteger, nullable=False, default=0, comment="删除标记")
  837. class BizSampleReception(Base):
  838. """样本接收 biz_sample_reception"""
  839. __tablename__ = "biz_sample_reception"
  840. id = Column(String(64), primary_key=True, comment="主键ID")
  841. protocol_sample_id = Column(String(64), nullable=False, comment="协议样本ID")
  842. collection_protocol_id = Column(String(64), nullable=False, comment="采集协议单ID")
  843. reception_time = Column(DateTime, nullable=False, comment="样本接收时间")
  844. handler_user_id = Column(String(64), nullable=True, comment="经手人用户ID")
  845. handler_name = Column(String(100), nullable=True, comment="经手人姓名")
  846. receive_temperature = Column(String(32), nullable=True, comment="接收温度")
  847. volume_ml = Column(Numeric(18, 4), nullable=True, comment="体积(ml)")
  848. net_weight_g = Column(Numeric(18, 4), nullable=True, comment="净重(g)")
  849. check_packaging = Column(SmallInteger, nullable=False, default=0, comment="包装检查")
  850. check_sealing = Column(SmallInteger, nullable=False, default=0, comment="封口检查")
  851. check_no_damage = Column(SmallInteger, nullable=False, default=0, comment="无破损")
  852. check_no_leakage = Column(SmallInteger, nullable=False, default=0, comment="无漏液")
  853. check_color = Column(SmallInteger, nullable=False, default=0, comment="颜色")
  854. check_tying_rope = Column(SmallInteger, nullable=False, default=0, comment="系绳")
  855. check_no_stratification = Column(SmallInteger, nullable=False, default=0, comment="无分层")
  856. accept_conclusion = Column(String(16), nullable=False, comment="结论 js接收 bj拒收")
  857. receive_attachments = Column(String(4000), nullable=True, comment="接收附件")
  858. reception_source = Column(String(20), nullable=False, default="cell_storage", comment="来源类型 cell_storage细胞存储 research_donation科研捐赠")
  859. donation_sample_id = Column(String(64), nullable=True, comment="捐赠样本ID(仅科研捐赠)")
  860. research_donation_id = Column(String(64), nullable=True, comment="科研捐赠单ID(仅科研捐赠)")
  861. sample_code = Column(String(32), nullable=True, comment="样本编码快照")
  862. tenant_no = Column(String(64), nullable=False, default="zkxw", comment="租户编号")
  863. order_num = Column(Integer, nullable=True, comment="排序号")
  864. remark = Column(String(512), nullable=True, comment="备注信息")
  865. create_by = Column(String(64), nullable=True, comment="创建人id")
  866. create_dept_id = Column(String(64), nullable=False, default="", comment="创建人部门ID")
  867. create_time = Column(DateTime, nullable=False, default=datetime.now, comment="创建时间")
  868. update_by = Column(String(64), nullable=True, comment="更新人id")
  869. update_time = Column(DateTime, nullable=False, default=datetime.now, onupdate=datetime.now, comment="更新时间")
  870. del_flag = Column(SmallInteger, nullable=False, default=0, comment="删除标记")
  871. # =============================================================================
  872. # 质量检测 — 第三方/实验室主数据、质检工单、质检任务
  873. # =============================================================================
  874. class BizQcThirdPartyCompany(Base):
  875. """第三方检测公司 biz_qc_third_party_company"""
  876. __tablename__ = "biz_qc_third_party_company"
  877. id = Column(String(64), primary_key=True, comment="主键ID")
  878. company_code = Column(String(64), nullable=False, comment="公司编码")
  879. company_name = Column(String(200), nullable=False, comment="公司名称")
  880. contact_name = Column(String(100), nullable=True, comment="联系人")
  881. contact_phone = Column(String(32), nullable=True, comment="联系电话")
  882. address = Column(String(500), nullable=True, comment="地址")
  883. invoice_title = Column(String(200), nullable=True, comment="发票抬头")
  884. tax_id = Column(String(64), nullable=True, comment="纳税人识别号")
  885. bank_name = Column(String(200), nullable=True, comment="开户银行")
  886. bank_account = Column(String(64), nullable=True, comment="银行账号")
  887. status = Column(String(1), nullable=False, default="1", comment="1启用 0停用")
  888. tenant_no = Column(String(64), nullable=False, default="zkxw", comment="租户编号")
  889. order_num = Column(Integer, nullable=True, comment="排序号")
  890. remark = Column(String(512), nullable=True, comment="备注")
  891. create_by = Column(String(64), nullable=True, comment="创建人id")
  892. create_dept_id = Column(String(64), nullable=False, default="", comment="创建人部门ID")
  893. create_time = Column(DateTime, nullable=False, default=datetime.now, comment="创建时间")
  894. update_by = Column(String(64), nullable=True, comment="更新人id")
  895. update_time = Column(DateTime, nullable=False, default=datetime.now, onupdate=datetime.now, comment="更新时间")
  896. del_flag = Column(SmallInteger, nullable=False, default=0, comment="删除标记")
  897. class BizQcThirdPartyItem(Base):
  898. """第三方检测项目 biz_qc_third_party_item"""
  899. __tablename__ = "biz_qc_third_party_item"
  900. id = Column(String(64), primary_key=True, comment="主键ID")
  901. company_id = Column(String(64), nullable=False, comment="第三方公司ID")
  902. item_code = Column(String(64), nullable=False, comment="项目编码")
  903. item_name = Column(String(200), nullable=False, comment="项目名称")
  904. fee_amount = Column(Numeric(18, 2), nullable=False, default=0, comment="费用元")
  905. status = Column(String(1), nullable=False, default="1", comment="1启用 0停用")
  906. tenant_no = Column(String(64), nullable=False, default="zkxw", comment="租户编号")
  907. order_num = Column(Integer, nullable=True, comment="排序号")
  908. remark = Column(String(512), nullable=True, comment="备注")
  909. create_by = Column(String(64), nullable=True, comment="创建人id")
  910. create_dept_id = Column(String(64), nullable=False, default="", comment="创建人部门ID")
  911. create_time = Column(DateTime, nullable=False, default=datetime.now, comment="创建时间")
  912. update_by = Column(String(64), nullable=True, comment="更新人id")
  913. update_time = Column(DateTime, nullable=False, default=datetime.now, onupdate=datetime.now, comment="更新时间")
  914. del_flag = Column(SmallInteger, nullable=False, default=0, comment="删除标记")
  915. class BizQcLabTestItem(Base):
  916. """实验室自检项目 biz_qc_lab_test_item"""
  917. __tablename__ = "biz_qc_lab_test_item"
  918. id = Column(String(64), primary_key=True, comment="主键ID")
  919. item_code = Column(String(64), nullable=False, comment="项目编码")
  920. item_name = Column(String(200), nullable=False, comment="项目名称")
  921. description = Column(String(500), nullable=True, comment="描述")
  922. status = Column(String(1), nullable=False, default="1", comment="1启用 0停用")
  923. tenant_no = Column(String(64), nullable=False, default="zkxw", comment="租户编号")
  924. order_num = Column(Integer, nullable=True, comment="排序号")
  925. remark = Column(String(512), nullable=True, comment="备注")
  926. create_by = Column(String(64), nullable=True, comment="创建人id")
  927. create_dept_id = Column(String(64), nullable=False, default="", comment="创建人部门ID")
  928. create_time = Column(DateTime, nullable=False, default=datetime.now, comment="创建时间")
  929. update_by = Column(String(64), nullable=True, comment="更新人id")
  930. update_time = Column(DateTime, nullable=False, default=datetime.now, onupdate=datetime.now, comment="更新时间")
  931. del_flag = Column(SmallInteger, nullable=False, default=0, comment="删除标记")
  932. class BizQcWorkOrder(Base):
  933. """质检工单 biz_qc_work_order"""
  934. __tablename__ = "biz_qc_work_order"
  935. id = Column(String(64), primary_key=True, comment="主键ID")
  936. work_order_no = Column(String(32), nullable=False, comment="工单号")
  937. reception_id = Column(String(64), nullable=False, comment="接收记录ID")
  938. protocol_sample_id = Column(String(64), nullable=False, comment="协议样本ID")
  939. collection_protocol_id = Column(String(64), nullable=False, comment="协议单ID")
  940. protocol_no = Column(String(64), nullable=True, comment="协议号快照")
  941. sample_code = Column(String(32), nullable=True, comment="样本编码快照")
  942. reception_source = Column(String(20), nullable=False, default="cell_storage", comment="来源类型 cell_storage/research_donation")
  943. qc_biz_type = Column(
  944. String(20),
  945. nullable=False,
  946. default="inbound",
  947. comment="质检业务类型 inbound入库质检 outbound出库质检",
  948. )
  949. work_order_status = Column(String(16), nullable=False, default="dpz", comment="工单状态")
  950. has_lab = Column(String(1), nullable=False, default="0", comment="含实验室自检")
  951. has_third_party = Column(String(1), nullable=False, default="0", comment="含第三方检测")
  952. configured_time = Column(DateTime, nullable=True, comment="配置时间")
  953. configured_by = Column(String(64), nullable=True, comment="配置人")
  954. third_party_fee_total = Column(Numeric(18, 2), nullable=True, comment="第三方费用合计")
  955. tenant_no = Column(String(64), nullable=False, default="zkxw", comment="租户编号")
  956. order_num = Column(Integer, nullable=True, comment="排序号")
  957. remark = Column(String(512), nullable=True, comment="备注")
  958. create_by = Column(String(64), nullable=True, comment="创建人id")
  959. create_dept_id = Column(String(64), nullable=False, default="", comment="创建人部门ID")
  960. create_time = Column(DateTime, nullable=False, default=datetime.now, comment="创建时间")
  961. update_by = Column(String(64), nullable=True, comment="更新人id")
  962. update_time = Column(DateTime, nullable=False, default=datetime.now, onupdate=datetime.now, comment="更新时间")
  963. del_flag = Column(SmallInteger, nullable=False, default=0, comment="删除标记")
  964. class BizQcWorkOrderLabItem(Base):
  965. """质检工单-实验室项目明细 biz_qc_work_order_lab_item"""
  966. __tablename__ = "biz_qc_work_order_lab_item"
  967. id = Column(String(64), primary_key=True, comment="主键ID")
  968. work_order_id = Column(String(64), nullable=False, comment="工单ID")
  969. lab_test_item_id = Column(String(64), nullable=False, comment="实验室项目ID")
  970. item_code = Column(String(64), nullable=False, comment="项目编码快照")
  971. item_name = Column(String(200), nullable=False, comment="项目名称快照")
  972. tenant_no = Column(String(64), nullable=False, default="zkxw", comment="租户编号")
  973. order_num = Column(Integer, nullable=True, comment="排序号")
  974. remark = Column(String(512), nullable=True, comment="备注")
  975. create_by = Column(String(64), nullable=True, comment="创建人id")
  976. create_dept_id = Column(String(64), nullable=False, default="", comment="创建人部门ID")
  977. create_time = Column(DateTime, nullable=False, default=datetime.now, comment="创建时间")
  978. update_by = Column(String(64), nullable=True, comment="更新人id")
  979. update_time = Column(DateTime, nullable=False, default=datetime.now, onupdate=datetime.now, comment="更新时间")
  980. del_flag = Column(SmallInteger, nullable=False, default=0, comment="删除标记")
  981. class BizQcWorkOrderThirdItem(Base):
  982. """质检工单-第三方项目明细 biz_qc_work_order_third_item"""
  983. __tablename__ = "biz_qc_work_order_third_item"
  984. id = Column(String(64), primary_key=True, comment="主键ID")
  985. work_order_id = Column(String(64), nullable=False, comment="工单ID")
  986. third_party_item_id = Column(String(64), nullable=False, comment="第三方项目ID")
  987. company_id = Column(String(64), nullable=False, comment="公司ID")
  988. company_name = Column(String(200), nullable=False, comment="公司名快照")
  989. item_code = Column(String(64), nullable=False, comment="项目编码快照")
  990. item_name = Column(String(200), nullable=False, comment="项目名称快照")
  991. fee_amount = Column(Numeric(18, 2), nullable=False, default=0, comment="费用快照")
  992. tenant_no = Column(String(64), nullable=False, default="zkxw", comment="租户编号")
  993. order_num = Column(Integer, nullable=True, comment="排序号")
  994. remark = Column(String(512), nullable=True, comment="备注")
  995. create_by = Column(String(64), nullable=True, comment="创建人id")
  996. create_dept_id = Column(String(64), nullable=False, default="", comment="创建人部门ID")
  997. create_time = Column(DateTime, nullable=False, default=datetime.now, comment="创建时间")
  998. update_by = Column(String(64), nullable=True, comment="更新人id")
  999. update_time = Column(DateTime, nullable=False, default=datetime.now, onupdate=datetime.now, comment="更新时间")
  1000. del_flag = Column(SmallInteger, nullable=False, default=0, comment="删除标记")
  1001. class BizQcTask(Base):
  1002. """质检任务 biz_qc_task"""
  1003. __tablename__ = "biz_qc_task"
  1004. id = Column(String(64), primary_key=True, comment="主键ID")
  1005. work_order_id = Column(String(64), nullable=False, comment="工单ID")
  1006. task_no = Column(String(32), nullable=False, comment="任务号")
  1007. task_type = Column(String(16), nullable=False, comment="sysz实验室 dsfjc第三方")
  1008. source_line_id = Column(String(64), nullable=False, comment="工单明细行ID")
  1009. sample_code = Column(String(32), nullable=True, comment="样本编码快照")
  1010. item_code = Column(String(64), nullable=False, comment="项目编码快照")
  1011. item_name = Column(String(200), nullable=False, comment="项目名称快照")
  1012. company_id = Column(String(64), nullable=True, comment="第三方公司ID")
  1013. company_name = Column(String(200), nullable=True, comment="第三方公司名")
  1014. fee_amount = Column(Numeric(18, 2), nullable=True, comment="费用快照")
  1015. task_status = Column(String(16), nullable=False, default="dzx", comment="任务状态")
  1016. conclusion = Column(String(16), nullable=True, comment="检测结论 tg通过 btg不通过")
  1017. third_party_attachments = Column(String(4000), nullable=True, comment="第三方材料")
  1018. completed_time = Column(DateTime, nullable=True, comment="完成时间")
  1019. completed_by = Column(String(64), nullable=True, comment="完成人")
  1020. tenant_no = Column(String(64), nullable=False, default="zkxw", comment="租户编号")
  1021. order_num = Column(Integer, nullable=True, comment="排序号")
  1022. remark = Column(String(512), nullable=True, comment="备注")
  1023. create_by = Column(String(64), nullable=True, comment="创建人id")
  1024. create_dept_id = Column(String(64), nullable=False, default="", comment="创建人部门ID")
  1025. create_time = Column(DateTime, nullable=False, default=datetime.now, comment="创建时间")
  1026. update_by = Column(String(64), nullable=True, comment="更新人id")
  1027. update_time = Column(DateTime, nullable=False, default=datetime.now, onupdate=datetime.now, comment="更新时间")
  1028. del_flag = Column(SmallInteger, nullable=False, default=0, comment="删除标记")
  1029. # =============================================================================
  1030. # V0.4 运营支撑(2.4 洁净室管理 / 库位管理 / 展馆预约)
  1031. # =============================================================================
  1032. class BizCleanRoom(Base):
  1033. """洁净室 biz_clean_room"""
  1034. __tablename__ = "biz_clean_room"
  1035. id = Column(String(64), primary_key=True, comment="主键ID")
  1036. room_code = Column(String(64), nullable=False, comment="编号")
  1037. room_name = Column(String(200), nullable=False, comment="名称")
  1038. room_grade = Column(String(8), nullable=True, comment="等级 A/B/C/D")
  1039. room_status = Column(String(16), nullable=False, default="zc", comment="zc正常 yc异常")
  1040. area_sqm = Column(Numeric(12, 2), nullable=True, comment="面积m²")
  1041. tenant_no = Column(String(64), nullable=False, default="zkxw", comment="租户编号")
  1042. order_num = Column(Integer, nullable=True, comment="排序号")
  1043. remark = Column(String(512), nullable=True, comment="备注")
  1044. create_by = Column(String(64), nullable=True, comment="创建人id")
  1045. create_dept_id = Column(String(64), nullable=False, default="", comment="创建人部门ID")
  1046. create_time = Column(DateTime, nullable=False, default=datetime.now, comment="创建时间")
  1047. update_by = Column(String(64), nullable=True, comment="更新人id")
  1048. update_time = Column(DateTime, nullable=False, default=datetime.now, onupdate=datetime.now, comment="更新时间")
  1049. del_flag = Column(SmallInteger, nullable=False, default=0, comment="删除标记")
  1050. class BizCleanRoomAccessLog(Base):
  1051. """洁净室出入记录 biz_clean_room_access_log"""
  1052. __tablename__ = "biz_clean_room_access_log"
  1053. id = Column(String(64), primary_key=True, comment="主键ID")
  1054. clean_room_id = Column(String(64), nullable=False, comment="洁净室ID")
  1055. user_id = Column(String(64), nullable=True, comment="人员用户ID")
  1056. person_name = Column(String(100), nullable=True, comment="人员姓名(冗余)")
  1057. dept_name = Column(String(200), nullable=True, comment="部门")
  1058. enter_time = Column(DateTime, nullable=False, comment="进入时间")
  1059. purpose = Column(String(512), nullable=True, comment="目的")
  1060. leave_time = Column(DateTime, nullable=True, comment="离开时间")
  1061. body_temp = Column(String(32), nullable=True, comment="体温")
  1062. tenant_no = Column(String(64), nullable=False, default="zkxw", comment="租户编号")
  1063. order_num = Column(Integer, nullable=True, comment="排序号")
  1064. remark = Column(String(512), nullable=True, comment="备注")
  1065. create_by = Column(String(64), nullable=True, comment="创建人id")
  1066. create_dept_id = Column(String(64), nullable=False, default="", comment="创建人部门ID")
  1067. create_time = Column(DateTime, nullable=False, default=datetime.now, comment="创建时间")
  1068. update_by = Column(String(64), nullable=True, comment="更新人id")
  1069. update_time = Column(DateTime, nullable=False, default=datetime.now, onupdate=datetime.now, comment="更新时间")
  1070. del_flag = Column(SmallInteger, nullable=False, default=0, comment="删除标记")
  1071. class BizStorageFacility(Base):
  1072. """存储设施树 biz_storage_facility"""
  1073. __tablename__ = "biz_storage_facility"
  1074. id = Column(String(64), primary_key=True, comment="主键ID")
  1075. parent_id = Column(String(64), nullable=False, default="0", comment="父节点ID,0根")
  1076. node_name = Column(String(200), nullable=False, comment="节点名称(罐/层/盒等)")
  1077. node_type = Column(String(32), nullable=True, comment="facility/layer/box 等扩展")
  1078. is_leaf = Column(SmallInteger, nullable=False, default=0, comment="是否叶子存储位 1是")
  1079. tenant_no = Column(String(64), nullable=False, default="zkxw", comment="租户编号")
  1080. order_num = Column(Integer, nullable=True, comment="排序号")
  1081. remark = Column(String(512), nullable=True, comment="备注")
  1082. create_by = Column(String(64), nullable=True, comment="创建人id")
  1083. create_dept_id = Column(String(64), nullable=False, default="", comment="创建人部门ID")
  1084. create_time = Column(DateTime, nullable=False, default=datetime.now, comment="创建时间")
  1085. update_by = Column(String(64), nullable=True, comment="更新人id")
  1086. update_time = Column(DateTime, nullable=False, default=datetime.now, onupdate=datetime.now, comment="更新时间")
  1087. del_flag = Column(SmallInteger, nullable=False, default=0, comment="删除标记")
  1088. class BizStorageFacilitySlot(Base):
  1089. """存储设施小格 biz_storage_facility_slot"""
  1090. __tablename__ = "biz_storage_facility_slot"
  1091. id = Column(String(64), primary_key=True, comment="主键ID")
  1092. facility_node_id = Column(String(64), nullable=False, comment="设施树叶子节点ID")
  1093. slot_code = Column(String(64), nullable=True, comment="小格编码/坐标")
  1094. slot_status = Column(String(16), nullable=True, comment="占用状态等扩展")
  1095. tenant_no = Column(String(64), nullable=False, default="zkxw", comment="租户编号")
  1096. order_num = Column(Integer, nullable=True, comment="排序号")
  1097. remark = Column(String(512), nullable=True, comment="备注")
  1098. create_by = Column(String(64), nullable=True, comment="创建人id")
  1099. create_dept_id = Column(String(64), nullable=False, default="", comment="创建人部门ID")
  1100. create_time = Column(DateTime, nullable=False, default=datetime.now, comment="创建时间")
  1101. update_by = Column(String(64), nullable=True, comment="更新人id")
  1102. update_time = Column(DateTime, nullable=False, default=datetime.now, onupdate=datetime.now, comment="更新时间")
  1103. del_flag = Column(SmallInteger, nullable=False, default=0, comment="删除标记")
  1104. class BizExhibitionAppointment(Base):
  1105. """展馆预约 biz_exhibition_appointment"""
  1106. __tablename__ = "biz_exhibition_appointment"
  1107. id = Column(String(64), primary_key=True, comment="主键ID")
  1108. appointment_no = Column(String(64), nullable=False, comment="预约编号")
  1109. visit_org = Column(String(200), nullable=True, comment="来访单位")
  1110. contact_name = Column(String(100), nullable=True, comment="联系人")
  1111. visit_date = Column(DateTime, nullable=True, comment="到访日期")
  1112. visitor_count = Column(Integer, nullable=True, comment="人数")
  1113. reception_user_id = Column(String(64), nullable=True, comment="接待人员用户ID")
  1114. tenant_no = Column(String(64), nullable=False, default="zkxw", comment="租户编号")
  1115. order_num = Column(Integer, nullable=True, comment="排序号")
  1116. remark = Column(String(512), nullable=True, comment="备注")
  1117. create_by = Column(String(64), nullable=True, comment="创建人id")
  1118. create_dept_id = Column(String(64), nullable=False, default="", comment="创建人部门ID")
  1119. create_time = Column(DateTime, nullable=False, default=datetime.now, comment="创建时间")
  1120. update_by = Column(String(64), nullable=True, comment="更新人id")
  1121. update_time = Column(DateTime, nullable=False, default=datetime.now, onupdate=datetime.now, comment="更新时间")
  1122. del_flag = Column(SmallInteger, nullable=False, default=0, comment="删除标记")
  1123. # =============================================================================
  1124. # V0.3 中试服务管理(2.3.1 ~ 2.3.6)
  1125. # =============================================================================
  1126. class BizCellProductType(Base):
  1127. """细胞产品类型 biz_cell_product_type"""
  1128. __tablename__ = "biz_cell_product_type"
  1129. id = Column(String(64), primary_key=True, comment="主键ID")
  1130. product_type_code = Column(String(64), nullable=False, comment="细胞产品类型编码")
  1131. product_type_name = Column(String(200), nullable=False, comment="细胞产品类型名称")
  1132. tenant_no = Column(String(64), nullable=False, default="zkxw", comment="租户编号")
  1133. order_num = Column(Integer, nullable=True, comment="排序号")
  1134. remark = Column(String(512), nullable=True, comment="备注")
  1135. create_by = Column(String(64), nullable=True, comment="创建人id")
  1136. create_dept_id = Column(String(64), nullable=False, default="", comment="创建人部门ID")
  1137. create_time = Column(DateTime, nullable=False, default=datetime.now, comment="创建时间")
  1138. update_by = Column(String(64), nullable=True, comment="更新人id")
  1139. update_time = Column(DateTime, nullable=False, default=datetime.now, onupdate=datetime.now, comment="更新时间")
  1140. del_flag = Column(SmallInteger, nullable=False, default=0, comment="删除标记")
  1141. class BizCellProductSpec(Base):
  1142. """细胞产品规格 biz_cell_product_spec"""
  1143. __tablename__ = "biz_cell_product_spec"
  1144. id = Column(String(64), primary_key=True, comment="主键ID")
  1145. spec_code = Column(String(64), nullable=False, comment="规格编码")
  1146. spec_name = Column(String(200), nullable=False, comment="规格名称")
  1147. tenant_no = Column(String(64), nullable=False, default="zkxw", comment="租户编号")
  1148. order_num = Column(Integer, nullable=True, comment="排序号")
  1149. remark = Column(String(512), nullable=True, comment="备注")
  1150. create_by = Column(String(64), nullable=True, comment="创建人id")
  1151. create_dept_id = Column(String(64), nullable=False, default="", comment="创建人部门ID")
  1152. create_time = Column(DateTime, nullable=False, default=datetime.now, comment="创建时间")
  1153. update_by = Column(String(64), nullable=True, comment="更新人id")
  1154. update_time = Column(DateTime, nullable=False, default=datetime.now, onupdate=datetime.now, comment="更新时间")
  1155. del_flag = Column(SmallInteger, nullable=False, default=0, comment="删除标记")
  1156. class BizCellProductPrice(Base):
  1157. """细胞产品价格体系 biz_cell_product_price"""
  1158. __tablename__ = "biz_cell_product_price"
  1159. id = Column(String(64), primary_key=True, comment="主键ID")
  1160. project_name = Column(String(200), nullable=False, comment="项目名称")
  1161. project_code = Column(String(64), nullable=False, comment="项目编码")
  1162. cell_type_code = Column(String(64), nullable=True, comment="细胞类型编码")
  1163. cell_type_name = Column(String(200), nullable=True, comment="细胞类型名称")
  1164. spec_text = Column(String(200), nullable=True, comment="规格(展示或关联规格编码)")
  1165. spec_id = Column(String(64), nullable=True, comment="规格ID")
  1166. cell_product_type_id = Column(String(64), nullable=True, comment="细胞产品类型ID")
  1167. unit_price = Column(Numeric(18, 2), nullable=True, comment="单价(元)")
  1168. tenant_no = Column(String(64), nullable=False, default="zkxw", comment="租户编号")
  1169. order_num = Column(Integer, nullable=True, comment="排序号")
  1170. remark = Column(String(512), nullable=True, comment="备注")
  1171. create_by = Column(String(64), nullable=True, comment="创建人id")
  1172. create_dept_id = Column(String(64), nullable=False, default="", comment="创建人部门ID")
  1173. create_time = Column(DateTime, nullable=False, default=datetime.now, comment="创建时间")
  1174. update_by = Column(String(64), nullable=True, comment="更新人id")
  1175. update_time = Column(DateTime, nullable=False, default=datetime.now, onupdate=datetime.now, comment="更新时间")
  1176. del_flag = Column(SmallInteger, nullable=False, default=0, comment="删除标记")
  1177. class BizCellProductProjectSystem(Base):
  1178. """细胞产品项目价格体系 biz_cell_product_project_system"""
  1179. __tablename__ = "biz_cell_product_project_system"
  1180. id = Column(String(64), primary_key=True, comment="主键ID")
  1181. system_name = Column(String(200), nullable=False, comment="体系名称")
  1182. system_code = Column(String(64), nullable=False, comment="体系编码")
  1183. status = Column(CHAR(1), nullable=False, default="1", comment="1正常 0停用")
  1184. tenant_no = Column(String(64), nullable=False, default="zkxw", comment="租户编号")
  1185. order_num = Column(Integer, nullable=True, comment="排序号")
  1186. remark = Column(String(512), nullable=True, comment="备注")
  1187. create_by = Column(String(64), nullable=True, comment="创建人id")
  1188. create_dept_id = Column(String(64), nullable=False, default="", comment="创建人部门ID")
  1189. create_time = Column(DateTime, nullable=False, default=datetime.now, comment="创建时间")
  1190. update_by = Column(String(64), nullable=True, comment="更新人id")
  1191. update_time = Column(DateTime, nullable=False, default=datetime.now, onupdate=datetime.now, comment="更新时间")
  1192. del_flag = Column(SmallInteger, nullable=False, default=0, comment="删除标记")
  1193. class BizCellProductProjectSystemItem(Base):
  1194. """项目价格体系-细胞价格明细 biz_cell_product_project_system_item"""
  1195. __tablename__ = "biz_cell_product_project_system_item"
  1196. id = Column(String(64), primary_key=True, comment="主键ID")
  1197. project_system_id = Column(String(64), nullable=False, comment="项目价格体系ID")
  1198. source_price_id = Column(String(64), nullable=True, comment="来源细胞产品价格体系行ID")
  1199. project_name = Column(String(200), nullable=True, comment="项目名称")
  1200. project_code = Column(String(64), nullable=True, comment="项目编码")
  1201. cell_type_code = Column(String(64), nullable=True, comment="细胞类型编码")
  1202. cell_type_name = Column(String(200), nullable=True, comment="细胞类型名称")
  1203. spec_text = Column(String(200), nullable=True, comment="规格")
  1204. spec_id = Column(String(64), nullable=True, comment="规格ID")
  1205. cell_product_type_id = Column(String(64), nullable=True, comment="细胞产品类型ID")
  1206. unit_price = Column(Numeric(18, 2), nullable=True, comment="单价(元)")
  1207. tenant_no = Column(String(64), nullable=False, default="zkxw", comment="租户编号")
  1208. order_num = Column(Integer, nullable=True, comment="排序号")
  1209. remark = Column(String(512), nullable=True, comment="备注")
  1210. create_by = Column(String(64), nullable=True, comment="创建人id")
  1211. create_dept_id = Column(String(64), nullable=False, default="", comment="创建人部门ID")
  1212. create_time = Column(DateTime, nullable=False, default=datetime.now, comment="创建时间")
  1213. update_by = Column(String(64), nullable=True, comment="更新人id")
  1214. update_time = Column(DateTime, nullable=False, default=datetime.now, onupdate=datetime.now, comment="更新时间")
  1215. del_flag = Column(SmallInteger, nullable=False, default=0, comment="删除标记")
  1216. class BizChannel(Base):
  1217. """渠道信息 biz_channel"""
  1218. __tablename__ = "biz_channel"
  1219. id = Column(String(64), primary_key=True, comment="主键ID")
  1220. channel_name = Column(String(200), nullable=False, comment="渠道名称")
  1221. credit_code = Column(String(64), nullable=True, comment="统一社会信用代码")
  1222. channel_type = Column(String(16), nullable=True, comment="yy医院 hzjg合作机构 zs诊所 zfjg政府机构 qt其他")
  1223. contact_name = Column(String(100), nullable=True, comment="联系人姓名")
  1224. contact_phone = Column(String(32), nullable=True, comment="联系电话")
  1225. contact_email = Column(String(128), nullable=True, comment="联系邮箱")
  1226. protocol_attachments = Column(String(4000), nullable=True, comment="渠道协议附件逗号分隔")
  1227. tenant_no = Column(String(64), nullable=False, default="zkxw", comment="租户编号")
  1228. order_num = Column(Integer, nullable=True, comment="排序号")
  1229. remark = Column(String(512), nullable=True, comment="备注")
  1230. create_by = Column(String(64), nullable=True, comment="创建人id")
  1231. create_dept_id = Column(String(64), nullable=False, default="", comment="创建人部门ID")
  1232. create_time = Column(DateTime, nullable=False, default=datetime.now, comment="创建时间")
  1233. update_by = Column(String(64), nullable=True, comment="更新人id")
  1234. update_time = Column(DateTime, nullable=False, default=datetime.now, onupdate=datetime.now, comment="更新时间")
  1235. del_flag = Column(SmallInteger, nullable=False, default=0, comment="删除标记")
  1236. class BizChannelAgreement(Base):
  1237. """渠道协议 biz_channel_agreement"""
  1238. __tablename__ = "biz_channel_agreement"
  1239. id = Column(String(64), primary_key=True, comment="主键ID")
  1240. channel_id = Column(String(64), nullable=False, comment="渠道ID")
  1241. agreement_type = Column(String(16), nullable=False, comment="kyxy科研 zsxy中试 lcxy临床")
  1242. business_type = Column(String(32), nullable=True, comment="kyyy科研应用/中试应用/临床应用(随协议类型)")
  1243. settle_mode = Column(String(16), nullable=True, comment="yj月结 jj季结 nj年结 dcjs单次结算")
  1244. credit_limit_amount = Column(Numeric(18, 2), nullable=True, comment="授信额度(元)")
  1245. effective_date = Column(CHAR(8), nullable=True, comment="生效日期YYYYMMDD")
  1246. expire_date = Column(CHAR(8), nullable=True, comment="到期日期YYYYMMDD")
  1247. agreement_status = Column(String(16), nullable=False, default="dsx", comment="dsx待生效 sxz生效中 yzf已作废")
  1248. tenant_no = Column(String(64), nullable=False, default="zkxw", comment="租户编号")
  1249. order_num = Column(Integer, nullable=True, comment="排序号")
  1250. remark = Column(String(512), nullable=True, comment="备注")
  1251. create_by = Column(String(64), nullable=True, comment="创建人id")
  1252. create_dept_id = Column(String(64), nullable=False, default="", comment="创建人部门ID")
  1253. create_time = Column(DateTime, nullable=False, default=datetime.now, comment="创建时间")
  1254. update_by = Column(String(64), nullable=True, comment="更新人id")
  1255. update_time = Column(DateTime, nullable=False, default=datetime.now, onupdate=datetime.now, comment="更新时间")
  1256. del_flag = Column(SmallInteger, nullable=False, default=0, comment="删除标记")
  1257. class BizChannelAgreementProductPrice(Base):
  1258. """渠道协议-细胞产品价格 biz_channel_agreement_product_price"""
  1259. __tablename__ = "biz_channel_agreement_product_price"
  1260. id = Column(String(64), primary_key=True, comment="主键ID")
  1261. channel_agreement_id = Column(String(64), nullable=False, comment="渠道协议ID")
  1262. project_name = Column(String(200), nullable=True, comment="项目名称")
  1263. project_code = Column(String(64), nullable=True, comment="项目编码")
  1264. cell_type_code = Column(String(64), nullable=True, comment="细胞类型编码")
  1265. cell_type_name = Column(String(200), nullable=True, comment="细胞类型名称")
  1266. spec_text = Column(String(200), nullable=True, comment="规格")
  1267. original_price = Column(Numeric(18, 2), nullable=True, comment="原价(元)")
  1268. agreement_price = Column(Numeric(18, 2), nullable=True, comment="协议价(元)")
  1269. tenant_no = Column(String(64), nullable=False, default="zkxw", comment="租户编号")
  1270. order_num = Column(Integer, nullable=True, comment="排序号")
  1271. remark = Column(String(512), nullable=True, comment="备注")
  1272. create_by = Column(String(64), nullable=True, comment="创建人id")
  1273. create_dept_id = Column(String(64), nullable=False, default="", comment="创建人部门ID")
  1274. create_time = Column(DateTime, nullable=False, default=datetime.now, comment="创建时间")
  1275. update_by = Column(String(64), nullable=True, comment="更新人id")
  1276. update_time = Column(DateTime, nullable=False, default=datetime.now, onupdate=datetime.now, comment="更新时间")
  1277. del_flag = Column(SmallInteger, nullable=False, default=0, comment="删除标记")
  1278. class BizChannelInvoice(Base):
  1279. """渠道开票信息 biz_channel_invoice"""
  1280. __tablename__ = "biz_channel_invoice"
  1281. id = Column(String(64), primary_key=True, comment="主键ID")
  1282. channel_id = Column(String(64), nullable=False, comment="渠道ID")
  1283. company_name = Column(String(200), nullable=False, comment="单位名称")
  1284. tax_no = Column(String(64), nullable=True, comment="税号")
  1285. company_address = Column(String(512), nullable=True, comment="单位地址")
  1286. company_phone = Column(String(64), nullable=True, comment="电话")
  1287. bank_name = Column(String(200), nullable=True, comment="开户银行")
  1288. bank_account = Column(String(64), nullable=True, comment="银行账号")
  1289. tenant_no = Column(String(64), nullable=False, default="zkxw", comment="租户编号")
  1290. order_num = Column(Integer, nullable=True, comment="排序号")
  1291. remark = Column(String(512), nullable=True, comment="备注")
  1292. create_by = Column(String(64), nullable=True, comment="创建人id")
  1293. create_dept_id = Column(String(64), nullable=False, default="", comment="创建人部门ID")
  1294. create_time = Column(DateTime, nullable=False, default=datetime.now, comment="创建时间")
  1295. update_by = Column(String(64), nullable=True, comment="更新人id")
  1296. update_time = Column(DateTime, nullable=False, default=datetime.now, onupdate=datetime.now, comment="更新时间")
  1297. del_flag = Column(SmallInteger, nullable=False, default=0, comment="删除标记")
  1298. class BizChannelMailAddress(Base):
  1299. """渠道邮寄地址 biz_channel_mail_address"""
  1300. __tablename__ = "biz_channel_mail_address"
  1301. id = Column(String(64), primary_key=True, comment="主键ID")
  1302. channel_id = Column(String(64), nullable=False, comment="渠道ID")
  1303. mail_address = Column(String(512), nullable=False, comment="邮寄地址")
  1304. mail_contact = Column(String(100), nullable=True, comment="邮寄联系人")
  1305. mail_phone = Column(String(32), nullable=True, comment="邮寄联系电话")
  1306. tenant_no = Column(String(64), nullable=False, default="zkxw", comment="租户编号")
  1307. order_num = Column(Integer, nullable=True, comment="排序号")
  1308. remark = Column(String(512), nullable=True, comment="备注")
  1309. create_by = Column(String(64), nullable=True, comment="创建人id")
  1310. create_dept_id = Column(String(64), nullable=False, default="", comment="创建人部门ID")
  1311. create_time = Column(DateTime, nullable=False, default=datetime.now, comment="创建时间")
  1312. update_by = Column(String(64), nullable=True, comment="更新人id")
  1313. update_time = Column(DateTime, nullable=False, default=datetime.now, onupdate=datetime.now, comment="更新时间")
  1314. del_flag = Column(SmallInteger, nullable=False, default=0, comment="删除标记")
  1315. class BizCheckupInstitution(Base):
  1316. """体检机构 biz_checkup_institution"""
  1317. __tablename__ = "biz_checkup_institution"
  1318. id = Column(String(64), primary_key=True, comment="主键ID")
  1319. institution_name = Column(String(200), nullable=False, comment="体检机构名称")
  1320. institution_address = Column(String(512), nullable=True, comment="体检机构地址")
  1321. contact_name = Column(String(100), nullable=True, comment="联系人")
  1322. contact_phone = Column(String(32), nullable=True, comment="联系人电话")
  1323. status = Column(CHAR(1), nullable=False, default="1", comment="1正常 0停用")
  1324. tenant_no = Column(String(64), nullable=False, default="zkxw", comment="租户编号")
  1325. order_num = Column(Integer, nullable=True, comment="排序号")
  1326. remark = Column(String(512), nullable=True, comment="备注")
  1327. create_by = Column(String(64), nullable=True, comment="创建人id")
  1328. create_dept_id = Column(String(64), nullable=False, default="", comment="创建人部门ID")
  1329. create_time = Column(DateTime, nullable=False, default=datetime.now, comment="创建时间")
  1330. update_by = Column(String(64), nullable=True, comment="更新人id")
  1331. update_time = Column(DateTime, nullable=False, default=datetime.now, onupdate=datetime.now, comment="更新时间")
  1332. del_flag = Column(SmallInteger, nullable=False, default=0, comment="删除标记")
  1333. class BizCheckupInstitutionInvoice(Base):
  1334. """体检机构开票信息 biz_checkup_institution_invoice"""
  1335. __tablename__ = "biz_checkup_institution_invoice"
  1336. id = Column(String(64), primary_key=True, comment="主键ID")
  1337. checkup_institution_id = Column(String(64), nullable=False, comment="体检机构ID")
  1338. company_name = Column(String(200), nullable=False, comment="单位名称")
  1339. tax_no = Column(String(64), nullable=True, comment="税号")
  1340. company_address = Column(String(512), nullable=True, comment="单位地址")
  1341. company_phone = Column(String(64), nullable=True, comment="电话")
  1342. bank_name = Column(String(200), nullable=True, comment="开户银行")
  1343. bank_account = Column(String(64), nullable=True, comment="银行账号")
  1344. tenant_no = Column(String(64), nullable=False, default="zkxw", comment="租户编号")
  1345. order_num = Column(Integer, nullable=True, comment="排序号")
  1346. remark = Column(String(512), nullable=True, comment="备注")
  1347. create_by = Column(String(64), nullable=True, comment="创建人id")
  1348. create_dept_id = Column(String(64), nullable=False, default="", comment="创建人部门ID")
  1349. create_time = Column(DateTime, nullable=False, default=datetime.now, comment="创建时间")
  1350. update_by = Column(String(64), nullable=True, comment="更新人id")
  1351. update_time = Column(DateTime, nullable=False, default=datetime.now, onupdate=datetime.now, comment="更新时间")
  1352. del_flag = Column(SmallInteger, nullable=False, default=0, comment="删除标记")
  1353. class BizCheckupInstitutionProject(Base):
  1354. """体检机构项目及价格 biz_checkup_institution_project"""
  1355. __tablename__ = "biz_checkup_institution_project"
  1356. id = Column(String(64), primary_key=True, comment="主键ID")
  1357. checkup_institution_id = Column(String(64), nullable=False, comment="体检机构ID")
  1358. project_name = Column(String(200), nullable=False, comment="项目名称")
  1359. project_fee = Column(Numeric(18, 2), nullable=True, comment="项目费用(元)")
  1360. status = Column(CHAR(1), nullable=False, default="1", comment="1正常 0停用")
  1361. tenant_no = Column(String(64), nullable=False, default="zkxw", comment="租户编号")
  1362. order_num = Column(Integer, nullable=True, comment="排序号")
  1363. remark = Column(String(512), nullable=True, comment="备注")
  1364. create_by = Column(String(64), nullable=True, comment="创建人id")
  1365. create_dept_id = Column(String(64), nullable=False, default="", comment="创建人部门ID")
  1366. create_time = Column(DateTime, nullable=False, default=datetime.now, comment="创建时间")
  1367. update_by = Column(String(64), nullable=True, comment="更新人id")
  1368. update_time = Column(DateTime, nullable=False, default=datetime.now, onupdate=datetime.now, comment="更新时间")
  1369. del_flag = Column(SmallInteger, nullable=False, default=0, comment="删除标记")
  1370. class BizCheckupInstitutionPackage(Base):
  1371. """体检机构项目套餐 biz_checkup_institution_package"""
  1372. __tablename__ = "biz_checkup_institution_package"
  1373. id = Column(String(64), primary_key=True, comment="主键ID")
  1374. checkup_institution_id = Column(String(64), nullable=False, comment="体检机构ID")
  1375. package_name = Column(String(200), nullable=False, comment="套餐名称")
  1376. package_code = Column(String(64), nullable=False, comment="套餐编码")
  1377. status = Column(CHAR(1), nullable=False, default="1", comment="1正常 0停用")
  1378. tenant_no = Column(String(64), nullable=False, default="zkxw", comment="租户编号")
  1379. order_num = Column(Integer, nullable=True, comment="排序号")
  1380. remark = Column(String(512), nullable=True, comment="备注")
  1381. create_by = Column(String(64), nullable=True, comment="创建人id")
  1382. create_dept_id = Column(String(64), nullable=False, default="", comment="创建人部门ID")
  1383. create_time = Column(DateTime, nullable=False, default=datetime.now, comment="创建时间")
  1384. update_by = Column(String(64), nullable=True, comment="更新人id")
  1385. update_time = Column(DateTime, nullable=False, default=datetime.now, onupdate=datetime.now, comment="更新时间")
  1386. del_flag = Column(SmallInteger, nullable=False, default=0, comment="删除标记")
  1387. class BizCheckupInstitutionPackageItem(Base):
  1388. """体检机构项目套餐明细 biz_checkup_institution_package_item"""
  1389. __tablename__ = "biz_checkup_institution_package_item"
  1390. id = Column(String(64), primary_key=True, comment="主键ID")
  1391. package_id = Column(String(64), nullable=False, comment="套餐ID")
  1392. checkup_institution_project_id = Column(String(64), nullable=False, comment="机构项目ID")
  1393. project_name = Column(String(200), nullable=False, comment="项目名称快照")
  1394. project_fee = Column(Numeric(18, 2), nullable=True, comment="套餐内项目费用(元)")
  1395. tenant_no = Column(String(64), nullable=False, default="zkxw", comment="租户编号")
  1396. order_num = Column(Integer, nullable=True, comment="排序号")
  1397. remark = Column(String(512), nullable=True, comment="备注")
  1398. create_by = Column(String(64), nullable=True, comment="创建人id")
  1399. create_dept_id = Column(String(64), nullable=False, default="", comment="创建人部门ID")
  1400. create_time = Column(DateTime, nullable=False, default=datetime.now, comment="创建时间")
  1401. update_by = Column(String(64), nullable=True, comment="更新人id")
  1402. update_time = Column(DateTime, nullable=False, default=datetime.now, onupdate=datetime.now, comment="更新时间")
  1403. del_flag = Column(SmallInteger, nullable=False, default=0, comment="删除标记")
  1404. # =============================================================================
  1405. # 生产管理(耗材 / 试剂 / SOP / 工序分类 / 产出类型 / 耗材包 / 工艺库)
  1406. # ============================================================================
  1407. class BizConsumable(Base):
  1408. """生产耗材 biz_consumable"""
  1409. __tablename__ = "biz_consumable"
  1410. id = Column(String(64), primary_key=True, comment="主键ID")
  1411. consumable_code = Column(String(64), nullable=False, comment="耗材编码")
  1412. consumable_name = Column(String(100), nullable=False, comment="耗材名称")
  1413. spec_model = Column(String(200), nullable=True, comment="规格型号")
  1414. standard_usage = Column(String(100), nullable=True, comment="标准用量")
  1415. unit = Column(String(64), nullable=True, comment="单位")
  1416. description = Column(String(500), nullable=True, comment="描述")
  1417. tenant_no = Column(String(64), nullable=False, default="zkxw", comment="租户编号")
  1418. order_num = Column(Integer, nullable=True, comment="排序号")
  1419. remark = Column(String(512), nullable=True, comment="备注")
  1420. create_by = Column(String(64), nullable=True, comment="创建人id")
  1421. create_dept_id = Column(String(64), nullable=False, default="", comment="创建人部门ID")
  1422. create_time = Column(DateTime, nullable=False, default=datetime.now, comment="创建时间")
  1423. update_by = Column(String(64), nullable=True, comment="更新人id")
  1424. update_time = Column(DateTime, nullable=False, default=datetime.now, onupdate=datetime.now, comment="更新时间")
  1425. del_flag = Column(SmallInteger, nullable=False, default=0, comment="删除标记")
  1426. class BizReagent(Base):
  1427. """试剂 biz_reagent"""
  1428. __tablename__ = "biz_reagent"
  1429. id = Column(String(64), primary_key=True, comment="主键ID")
  1430. reagent_code = Column(String(64), nullable=False, comment="试剂编码")
  1431. reagent_name = Column(String(100), nullable=False, comment="试剂名称")
  1432. spec = Column(String(200), nullable=True, comment="规格")
  1433. standard_usage = Column(String(100), nullable=True, comment="标准用量")
  1434. unit = Column(String(64), nullable=True, comment="单位")
  1435. description = Column(String(500), nullable=True, comment="描述")
  1436. tenant_no = Column(String(64), nullable=False, default="zkxw", comment="租户编号")
  1437. order_num = Column(Integer, nullable=True, comment="排序号")
  1438. remark = Column(String(512), nullable=True, comment="备注")
  1439. create_by = Column(String(64), nullable=True, comment="创建人id")
  1440. create_dept_id = Column(String(64), nullable=False, default="", comment="创建人部门ID")
  1441. create_time = Column(DateTime, nullable=False, default=datetime.now, comment="创建时间")
  1442. update_by = Column(String(64), nullable=True, comment="更新人id")
  1443. update_time = Column(DateTime, nullable=False, default=datetime.now, onupdate=datetime.now, comment="更新时间")
  1444. del_flag = Column(SmallInteger, nullable=False, default=0, comment="删除标记")
  1445. class BizSopDocument(Base):
  1446. """SOP文档 biz_sop_document"""
  1447. __tablename__ = "biz_sop_document"
  1448. id = Column(String(64), primary_key=True, comment="主键ID")
  1449. sop_code = Column(String(64), nullable=False, comment="SOP编号")
  1450. sop_name = Column(String(200), nullable=False, comment="SOP文档名称")
  1451. version_no = Column(String(50), nullable=True, comment="版本号")
  1452. sop_attachments = Column(String(2000), nullable=True, comment="SOP文档附件(逗号分隔URL)")
  1453. tenant_no = Column(String(64), nullable=False, default="zkxw", comment="租户编号")
  1454. order_num = Column(Integer, nullable=True, comment="排序号")
  1455. remark = Column(String(512), nullable=True, comment="备注")
  1456. create_by = Column(String(64), nullable=True, comment="创建人id")
  1457. create_dept_id = Column(String(64), nullable=False, default="", comment="创建人部门ID")
  1458. create_time = Column(DateTime, nullable=False, default=datetime.now, comment="创建时间")
  1459. update_by = Column(String(64), nullable=True, comment="更新人id")
  1460. update_time = Column(DateTime, nullable=False, default=datetime.now, onupdate=datetime.now, comment="更新时间")
  1461. del_flag = Column(SmallInteger, nullable=False, default=0, comment="删除标记")
  1462. class BizProcessCategory(Base):
  1463. """工序分类 biz_process_category"""
  1464. __tablename__ = "biz_process_category"
  1465. id = Column(String(64), primary_key=True, comment="主键ID")
  1466. category_code = Column(String(64), nullable=False, comment="分类编码")
  1467. category_name = Column(String(100), nullable=False, comment="分类名称")
  1468. tenant_no = Column(String(64), nullable=False, default="zkxw", comment="租户编号")
  1469. order_num = Column(Integer, nullable=True, comment="排序号")
  1470. remark = Column(String(512), nullable=True, comment="备注")
  1471. create_by = Column(String(64), nullable=True, comment="创建人id")
  1472. create_dept_id = Column(String(64), nullable=False, default="", comment="创建人部门ID")
  1473. create_time = Column(DateTime, nullable=False, default=datetime.now, comment="创建时间")
  1474. update_by = Column(String(64), nullable=True, comment="更新人id")
  1475. update_time = Column(DateTime, nullable=False, default=datetime.now, onupdate=datetime.now, comment="更新时间")
  1476. del_flag = Column(SmallInteger, nullable=False, default=0, comment="删除标记")
  1477. class BizOutputType(Base):
  1478. """产出类型 biz_output_type"""
  1479. __tablename__ = "biz_output_type"
  1480. id = Column(String(64), primary_key=True, comment="主键ID")
  1481. type_code = Column(String(64), nullable=False, comment="类型编码")
  1482. type_name = Column(String(100), nullable=False, comment="类型名称")
  1483. tenant_no = Column(String(64), nullable=False, default="zkxw", comment="租户编号")
  1484. order_num = Column(Integer, nullable=True, comment="排序号")
  1485. remark = Column(String(512), nullable=True, comment="备注")
  1486. create_by = Column(String(64), nullable=True, comment="创建人id")
  1487. create_dept_id = Column(String(64), nullable=False, default="", comment="创建人部门ID")
  1488. create_time = Column(DateTime, nullable=False, default=datetime.now, comment="创建时间")
  1489. update_by = Column(String(64), nullable=True, comment="更新人id")
  1490. update_time = Column(DateTime, nullable=False, default=datetime.now, onupdate=datetime.now, comment="更新时间")
  1491. del_flag = Column(SmallInteger, nullable=False, default=0, comment="删除标记")
  1492. class BizConsumablePack(Base):
  1493. """耗材包 biz_consumable_pack"""
  1494. __tablename__ = "biz_consumable_pack"
  1495. id = Column(String(64), primary_key=True, comment="主键ID")
  1496. pack_code = Column(String(64), nullable=False, comment="编号")
  1497. pack_name = Column(String(100), nullable=False, comment="名称")
  1498. usage_scene = Column(String(200), nullable=True, comment="使用场景")
  1499. pack_type = Column(String(20), nullable=True, comment="类型(bzhcb-标准耗材包 zdyhcb-自定义耗材包)")
  1500. status = Column(CHAR(1), nullable=True, default="1", comment="状态(1-启用 0-停用)")
  1501. tenant_no = Column(String(64), nullable=False, default="zkxw", comment="租户编号")
  1502. order_num = Column(Integer, nullable=True, comment="排序号")
  1503. remark = Column(String(512), nullable=True, comment="备注")
  1504. create_by = Column(String(64), nullable=True, comment="创建人id")
  1505. create_dept_id = Column(String(64), nullable=False, default="", comment="创建人部门ID")
  1506. create_time = Column(DateTime, nullable=False, default=datetime.now, comment="创建时间")
  1507. update_by = Column(String(64), nullable=True, comment="更新人id")
  1508. update_time = Column(DateTime, nullable=False, default=datetime.now, onupdate=datetime.now, comment="更新时间")
  1509. del_flag = Column(SmallInteger, nullable=False, default=0, comment="删除标记")
  1510. class BizConsumablePackItem(Base):
  1511. """耗材包明细 biz_consumable_pack_item"""
  1512. __tablename__ = "biz_consumable_pack_item"
  1513. id = Column(String(64), primary_key=True, comment="主键ID")
  1514. pack_id = Column(String(64), nullable=False, comment="耗材包id")
  1515. consumable_code = Column(String(64), nullable=True, comment="耗材编码")
  1516. consumable_name = Column(String(100), nullable=True, comment="耗材名称")
  1517. spec_model = Column(String(200), nullable=True, comment="耗材规格型号")
  1518. standard_usage = Column(String(100), nullable=True, comment="标准用量")
  1519. unit = Column(String(64), nullable=True, comment="单位")
  1520. remark = Column(String(512), nullable=True, comment="备注")
  1521. tenant_no = Column(String(64), nullable=False, default="zkxw", comment="租户编号")
  1522. order_num = Column(Integer, nullable=True, comment="排序号")
  1523. create_by = Column(String(64), nullable=True, comment="创建人id")
  1524. create_dept_id = Column(String(64), nullable=False, default="", comment="创建人部门ID")
  1525. create_time = Column(DateTime, nullable=False, default=datetime.now, comment="创建时间")
  1526. update_by = Column(String(64), nullable=True, comment="更新人id")
  1527. update_time = Column(DateTime, nullable=False, default=datetime.now, onupdate=datetime.now, comment="更新时间")
  1528. del_flag = Column(SmallInteger, nullable=False, default=0, comment="删除标记")
  1529. class BizProcess(Base):
  1530. """工艺 biz_process"""
  1531. __tablename__ = "biz_process"
  1532. id = Column(String(64), primary_key=True, comment="主键ID")
  1533. process_code = Column(String(64), nullable=False, comment="工序代码")
  1534. category_id = Column(String(64), nullable=True, comment="工序分类id")
  1535. process_name = Column(String(100), nullable=False, comment="工序名称")
  1536. description = Column(String(500), nullable=True, comment="描述")
  1537. equipment_name = Column(String(200), nullable=True, comment="预计使用设备名称")
  1538. estimated_duration = Column(String(100), nullable=True, comment="预估耗时")
  1539. sop_ids = Column(String(1000), nullable=True, comment="关联SOP文档id(逗号分隔)")
  1540. tenant_no = Column(String(64), nullable=False, default="zkxw", comment="租户编号")
  1541. order_num = Column(Integer, nullable=True, comment="排序号")
  1542. remark = Column(String(512), nullable=True, comment="备注")
  1543. create_by = Column(String(64), nullable=True, comment="创建人id")
  1544. create_dept_id = Column(String(64), nullable=False, default="", comment="创建人部门ID")
  1545. create_time = Column(DateTime, nullable=False, default=datetime.now, comment="创建时间")
  1546. update_by = Column(String(64), nullable=True, comment="更新人id")
  1547. update_time = Column(DateTime, nullable=False, default=datetime.now, onupdate=datetime.now, comment="更新时间")
  1548. del_flag = Column(SmallInteger, nullable=False, default=0, comment="删除标记")
  1549. class BizProcessReagent(Base):
  1550. """工艺试剂 biz_process_reagent"""
  1551. __tablename__ = "biz_process_reagent"
  1552. id = Column(String(64), primary_key=True, comment="主键ID")
  1553. process_id = Column(String(64), nullable=False, comment="工艺id")
  1554. reagent_code = Column(String(64), nullable=True, comment="试剂编码")
  1555. reagent_name = Column(String(100), nullable=True, comment="试剂名称")
  1556. spec = Column(String(200), nullable=True, comment="规格")
  1557. standard_usage = Column(String(100), nullable=True, comment="标准用量")
  1558. unit = Column(String(64), nullable=True, comment="单位")
  1559. is_key_material = Column(CHAR(1), nullable=True, default="0", comment="是否关键物料(0-否 1-是)")
  1560. tenant_no = Column(String(64), nullable=False, default="zkxw", comment="租户编号")
  1561. order_num = Column(Integer, nullable=True, comment="排序号")
  1562. remark = Column(String(512), nullable=True, comment="备注")
  1563. create_by = Column(String(64), nullable=True, comment="创建人id")
  1564. create_dept_id = Column(String(64), nullable=False, default="", comment="创建人部门ID")
  1565. create_time = Column(DateTime, nullable=False, default=datetime.now, comment="创建时间")
  1566. update_by = Column(String(64), nullable=True, comment="更新人id")
  1567. update_time = Column(DateTime, nullable=False, default=datetime.now, onupdate=datetime.now, comment="更新时间")
  1568. del_flag = Column(SmallInteger, nullable=False, default=0, comment="删除标记")
  1569. class BizProcessConsumable(Base):
  1570. """工艺耗材 biz_process_consumable"""
  1571. __tablename__ = "biz_process_consumable"
  1572. id = Column(String(64), primary_key=True, comment="主键ID")
  1573. process_id = Column(String(64), nullable=False, comment="工艺id")
  1574. consumable_code = Column(String(64), nullable=True, comment="耗材编码")
  1575. consumable_name = Column(String(100), nullable=True, comment="耗材名称")
  1576. spec_model = Column(String(200), nullable=True, comment="耗材规格型号")
  1577. standard_usage = Column(String(100), nullable=True, comment="标准用量")
  1578. unit = Column(String(64), nullable=True, comment="单位")
  1579. is_required = Column(CHAR(1), nullable=True, default="1", comment="是否必需(1-必须 0-可选)")
  1580. remark = Column(String(512), nullable=True, comment="备注")
  1581. tenant_no = Column(String(64), nullable=False, default="zkxw", comment="租户编号")
  1582. order_num = Column(Integer, nullable=True, comment="排序号")
  1583. create_by = Column(String(64), nullable=True, comment="创建人id")
  1584. create_dept_id = Column(String(64), nullable=False, default="", comment="创建人部门ID")
  1585. create_time = Column(DateTime, nullable=False, default=datetime.now, comment="创建时间")
  1586. update_by = Column(String(64), nullable=True, comment="更新人id")
  1587. update_time = Column(DateTime, nullable=False, default=datetime.now, onupdate=datetime.now, comment="更新时间")
  1588. del_flag = Column(SmallInteger, nullable=False, default=0, comment="删除标记")
  1589. class BizProcessOutput(Base):
  1590. """工艺产出物 biz_process_output"""
  1591. __tablename__ = "biz_process_output"
  1592. id = Column(String(64), primary_key=True, comment="主键ID")
  1593. process_id = Column(String(64), nullable=False, comment="工艺id")
  1594. output_type_id = Column(String(64), nullable=True, comment="产出类型id")
  1595. output_name = Column(String(200), nullable=True, comment="产出物名称")
  1596. output_barcode = Column(String(200), nullable=True, comment="产出物条码")
  1597. tenant_no = Column(String(64), nullable=False, default="zkxw", comment="租户编号")
  1598. order_num = Column(Integer, nullable=True, comment="排序号")
  1599. remark = Column(String(512), nullable=True, comment="备注")
  1600. create_by = Column(String(64), nullable=True, comment="创建人id")
  1601. create_dept_id = Column(String(64), nullable=False, default="", comment="创建人部门ID")
  1602. create_time = Column(DateTime, nullable=False, default=datetime.now, comment="创建时间")
  1603. update_by = Column(String(64), nullable=True, comment="更新人id")
  1604. update_time = Column(DateTime, nullable=False, default=datetime.now, onupdate=datetime.now, comment="更新时间")
  1605. del_flag = Column(SmallInteger, nullable=False, default=0, comment="删除标记")
  1606. class BizProcessDataCollection(Base):
  1607. __tablename__ = "biz_process_data_collection"
  1608. id = Column(String(64), primary_key=True, comment="主键ID")
  1609. process_id = Column(String(64), nullable=False, comment="工艺id")
  1610. collection_name = Column(String(200), nullable=False, comment="采集项名称")
  1611. unit = Column(String(64), nullable=True, comment="单位")
  1612. tenant_no = Column(String(64), nullable=False, default="zkxw", comment="租户编号")
  1613. order_num = Column(Integer, nullable=True, comment="排序号")
  1614. remark = Column(String(512), nullable=True, comment="备注")
  1615. create_by = Column(String(64), nullable=True, comment="创建人id")
  1616. create_dept_id = Column(String(64), nullable=False, default="", comment="创建人部门ID")
  1617. create_time = Column(DateTime, nullable=False, default=datetime.now, comment="创建时间")
  1618. update_by = Column(String(64), nullable=True, comment="更新人id")
  1619. update_time = Column(DateTime, nullable=False, default=datetime.now, onupdate=datetime.now, comment="更新时间")
  1620. del_flag = Column(SmallInteger, nullable=False, default=0, comment="删除标记")
  1621. class BizProcessRoute(Base):
  1622. """工艺路线 biz_process_route"""
  1623. __tablename__ = "biz_process_route"
  1624. id = Column(String(64), primary_key=True, comment="主键ID")
  1625. route_code = Column(String(64), nullable=False, comment="路线编码")
  1626. route_name = Column(String(100), nullable=False, comment="路线名称")
  1627. product_type_id = Column(String(64), nullable=True, comment="产品类型id")
  1628. version = Column(String(50), nullable=True, comment="版本号")
  1629. is_current = Column(CHAR(1), nullable=True, default="0", comment="是否当前版本(0-否 1-是)")
  1630. tenant_no = Column(String(64), nullable=False, default="zkxw", comment="租户编号")
  1631. order_num = Column(Integer, nullable=True, comment="排序号")
  1632. remark = Column(String(512), nullable=True, comment="备注")
  1633. create_by = Column(String(64), nullable=True, comment="创建人id")
  1634. create_dept_id = Column(String(64), nullable=False, default="", comment="创建人部门ID")
  1635. create_time = Column(DateTime, nullable=False, default=datetime.now, comment="创建时间")
  1636. update_by = Column(String(64), nullable=True, comment="更新人id")
  1637. update_time = Column(DateTime, nullable=False, default=datetime.now, onupdate=datetime.now, comment="更新时间")
  1638. del_flag = Column(SmallInteger, nullable=False, default=0, comment="删除标记")
  1639. class BizProcessRouteStep(Base):
  1640. """工艺路线步骤 biz_process_route_step"""
  1641. __tablename__ = "biz_process_route_step"
  1642. id = Column(String(64), primary_key=True, comment="主键ID")
  1643. route_id = Column(String(64), nullable=False, comment="路线id")
  1644. process_id = Column(String(64), nullable=True, comment="关联工艺id")
  1645. step_order = Column(Integer, nullable=True, comment="步骤顺序")
  1646. process_code = Column(String(64), nullable=True, comment="工序代码")
  1647. category_id = Column(String(64), nullable=True, comment="工序分类id")
  1648. process_name = Column(String(100), nullable=True, comment="工序名称")
  1649. description = Column(String(500), nullable=True, comment="描述")
  1650. equipment_name = Column(String(200), nullable=True, comment="预计使用设备名称")
  1651. estimated_duration = Column(String(100), nullable=True, comment="预估耗时")
  1652. sop_ids = Column(String(1000), nullable=True, comment="关联SOP文档id(逗号分隔)")
  1653. tenant_no = Column(String(64), nullable=False, default="zkxw", comment="租户编号")
  1654. order_num = Column(Integer, nullable=True, comment="排序号")
  1655. remark = Column(String(512), nullable=True, comment="备注")
  1656. create_by = Column(String(64), nullable=True, comment="创建人id")
  1657. create_dept_id = Column(String(64), nullable=False, default="", comment="创建人部门ID")
  1658. create_time = Column(DateTime, nullable=False, default=datetime.now, comment="创建时间")
  1659. update_by = Column(String(64), nullable=True, comment="更新人id")
  1660. update_time = Column(DateTime, nullable=False, default=datetime.now, onupdate=datetime.now, comment="更新时间")
  1661. del_flag = Column(SmallInteger, nullable=False, default=0, comment="删除标记")
  1662. class BizProcessRouteStepReagent(Base):
  1663. """工艺路线步骤试剂 biz_process_route_step_reagent"""
  1664. __tablename__ = "biz_process_route_step_reagent"
  1665. id = Column(String(64), primary_key=True, comment="主键ID")
  1666. step_id = Column(String(64), nullable=False, comment="步骤id")
  1667. reagent_code = Column(String(64), nullable=True, comment="试剂编码")
  1668. reagent_name = Column(String(100), nullable=True, comment="试剂名称")
  1669. spec = Column(String(200), nullable=True, comment="规格")
  1670. standard_usage = Column(String(100), nullable=True, comment="标准用量")
  1671. unit = Column(String(64), nullable=True, comment="单位")
  1672. is_key_material = Column(CHAR(1), nullable=True, default="0", comment="是否关键物料(0-否 1-是)")
  1673. tenant_no = Column(String(64), nullable=False, default="zkxw", comment="租户编号")
  1674. order_num = Column(Integer, nullable=True, comment="排序号")
  1675. remark = Column(String(512), nullable=True, comment="备注")
  1676. create_by = Column(String(64), nullable=True, comment="创建人id")
  1677. create_dept_id = Column(String(64), nullable=False, default="", comment="创建人部门ID")
  1678. create_time = Column(DateTime, nullable=False, default=datetime.now, comment="创建时间")
  1679. update_by = Column(String(64), nullable=True, comment="更新人id")
  1680. update_time = Column(DateTime, nullable=False, default=datetime.now, onupdate=datetime.now, comment="更新时间")
  1681. del_flag = Column(SmallInteger, nullable=False, default=0, comment="删除标记")
  1682. class BizProcessRouteStepConsumable(Base):
  1683. """工艺路线步骤耗材 biz_process_route_step_consumable"""
  1684. __tablename__ = "biz_process_route_step_consumable"
  1685. id = Column(String(64), primary_key=True, comment="主键ID")
  1686. step_id = Column(String(64), nullable=False, comment="步骤id")
  1687. consumable_code = Column(String(64), nullable=True, comment="耗材编码")
  1688. consumable_name = Column(String(100), nullable=True, comment="耗材名称")
  1689. spec_model = Column(String(200), nullable=True, comment="耗材规格型号")
  1690. standard_usage = Column(String(100), nullable=True, comment="标准用量")
  1691. unit = Column(String(64), nullable=True, comment="单位")
  1692. is_required = Column(CHAR(1), nullable=True, default="1", comment="是否必需(1-必须 0-可选)")
  1693. remark = Column(String(512), nullable=True, comment="备注")
  1694. tenant_no = Column(String(64), nullable=False, default="zkxw", comment="租户编号")
  1695. order_num = Column(Integer, nullable=True, comment="排序号")
  1696. create_by = Column(String(64), nullable=True, comment="创建人id")
  1697. create_dept_id = Column(String(64), nullable=False, default="", comment="创建人部门ID")
  1698. create_time = Column(DateTime, nullable=False, default=datetime.now, comment="创建时间")
  1699. update_by = Column(String(64), nullable=True, comment="更新人id")
  1700. update_time = Column(DateTime, nullable=False, default=datetime.now, onupdate=datetime.now, comment="更新时间")
  1701. del_flag = Column(SmallInteger, nullable=False, default=0, comment="删除标记")
  1702. class BizProcessRouteStepOutput(Base):
  1703. """工艺路线步骤产出物 biz_process_route_step_output"""
  1704. __tablename__ = "biz_process_route_step_output"
  1705. id = Column(String(64), primary_key=True, comment="主键ID")
  1706. step_id = Column(String(64), nullable=False, comment="步骤id")
  1707. output_type_id = Column(String(64), nullable=True, comment="产出类型id")
  1708. output_name = Column(String(200), nullable=True, comment="产出物名称")
  1709. output_barcode = Column(String(200), nullable=True, comment="产出物条码")
  1710. tenant_no = Column(String(64), nullable=False, default="zkxw", comment="租户编号")
  1711. order_num = Column(Integer, nullable=True, comment="排序号")
  1712. remark = Column(String(512), nullable=True, comment="备注")
  1713. create_by = Column(String(64), nullable=True, comment="创建人id")
  1714. create_dept_id = Column(String(64), nullable=False, default="", comment="创建人部门ID")
  1715. create_time = Column(DateTime, nullable=False, default=datetime.now, comment="创建时间")
  1716. update_by = Column(String(64), nullable=True, comment="更新人id")
  1717. update_time = Column(DateTime, nullable=False, default=datetime.now, onupdate=datetime.now, comment="更新时间")
  1718. del_flag = Column(SmallInteger, nullable=False, default=0, comment="删除标记")
  1719. class BizProcessRouteStepDataCollection(Base):
  1720. """工艺路线步骤数据采集项 biz_process_route_step_data_collection"""
  1721. __tablename__ = "biz_process_route_step_data_collection"
  1722. id = Column(String(64), primary_key=True, comment="主键ID")
  1723. step_id = Column(String(64), nullable=False, comment="步骤id")
  1724. collection_name = Column(String(100), nullable=True, comment="采集项名称")
  1725. unit = Column(String(64), nullable=True, comment="单位")
  1726. tenant_no = Column(String(64), nullable=False, default="zkxw", comment="租户编号")
  1727. order_num = Column(Integer, nullable=True, comment="排序号")
  1728. remark = Column(String(512), nullable=True, comment="备注")
  1729. create_by = Column(String(64), nullable=True, comment="创建人id")
  1730. create_dept_id = Column(String(64), nullable=False, default="", comment="创建人部门ID")
  1731. create_time = Column(DateTime, nullable=False, default=datetime.now, comment="创建时间")
  1732. update_by = Column(String(64), nullable=True, comment="更新人id")
  1733. update_time = Column(DateTime, nullable=False, default=datetime.now, onupdate=datetime.now, comment="更新时间")
  1734. del_flag = Column(SmallInteger, nullable=False, default=0, comment="删除标记")
  1735. # =============================================================================
  1736. # 生产执行(细胞产品 / 生产工单 / 生产任务 / 生产步骤 / 投入产出)
  1737. # =============================================================================
  1738. class BizCellProduct(Base):
  1739. """细胞产品 biz_cell_product"""
  1740. __tablename__ = "biz_cell_product"
  1741. id = Column(String(64), primary_key=True, comment="主键ID")
  1742. product_code = Column(String(64), nullable=False, comment="产品编码")
  1743. product_name = Column(String(200), nullable=False, comment="产品名称")
  1744. product_type_id = Column(String(64), nullable=True, comment="产品类型ID")
  1745. spec_id = Column(String(64), nullable=True, comment="规格ID")
  1746. batch_no = Column(String(64), nullable=True, comment="批号")
  1747. storage_slot_id = Column(String(64), nullable=True, comment="库位ID")
  1748. product_status = Column(String(16), nullable=True, default="zk", comment="产品状态 zk在库 ck出库")
  1749. source_type = Column(String(32), nullable=True, default="production", comment="来源类型 production生产 qc质检")
  1750. production_task_id = Column(String(64), nullable=True, comment="生产任务ID")
  1751. quantity = Column(Numeric(18, 4), nullable=True, comment="数量")
  1752. unit = Column(String(64), nullable=True, comment="单位")
  1753. expiry_date = Column(DateTime, nullable=True, comment="有效期")
  1754. product_images = Column(String(4000), nullable=True, comment="产品图片(逗号分隔URL)")
  1755. tenant_no = Column(String(64), nullable=False, default="zkxw", comment="租户编号")
  1756. order_num = Column(Integer, nullable=True, comment="排序号")
  1757. remark = Column(String(512), nullable=True, comment="备注")
  1758. create_by = Column(String(64), nullable=True, comment="创建人id")
  1759. create_dept_id = Column(String(64), nullable=False, default="", comment="创建人部门ID")
  1760. create_time = Column(DateTime, nullable=False, default=datetime.now, comment="创建时间")
  1761. update_by = Column(String(64), nullable=True, comment="更新人id")
  1762. update_time = Column(DateTime, nullable=False, default=datetime.now, onupdate=datetime.now, comment="更新时间")
  1763. del_flag = Column(SmallInteger, nullable=False, default=0, comment="删除标记")
  1764. class BizProductionWorkOrder(Base):
  1765. """生产工单 biz_production_work_order"""
  1766. __tablename__ = "biz_production_work_order"
  1767. id = Column(String(64), primary_key=True, comment="主键ID")
  1768. work_order_no = Column(String(32), nullable=False, comment="工单号")
  1769. reception_id = Column(String(64), nullable=False, comment="接收记录ID")
  1770. protocol_sample_id = Column(String(64), nullable=False, comment="协议样本ID")
  1771. collection_protocol_id = Column(String(64), nullable=False, comment="采集协议单ID")
  1772. protocol_no = Column(String(64), nullable=True, comment="协议号快照")
  1773. sample_code = Column(String(32), nullable=True, comment="样本编码快照")
  1774. reception_source = Column(String(20), nullable=False, default="cell_storage", comment="来源类型 cell_storage细胞存储 research_donation科研捐赠")
  1775. work_order_status = Column(String(16), nullable=False, default="dpz", comment="工单状态 dpz待配置 dpz待派工 jxz执行中 ywc已完成 yzf已作废")
  1776. tenant_no = Column(String(64), nullable=False, default="zkxw", comment="租户编号")
  1777. order_num = Column(Integer, nullable=True, comment="排序号")
  1778. remark = Column(String(512), nullable=True, comment="备注")
  1779. create_by = Column(String(64), nullable=True, comment="创建人id")
  1780. create_dept_id = Column(String(64), nullable=False, default="", comment="创建人部门ID")
  1781. create_time = Column(DateTime, nullable=False, default=datetime.now, comment="创建时间")
  1782. update_by = Column(String(64), nullable=True, comment="更新人id")
  1783. update_time = Column(DateTime, nullable=False, default=datetime.now, onupdate=datetime.now, comment="更新时间")
  1784. del_flag = Column(SmallInteger, nullable=False, default=0, comment="删除标记")
  1785. class BizProductionTask(Base):
  1786. """生产任务 biz_production_task"""
  1787. __tablename__ = "biz_production_task"
  1788. id = Column(String(64), primary_key=True, comment="主键ID")
  1789. task_no = Column(String(32), nullable=False, comment="任务号")
  1790. work_order_id = Column(String(64), nullable=False, comment="工单ID")
  1791. task_name = Column(String(200), nullable=True, comment="任务名称")
  1792. description = Column(String(500), nullable=True, comment="描述")
  1793. route_id = Column(String(64), nullable=True, comment="工艺路线ID")
  1794. task_status = Column(String(16), nullable=False, default="dpz", comment="任务状态 dpz待配置 dpz待执行 jxz执行中 ywc已完成")
  1795. started_time = Column(DateTime, nullable=True, comment="开始时间")
  1796. completed_time = Column(DateTime, nullable=True, comment="完成时间")
  1797. remark = Column(String(512), nullable=True, comment="备注")
  1798. attachments = Column(String(4000), nullable=True, comment="附件(逗号分隔URL)")
  1799. tenant_no = Column(String(64), nullable=False, default="zkxw", comment="租户编号")
  1800. order_num = Column(Integer, nullable=True, comment="排序号")
  1801. create_by = Column(String(64), nullable=True, comment="创建人id")
  1802. create_dept_id = Column(String(64), nullable=False, default="", comment="创建人部门ID")
  1803. create_time = Column(DateTime, nullable=False, default=datetime.now, comment="创建时间")
  1804. update_by = Column(String(64), nullable=True, comment="更新人id")
  1805. update_time = Column(DateTime, nullable=False, default=datetime.now, onupdate=datetime.now, comment="更新时间")
  1806. del_flag = Column(SmallInteger, nullable=False, default=0, comment="删除标记")
  1807. class BizProductionTaskInput(Base):
  1808. """生产任务投入物 biz_production_task_input"""
  1809. __tablename__ = "biz_production_task_input"
  1810. id = Column(String(64), primary_key=True, comment="主键ID")
  1811. task_id = Column(String(64), nullable=False, comment="任务ID")
  1812. input_type = Column(String(32), nullable=True, comment="投入物类型 sample样本 reagent试剂 consumable耗材")
  1813. input_id = Column(String(64), nullable=True, comment="投入物ID")
  1814. input_code = Column(String(64), nullable=True, comment="投入物编码")
  1815. input_name = Column(String(200), nullable=True, comment="投入物名称")
  1816. tenant_no = Column(String(64), nullable=False, default="zkxw", comment="租户编号")
  1817. order_num = Column(Integer, nullable=True, comment="排序号")
  1818. remark = Column(String(512), nullable=True, comment="备注")
  1819. create_by = Column(String(64), nullable=True, comment="创建人id")
  1820. create_dept_id = Column(String(64), nullable=False, default="", comment="创建人部门ID")
  1821. create_time = Column(DateTime, nullable=False, default=datetime.now, comment="创建时间")
  1822. update_by = Column(String(64), nullable=True, comment="更新人id")
  1823. update_time = Column(DateTime, nullable=False, default=datetime.now, onupdate=datetime.now, comment="更新时间")
  1824. del_flag = Column(SmallInteger, nullable=False, default=0, comment="删除标记")
  1825. class BizProductionTaskStep(Base):
  1826. """生产任务步骤 biz_production_task_step"""
  1827. __tablename__ = "biz_production_task_step"
  1828. id = Column(String(64), primary_key=True, comment="主键ID")
  1829. task_id = Column(String(64), nullable=False, comment="任务ID")
  1830. step_order = Column(Integer, nullable=True, comment="步骤顺序")
  1831. process_code = Column(String(64), nullable=True, comment="工序代码")
  1832. category_id = Column(String(64), nullable=True, comment="工序分类ID")
  1833. process_name = Column(String(100), nullable=True, comment="工序名称")
  1834. description = Column(String(500), nullable=True, comment="描述")
  1835. equipment_name = Column(String(200), nullable=True, comment="预计使用设备名称")
  1836. estimated_duration = Column(String(100), nullable=True, comment="预估耗时")
  1837. actual_duration = Column(String(100), nullable=True, comment="实际耗时")
  1838. sop_ids = Column(String(1000), nullable=True, comment="关联SOP文档id(逗号分隔)")
  1839. step_status = Column(String(16), nullable=True, default="dzx", comment="步骤状态 dzx待执行 jxz执行中 ywc已完成")
  1840. started_time = Column(DateTime, nullable=True, comment="开始时间")
  1841. completed_time = Column(DateTime, nullable=True, comment="完成时间")
  1842. tenant_no = Column(String(64), nullable=False, default="zkxw", comment="租户编号")
  1843. order_num = Column(Integer, nullable=True, comment="排序号")
  1844. remark = Column(String(512), nullable=True, comment="备注")
  1845. create_by = Column(String(64), nullable=True, comment="创建人id")
  1846. create_dept_id = Column(String(64), nullable=False, default="", comment="创建人部门ID")
  1847. create_time = Column(DateTime, nullable=False, default=datetime.now, comment="创建时间")
  1848. update_by = Column(String(64), nullable=True, comment="更新人id")
  1849. update_time = Column(DateTime, nullable=False, default=datetime.now, onupdate=datetime.now, comment="更新时间")
  1850. del_flag = Column(SmallInteger, nullable=False, default=0, comment="删除标记")
  1851. class BizProductionTaskStepReagent(Base):
  1852. """生产任务步骤试剂 biz_production_task_step_reagent"""
  1853. __tablename__ = "biz_production_task_step_reagent"
  1854. id = Column(String(64), primary_key=True, comment="主键ID")
  1855. step_id = Column(String(64), nullable=False, comment="步骤ID")
  1856. reagent_code = Column(String(64), nullable=True, comment="试剂编码")
  1857. reagent_name = Column(String(100), nullable=True, comment="试剂名称")
  1858. spec = Column(String(200), nullable=True, comment="规格")
  1859. standard_usage = Column(String(100), nullable=True, comment="标准用量")
  1860. actual_usage = Column(String(100), nullable=True, comment="实际用量")
  1861. unit = Column(String(64), nullable=True, comment="单位")
  1862. is_key_material = Column(CHAR(1), nullable=True, default="0", comment="是否关键物料(0-否 1-是)")
  1863. tenant_no = Column(String(64), nullable=False, default="zkxw", comment="租户编号")
  1864. order_num = Column(Integer, nullable=True, comment="排序号")
  1865. remark = Column(String(512), nullable=True, comment="备注")
  1866. create_by = Column(String(64), nullable=True, comment="创建人id")
  1867. create_dept_id = Column(String(64), nullable=False, default="", comment="创建人部门ID")
  1868. create_time = Column(DateTime, nullable=False, default=datetime.now, comment="创建时间")
  1869. update_by = Column(String(64), nullable=True, comment="更新人id")
  1870. update_time = Column(DateTime, nullable=False, default=datetime.now, onupdate=datetime.now, comment="更新时间")
  1871. del_flag = Column(SmallInteger, nullable=False, default=0, comment="删除标记")
  1872. class BizProductionTaskStepConsumable(Base):
  1873. """生产任务步骤耗材 biz_production_task_step_consumable"""
  1874. __tablename__ = "biz_production_task_step_consumable"
  1875. id = Column(String(64), primary_key=True, comment="主键ID")
  1876. step_id = Column(String(64), nullable=False, comment="步骤ID")
  1877. consumable_code = Column(String(64), nullable=True, comment="耗材编码")
  1878. consumable_name = Column(String(100), nullable=True, comment="耗材名称")
  1879. spec_model = Column(String(200), nullable=True, comment="耗材规格型号")
  1880. standard_usage = Column(String(100), nullable=True, comment="标准用量")
  1881. actual_usage = Column(String(100), nullable=True, comment="实际用量")
  1882. unit = Column(String(64), nullable=True, comment="单位")
  1883. is_required = Column(CHAR(1), nullable=True, default="1", comment="是否必需(1-必须 0-可选)")
  1884. tenant_no = Column(String(64), nullable=False, default="zkxw", comment="租户编号")
  1885. order_num = Column(Integer, nullable=True, comment="排序号")
  1886. remark = Column(String(512), nullable=True, comment="备注")
  1887. create_by = Column(String(64), nullable=True, comment="创建人id")
  1888. create_dept_id = Column(String(64), nullable=False, default="", comment="创建人部门ID")
  1889. create_time = Column(DateTime, nullable=False, default=datetime.now, comment="创建时间")
  1890. update_by = Column(String(64), nullable=True, comment="更新人id")
  1891. update_time = Column(DateTime, nullable=False, default=datetime.now, onupdate=datetime.now, comment="更新时间")
  1892. del_flag = Column(SmallInteger, nullable=False, default=0, comment="删除标记")
  1893. class BizProductionTaskStepOutput(Base):
  1894. """生产任务步骤产出物 biz_production_task_step_output"""
  1895. __tablename__ = "biz_production_task_step_output"
  1896. id = Column(String(64), primary_key=True, comment="主键ID")
  1897. step_id = Column(String(64), nullable=False, comment="步骤ID")
  1898. output_type_id = Column(String(64), nullable=True, comment="产出类型ID")
  1899. output_name = Column(String(200), nullable=True, comment="产出物名称")
  1900. output_barcode = Column(String(200), nullable=True, comment="产出物条码")
  1901. tenant_no = Column(String(64), nullable=False, default="zkxw", comment="租户编号")
  1902. order_num = Column(Integer, nullable=True, comment="排序号")
  1903. remark = Column(String(512), nullable=True, comment="备注")
  1904. create_by = Column(String(64), nullable=True, comment="创建人id")
  1905. create_dept_id = Column(String(64), nullable=False, default="", comment="创建人部门ID")
  1906. create_time = Column(DateTime, nullable=False, default=datetime.now, comment="创建时间")
  1907. update_by = Column(String(64), nullable=True, comment="更新人id")
  1908. update_time = Column(DateTime, nullable=False, default=datetime.now, onupdate=datetime.now, comment="更新时间")
  1909. del_flag = Column(SmallInteger, nullable=False, default=0, comment="删除标记")
  1910. class BizProductionTaskStepDataCollection(Base):
  1911. """生产任务步骤数据采集项 biz_production_task_step_data_collection"""
  1912. __tablename__ = "biz_production_task_step_data_collection"
  1913. id = Column(String(64), primary_key=True, comment="主键ID")
  1914. step_id = Column(String(64), nullable=False, comment="步骤ID")
  1915. collection_name = Column(String(200), nullable=True, comment="采集项名称")
  1916. unit = Column(String(64), nullable=True, comment="单位")
  1917. collection_value = Column(String(500), nullable=True, comment="采集值")
  1918. tenant_no = Column(String(64), nullable=False, default="zkxw", comment="租户编号")
  1919. order_num = Column(Integer, nullable=True, comment="排序号")
  1920. remark = Column(String(512), nullable=True, comment="备注")
  1921. create_by = Column(String(64), nullable=True, comment="创建人id")
  1922. create_dept_id = Column(String(64), nullable=False, default="", comment="创建人部门ID")
  1923. create_time = Column(DateTime, nullable=False, default=datetime.now, comment="创建时间")
  1924. update_by = Column(String(64), nullable=True, comment="更新人id")
  1925. update_time = Column(DateTime, nullable=False, default=datetime.now, onupdate=datetime.now, comment="更新时间")
  1926. del_flag = Column(SmallInteger, nullable=False, default=0, comment="删除标记")
  1927. class BizProductionTaskOutput(Base):
  1928. """生产任务最终产出 biz_production_task_output"""
  1929. __tablename__ = "biz_production_task_output"
  1930. id = Column(String(64), primary_key=True, comment="主键ID")
  1931. task_id = Column(String(64), nullable=False, comment="任务ID")
  1932. cell_product_id = Column(String(64), nullable=True, comment="细胞产品ID")
  1933. storage_slot_id = Column(String(64), nullable=True, comment="库位ID")
  1934. output_name = Column(String(200), nullable=True, comment="产出物名称")
  1935. output_barcode = Column(String(200), nullable=True, comment="产出物条码")
  1936. quantity = Column(Numeric(18, 4), nullable=True, comment="数量")
  1937. unit = Column(String(64), nullable=True, comment="单位")
  1938. remark = Column(String(512), nullable=True, comment="备注")
  1939. attachments = Column(String(4000), nullable=True, comment="附件(逗号分隔URL)")
  1940. tenant_no = Column(String(64), nullable=False, default="zkxw", comment="租户编号")
  1941. order_num = Column(Integer, nullable=True, comment="排序号")
  1942. create_by = Column(String(64), nullable=True, comment="创建人id")
  1943. create_dept_id = Column(String(64), nullable=False, default="", comment="创建人部门ID")
  1944. create_time = Column(DateTime, nullable=False, default=datetime.now, comment="创建时间")
  1945. update_by = Column(String(64), nullable=True, comment="更新人id")
  1946. update_time = Column(DateTime, nullable=False, default=datetime.now, onupdate=datetime.now, comment="更新时间")
  1947. del_flag = Column(SmallInteger, nullable=False, default=0, comment="删除标记")
  1948. from app.models.qc_param import BizQcItemParam, BizQcTaskResult # noqa: E402,F401