Difference between revisions of "Stdorgname Table"
Jump to navigation
Jump to search
(Created page with "Return to Patent Data Specifications. Table "public.stdorgname" Column | Type | Modifiers -----------+------------------------+-----...") |
|||
| (10 intermediate revisions by one other user not shown) | |||
| Line 1: | Line 1: | ||
| − | Return to [[Patent | + | 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 "public.stdorgname" | Table "public.stdorgname" | ||
Column | Type | Modifiers | Column | Type | Modifiers | ||
| Line 23: | Line 28: | ||
02 Micro, Inc | 02 Micro, Inc | ||
02Micro Intermnational Limited | 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== | ||
| + | [[Category: Internal]] | ||
| + | [[Internal Classification: Data Tables| ]] | ||
Latest revision as of 18: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.
