E-Parts

  • 部品用DB構築
  • Railsにて

仕様策定

  • registers
  • capacitors
  • lcds

共通テーブル

  • manufacturers
  • distributors
  • packages
  • statuses
    • amount
    • stockplace
  • stockplace

個別テーブル

  • led
    ruby script/generate scaffold led name:string color:string vol:integer cur:integer spectrum:string mcd:integer styletype:string style:string lm:string range:integer ecommon_id:integer note:string
  • capacitor
    ruby script/generate scaffold capacitor capa:string vol:integer tolerance:string esr:string lifetemp:string feature:string size:string lspacing:float mountlsize:string thick:float ecommon_id:integer note:string
  • lcd
    ruby script/generate scaffold lcd name:string kind:string resolution:string aspectratio:string color:integer contratio:string condition:string interfacetype:string controller:string viewrange:string vdd:string vlcd:string vin:string lcdsize:string dotsize:string dotspacing:string dotpitch:string backlightnum:integer backlighttype:string ecommon_id:integer note:string
  • fpga
    ruby script/generate scaffold fpga name:string delay:float io:integer le:integer register:integer bit:integer inputvol:string ecommon_id:integer note:string
  • mcu
    ruby script/generate scaffold mcu name:string kind:string core:string coresize:string speed:string connect:string peripheral:string io:integer pram:string pramtype:string eepromsize:string ramsize:string voltage:string dconv:string oscillator:string ecommon_id:integer note:string
  • cpld
    ruby script/generate scaffold cpld name:string kind:string progtype:string memtype:string delay:float inputvol:string mcell:integer io:integer lblock:integer temp:string ecommon_id:integer note:string

レギュレータ

fieldexampletype
namestring
dropoutfloat
outvolfloat
outculfloat
limitculfloat

抵抗器

  • registers
    fieldexampletype
    name10k2012string
    ohm100string
    watt1/8Wstring
    ecommon_id10integer
    notesomestring
ruby script/generate scaffold resistor name:string ohm:integer watt:string ecommon_id:integer note:string
  • ecommon
    fieldexampletype
    name10k2012string
    category_id3integer
    qty100integer
    price6integer
    datasheeturlhttp://www.something.orgstring
    imgurlhttp://www.someplace.orgstring
    dist_iddigi-keyinteger
    manu_idyagiinteger
    boughtdate2009.12.1date
    package_id1integer
    place_idinteger
    notesomethingstring
ruby script/generate scaffold ecommon name:string category_id:integer qty:integer price:integer datasheeturl:string imgurl:string dist_id:integer manu_id:integer boughtdate:date package_id:integer place_id:integer note:string
  • package
    fieldexampletype
    nameLQFPstring
    leads44integer
    e0.80float
    w0.3float
    notesomethingstring
ruby script/generate scaffold package name:string lead:integer e:float w:float note:string
  • category
    fieldexampletype
    namehogestring
    notessomethingstring
ruby script/generate scaffold category name:string note:string
  • dist
    fieldexampletype
    namehogestring
    notessomethingstring
  • manu
    fieldexampletype
    namehogestring
    notessomethingstring
  • mounttype
    fieldexampletype
    namehogestring
    notessomethingstring

FPGA

  • fpga
    fieldexampletype
    nameCycloneIII 2910 LEstring
    partnumEP3C5E144C8string
    category_id3string
    le2910integer
    ionum64integer
    supvol1.2-3.3Vstring
    partsid10integer
    notessomestring
  • packages
fieldexampletype
caseLQFPstring
leads44integer
e0.80float
w0.3float
notesomethingstring


トップ   編集 凍結 差分 バックアップ 添付 複製 名前変更 リロード   新規 一覧 単語検索 最終更新   ヘルプ   最終更新のRSS
Last-modified: 2016-09-22 (木) 13:20:35 (1730d)