Just for keeping track of schemas

[billyeh]

Patent Disambiguation Schemas

Assignee

CREATE TABLE assignee (
                Patent VARCHAR(8),
                AsgType INTEGER,
                Assignee VARCHAR(30),
                City VARCHAR(10),
                State VARCHAR(2),
                Country VARCHAR(2),
                Nationality VARCHAR(2),
                Residence VARCHAR(2),
                AsgSeq INTEGER);
CREATE UNIQUE INDEX uqAsg ON assignee (Patent, AsgSeq);

Citation

CREATE TABLE citation (
                Patent VARCHAR(8),
                Cit_Date INTEGER,
                Cit_Name VARCHAR(10),
                Cit_Kind VARCHAR(1),
                Cit_Country VARCHAR(2),
                Citation VARCHAR(8),
                Category VARCHAR(15),
                CitSeq INTEGER);
CREATE UNIQUE INDEX uqCit ON citation (Patent, CitSeq);

Class

CREATE TABLE class (
                Patent VARCHAR(8),
                Prim INTEGER,
                Class VARCHAR(3),
                SubClass VARCHAR(3));
CREATE UNIQUE INDEX uqClass ON class (Patent, Class, SubClass);

Inventor

CREATE TABLE inventor (
                Patent VARCHAR(8),
                Firstname VARCHAR(15),
                Lastname VARCHAR(15),
                Street VARCHAR(15),
                City VARCHAR(10),
                State VARCHAR(2),
                Country VARCHAR(12),
                Zipcode VARCHAR(5),
                Nationality VARCHAR(2),
                InvSeq INTEGER);
CREATE UNIQUE INDEX uqInv ON inventor (Patent, InvSeq);

Lawyer

CREATE TABLE lawyer (
                Patent VARCHAR(8),
                Firstname VARCHAR(15),
                Lastname VARCHAR(15),
                LawCountry VARCHAR(2),
                OrgName VARCHAR(20),
                LawSeq INTEGER);
CREATE UNIQUE INDEX uqLawyer ON lawyer (Patent, LawSeq);

Patdesc

CREATE TABLE patdesc (
                Patent VARCHAR(8),
                Abstract VARCHAR(50),
                Title VARCHAR(20));
CREATE UNIQUE INDEX uqPatDesc ON patdesc (Patent);

Patent

CREATE TABLE patent (
                Patent VARCHAR(8),
                Kind VARCHAR(3),
                Claims INTEGER,
                AppType INTEGER,
                AppNum VARCHAR(8),
                GDate INTEGER,
                GYear INTEGER,
                AppDate INTEGER,
                AppYear INTEGER,
                PatType VARCHAR(15) );
CREATE UNIQUE INDEX uqPat on patent (Patent);

Sciref

CREATE TABLE sciref (
                Patent VARCHAR(8),
                Descrip VARCHAR(20),
                CitSeq INTEGER);
CREATE UNIQUE INDEX uqSciref ON sciref (Patent, CitSeq);

USRelDoc

CREATE TABLE usreldoc (
                Patent VARCHAR(8),      DocType VARCHAR(10),    OrderSeq INTEGER,
                Country VARCHAR(2),     RelPatent VARCHAR(8),   Kind VARCHAR(2),
                RelDate INTEGER,        Status VARCHAR(10));
CREATE UNIQUE INDEX uqUSRelDoc ON usreldoc (Patent, OrderSeq);

[gtfierro]

Why is this filed as an issue?

[billyeh]

Sorry, I don't know either. Thought it might be useful to have around in some readme or something.