Description of a table holding patent assignees.

gistfile1.txt

TABLE_QUALIFIER  TABLE_OWNER	TABLE_NAME	COLUMN_NAME	DATA_TYPE	TYPE_NAME	PRECISION	LENGTH	SCALE	RADIX	NULLABLE	REMARKS	COLUMN_DEF	SQL_DATA_TYPE	SQL_DATETIME_SUB	CHAR_OCTET_LENGTH	ORDINAL_POSITION	IS_NULLABLE	SS_DATA_TYPE
patents	dbo	assignee	internal_id	4	int	10	4	0	10	0	NULL	NULL	4	NULL	NULL	1	NO	56
patents	dbo	assignee	external_id	-8	nchar	100	200	NULL	NULL	1	NULL	NULL	-8	NULL	200	2	YES	39
patents	dbo	assignee	word_count	4	int	10	4	0	10	1	NULL	NULL	4	NULL	NULL	3	YES	38
patents	dbo	assignee	mime_type	-8	nchar	50	100	NULL	NULL	1	NULL	NULL	-8	NULL	100	4	YES	39
patents	dbo	assignee	date	-8	nchar	30	60	NULL	NULL	1	NULL	NULL	-8	NULL	60	5	YES	39
patents	dbo	assignee	checksum	-8	nchar	128	256	NULL	NULL	1	NULL	NULL	-8	NULL	256	6	YES	39
patents	dbo	assignee	status	-8	nchar	10	20	NULL	NULL	1	NULL	NULL	-8	NULL	20	7	YES	39
patents	dbo	assignee	rmcollectionid	-8	nchar	20	40	NULL	NULL	1	NULL	NULL	-8	NULL	40	8	YES	39
patents	dbo	assignee	meta_title	-8	nchar	500	1000	NULL	NULL	1	NULL	NULL	-8	NULL	1000	9	YES	39
patents	dbo	assignee	assignee_orgname	-8	nchar	500	1000	NULL	NULL	1	NULL	NULL	-8	NULL	1000	10	YES	39
patents	dbo	assignee	assignee_city	-8	nchar	200	400	NULL	NULL	1	NULL	NULL	-8	NULL	400	11	YES	39
patents	dbo	assignee	assignee_role	-8	nchar	100	200	NULL	NULL	1	NULL	NULL	-8	NULL	200	12	YES	39
patents	dbo	assignee	ipcr_classification	-8	nchar	500	1000	NULL	NULL	1	NULL	NULL	-8	NULL	1000	13	YES	39