当前位置: 首页 > news >正文

AD元器件库中参数的设计

AD软件中元器件库中的元器件可以自定义添加参数,这些参数可以用于元器件的特性描述,也可以用于元器件的特性计算。

在搭建数据库类型的元件库时就会遇到这个问题,如何选择元器件的参数放在库中呢?因为数据库的表结构是固定的,所以元器件的参数字段也是固定的,如果元器件的参数太多,那么表结构就会很复杂,不利于维护。如果元器件的参数太少,那么元器件的特性描述就会不够详细,不利于使用。

“良好的设计就是合理的trade-off的结果”,所以在设计元器件库时,需要权衡元器件的参数数量和表结构的复杂度。

目前我在数据库中采用的字段如下:

{"Component": {"name": "Component","description": "电子元器件","default_location": 0,"default_keywords": "component 元器件","parent": "Electrical","structural": true,"icon": "","parameter_template": {"pin_count": {"name": "Pin Count","description": "引脚数量,不含裸露焊盘、定位引脚等","checkbox": false},"ep_pin_count": {"name": "EP Pin Count","description": "裸露焊盘或定位引脚数量","checkbox": false},"ad_sym_ref": {"name": "AD Library Ref","description": "AD原理图符号库引用","checkbox": false},"ad_fp_ref": {"name": "AD Footprint Ref","description": "AD PCB封装图形库引用","checkbox": false},"ad_fp_ref_2": {"name": "AD Footprint Ref 2","description": "AD PCB封装图形库引用 2","checkbox": false},"ad_fp_ref_3": {"name": "AD Footprint Ref 3","description": "AD PCB封装图形库引用 3","checkbox": false},"ad_link1_description": {"name": "ComponentLink1Description","description": "元器件链接 1 描述","checkbox": false},"ad_link1_url": {"name": "ComponentLink1URL","description": "元器件链接 1 URL","checkbox": false},"ad_link2_description": {"name": "ComponentLink2Description","description": "元器件链接 2 描述","checkbox": false},"ad_link2_url": {"name": "ComponentLink2URL","description": "元器件链接 2 URL","checkbox": false},"mount_type": {"name": "Mount Type","description": "安装类型","checkbox": false,"choices": "SMT,THT,MIX"},"package_name": {"name": "Package Name","description": "封装名称","checkbox": false},"operating_temperature": {"name": "Operating Temperature","description": "工作温度范围","checkbox": false},"rohs": {"name": "RoHS","description": "RoHS 认证","checkbox": false},"gpn": {"name": "GPN","description": "通用编码,一般编码","checkbox": false},"type": {"name": "Type","description": "类型 细分类型","checkbox": false}},"subcategories": {"IC": {"name": "IC","description": "集成电路","default_location": 0,"default_keywords": "ic 集成电路","parent": "Component","structural": false,"parameter_template": {"operating_voltage": {"name": "Operating Voltage","description": "工作电压","checkbox": false},"operating_current": {"name": "Operating Current","description": "工作电流","checkbox": false},"max_voltage": {"name": "Max Voltage","description": "最大电压","checkbox": false}}},"Resistor": {"name": "Resistor","description": "电阻","default_location": 0,"default_keywords": "resistor 电阻","parent": "Component","structural": false,"parameter_template": {"resistance": {"name": "Resistance","description": "电阻值","checkbox": false},"tolerance": {"name": "Tolerance","description": "容差","checkbox": false},"rated_power": {"name": "Rated Power","description": "额定功率","checkbox": false},"rated_voltage": {"name": "Rated Voltage","description": "额定电压","checkbox": false},"temperature_coefficient": {"name": "Temperature Coefficient","description": "温度系数","checkbox": false}}},"Capacitor": {"name": "Capacitor","description": "电容","default_location": 0,"default_keywords": "capacitor 电容","parent": "Component","structural": false,"parameter_template": {"capacitance": {"name": "Capacitance","description": "电容值","checkbox": false},"tolerance": {"name": "Tolerance","description": "容差","checkbox": false},"rated_voltage": {"name": "Rated Voltage","description": "额定电压","checkbox": false},"temperature_coefficient": {"name": "Temperature Coefficient","description": "温度系数","checkbox": false}}},"Inductor": {"name": "Inductor","description": "电感","default_location": 0,"default_keywords": "inductor 电感","parent": "Component","structural": false,"parameter_template": {"inductance": {"name": "Inductance","description": "电感值","checkbox": false},"tolerance": {"name": "Tolerance","description": "容差","checkbox": false},"self_resonant_frequency": {"name": "Self Resonant Frequency","description": "自谐振频率","checkbox": false},"dc_resistance": {"name": "DC Resistance","description": "直流电阻","checkbox": false},"rated_current": {"name": "Rated Current","description": "热额定电流","checkbox": false},"saturation_current": {"name": "Saturation Current","description": "饱和电流","checkbox": false}}},"Diode": {"name": "Diode","description": "二极管","default_location": 0,"default_keywords": "diode 二极管","parent": "Component","structural": false,"parameter_template": {"forward_voltage": {"name": "Forward Voltage","description": "正向电压","checkbox": false},"reverse_voltage": {"name": "Reverse Voltage","description": "反向电压","checkbox": false},"forward_current": {"name": "Forward Current","description": "正向电流","checkbox": false},"reverse_current": {"name": "Reverse Current","description": "反向电流","checkbox": false},"reverse_recovery_time": {"name": "Reverse Recovery Time","description": "反向恢复时间","checkbox": false}}},"Transistor": {"name": "Transistor","description": "晶体管 三极管 FET 晶闸管","default_location": 0,"default_keywords": "transistor 晶体管","parent": "Component","structural": false,"parameter_template": {"vce": {"name": "Vce/Vds","description": "集电极-发射极电压","checkbox": false},"ic": {"name": "Ic/Id","description": "集电极电流","checkbox": false},"vce_sat": {"name": "Vce_sat/Vds_sat","description": "饱和电压","checkbox": false}}},"Connector": {"name": "Connector","description": "连接器 接插件","default_location": 0,"default_keywords": "connector 连接器","parent": "Component","structural": false,"parameter_template": {"mount_angle": {"name": "Mount Angle","description": "安装角度","checkbox": false,"choices": "90°,180°,Other"},"contact_count": {"name": "Contact Count","description": "接点数量","checkbox": false},"contact_pitch": {"name": "Contact Pitch","description": "接点间距","checkbox": false},"rated_current": {"name": "Rated Current","description": "额定电流","checkbox": false},"rated_voltage": {"name": "Rated Voltage","description": "额定电压","checkbox": false}}},"Switch": {"name": "Switch","description": "开关 按键","default_location": 0,"default_keywords": "switch 开关","parent": "Component","structural": false,"parameter_template": {"mount_angle": {"name": "Mount Angle","description": "安装角度","checkbox": false,"choices": "90°,180°,Other"},"contact_count": {"name": "Contact Count","description": "接点数量","checkbox": false},"contact_pitch": {"name": "Contact Pitch","description": "接点间距","checkbox": false},"rated_current": {"name": "Rated Current","description": "额定电流","checkbox": false},"rated_voltage": {"name": "Rated Voltage","description": "额定电压","checkbox": false}}},"Relay": {"name": "Relay","description": "继电器","default_location": 0,"default_keywords": "relay 继电器","parent": "Component","structural": false,"parameter_template": {"rated_voltage": {"name": "Rated Voltage","description": "额定电压","checkbox": false},"rated_current": {"name": "Rated Current","description": "额定电流","checkbox": false}}},"Fuse": {"name": "Fuse","description": "保险丝 保护器件","default_location": 0,"default_keywords": "fuse 保险丝","parent": "Component","structural": false,"parameter_template": {"rated_current": {"name": "Rated Current","description": "额定电流","checkbox": false},"rated_voltage": {"name": "Rated Voltage","description": "额定电压","checkbox": false},"breaking_capacity": {"name": "Breaking Capacity","description": "熔断容量","checkbox": false},"cold_resistance": {"name": "Cold Resistance","description": "冷电阻","checkbox": false}}},"Transformer": {"name": "Transformer","description": "变压器","default_location": 0,"default_keywords": "transformer 变压器","parent": "Component","structural": false,"parameter_template": {"transform_ratio": {"name": "Transform Ratio","description": "变比","checkbox": false},"rated_power": {"name": "Rated Power","description": "额定功率","checkbox": false}}},"Crystal": {"name": "Crystal","description": "晶振 晶体 陶振 谐振器 振荡器","default_location": 0,"default_keywords": "crystal 晶振","parent": "Component","structural": false,"parameter_template": {"frequency": {"name": "Frequency","description": "频率","checkbox": false},"tolerance": {"name": "Tolerance","description": "容差","checkbox": false},"load_capacity": {"name": "Load Capacity","description": "负载容量","checkbox": false},"temperature_coefficient": {"name": "Temperature Coefficient","description": "温度系数","checkbox": false}}},"Module": {"name": "Module","description": "模块 模组","default_location": 0,"default_keywords": "module 模块","parent": "Component","structural": false,"parameter_template": {"operating_voltage": {"name": "Operating Voltage","description": "工作电压","checkbox": false},"operating_current": {"name": "Operating Current","description": "工作电流","checkbox": false},"max_voltage": {"name": "Max Voltage","description": "最大电压","checkbox": false}}},"Other": {"name": "Other","description": "其它电子元器件","default_location": 0,"default_keywords": "other 其它","parent": "Component","structural": false,"parameter_template": {}}}}
}

