Hello, Kaspar!

On 2017-01-13 12:50, Kaspar Emanuel wrote:
> Hi all,
> 
> I have started an initiative for external tools to agree on a few default 
> field names in schematics. Full details in the forum where you can also 
> propose amendments and register your preference.
> 
> https://forum.kicad.info/t/standard-symbol-field-names-initiative/4870

I am not sure how far you would go with KiCAD here and it's libraries.
I would keep things simple and _not_ add manufacturer information to the KiCAD 
libraries - divide and conquer!
Better split it up and link to all necessary information with a key/index in a 
database. (In my case it's 'partname', but it can become more complex: a 
combination of 'partname'+'value'+'instance')

I'll attach the Create code of my (still far away from perfect) database to 
give you an idea what maintainability hell you might run into if you keep 
everything inside of KiCAD, while KiCAD doesn't have a fully capable database 
frontend (yet ;-):

CREATE TABLE `main` (
        `mfg` VARCHAR(45) NULL DEFAULT '' COMMENT 'mfg name',
        `mfgname` VARCHAR(45) NULL DEFAULT '' COMMENT 'mfg partname',
        `description` VARCHAR(255) NULL DEFAULT '' COMMENT 'functional 
specification',
        `lycomment` VARCHAR(255) NULL DEFAULT '' COMMENT 'comment regarding 
part usage',
        `partname` VARCHAR(45) NULL DEFAULT '' COMMENT 'KEY: partname_metric',
        `partname_old` VARCHAR(45) NULL DEFAULT '' COMMENT 'KEY: 
partname_imperial (obsolete)',
        `caedecal` VARCHAR(45) NULL DEFAULT '' COMMENT 'cae decal name',
        `pincount` SMALLINT(5) UNSIGNED NULL DEFAULT '0' COMMENT 'no of package 
pins including e-pad, excluding drills',
        `value` VARCHAR(20) NULL DEFAULT '' COMMENT 'ATTRIBUTE: primary 
component value',
        `pcbdecal` VARCHAR(45) NULL DEFAULT '' COMMENT 'pcb decal name ',
        `mfgpkg` VARCHAR(45) NULL DEFAULT '' COMMENT 'mfg package 
specification',
        `mfgpkg_iec` VARCHAR(45) NULL DEFAULT '' COMMENT 'mfg package 
specification IEC',
        `mfgpkg_jeita` VARCHAR(45) NULL DEFAULT '' COMMENT 'mfg package 
specification JEITA',
        `mfgpkg_jedec` VARCHAR(45) NULL DEFAULT '' COMMENT 'mfg package 
specification JEDEC',
        `power` DECIMAL(7,3) UNSIGNED NULL DEFAULT '0.000' COMMENT 'power 
rating',
        `voltage` DECIMAL(7,3) UNSIGNED NULL DEFAULT '0.000' COMMENT 'voltage 
rating',
        `current` DECIMAL(7,3) UNSIGNED NULL DEFAULT '0.000' COMMENT 'current 
rating',
        `temp_min` SMALLINT(5) NULL DEFAULT '0' COMMENT 'min operating 
temperature',
        `temp_max` SMALLINT(5) NULL DEFAULT '0' COMMENT 'max operating 
temperature',
        `pitch` DECIMAL(7,3) UNSIGNED NULL DEFAULT '0.000' COMMENT 'footprint 
minimum pitch',
        `length` DECIMAL(7,3) UNSIGNED NULL DEFAULT '0.000' COMMENT 'length of 
part',
        `width` DECIMAL(7,3) UNSIGNED NULL DEFAULT '0.000' COMMENT 'width of 
part',
        `height` DECIMAL(7,3) UNSIGNED NULL DEFAULT '0.000' COMMENT 'height of 
part',
        `rohs` VARCHAR(10) NULL DEFAULT '' COMMENT 'rohs conformity',
        `dista` VARCHAR(255) NULL DEFAULT '' COMMENT 'primary distributor',
        `ordernoa` VARCHAR(255) NULL DEFAULT '' COMMENT 'orderno of primary 
distributor',
        `minordera` INT(10) UNSIGNED NULL DEFAULT '0' COMMENT 'minimum order 
qty of primary distributor',
        `currency` ENUM('EUR','USD','CAD') NOT NULL DEFAULT 'EUR' COMMENT 
'currency for all prices in this row',
        `pricea1` DECIMAL(10,5) NULL DEFAULT '0.00000' COMMENT 'price at one',
        `pricea2` DECIMAL(10,5) NULL DEFAULT '0.00000' COMMENT 'price at many',
        `qtya2` INT(10) UNSIGNED NULL DEFAULT '0' COMMENT 'package size many',
        `status` VARCHAR(10) NULL DEFAULT '' COMMENT 'general status if part is 
usable',
        `available` VARCHAR(10) NULL DEFAULT '' COMMENT 'general status about 
part availability',
        `stockqty` INT(10) NOT NULL DEFAULT '0' COMMENT 'in-house stock qty',
        `extqty` INT(10) NOT NULL DEFAULT '0' COMMENT 'ext mfg stock qty',
        `stockplace` VARCHAR(10) NULL DEFAULT '' COMMENT 'stock place',
        `stockcomment` VARCHAR(100) NULL DEFAULT '' COMMENT 'stock comment',
        `mfgcomment` VARCHAR(100) NULL DEFAULT '' COMMENT 'assembly house 
comment',
        `tstamp` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE 
CURRENT_TIMESTAMP COMMENT 'timestamp of last update',
        `grp` VARCHAR(45) NULL DEFAULT '' COMMENT 'part group',
        `tqsap0` VARCHAR(45) NULL DEFAULT '' COMMENT 'mfg sap number 1',
        `tqmat0` VARCHAR(100) NULL DEFAULT '' COMMENT 'mfg mat name 1',
        `tqsap1` VARCHAR(45) NULL DEFAULT '' COMMENT 'mfg sap number 2',
        `tqmat1` VARCHAR(100) NULL DEFAULT '' COMMENT 'mfg mat name 2',
        `tqsap2` VARCHAR(45) NULL DEFAULT '' COMMENT 'mfg sap number 3',
        `tqmat2` VARCHAR(100) NULL DEFAULT '' COMMENT 'mfg mat name 3',
        `idx` INT(10) NOT NULL AUTO_INCREMENT COMMENT 'unique index',
        UNIQUE INDEX `idx` (`idx`)
)
COLLATE='utf8_general_ci'
ENGINE=InnoDB
AUTO_INCREMENT=2222
;


Just funny, that the index is on 2222 today :-) Let's have a schnaps!

Regards,

Clemens



_______________________________________________
Mailing list: https://launchpad.net/~kicad-developers
Post to     : kicad-developers@lists.launchpad.net
Unsubscribe : https://launchpad.net/~kicad-developers
More help   : https://help.launchpad.net/ListHelp

Reply via email to