aarbitandClaude Sonnet 5
a5c2ad87e1
Replaces the old ungendered catalog (plain XLR, TS/TRS 1/4", Speakon NL2/4/8, etc.) with a full Male/Female-aware set covering audio, video, network/data, USB (with Host/Device role split for USB-C), power, RF coax, and fiber connectors, plus real-world bridging/adapter cables — enough to model gender benders and specify exact cable types in the BOM instead of just a connector family. The catalog now lives entirely in the DB (seeded via supabase/seed.sql, captured with the new export-seed.mjs) rather than partly hardcoded in domain/library.ts, which is now unused. Existing seeded diagrams/devices were intentionally not migrated to the new port types — there was nothing important in them yet. Co-Authored-By: Claude Sonnet 5 <noreply@anthropic.com> Claude-Session: https://claude.ai/code/session_017DUU6CnxECCDeqDNYJgr5x
306 lines
58 KiB
SQL
306 lines
58 KiB
SQL
-- Generated by scripts/export-seed.mjs from the local Supabase database's public
|
|
-- catalog rows. Do not hand-edit — author new devices/connectors via the app's
|
|
-- GUI instead (as an Admin, check "Publish directly to the shared library"),
|
|
-- then re-run: npm run export-seed
|
|
-- Seeds the public catalog: is_public = true, owner_id = null (system-owned).
|
|
|
|
-- Device categories
|
|
insert into public.device_categories (id, name, is_public) values ('adapter', 'Adapter / Converter', true);
|
|
insert into public.device_categories (id, name, is_public) values ('amplifier', 'Amplifier / Receiver', true);
|
|
insert into public.device_categories (id, name, is_public) values ('audio-source', 'Audio Source', true);
|
|
insert into public.device_categories (id, name, is_public) values ('camera', 'Camera', true);
|
|
insert into public.device_categories (id, name, is_public) values ('computer', 'Computer', true);
|
|
insert into public.device_categories (id, name, is_public) values ('control', 'Control', true);
|
|
insert into public.device_categories (id, name, is_public) values ('display', 'Display', true);
|
|
insert into public.device_categories (id, name, is_public) values ('mixer', 'Mixer', true);
|
|
insert into public.device_categories (id, name, is_public) values ('network', 'Network', true);
|
|
insert into public.device_categories (id, name, is_public) values ('other', 'Other', true);
|
|
insert into public.device_categories (id, name, is_public) values ('power', 'Power', true);
|
|
insert into public.device_categories (id, name, is_public) values ('speaker', 'Speaker', true);
|
|
insert into public.device_categories (id, name, is_public) values ('synth', 'Synthesizer / Sound Module', true);
|
|
insert into public.device_categories (id, name, is_public) values ('video-source', 'Video Source', true);
|
|
|
|
-- Manufacturers
|
|
|
|
-- Port types
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-trs-6.35mm-bal-f', '1/4in TRS (Balanced Audio) (Female)', 'audio', 'trs-6.35mm-f', '{"trs-6.35mm-m","ts-6.35mm-m","ts-6.35mm-f"}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-trs-6.35mm-bal-m', '1/4in TRS (Balanced Audio) (Male)', 'audio', 'trs-6.35mm-m', '{}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-trs-6.35mm-f', '1/4in TRS (Female)', 'audio', 'trs-6.35mm-f', '{"trs-6.35mm-m","ts-6.35mm-m","ts-6.35mm-f"}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-trs-6.35mm-m', '1/4in TRS (Male)', 'audio', 'trs-6.35mm-m', '{}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-trs-6.35mm-stereo-f', '1/4in TRS (Stereo Audio) (Female)', 'audio', 'trs-6.35mm-f', '{"trs-6.35mm-m","ts-6.35mm-m","ts-6.35mm-f"}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-trs-6.35mm-stereo-m', '1/4in TRS (Stereo Audio) (Male)', 'audio', 'trs-6.35mm-m', '{}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-ts-6.35mm-f', '1/4in TS (Female)', 'audio', 'ts-6.35mm-f', '{"ts-6.35mm-m","trs-6.35mm-m","trs-6.35mm-f"}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-ts-6.35mm-m', '1/4in TS (Male)', 'audio', 'ts-6.35mm-m', '{}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-ts-6.35mm-unbal-f', '1/4in TS (Unbalanced Audio) (Female)', 'audio', 'ts-6.35mm-f', '{"ts-6.35mm-m","trs-6.35mm-m","trs-6.35mm-f"}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-ts-6.35mm-unbal-m', '1/4in TS (Unbalanced Audio) (Male)', 'audio', 'ts-6.35mm-m', '{}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-trrs-2.5mm-f', '2.5mm TRRS (Female)', 'audio', 'trrs-2.5mm-f', '{"trrs-2.5mm-m","ts-2.5mm-m","ts-2.5mm-f","trs-2.5mm-m","trs-2.5mm-f"}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-trrs-2.5mm-m', '2.5mm TRRS (Male)', 'audio', 'trrs-2.5mm-m', '{}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-trs-2.5mm-bal-f', '2.5mm TRS (Balanced Audio) (Female)', 'audio', 'trs-2.5mm-f', '{"trs-2.5mm-m","ts-2.5mm-m","ts-2.5mm-f","trrs-2.5mm-m","trrs-2.5mm-f"}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-trs-2.5mm-bal-m', '2.5mm TRS (Balanced Audio) (Male)', 'audio', 'trs-2.5mm-m', '{}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-trs-2.5mm-f', '2.5mm TRS (Female)', 'audio', 'trs-2.5mm-f', '{"trs-2.5mm-m","ts-2.5mm-m","ts-2.5mm-f","trrs-2.5mm-m","trrs-2.5mm-f"}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-trs-2.5mm-m', '2.5mm TRS (Male)', 'audio', 'trs-2.5mm-m', '{}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-trs-2.5mm-stereo-f', '2.5mm TRS (Stereo Audio) (Female)', 'audio', 'trs-2.5mm-f', '{"trs-2.5mm-m","ts-2.5mm-m","ts-2.5mm-f","trrs-2.5mm-m","trrs-2.5mm-f"}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-trs-2.5mm-stereo-m', '2.5mm TRS (Stereo Audio) (Male)', 'audio', 'trs-2.5mm-m', '{}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-ts-2.5mm-f', '2.5mm TS (Female)', 'audio', 'ts-2.5mm-f', '{"ts-2.5mm-m","trs-2.5mm-m","trs-2.5mm-f","trrs-2.5mm-m","trrs-2.5mm-f"}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-ts-2.5mm-m', '2.5mm TS (Male)', 'audio', 'ts-2.5mm-m', '{}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-ts-2.5mm-unbal-f', '2.5mm TS (Unbalanced Audio) (Female)', 'audio', 'ts-2.5mm-f', '{"ts-2.5mm-m","trs-2.5mm-m","trs-2.5mm-f","trrs-2.5mm-m","trrs-2.5mm-f"}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-ts-2.5mm-unbal-m', '2.5mm TS (Unbalanced Audio) (Male)', 'audio', 'ts-2.5mm-m', '{}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-trrs-3.5mm-f', '3.5mm TRRS (Female)', 'audio', 'trrs-3.5mm-f', '{"trrs-3.5mm-m","ts-3.5mm-m","ts-3.5mm-f","trs-3.5mm-m","trs-3.5mm-f"}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-trrs-3.5mm-m', '3.5mm TRRS (Male)', 'audio', 'trrs-3.5mm-m', '{}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-trs-3.5mm-bal-f', '3.5mm TRS (Balanced Audio) (Female)', 'audio', 'trs-3.5mm-f', '{"trs-3.5mm-m","ts-3.5mm-m","ts-3.5mm-f","trrs-3.5mm-m","trrs-3.5mm-f"}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-trs-3.5mm-bal-m', '3.5mm TRS (Balanced Audio) (Male)', 'audio', 'trs-3.5mm-m', '{}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-trs-3.5mm-f', '3.5mm TRS (Female)', 'audio', 'trs-3.5mm-f', '{"trs-3.5mm-m","ts-3.5mm-m","ts-3.5mm-f","trrs-3.5mm-m","trrs-3.5mm-f"}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-trs-3.5mm-m', '3.5mm TRS (Male)', 'audio', 'trs-3.5mm-m', '{}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-trs-3.5mm-stereo-f', '3.5mm TRS (Stereo Audio) (Female)', 'audio', 'trs-3.5mm-f', '{"trs-3.5mm-m","ts-3.5mm-m","ts-3.5mm-f","trrs-3.5mm-m","trrs-3.5mm-f"}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-trs-3.5mm-stereo-m', '3.5mm TRS (Stereo Audio) (Male)', 'audio', 'trs-3.5mm-m', '{}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-midi-trs-a-f', '3.5mm TRS MIDI (Type A) (Female)', 'control', 'midi-trs-a-f', '{"midi-trs-a-m"}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-midi-trs-a-m', '3.5mm TRS MIDI (Type A) (Male)', 'control', 'midi-trs-a-m', '{}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-midi-trs-b-f', '3.5mm TRS MIDI (Type B) (Female)', 'control', 'midi-trs-b-f', '{"midi-trs-b-m"}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-midi-trs-b-m', '3.5mm TRS MIDI (Type B) (Male)', 'control', 'midi-trs-b-m', '{}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-ts-3.5mm-f', '3.5mm TS (Female)', 'audio', 'ts-3.5mm-f', '{"ts-3.5mm-m","trs-3.5mm-m","trs-3.5mm-f","trrs-3.5mm-m","trrs-3.5mm-f"}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-ts-3.5mm-m', '3.5mm TS (Male)', 'audio', 'ts-3.5mm-m', '{}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-ts-3.5mm-unbal-f', '3.5mm TS (Unbalanced Audio) (Female)', 'audio', 'ts-3.5mm-f', '{"ts-3.5mm-m","trs-3.5mm-m","trs-3.5mm-f","trrs-3.5mm-m","trrs-3.5mm-f"}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-ts-3.5mm-unbal-m', '3.5mm TS (Unbalanced Audio) (Male)', 'audio', 'ts-3.5mm-m', '{}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-apple-30pin-f', '30-pin Apple Dock Connector (Female)', 'usb', 'apple-30pin-f', '{"apple-30pin-m"}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-apple-30pin-m', '30-pin Apple Dock Connector (Male)', 'usb', 'apple-30pin-m', '{}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-trrrs-4.4mm-f', '4.4mm TRRRS (Female)', 'audio', 'trrrs-4.4mm-f', '{"trrrs-4.4mm-m"}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-trrrs-4.4mm-m', '4.4mm TRRRS (Male)', 'audio', 'trrrs-4.4mm-m', '{}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-banana-f', 'Banana (Female)', 'audio', 'banana-f', '{"banana-m"}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-banana-m', 'Banana (Male)', 'audio', 'banana-m', '{}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-bare-wire', 'Bare Wire', 'audio', 'bare-wire', '{}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-bnc-f', 'Coaxial BNC (Female)', 'video', 'bnc-f', '{"bnc-m"}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-bnc-m', 'Coaxial BNC (Male)', 'video', 'bnc-m', '{}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-coax-f-f', 'Coaxial F (Female)', 'video', 'coax-f-f', '{"coax-f-m"}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-coax-f-m', 'Coaxial F (Male)', 'video', 'coax-f-m', '{}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-coax-n-f', 'Coaxial N (Female)', 'other', 'coax-n-f', '{"coax-n-m"}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-coax-n-m', 'Coaxial N (Male)', 'other', 'coax-n-m', '{}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-coax-sma-f', 'Coaxial SMA (Female)', 'other', 'coax-sma-f', '{"coax-sma-m"}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-coax-sma-m', 'Coaxial SMA (Male)', 'other', 'coax-sma-m', '{}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-rca-composite-f', 'Composite Video (RCA) (Female)', 'video', 'rca-composite-f', '{"rca-composite-m"}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-rca-composite-m', 'Composite Video (RCA) (Male)', 'video', 'rca-composite-m', '{}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-displayport-f', 'DisplayPort (Female)', 'video', 'displayport-f', '{"displayport-m"}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-displayport-m', 'DisplayPort (Male)', 'video', 'displayport-m', '{}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-dvi-a-f', 'DVI-A (Female)', 'video', 'dvi-a-f', '{"dvi-a-m"}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-dvi-a-m', 'DVI-A (Male)', 'video', 'dvi-a-m', '{}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-dvi-d-dual-f', 'DVI-D (Dual Link) (Female)', 'video', 'dvi-d-dual-f', '{"dvi-d-dual-m","dvi-d-single-m"}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-dvi-d-dual-m', 'DVI-D (Dual Link) (Male)', 'video', 'dvi-d-dual-m', '{}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-dvi-d-single-f', 'DVI-D (Single Link) (Female)', 'video', 'dvi-d-single-f', '{"dvi-d-single-m"}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-dvi-d-single-m', 'DVI-D (Single Link) (Male)', 'video', 'dvi-d-single-m', '{}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-dvi-i-dual-f', 'DVI-I (Dual Link) (Female)', 'video', 'dvi-i-dual-f', '{"dvi-i-dual-m","dvi-i-single-m","dvi-d-dual-m","dvi-d-single-m","dvi-a-m"}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-dvi-i-dual-m', 'DVI-I (Dual Link) (Male)', 'video', 'dvi-i-dual-m', '{}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-dvi-i-single-f', 'DVI-I (Single Link) (Female)', 'video', 'dvi-i-single-f', '{"dvi-i-single-m","dvi-d-single-m","dvi-a-m"}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-dvi-i-single-m', 'DVI-I (Single Link) (Male)', 'video', 'dvi-i-single-m', '{}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-esata-f', 'eSATA (Female)', 'other', 'esata-f', '{"esata-m"}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-esata-m', 'eSATA (Male)', 'other', 'esata-m', '{}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-euroblock-f', 'Euroblock (Female)', 'audio', 'euroblock-f', '{"euroblock-m"}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-euroblock-m', 'Euroblock (Male)', 'audio', 'euroblock-m', '{}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-fiber-lc-f', 'Fiber LC (Female)', 'network', 'fiber-lc-f', '{"fiber-lc-m"}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-fiber-lc-m', 'Fiber LC (Male)', 'network', 'fiber-lc-m', '{}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-fiber-mtp-f', 'Fiber MTP/MPO (Female)', 'network', 'fiber-mtp-f', '{"fiber-mtp-m"}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-fiber-mtp-m', 'Fiber MTP/MPO (Male)', 'network', 'fiber-mtp-m', '{}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-fiber-sc-f', 'Fiber SC (Female)', 'network', 'fiber-sc-f', '{"fiber-sc-m"}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-fiber-sc-m', 'Fiber SC (Male)', 'network', 'fiber-sc-m', '{}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-fiber-st-f', 'Fiber ST (Female)', 'network', 'fiber-st-f', '{"fiber-st-m"}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-fiber-st-m', 'Fiber ST (Male)', 'network', 'fiber-st-m', '{}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-firewire400-4pin-f', 'FireWire 400 4-pin (Female)', 'other', 'firewire400-4pin-f', '{"firewire400-4pin-m"}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-firewire400-4pin-m', 'FireWire 400 4-pin (Male)', 'other', 'firewire400-4pin-m', '{}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-firewire400-6pin-f', 'FireWire 400 6-pin (Female)', 'other', 'firewire400-6pin-f', '{"firewire400-6pin-m"}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-firewire400-6pin-m', 'FireWire 400 6-pin (Male)', 'other', 'firewire400-6pin-m', '{}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-firewire800-f', 'FireWire 800 (Female)', 'other', 'firewire800-f', '{"firewire800-m"}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-firewire800-m', 'FireWire 800 (Male)', 'other', 'firewire800-m', '{}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-da15-gameport-f', 'Gameport DA-15 (Female)', 'other', 'da15-gameport-f', '{"da15-gameport-m"}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-da15-gameport-m', 'Gameport DA-15 (Male)', 'other', 'da15-gameport-m', '{}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-hdmi-f', 'HDMI (Female)', 'video', 'hdmi-f', '{"hdmi-m"}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-hdmi-m', 'HDMI (Male)', 'video', 'hdmi-m', '{}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-iec-c13-f', 'IEC C13 (Female)', 'power', 'iec-c13-f', '{"iec-c14-m"}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-iec-c14-m', 'IEC C14 (Male)', 'power', 'iec-c14-m', '{"iec-c13-f"}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-iec-generic-m', 'IEC Small Appliance Connector (Generic Male)', 'power', 'iec-generic-m', '{}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-iec-generic-f', 'IEC Small Appliance Inlet (Generic Female)', 'power', 'iec-generic-f', '{"iec-generic-m"}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-ir-3.5mm-f', 'IR (3.5mm Emitter/Receiver) (Female)', 'control', 'ir-3.5mm-f', '{"ir-3.5mm-m"}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-ir-3.5mm-m', 'IR (3.5mm Emitter/Receiver) (Male)', 'control', 'ir-3.5mm-m', '{}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-lightning-f', 'Lightning (Female)', 'usb', 'lightning-f', '{"lightning-m"}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-lightning-m', 'Lightning (Male)', 'usb', 'lightning-m', '{}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-hdmi-micro-f', 'Micro HDMI (Female)', 'video', 'hdmi-micro-f', '{"hdmi-micro-m"}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-hdmi-micro-m', 'Micro HDMI (Male)', 'video', 'hdmi-micro-m', '{}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-dvi-micro-f', 'Micro-DVI (Female)', 'video', 'dvi-micro-f', '{"dvi-micro-m"}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-dvi-micro-m', 'Micro-DVI (Male)', 'video', 'dvi-micro-m', '{}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-midi-din-f', 'MIDI (5-pin DIN) (Female)', 'control', 'midi-din-f', '{"midi-din-m"}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-midi-din-m', 'MIDI (5-pin DIN) (Male)', 'control', 'midi-din-m', '{}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-hdmi-mini-f', 'Mini HDMI (Female)', 'video', 'hdmi-mini-f', '{"hdmi-mini-m"}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-hdmi-mini-m', 'Mini HDMI (Male)', 'video', 'hdmi-mini-m', '{}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-dvi-mini-f', 'Mini-DVI (Female)', 'video', 'dvi-mini-f', '{"dvi-mini-m"}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-dvi-mini-m', 'Mini-DVI (Male)', 'video', 'dvi-mini-m', '{}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-nema-5-15p-m', 'NEMA 5-15P (Male)', 'power', 'nema-5-15p-m', '{}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-nema-5-15r-f', 'NEMA 5-15R (Female)', 'power', 'nema-5-15r-f', '{"nema-5-15p-m"}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-toslink-f', 'Optical TOSLINK (Jack)', 'audio', 'toslink-f', '{"toslink-m"}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-toslink-m', 'Optical TOSLINK (Plug)', 'audio', 'toslink-m', '{}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-db25-parallel-f', 'Parallel DB-25 (Female)', 'other', 'db25-parallel-f', '{"db25-parallel-m"}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-db25-parallel-m', 'Parallel DB-25 (Male)', 'other', 'db25-parallel-m', '{}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-ps2-f', 'PS/2 (Female)', 'control', 'ps2-f', '{"ps2-m"}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-ps2-m', 'PS/2 (Male)', 'control', 'ps2-m', '{}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-rca-spdif-f', 'RCA (S/PDIF) (Female)', 'audio', 'rca-audio-f', '{"rca-audio-m"}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-rca-spdif-m', 'RCA (S/PDIF) (Male)', 'audio', 'rca-audio-m', '{}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-rca-unbal-f', 'RCA (Unbalanced Audio) (Female)', 'audio', 'rca-audio-f', '{"rca-audio-m"}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-rca-unbal-m', 'RCA (Unbalanced Audio) (Male)', 'audio', 'rca-audio-m', '{}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-ring-terminal', 'Ring Terminal', 'audio', 'ring-terminal', '{}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-rj11-phone-f', 'RJ-11 Phone (Jack)', 'network', 'rj11-phone-f', '{"rj11-phone-m"}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-rj11-phone-m', 'RJ-11 Phone (Plug)', 'network', 'rj11-phone-m', '{}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-rj45-sfp-jack', 'RJ-45 (SFP) (Jack)', 'network', 'rj45-ethernet-f', '{"rj45-ethernet-m"}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-rj45-sfp-plug', 'RJ-45 (SFP) (Plug)', 'network', 'rj45-ethernet-m', '{}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-rj45-ethernet-f', 'RJ-45 Ethernet (Jack)', 'network', 'rj45-ethernet-f', '{"rj45-ethernet-m"}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-rj45-ethernet-m', 'RJ-45 Ethernet (Plug)', 'network', 'rj45-ethernet-m', '{}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-svideo-f', 'S-Video (Female)', 'video', 'svideo-f', '{"svideo-m"}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-svideo-m', 'S-Video (Male)', 'video', 'svideo-m', '{}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-scart-f', 'SCART (Female)', 'video', 'scart-f', '{"scart-m"}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-scart-m', 'SCART (Male)', 'video', 'scart-m', '{}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-de9-serial-f', 'Serial RS232 DE-9 (Female)', 'control', 'de9-serial-f', '{"de9-serial-m"}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-de9-serial-m', 'Serial RS232 DE-9 (Male)', 'control', 'de9-serial-m', '{}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-spade-terminal', 'Spade Terminal', 'audio', 'spade-terminal', '{}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-speakon-nl2-jack', 'Speakon NL2 (Jack)', 'audio', 'speakon-nl2-jack', '{"speakon-nl2-plug"}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-speakon-nl2-plug', 'Speakon NL2 (Plug)', 'audio', 'speakon-nl2-plug', '{}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-speakon-nl4-jack', 'Speakon NL4 (Jack)', 'audio', 'speakon-nl4-jack', '{"speakon-nl4-plug","speakon-nl2-plug"}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-speakon-nl4-plug', 'Speakon NL4 (Plug)', 'audio', 'speakon-nl4-plug', '{}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-speakon-nl8-jack', 'Speakon NL8 (Jack)', 'audio', 'speakon-nl8-jack', '{"speakon-nl8-plug","speakon-nl2-plug","speakon-nl4-plug"}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-speakon-nl8-plug', 'Speakon NL8 (Plug)', 'audio', 'speakon-nl8-plug', '{}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-thunderbolt-12-mdp-f', 'Thunderbolt 1/2 (Mini DisplayPort) (Female)', 'video', 'thunderbolt-12-mdp-f', '{"thunderbolt-12-mdp-m"}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-thunderbolt-12-mdp-m', 'Thunderbolt 1/2 (Mini DisplayPort) (Male)', 'video', 'thunderbolt-12-mdp-m', '{}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-usb-3-b-f', 'USB 3.0 B (Female)', 'usb', 'usb-3-b-f', '{"usb-3-b-m","usb-b-m"}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-usb-3-b-m', 'USB 3.0 B (Male)', 'usb', 'usb-3-b-m', '{}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-usb-3-micro-b-f', 'USB 3.0 Micro-B (Female)', 'usb', 'usb-3-micro-b-f', '{"usb-3-micro-b-m","usb-micro-b-m"}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-usb-3-micro-b-m', 'USB 3.0 Micro-B (Male)', 'usb', 'usb-3-micro-b-m', '{}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-usb-micro-a-f', 'USB Micro-A (Female)', 'usb', 'usb-micro-a-f', '{"usb-micro-a-m"}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-usb-micro-a-m', 'USB Micro-A (Male)', 'usb', 'usb-micro-a-m', '{}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-usb-micro-b-f', 'USB Micro-B (Female)', 'usb', 'usb-micro-b-f', '{"usb-micro-b-m"}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-usb-micro-b-m', 'USB Micro-B (Male)', 'usb', 'usb-micro-b-m', '{}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-usb-mini-b-f', 'USB Mini-B (Female)', 'usb', 'usb-mini-b-f', '{"usb-mini-b-m"}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-usb-mini-b-m', 'USB Mini-B (Male)', 'usb', 'usb-mini-b-m', '{}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-usb-a-f', 'USB-A (Female)', 'usb', 'usb-a-f', '{"usb-a-m"}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-usb-a-m', 'USB-A (Male)', 'usb', 'usb-a-m', '{}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-usb-b-f', 'USB-B (Female)', 'usb', 'usb-b-f', '{"usb-b-m"}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-usb-b-m', 'USB-B (Male)', 'usb', 'usb-b-m', '{}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-usb-c-f', 'USB-C (Female)', 'usb', 'usb-c-f', '{"usb-c-m","usb-c-host-f","usb-c-device-f"}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-usb-c-m', 'USB-C (Male)', 'usb', 'usb-c-m', '{}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-usb-c-tb3-f', 'USB-C (Thunderbolt 3) (Female)', 'usb', 'usb-c-f', '{"usb-c-m"}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-usb-c-tb3-m', 'USB-C (Thunderbolt 3) (Male)', 'usb', 'usb-c-m', '{}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-usb-c-tb4-f', 'USB-C (Thunderbolt 4) (Female)', 'usb', 'usb-c-f', '{"usb-c-m"}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-usb-c-tb4-m', 'USB-C (Thunderbolt 4) (Male)', 'usb', 'usb-c-m', '{}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-usb-c-tb5-f', 'USB-C (Thunderbolt 5) (Female)', 'usb', 'usb-c-f', '{"usb-c-m"}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-usb-c-tb5-m', 'USB-C (Thunderbolt 5) (Male)', 'usb', 'usb-c-m', '{}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-usb-c-3-f', 'USB-C (USB 3.0) (Female)', 'usb', 'usb-c-f', '{"usb-c-m"}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-usb-c-3-m', 'USB-C (USB 3.0) (Male)', 'usb', 'usb-c-m', '{}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-usb-c-4-f', 'USB-C (USB 4.0) (Female)', 'usb', 'usb-c-f', '{"usb-c-m"}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-usb-c-4-m', 'USB-C (USB 4.0) (Male)', 'usb', 'usb-c-m', '{}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-usb-c-device-f', 'USB-C Device (Female)', 'usb', 'usb-c-device-f', '{"usb-c-m","usb-c-host-f","usb-c-f"}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-usb-c-host-f', 'USB-C Host (Female)', 'usb', 'usb-c-host-f', '{"usb-c-m","usb-c-device-f","usb-c-f"}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-vga-f', 'VGA (Female)', 'video', 'vga-f', '{"vga-m"}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-vga-m', 'VGA (Male)', 'video', 'vga-m', '{}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-xlr-f', 'XLR (Female)', 'audio', 'xlr-f', '{"xlr-m"}', null, true);
|
|
insert into public.port_types (id, name, category, family, compatible_family_ids, max_connections, is_public) values ('pt-xlr-m', 'XLR (Male)', 'audio', 'xlr-m', '{}', null, true);
|
|
|
|
-- Cable types
|
|
insert into public.cable_types (id, name, family, family2, unit, cost_per_unit, is_public) values ('ct-trs-6.35mm', '1/4in TRS Cable (Male-Male)', 'trs-6.35mm-m', null, 'ft', null, true);
|
|
insert into public.cable_types (id, name, family, family2, unit, cost_per_unit, is_public) values ('ct-ts-6.35mm', '1/4in TS Cable (Male-Male)', 'ts-6.35mm-m', null, 'ft', null, true);
|
|
insert into public.cable_types (id, name, family, family2, unit, cost_per_unit, is_public) values ('ct-trrs-2.5mm', '2.5mm TRRS Cable (Male-Male)', 'trrs-2.5mm-m', null, 'ft', null, true);
|
|
insert into public.cable_types (id, name, family, family2, unit, cost_per_unit, is_public) values ('ct-trs-2.5mm', '2.5mm TRS Cable (Male-Male)', 'trs-2.5mm-m', null, 'ft', null, true);
|
|
insert into public.cable_types (id, name, family, family2, unit, cost_per_unit, is_public) values ('ct-ts-2.5mm', '2.5mm TS Cable (Male-Male)', 'ts-2.5mm-m', null, 'ft', null, true);
|
|
insert into public.cable_types (id, name, family, family2, unit, cost_per_unit, is_public) values ('ct-trrs-3.5mm', '3.5mm TRRS Cable (Male-Male)', 'trrs-3.5mm-m', null, 'ft', null, true);
|
|
insert into public.cable_types (id, name, family, family2, unit, cost_per_unit, is_public) values ('ct-trs-3.5mm', '3.5mm TRS Cable (Male-Male)', 'trs-3.5mm-m', null, 'ft', null, true);
|
|
insert into public.cable_types (id, name, family, family2, unit, cost_per_unit, is_public) values ('ct-midi-trs-a', '3.5mm TRS MIDI (Type A) Cable (Male-Male)', 'midi-trs-a-m', null, 'ft', null, true);
|
|
insert into public.cable_types (id, name, family, family2, unit, cost_per_unit, is_public) values ('ct-midi-trs-b', '3.5mm TRS MIDI (Type B) Cable (Male-Male)', 'midi-trs-b-m', null, 'ft', null, true);
|
|
insert into public.cable_types (id, name, family, family2, unit, cost_per_unit, is_public) values ('ct-ts-3.5mm', '3.5mm TS Cable (Male-Male)', 'ts-3.5mm-m', null, 'ft', null, true);
|
|
insert into public.cable_types (id, name, family, family2, unit, cost_per_unit, is_public) values ('ct-apple-30pin', '30-pin Apple Dock Connector Cable (Male-Male)', 'apple-30pin-m', null, 'ft', null, true);
|
|
insert into public.cable_types (id, name, family, family2, unit, cost_per_unit, is_public) values ('ct-trrrs-4.4mm', '4.4mm TRRRS Cable (Male-Male)', 'trrrs-4.4mm-m', null, 'ft', null, true);
|
|
insert into public.cable_types (id, name, family, family2, unit, cost_per_unit, is_public) values ('ct-banana', 'Banana Cable (Male-Male)', 'banana-m', null, 'ft', null, true);
|
|
insert into public.cable_types (id, name, family, family2, unit, cost_per_unit, is_public) values ('ct-bnc', 'Coaxial BNC Cable (Male-Male)', 'bnc-m', null, 'ft', null, true);
|
|
insert into public.cable_types (id, name, family, family2, unit, cost_per_unit, is_public) values ('ct-coax-f', 'Coaxial F Cable (Male-Male)', 'coax-f-m', null, 'ft', null, true);
|
|
insert into public.cable_types (id, name, family, family2, unit, cost_per_unit, is_public) values ('ct-coax-n', 'Coaxial N Cable (Male-Male)', 'coax-n-m', null, 'ft', null, true);
|
|
insert into public.cable_types (id, name, family, family2, unit, cost_per_unit, is_public) values ('ct-coax-sma', 'Coaxial SMA Cable (Male-Male)', 'coax-sma-m', null, 'ft', null, true);
|
|
insert into public.cable_types (id, name, family, family2, unit, cost_per_unit, is_public) values ('ct-rca-composite', 'Composite Video Cable (RCA, Male-Male)', 'rca-composite-m', null, 'ft', null, true);
|
|
insert into public.cable_types (id, name, family, family2, unit, cost_per_unit, is_public) values ('ct-displayport', 'DisplayPort Cable (Male-Male)', 'displayport-m', null, 'ft', null, true);
|
|
insert into public.cable_types (id, name, family, family2, unit, cost_per_unit, is_public) values ('ct-dvi-a', 'DVI-A Cable (Male-Male)', 'dvi-a-m', null, 'ft', null, true);
|
|
insert into public.cable_types (id, name, family, family2, unit, cost_per_unit, is_public) values ('ct-dvi-d-dual', 'DVI-D (Dual Link) Cable (Male-Male)', 'dvi-d-dual-m', null, 'ft', null, true);
|
|
insert into public.cable_types (id, name, family, family2, unit, cost_per_unit, is_public) values ('ct-dvi-d-single', 'DVI-D (Single Link) Cable (Male-Male)', 'dvi-d-single-m', null, 'ft', null, true);
|
|
insert into public.cable_types (id, name, family, family2, unit, cost_per_unit, is_public) values ('ct-dvi-i-dual', 'DVI-I (Dual Link) Cable (Male-Male)', 'dvi-i-dual-m', null, 'ft', null, true);
|
|
insert into public.cable_types (id, name, family, family2, unit, cost_per_unit, is_public) values ('ct-dvi-i-single', 'DVI-I (Single Link) Cable (Male-Male)', 'dvi-i-single-m', null, 'ft', null, true);
|
|
insert into public.cable_types (id, name, family, family2, unit, cost_per_unit, is_public) values ('ct-bridge-d0fa9517', 'DVI-I to VGA Cable', 'dvi-i-single-m', 'vga-m', 'ft', null, true);
|
|
insert into public.cable_types (id, name, family, family2, unit, cost_per_unit, is_public) values ('ct-esata', 'eSATA Cable (Male-Male)', 'esata-m', null, 'ft', null, true);
|
|
insert into public.cable_types (id, name, family, family2, unit, cost_per_unit, is_public) values ('ct-euroblock', 'Euroblock Cable (Male-Male)', 'euroblock-m', null, 'ft', null, true);
|
|
insert into public.cable_types (id, name, family, family2, unit, cost_per_unit, is_public) values ('ct-firewire400-4pin', 'FireWire 400 4-pin Cable (Male-Male)', 'firewire400-4pin-m', null, 'ft', null, true);
|
|
insert into public.cable_types (id, name, family, family2, unit, cost_per_unit, is_public) values ('ct-firewire400-6pin', 'FireWire 400 6-pin Cable (Male-Male)', 'firewire400-6pin-m', null, 'ft', null, true);
|
|
insert into public.cable_types (id, name, family, family2, unit, cost_per_unit, is_public) values ('ct-bridge-9d257d85', 'FireWire 400 6-pin to 4-pin Cable', 'firewire400-6pin-m', 'firewire400-4pin-m', 'ft', null, true);
|
|
insert into public.cable_types (id, name, family, family2, unit, cost_per_unit, is_public) values ('ct-firewire800', 'FireWire 800 Cable (Male-Male)', 'firewire800-m', null, 'ft', null, true);
|
|
insert into public.cable_types (id, name, family, family2, unit, cost_per_unit, is_public) values ('ct-da15-gameport', 'Gameport DA-15 Cable (Male-Male)', 'da15-gameport-m', null, 'ft', null, true);
|
|
insert into public.cable_types (id, name, family, family2, unit, cost_per_unit, is_public) values ('ct-iec-generic-power-cord', 'Generic Small Appliance Power Cord (to NEMA 5-15P)', 'iec-generic-m', 'nema-5-15p-m', 'ft', null, true);
|
|
insert into public.cable_types (id, name, family, family2, unit, cost_per_unit, is_public) values ('ct-hdmi', 'HDMI Cable (Male-Male)', 'hdmi-m', null, 'ft', null, true);
|
|
insert into public.cable_types (id, name, family, family2, unit, cost_per_unit, is_public) values ('ct-bridge-d6e40e1e', 'HDMI to Micro HDMI Cable', 'hdmi-m', 'hdmi-micro-m', 'ft', null, true);
|
|
insert into public.cable_types (id, name, family, family2, unit, cost_per_unit, is_public) values ('ct-bridge-0b94248e', 'HDMI to Mini HDMI Cable', 'hdmi-m', 'hdmi-mini-m', 'ft', null, true);
|
|
insert into public.cable_types (id, name, family, family2, unit, cost_per_unit, is_public) values ('ct-iec-power-cord', 'IEC Power Cord (C13 to NEMA 5-15P)', 'iec-c13-f', 'nema-5-15p-m', 'ft', null, true);
|
|
insert into public.cable_types (id, name, family, family2, unit, cost_per_unit, is_public) values ('ct-ir-3.5mm', 'IR (3.5mm) Cable (Male-Male)', 'ir-3.5mm-m', null, 'ft', null, true);
|
|
insert into public.cable_types (id, name, family, family2, unit, cost_per_unit, is_public) values ('ct-fiber-lc-mm', 'LC Fiber Cable (Multimode OM4, Male-Male)', 'fiber-lc-m', null, 'ft', null, true);
|
|
insert into public.cable_types (id, name, family, family2, unit, cost_per_unit, is_public) values ('ct-fiber-lc-sm-apc', 'LC Fiber Cable (Single-Mode OS2, APC, Male-Male)', 'fiber-lc-m', null, 'ft', null, true);
|
|
insert into public.cable_types (id, name, family, family2, unit, cost_per_unit, is_public) values ('ct-fiber-lc-sm-upc', 'LC Fiber Cable (Single-Mode OS2, UPC, Male-Male)', 'fiber-lc-m', null, 'ft', null, true);
|
|
insert into public.cable_types (id, name, family, family2, unit, cost_per_unit, is_public) values ('ct-lightning', 'Lightning Cable (Male-Male)', 'lightning-m', null, 'ft', null, true);
|
|
insert into public.cable_types (id, name, family, family2, unit, cost_per_unit, is_public) values ('ct-hdmi-micro', 'Micro HDMI Cable (Male-Male)', 'hdmi-micro-m', null, 'ft', null, true);
|
|
insert into public.cable_types (id, name, family, family2, unit, cost_per_unit, is_public) values ('ct-dvi-micro', 'Micro-DVI Cable (Male-Male)', 'dvi-micro-m', null, 'ft', null, true);
|
|
insert into public.cable_types (id, name, family, family2, unit, cost_per_unit, is_public) values ('ct-bridge-059a26fc', 'Micro-DVI to DVI Adapter Cable', 'dvi-micro-m', 'dvi-d-single-m', 'ft', null, true);
|
|
insert into public.cable_types (id, name, family, family2, unit, cost_per_unit, is_public) values ('ct-midi-din', 'MIDI (5-pin DIN) Cable (Male-Male)', 'midi-din-m', null, 'ft', null, true);
|
|
insert into public.cable_types (id, name, family, family2, unit, cost_per_unit, is_public) values ('ct-hdmi-mini', 'Mini HDMI Cable (Male-Male)', 'hdmi-mini-m', null, 'ft', null, true);
|
|
insert into public.cable_types (id, name, family, family2, unit, cost_per_unit, is_public) values ('ct-dvi-mini', 'Mini-DVI Cable (Male-Male)', 'dvi-mini-m', null, 'ft', null, true);
|
|
insert into public.cable_types (id, name, family, family2, unit, cost_per_unit, is_public) values ('ct-bridge-8aa72e71', 'Mini-DVI to DVI Adapter Cable', 'dvi-mini-m', 'dvi-d-single-m', 'ft', null, true);
|
|
insert into public.cable_types (id, name, family, family2, unit, cost_per_unit, is_public) values ('ct-fiber-mtp-mm', 'MTP/MPO Fiber Cable (Multimode OM4, 12-fiber, Male-Female)', 'fiber-mtp-m', 'fiber-mtp-f', 'ft', null, true);
|
|
insert into public.cable_types (id, name, family, family2, unit, cost_per_unit, is_public) values ('ct-fiber-mtp-sm', 'MTP/MPO Fiber Cable (Single-Mode OS2, 12-fiber, Male-Female)', 'fiber-mtp-m', 'fiber-mtp-f', 'ft', null, true);
|
|
insert into public.cable_types (id, name, family, family2, unit, cost_per_unit, is_public) values ('ct-nema-5-15-ext', 'NEMA 5-15 Extension Cable (5-15P to 5-15R)', 'nema-5-15p-m', 'nema-5-15r-f', 'ft', null, true);
|
|
insert into public.cable_types (id, name, family, family2, unit, cost_per_unit, is_public) values ('ct-toslink', 'Optical TOSLINK Cable (Plug-Plug)', 'toslink-m', null, 'ft', null, true);
|
|
insert into public.cable_types (id, name, family, family2, unit, cost_per_unit, is_public) values ('ct-db25-parallel', 'Parallel DB-25 Cable (Male-Male)', 'db25-parallel-m', null, 'ft', null, true);
|
|
insert into public.cable_types (id, name, family, family2, unit, cost_per_unit, is_public) values ('ct-ps2', 'PS/2 Cable (Male-Male)', 'ps2-m', null, 'ft', null, true);
|
|
insert into public.cable_types (id, name, family, family2, unit, cost_per_unit, is_public) values ('ct-rca-audio', 'RCA Cable (Male-Male)', 'rca-audio-m', null, 'ft', null, true);
|
|
insert into public.cable_types (id, name, family, family2, unit, cost_per_unit, is_public) values ('ct-rj11-phone', 'RJ-11 Phone Cable (Plug-Plug)', 'rj11-phone-m', null, 'ft', null, true);
|
|
insert into public.cable_types (id, name, family, family2, unit, cost_per_unit, is_public) values ('ct-rj45-ethernet', 'RJ-45 Ethernet Cable (Plug-Plug)', 'rj45-ethernet-m', null, 'ft', null, true);
|
|
insert into public.cable_types (id, name, family, family2, unit, cost_per_unit, is_public) values ('ct-svideo', 'S-Video Cable (Male-Male)', 'svideo-m', null, 'ft', null, true);
|
|
insert into public.cable_types (id, name, family, family2, unit, cost_per_unit, is_public) values ('ct-fiber-sc-mm', 'SC Fiber Cable (Multimode OM4, Male-Male)', 'fiber-sc-m', null, 'ft', null, true);
|
|
insert into public.cable_types (id, name, family, family2, unit, cost_per_unit, is_public) values ('ct-fiber-sc-sm-apc', 'SC Fiber Cable (Single-Mode OS2, APC, Male-Male)', 'fiber-sc-m', null, 'ft', null, true);
|
|
insert into public.cable_types (id, name, family, family2, unit, cost_per_unit, is_public) values ('ct-fiber-sc-sm-upc', 'SC Fiber Cable (Single-Mode OS2, UPC, Male-Male)', 'fiber-sc-m', null, 'ft', null, true);
|
|
insert into public.cable_types (id, name, family, family2, unit, cost_per_unit, is_public) values ('ct-scart', 'SCART Cable (Male-Male)', 'scart-m', null, 'ft', null, true);
|
|
insert into public.cable_types (id, name, family, family2, unit, cost_per_unit, is_public) values ('ct-sdi-12g', 'SDI Cable (12G-SDI, BNC, Male-Male)', 'bnc-m', null, 'ft', null, true);
|
|
insert into public.cable_types (id, name, family, family2, unit, cost_per_unit, is_public) values ('ct-sdi-3g', 'SDI Cable (3G-SDI, BNC, Male-Male)', 'bnc-m', null, 'ft', null, true);
|
|
insert into public.cable_types (id, name, family, family2, unit, cost_per_unit, is_public) values ('ct-sdi-hd', 'SDI Cable (HD-SDI, BNC, Male-Male)', 'bnc-m', null, 'ft', null, true);
|
|
insert into public.cable_types (id, name, family, family2, unit, cost_per_unit, is_public) values ('ct-de9-serial', 'Serial RS232 DE-9 Cable (Male-Male)', 'de9-serial-m', null, 'ft', null, true);
|
|
insert into public.cable_types (id, name, family, family2, unit, cost_per_unit, is_public) values ('ct-speakon-nl2', 'Speakon NL2 Cable (Plug-Plug)', 'speakon-nl2-plug', null, 'ft', null, true);
|
|
insert into public.cable_types (id, name, family, family2, unit, cost_per_unit, is_public) values ('ct-speakon-nl4', 'Speakon NL4 Cable (Plug-Plug)', 'speakon-nl4-plug', null, 'ft', null, true);
|
|
insert into public.cable_types (id, name, family, family2, unit, cost_per_unit, is_public) values ('ct-speakon-nl8', 'Speakon NL8 Cable (Plug-Plug)', 'speakon-nl8-plug', null, 'ft', null, true);
|
|
insert into public.cable_types (id, name, family, family2, unit, cost_per_unit, is_public) values ('ct-fiber-st-mm', 'ST Fiber Cable (Multimode OM1, Male-Male)', 'fiber-st-m', null, 'ft', null, true);
|
|
insert into public.cable_types (id, name, family, family2, unit, cost_per_unit, is_public) values ('ct-thunderbolt-12-mdp', 'Thunderbolt 1/2 (Mini DisplayPort) Cable (Male-Male)', 'thunderbolt-12-mdp-m', null, 'ft', null, true);
|
|
insert into public.cable_types (id, name, family, family2, unit, cost_per_unit, is_public) values ('ct-bridge-a697c221', 'Thunderbolt 1/2 (Mini DisplayPort) to DisplayPort Cable', 'thunderbolt-12-mdp-m', 'displayport-m', 'ft', null, true);
|
|
insert into public.cable_types (id, name, family, family2, unit, cost_per_unit, is_public) values ('ct-bridge-e7860b7d', 'Thunderbolt 1/2 (Mini DisplayPort) to HDMI Cable', 'thunderbolt-12-mdp-m', 'hdmi-m', 'ft', null, true);
|
|
insert into public.cable_types (id, name, family, family2, unit, cost_per_unit, is_public) values ('ct-midi-trs-a-to-din', 'TRS MIDI (Type A) to 5-pin DIN MIDI Adapter Cable', 'midi-trs-a-m', 'midi-din-m', 'ft', null, true);
|
|
insert into public.cable_types (id, name, family, family2, unit, cost_per_unit, is_public) values ('ct-midi-trs-b-to-din', 'TRS MIDI (Type B) to 5-pin DIN MIDI Adapter Cable', 'midi-trs-b-m', 'midi-din-m', 'ft', null, true);
|
|
insert into public.cable_types (id, name, family, family2, unit, cost_per_unit, is_public) values ('ct-midi-trs-a-to-b', 'TRS MIDI Type A to Type B Adapter Cable', 'midi-trs-a-m', 'midi-trs-b-m', 'ft', null, true);
|
|
insert into public.cable_types (id, name, family, family2, unit, cost_per_unit, is_public) values ('ct-usb-3-b', 'USB 3.0 B Cable (Male-Male)', 'usb-3-b-m', null, 'ft', null, true);
|
|
insert into public.cable_types (id, name, family, family2, unit, cost_per_unit, is_public) values ('ct-usb-3-micro-b', 'USB 3.0 Micro-B Cable (Male-Male)', 'usb-3-micro-b-m', null, 'ft', null, true);
|
|
insert into public.cable_types (id, name, family, family2, unit, cost_per_unit, is_public) values ('ct-usb-micro-a', 'USB Micro-A Cable (Male-Male)', 'usb-micro-a-m', null, 'ft', null, true);
|
|
insert into public.cable_types (id, name, family, family2, unit, cost_per_unit, is_public) values ('ct-usb-micro-b', 'USB Micro-B Cable (Male-Male)', 'usb-micro-b-m', null, 'ft', null, true);
|
|
insert into public.cable_types (id, name, family, family2, unit, cost_per_unit, is_public) values ('ct-usb-mini-b', 'USB Mini-B Cable (Male-Male)', 'usb-mini-b-m', null, 'ft', null, true);
|
|
insert into public.cable_types (id, name, family, family2, unit, cost_per_unit, is_public) values ('ct-usb-a', 'USB-A Cable (Male-Male)', 'usb-a-m', null, 'ft', null, true);
|
|
insert into public.cable_types (id, name, family, family2, unit, cost_per_unit, is_public) values ('ct-bridge-ca20f06e', 'USB-A to Micro-B Cable', 'usb-a-m', 'usb-micro-b-m', 'ft', null, true);
|
|
insert into public.cable_types (id, name, family, family2, unit, cost_per_unit, is_public) values ('ct-bridge-9d98ff40', 'USB-A to Mini-B Cable', 'usb-a-m', 'usb-mini-b-m', 'ft', null, true);
|
|
insert into public.cable_types (id, name, family, family2, unit, cost_per_unit, is_public) values ('ct-bridge-0e6a1d1a', 'USB-A to USB-B Cable', 'usb-a-m', 'usb-b-m', 'ft', null, true);
|
|
insert into public.cable_types (id, name, family, family2, unit, cost_per_unit, is_public) values ('ct-bridge-2ff334f7', 'USB-A to USB-C Cable', 'usb-a-m', 'usb-c-m', 'ft', null, true);
|
|
insert into public.cable_types (id, name, family, family2, unit, cost_per_unit, is_public) values ('ct-usb-b', 'USB-B Cable (Male-Male)', 'usb-b-m', null, 'ft', null, true);
|
|
insert into public.cable_types (id, name, family, family2, unit, cost_per_unit, is_public) values ('ct-usb-c', 'USB-C Cable (Male-Male)', 'usb-c-m', null, 'ft', null, true);
|
|
insert into public.cable_types (id, name, family, family2, unit, cost_per_unit, is_public) values ('ct-bridge-aef42c66', 'USB-C to Micro-B Cable', 'usb-c-m', 'usb-micro-b-m', 'ft', null, true);
|
|
insert into public.cable_types (id, name, family, family2, unit, cost_per_unit, is_public) values ('ct-vga', 'VGA Cable (Male-Male)', 'vga-m', null, 'ft', null, true);
|
|
insert into public.cable_types (id, name, family, family2, unit, cost_per_unit, is_public) values ('ct-xlr', 'XLR Cable (Male-Male)', 'xlr-m', null, 'ft', null, true);
|
|
insert into public.cable_types (id, name, family, family2, unit, cost_per_unit, is_public) values ('ct-bridge-1a2f43f6', 'XLR to 1/4in TRS Cable', 'xlr-m', 'trs-6.35mm-m', 'ft', null, true);
|
|
|
|
-- Device templates + their ports
|
|
insert into public.device_templates (id, name, category_id, manufacturer_id, model, cost, is_public) values ('dt-trs35-coupler-ff', '3.5mm TRS Coupler (Female-Female)', 'adapter', null, null, null, true);
|
|
insert into public.device_template_ports (id, device_template_id, name, direction, port_type_id, sort_order, built_in_cable) values ('9185c81a-d109-4e53-9493-f1e24ac19f99', 'dt-trs35-coupler-ff', '3.5mm TRS A', 'bidirectional', 'pt-trs-3.5mm-f', 0, false);
|
|
insert into public.device_template_ports (id, device_template_id, name, direction, port_type_id, sort_order, built_in_cable) values ('c5a38999-8b9a-4ec4-95fa-3a660d2c2c3f', 'dt-trs35-coupler-ff', '3.5mm TRS B', 'bidirectional', 'pt-trs-3.5mm-f', 1, false);
|
|
insert into public.device_templates (id, name, category_id, manufacturer_id, model, cost, is_public) values ('dt-rca-coupler-ff', 'RCA Coupler (Female-Female)', 'adapter', null, null, null, true);
|
|
insert into public.device_template_ports (id, device_template_id, name, direction, port_type_id, sort_order, built_in_cable) values ('0c7e924a-6ea5-4433-b224-57a3c533954b', 'dt-rca-coupler-ff', 'RCA A', 'bidirectional', 'pt-rca-unbal-f', 0, false);
|
|
insert into public.device_template_ports (id, device_template_id, name, direction, port_type_id, sort_order, built_in_cable) values ('0769c32d-0d9f-4045-85b0-75548e86a88b', 'dt-rca-coupler-ff', 'RCA B', 'bidirectional', 'pt-rca-unbal-f', 1, false);
|
|
insert into public.device_templates (id, name, category_id, manufacturer_id, model, cost, is_public) values ('dt-xlr-genderchanger-mm', 'XLR Gender Changer (Male-Male)', 'adapter', null, null, null, true);
|
|
insert into public.device_template_ports (id, device_template_id, name, direction, port_type_id, sort_order, built_in_cable) values ('7a3209c7-7c1f-48de-9c3b-e97874efc50c', 'dt-xlr-genderchanger-mm', 'XLR A', 'bidirectional', 'pt-xlr-m', 0, false);
|
|
insert into public.device_template_ports (id, device_template_id, name, direction, port_type_id, sort_order, built_in_cable) values ('098854e9-af35-4118-b05e-b245ca63585e', 'dt-xlr-genderchanger-mm', 'XLR B', 'bidirectional', 'pt-xlr-m', 1, false);
|
|
|