大家有什么好的想法和建议欢迎在评论区留言😀

公众号 | FunIO
微信搜一搜 “funio”,发现更多精彩内容。
个人博客 | blog.boringhex.top

相关文章:

  • 北京网站建设多少钱?
  • 辽宁网页制作哪家好_网站建设
  • 高端品牌网站建设_汉中网站制作
  • Java Spring Boot 项目中的密码加密与验证开发案例手册
  • FPGA技术赋能云数据中心:提高性能与效率
  • 数据治理与数据管理的区别:深入剖析与理解
  • [Go]-抢购类业务方案
  • Qt QSerialPort数据发送和接收DataComm
  • 对浏览器事件循环机制的理解
  • Redis 篇-深入了解基于 Redis 实现消息队列(比较基于 List 实现消息队列、基于 PubSub 发布订阅模型之间的区别)
  • JDBC简介与应用:Java数据库连接的核心概念和技术
  • 【Redis】Redis 典型应用 - 缓存 (Cache) 原理与策略
  • BuripSuiteProfessional 抓取HTTPS配置
  • Java实现简易计算器功能(idea)
  • day5 QT
  • 多级缓存的设计与实现
  • C语言代码练习(第十八天)
  • ​如何使用QGIS制作三维建筑
  • 【跃迁之路】【585天】程序员高效学习方法论探索系列(实验阶段342-2018.09.13)...
  • HashMap剖析之内部结构
  • Java知识点总结(JDBC-连接步骤及CRUD)
  • JS正则表达式精简教程(JavaScript RegExp 对象)
  • Leetcode 27 Remove Element
  • linux安装openssl、swoole等扩展的具体步骤
  • Python中eval与exec的使用及区别
  • Spark RDD学习: aggregate函数
  • Vue实战(四)登录/注册页的实现
  • 闭包--闭包作用之保存(一)
  • 程序员该如何有效的找工作?
  • 从0实现一个tiny react(三)生命周期
  • 看图轻松理解数据结构与算法系列(基于数组的栈)
  • 快速构建spring-cloud+sleuth+rabbit+ zipkin+es+kibana+grafana日志跟踪平台
  • 前嗅ForeSpider中数据浏览界面介绍
  • 如何选择开源的机器学习框架?
  • 我建了一个叫Hello World的项目
  • 想晋级高级工程师只知道表面是不够的!Git内部原理介绍
  • 项目实战-Api的解决方案
  • ​​​​​​​sokit v1.3抓手机应用socket数据包: Socket是传输控制层协议,WebSocket是应用层协议。
  • ​二进制运算符:(与运算)、|(或运算)、~(取反运算)、^(异或运算)、位移运算符​
  • (附源码)springboot家庭装修管理系统 毕业设计 613205
  • (附源码)ssm高校志愿者服务系统 毕业设计 011648
  • (附源码)计算机毕业设计ssm电影分享网站
  • (十三)Flask之特殊装饰器详解
  • (学习日记)2024.03.25:UCOSIII第二十二节:系统启动流程详解
  • (一)C语言之入门:使用Visual Studio Community 2022运行hello world
  • (转)负载均衡,回话保持,cookie
  • ******IT公司面试题汇总+优秀技术博客汇总
  • *p++,*(p++),*++p,(*p)++区别?
  • .NET Core 成都线下面基会拉开序幕
  • .NET Core 项目指定SDK版本
  • .NET Framework 3.5安装教程
  • .net MySql
  • .net redis定时_一场由fork引发的超时,让我们重新探讨了Redis的抖动问题
  • .NET 将混合了多个不同平台(Windows Mac Linux)的文件 目录的路径格式化成同一个平台下的路径
  • .NET/C# 在代码中测量代码执行耗时的建议(比较系统性能计数器和系统时间)
  • .net反编译工具
  • .Net高阶异常处理第二篇~~ dump进阶之MiniDumpWriter
  • .NET开源、简单、实用的数据库文档生成工具