Difference between revisions of "Stdorgname Table"

From edegan.com
Jump to navigation Jump to search
 
(5 intermediate revisions by one other user not shown)
Line 1: Line 1:
Return to [[Patent Data Specifications]].
+
Return to [[Patent]].
  
 +
==Table Purpose==
 +
<section begin="std" />
 +
The Stdorgname Table is used to standardize firm names in the database in the Matchorgname Table.
 +
<section end="std" />
 
==Table Structure==
 
==Table Structure==
 
             Table "public.stdorgname"
 
             Table "public.stdorgname"
Line 27: Line 31:
 
==Table Variables==
 
==Table Variables==
 
The table consists of all the aliases and variations of a firm's name. Each entry is unique.
 
The table consists of all the aliases and variations of a firm's name. Each entry is unique.
 
==Table Purpose==
 
The Stdorgname Table was used to standardize firm names in the database in the Matchorgname Table.
 
  
 
==Current Problems==
 
==Current Problems==
 +
[[Category: Internal]]
 +
[[Internal Classification: Data Tables| ]]

Latest revision as of 17:09, 2 September 2016

Return to Patent.

Table Purpose

The Stdorgname Table is used to standardize firm names in the database in the Matchorgname Table.

Table Structure

            Table "public.stdorgname"
  Column   |          Type          | Modifiers 
-----------+------------------------+-----------
stdorgname | character varying(255) | 
stdorgname            
---------------------------------
000 “Midera-K”
000 “MP ELSYS”
002134761 Ontario Ltd.
002152706 Ontario Ltd.
0055 Management Services Pty Ltd
01Click, L.L.C.
01 Communique Laboratory Inc.
01 dB Metravib
01 Inc.
0200L, LLC
02 (Germany) GmbH & Co. OHG
02IC, Inc.
02Micro
02 Micro, Inc
02Micro Intermnational Limited

Table Variables

The table consists of all the aliases and variations of a firm's name. Each entry is unique.

Current Problems