Changes
Jump to navigation
Jump to search
no edit summary
The following is the schema for the 10 tables in this database:
I have cleaned up and fixed the types for the the following tables:
CREATE TABLE patents (
Patent varcharinteger, #to int Kind varchar, #only types NULL, A1, B1, B2, E1 (check E1 is numeric)
Claims integer,
AppType varcharinteger, #to int (http://www.uspto.gov/web/offices/ac/ido/oeip/taf/filingyr.htm) 29 is design AppNum varcharinteger, #to int
GDate date,
GYear integer,
AppDate varchardate, #date AppYear varchar #to intinteger
);
CREATE TABLE classes (
Patent varchar, #to intinteger
Prim integer,
Class varchar,
CREATE TABLE assignees (
Patent varcharinteger, #to int AsgType varcharinteger, #to int
Assignee varchar,
City varchar,
CREATE TABLE citations (
Patent varcharinteger, Cit_Date varchardate,
Cit_Name varchar,
Cit_Kind varchar,
CREATE TABLE inventors (
Patent varcharinteger,
Firstname varchar,
Lastname varchar,
State varchar,
Country varchar,
Zipcode integervarchar,#??
Nationality varchar,
InvSeq integer
);
I have not processed the following tables:
CREATE TABLE patdesc (
