本ページは，毎日1回午前3時時点のデータベース登録情報をもとに作成しています．したがって，本日登録・修正した変更内容は反映していません．本日作業分の変更内容の反映には，明日までお待ち下さい．

Table Definition : "PatentAndPracticalModel"

Definition of PatentAndPracticalModel.

XML: patent (XML, DTD)

SQL: t_10013

名前: （英）PatentAndPracticalModel （日）特許・実用新案（読）とっきょじつようしんあん

説明: （英）patent or practical model （日）特許と実用新案の情報

解説: （英）（日）教職員が取得(出願・公開中も含む)している特許・実用新案を登録するテーブルです．

マップ:

属性:

指揮: 種別 (patent.kind).

タプル権限(既定値): 読権: 公開, 作権: ユーザ, 書権: 制限, 削権: 制限.

カラム権限(既定値): 読権: 公開, 作権: 制限, 書権: 制限, 削権: 制限.

登録されているカラム

名前 XML
SQL 説明型番数 MAP 権限
委譲分類同義期間
限定用法該当
無可読権作権書権削権見順巾

組織
Organization @.organization
c_organization 特許・実用新案の属する組織
name of organization 参照 0 * 組織
◎ ○ 推奨 (公開) (ユーザ) (制限) (制限) 長 0 20

種別
Kind @.kind
c_kind 特許・実用新案の区別
kind of patent or practical model 参照 1 1 特許・実用新案属性
◎ [指揮] (公開) (ユーザ) (制限) (制限) 長 0 10

出願国
Nation @.kind2
c_kind2 出願国または国内，国外，国際の別
applied nation, domestic, foreign or international 参照 2 * 国家
 国分類
○ 必須 (公開) (ユーザ) (制限) (制限) × 0 10

発明者
Inventor @.inventor
c_inventor 発明者など
inventor of a patent or practical model 名称 3 * 個人
◎ 必須 (公開) (ユーザ) (制限) (制限) 短 0 20

  役割
  Role @.inventor.role
c_inventor_role 役割
Role 文 4 1 役割
任意 (公開) (ユーザ) (制限) (制限) × 0 20

  貢献度
  Contribution @.inventor.contribution
c_inventor_contribution 貢献度
Contribution 整数 5 1 任意 (公開) (ユーザ) (制限) (制限) × 0 10

  学籍番号
  StudentCode @.inventor.studentcode
c_inventor_studentcode 学生の学籍番号
Student Code 外部DB識別子 6 1 推奨 (ユーザ) (ユーザ) (制限) (制限) × 0 12

  所属(学生)
  InventorAffiliate @.inventor.affiliate
c_inventor_affiliate 学生の所属組織
Affiliate of Student 参照 7 1 組織
(ユーザ) (ユーザ) (制限) (制限) × 0 10

  肩書(学生)
  InventorTitle @.inventor.title
c_inventor_title 学生の身分
Title of Inventor(Student) 参照 8 1 肩書
(ユーザ) (ユーザ) (制限) (制限) × 0 10

出願人
Applicant @.applicant
c_applicant 出願人など
applicant of a patent or practical model 名称 9 * 個人
 組織
◎ 推奨 (公開) (ユーザ) (制限) (制限) 短 0 20

名称
Name @.name
c_name 発明の名称
name of patent 文 10 1 必須 (公開) (ユーザ) (制限) (制限) 短 0 100

要約
Summary @.summary
c_summary 要約
summary 段落 11 1 任意 (公開) (ユーザ) (制限) (制限) × 0 500

キーワード
Keyword @.keyword
c_keyword 特許のキーワード
keyword of patent 名称 12 * キーワード
推奨 (公開) (ユーザ) (制限) (制限) × 0 20

出願
Apply @.apply
c_apply 特許願の番号など
appliance テキスト 13 1 必須 (公開) (ユーザ) (制限) (制限) × 0 20

  出願年月日
  ApplyDate @.apply.date
c_apply_date 出願年月日
date of application 日付 14 1 必須 (公開) (ユーザ) (制限) (制限) 短 1 20

開示
Disclosure @.disclosure
c_disclosure 特許開など
disclosure number テキスト 15 1 必須 (公開) (ユーザ) (制限) (制限) × 0 20

  開示年月日
  DisclosureDate @.disclosure.date
c_disclosure_date 開示年月日
date of disclosure 日付 16 1 必須 (公開) (ユーザ) (制限) (制限) 短 1 20

番号
No. @.number
c_number 特許番号・実用新案番号
number テキスト 17 1 必須 (公開) (ユーザ) (制限) (制限) × 0 20

年月日
Date @.date
c_date 確定年月日
date of patent 日付 18 1 ○ 必須 (公開) (ユーザ) (制限) (制限) 短 1 20

備考
Note @.note
c_note 備考
Note 文 19 * 任意 (公開) (ユーザ) (制限) (制限) × 0 200

カラムの解説文:

組織: (英) Please choose the organization. (日) 特許・実用新案を掲載すべき組織を選択してください．各組織の特許の実績などを集計するときに利用します．発明者が複数の組織にまたがっているときにはそれらを全て登録してください．

種別: (英) Please choose the kind. (日) 特許・実用新案などの種別を選んでください．

出願国: (英) Please choose the nation or kind (domestic, foreign or international). (日) 出願国または国内，外国，国際の別を選択してください．1回の申請において同時に複数の国家に申請を行ったことになる場合のみそれらの国家を複数登録してください．なお，内容が同じでも申請が別の場合には別の【特許・実用新案】情報を作成して各々の国家を登録してください．

発明者: (英) Please choose or write the holder. (日) 特許・実用新案を発明した人を選択もしくは記入してください．

役割: (英) Role (日) 貢献の種別

貢献度: (英) Contribution (日) 貢献度

学籍番号: (英) Student code (10 digits) if inventor is student. (日) 発明者が本学の学生の場合，学生の学籍番号(10桁)を記入してください．

所属(学生): (英) Organization which the inventor(student) belonging on. (日) 発明者が本学の学生の場合，学生の所属する組織（学科，専攻，コース）を選択して下さい．

肩書(学生): (英) Title of inventor(student). (日) 発明者が本学の学生の場合，学生の身分（修士課程，博士課程，…等）を選択して下さい．

出願人: (英) Please choose or write the holder. (日) 特許・実用新案を出願した人を選択もしくは記入してください．

名称: (英) Please write the name of patent, etc. (日) 発明の名称を記入してください．

要約: (英) Please write the summary of patent, etc. (voluntary) (日) 発明の内容を記入してください．（必須ではありません）

キーワード: (英) Please write the keyword of patent. (voluntary) (日) キーワードを記入してください．(必須ではありません)

出願: (英) Please write the appliance. (日) 特許願の番号などを記述して下さい．

出願年月日: (英) Please write the date of application. (日) 出願年月日を記入してください．

開示: (英) Please write the disclosure number. (日) 特許開などを記入してください．

開示年月日: (英) Please write the date of disclosure. (日) 開示年月日を記入してください．

番号: (英) Please write the number of patent, etc. (日) 特許番号・実用新案番号などを記入してください．

年月日: (英) Please write the date of patent, etc. (日) 確定年月日を記入してください．

備考: (英) Please write the information which cannot be written on registered column. (日) 登録されているカラムに記述すべき内容以外に，特に記しておきたい事柄があれば記述してください．

参照しているカラム:

Relational tables associated with PatentAndPracticalModel.

Primary table: "t_10013"

Columns:

XML column name SQL definition description

Base Columns
patent.organization c_organization mtext[] EID
v_organization
e_organization integer[] list of EID in this column.

patent.kind c_kind mtext EID
v_kind
e_kind integer[] list of EID in this column.

patent.kind2 c_kind2 mtext[] EID
v_kind2
e_kind2 integer[] list of EID in this column.

patent.inventor c_inventor mtext[] NAME
v_inventor
e_inventor integer[] list of EID in this column.

patent.inventor.role c_inventor_role mtext[] SENTENCE
v_inventor_role
e_inventor_role integer[] list of EID in this column.

patent.inventor.contribution c_inventor_contribution int4[] INTEGER
v_inventor_contribution
e_inventor_contribution integer[] list of EID in this column.

patent.inventor.studentcode c_inventor_studentcode text[] EXTID
v_inventor_studentcode
e_inventor_studentcode integer[] list of EID in this column.

patent.inventor.affiliate c_inventor_affiliate mtext[] EID
v_inventor_affiliate
e_inventor_affiliate integer[] list of EID in this column.

patent.inventor.title c_inventor_title mtext[] EID
v_inventor_title
e_inventor_title integer[] list of EID in this column.

patent.applicant c_applicant mtext[] NAME
v_applicant
e_applicant integer[] list of EID in this column.

patent.name c_name mtext SENTENCE
v_name
e_name integer[] list of EID in this column.

patent.summary c_summary mtext PARAGRAPH
v_summary
e_summary integer[] list of EID in this column.

patent.keyword c_keyword mtext[] NAME
v_keyword
e_keyword integer[] list of EID in this column.

patent.apply c_apply text TEXT
v_apply
e_apply integer[] list of EID in this column.

patent.apply.date c_apply_date int4 DATE
v_apply_date
e_apply_date integer[] list of EID in this column.

patent.disclosure c_disclosure text TEXT
v_disclosure
e_disclosure integer[] list of EID in this column.

patent.disclosure.date c_disclosure_date int4 DATE
v_disclosure_date
e_disclosure_date integer[] list of EID in this column.

patent.number c_number text TEXT
v_number
e_number integer[] list of EID in this column.

patent.date c_date int4 DATE
v_date
e_date integer[] list of EID in this column.

patent.note c_note mtext[] SENTENCE
v_note
e_note integer[] list of EID in this column.

l_eid integer[] list of EID in this tuple.
l_peid integer[] list of authorized EID in this tuple.

Secondary tables:

"t_10013_organization"     --- associated with patent.organization

Columns:

XML column name SQL definition description

Base Columns
patent.organization r_idx0 integer subscript in primary tuple.
c_organization mtext[] EID
v_organization
e_organization integer[] list of EID in this column.

"t_10013_kind"     --- associated with patent.kind

Columns:

XML column name SQL definition description

Base Columns
patent.kind r_idx0 integer subscript in primary tuple.
c_kind mtext EID
v_kind
e_kind integer[] list of EID in this column.

"t_10013_kind2"     --- associated with patent.kind2

Columns:

XML column name SQL definition description

Base Columns
patent.kind2 r_idx0 integer subscript in primary tuple.
c_kind2 mtext EID
v_kind2
e_kind2 integer[] list of EID in this column.

"t_10013_inventor"     --- associated with patent.inventor

Columns:

XML column name SQL definition description

Base Columns
patent.inventor r_idx0 integer subscript in primary tuple.
c_inventor mtext NAME
v_inventor
e_inventor integer[] list of EID in this column.

patent.inventor.role c_inventor_role mtext SENTENCE
v_inventor_role
e_inventor_role integer[] list of EID in this column.

patent.inventor.contribution c_inventor_contribution int4 INTEGER
v_inventor_contribution
e_inventor_contribution integer[] list of EID in this column.

patent.inventor.studentcode c_inventor_studentcode text EXTID
v_inventor_studentcode
e_inventor_studentcode integer[] list of EID in this column.

patent.inventor.affiliate c_inventor_affiliate mtext[] EID
v_inventor_affiliate
e_inventor_affiliate integer[] list of EID in this column.

patent.inventor.title c_inventor_title mtext EID
v_inventor_title
e_inventor_title integer[] list of EID in this column.

"t_10013_inventor_role"     --- associated with patent.inventor.role

Columns:

XML column name SQL definition description

Base Columns
patent.inventor r_idx0 integer subscript in primary tuple.
c_inventor mtext NAME
v_inventor
e_inventor integer[] list of EID in this column.

patent.inventor.role r_idx1 integer subscript in super column.
c_inventor_role mtext SENTENCE
v_inventor_role
e_inventor_role integer[] list of EID in this column.

"t_10013_inventor_contribu"     --- associated with patent.inventor.contribution

Columns:

XML column name SQL definition description

Base Columns
patent.inventor r_idx0 integer subscript in primary tuple.
c_inventor mtext NAME
v_inventor
e_inventor integer[] list of EID in this column.

patent.inventor.contribution r_idx1 integer subscript in super column.
c_inventor_contribution int4 INTEGER
v_inventor_contribution
e_inventor_contribution integer[] list of EID in this column.

"t_10013_inventor_studentc"     --- associated with patent.inventor.studentcode

Columns:

XML column name SQL definition description

Base Columns
patent.inventor r_idx0 integer subscript in primary tuple.
c_inventor mtext NAME
v_inventor
e_inventor integer[] list of EID in this column.

patent.inventor.studentcode r_idx1 integer subscript in super column.
c_inventor_studentcode text EXTID
v_inventor_studentcode
e_inventor_studentcode integer[] list of EID in this column.

"t_10013_inventor_affiliat"     --- associated with patent.inventor.affiliate

Columns:

XML column name SQL definition description

Base Columns
patent.inventor r_idx0 integer subscript in primary tuple.
c_inventor mtext NAME
v_inventor
e_inventor integer[] list of EID in this column.

patent.inventor.affiliate r_idx1 integer subscript in super column.
c_inventor_affiliate mtext[] EID
v_inventor_affiliate
e_inventor_affiliate integer[] list of EID in this column.

"t_10013_inventor_title"     --- associated with patent.inventor.title

Columns:

XML column name SQL definition description

Base Columns
patent.inventor r_idx0 integer subscript in primary tuple.
c_inventor mtext NAME
v_inventor
e_inventor integer[] list of EID in this column.

patent.inventor.title r_idx1 integer subscript in super column.
c_inventor_title mtext EID
v_inventor_title
e_inventor_title integer[] list of EID in this column.

"t_10013_applicant"     --- associated with patent.applicant

Columns:

XML column name SQL definition description

Base Columns
patent.applicant r_idx0 integer subscript in primary tuple.
c_applicant mtext[] NAME
v_applicant
e_applicant integer[] list of EID in this column.

"t_10013_name"     --- associated with patent.name

Columns:

XML column name SQL definition description

Base Columns
patent.name r_idx0 integer subscript in primary tuple.
c_name mtext SENTENCE
v_name
e_name integer[] list of EID in this column.

"t_10013_summary"     --- associated with patent.summary

Columns:

XML column name SQL definition description

Base Columns
patent.summary r_idx0 integer subscript in primary tuple.
c_summary mtext PARAGRAPH
v_summary
e_summary integer[] list of EID in this column.

"t_10013_keyword"     --- associated with patent.keyword

Columns:

XML column name SQL definition description

Base Columns
patent.keyword r_idx0 integer subscript in primary tuple.
c_keyword mtext NAME
v_keyword
e_keyword integer[] list of EID in this column.

"t_10013_apply"     --- associated with patent.apply

Columns:

XML column name SQL definition description

Base Columns
patent.apply r_idx0 integer subscript in primary tuple.
c_apply text TEXT
v_apply
e_apply integer[] list of EID in this column.

patent.apply.date c_apply_date int4 DATE
v_apply_date
e_apply_date integer[] list of EID in this column.

"t_10013_apply_date"     --- associated with patent.apply.date

Columns:

XML column name SQL definition description

Base Columns
patent.apply r_idx0 integer subscript in primary tuple.
c_apply text TEXT
v_apply
e_apply integer[] list of EID in this column.

patent.apply.date r_idx1 integer subscript in super column.
c_apply_date int4 DATE
v_apply_date
e_apply_date integer[] list of EID in this column.

"t_10013_disclosure"     --- associated with patent.disclosure

Columns:

XML column name SQL definition description

Base Columns
patent.disclosure r_idx0 integer subscript in primary tuple.
c_disclosure text TEXT
v_disclosure
e_disclosure integer[] list of EID in this column.

patent.disclosure.date c_disclosure_date int4 DATE
v_disclosure_date
e_disclosure_date integer[] list of EID in this column.

"t_10013_disclosure_date"     --- associated with patent.disclosure.date

Columns:

XML column name SQL definition description

Base Columns
patent.disclosure r_idx0 integer subscript in primary tuple.
c_disclosure text TEXT
v_disclosure
e_disclosure integer[] list of EID in this column.

patent.disclosure.date r_idx1 integer subscript in super column.
c_disclosure_date int4 DATE
v_disclosure_date
e_disclosure_date integer[] list of EID in this column.

"t_10013_number"     --- associated with patent.number

Columns:

XML column name SQL definition description

Base Columns
patent.number r_idx0 integer subscript in primary tuple.
c_number text TEXT
v_number
e_number integer[] list of EID in this column.

"t_10013_date"     --- associated with patent.date

Columns:

XML column name SQL definition description

Base Columns
patent.date r_idx0 integer subscript in primary tuple.
c_date int4 DATE
v_date
e_date integer[] list of EID in this column.

"t_10013_note"     --- associated with patent.note

Columns:

XML column name SQL definition description

Base Columns
patent.note r_idx0 integer subscript in primary tuple.
c_note mtext SENTENCE
v_note
e_note integer[] list of EID in this column.

名前	XML SQL	説明	型	番	数	MAP	権限委譲	分類	用法	読権	作権	書権	削権	見	順	巾
組織 Organization	@.organization c_organization	特許・実用新案の属する組織 name of organization	参照	0	*	組織	◎	○	推奨	(公開)	(ユーザ)	(制限)	(制限)	長	0	20
種別 Kind	@.kind c_kind	特許・実用新案の区別 kind of patent or practical model	参照	1	1	特許・実用新案属性		◎	[指揮]	(公開)	(ユーザ)	(制限)	(制限)	長	0	10
出願国 Nation	@.kind2 c_kind2	出願国または国内，国外，国際の別 applied nation, domestic, foreign or international	参照	2	*	国家国分類		○	必須	(公開)	(ユーザ)	(制限)	(制限)	×	0	10
発明者 Inventor	@.inventor c_inventor	発明者など inventor of a patent or practical model	名称	3	*	個人	◎		必須	(公開)	(ユーザ)	(制限)	(制限)	短	0	20
役割 Role	@.inventor.role c_inventor_role	役割 Role	文	4	1	役割			任意	(公開)	(ユーザ)	(制限)	(制限)	×	0	20
貢献度 Contribution	@.inventor.contribution c_inventor_contribution	貢献度 Contribution	整数	5	1				任意	(公開)	(ユーザ)	(制限)	(制限)	×	0	10
学籍番号 StudentCode	@.inventor.studentcode c_inventor_studentcode	学生の学籍番号 Student Code	外部DB識別子	6	1				推奨	(ユーザ)	(ユーザ)	(制限)	(制限)	×	0	12
所属(学生) InventorAffiliate	@.inventor.affiliate c_inventor_affiliate	学生の所属組織 Affiliate of Student	参照	7	1	組織				(ユーザ)	(ユーザ)	(制限)	(制限)	×	0	10
肩書(学生) InventorTitle	@.inventor.title c_inventor_title	学生の身分 Title of Inventor(Student)	参照	8	1	肩書				(ユーザ)	(ユーザ)	(制限)	(制限)	×	0	10
出願人 Applicant	@.applicant c_applicant	出願人など applicant of a patent or practical model	名称	9	*	個人組織	◎		推奨	(公開)	(ユーザ)	(制限)	(制限)	短	0	20
名称 Name	@.name c_name	発明の名称 name of patent	文	10	1				必須	(公開)	(ユーザ)	(制限)	(制限)	短	0	100
要約 Summary	@.summary c_summary	要約 summary	段落	11	1				任意	(公開)	(ユーザ)	(制限)	(制限)	×	0	500
キーワード Keyword	@.keyword c_keyword	特許のキーワード keyword of patent	名称	12	*	キーワード			推奨	(公開)	(ユーザ)	(制限)	(制限)	×	0	20
出願 Apply	@.apply c_apply	特許願の番号など appliance	テキスト	13	1				必須	(公開)	(ユーザ)	(制限)	(制限)	×	0	20
出願年月日 ApplyDate	@.apply.date c_apply_date	出願年月日 date of application	日付	14	1				必須	(公開)	(ユーザ)	(制限)	(制限)	短	1	20
開示 Disclosure	@.disclosure c_disclosure	特許開など disclosure number	テキスト	15	1				必須	(公開)	(ユーザ)	(制限)	(制限)	×	0	20
開示年月日 DisclosureDate	@.disclosure.date c_disclosure_date	開示年月日 date of disclosure	日付	16	1				必須	(公開)	(ユーザ)	(制限)	(制限)	短	1	20
番号 No.	@.number c_number	特許番号・実用新案番号 number	テキスト	17	1				必須	(公開)	(ユーザ)	(制限)	(制限)	×	0	20
年月日 Date	@.date c_date	確定年月日 date of patent	日付	18	1			○	必須	(公開)	(ユーザ)	(制限)	(制限)	短	1	20
備考 Note	@.note c_note	備考 Note	文	19	*				任意	(公開)	(ユーザ)	(制限)	(制限)	×	0	200

XML	column name	SQL definition	description
	Base Columns
patent.organization	c_organization	mtext[]	EID
v_organization
e_organization	integer[]	list of EID in this column.
patent.kind	c_kind	mtext	EID
v_kind
e_kind	integer[]	list of EID in this column.
patent.kind2	c_kind2	mtext[]	EID
v_kind2
e_kind2	integer[]	list of EID in this column.
patent.inventor	c_inventor	mtext[]	NAME
v_inventor
e_inventor	integer[]	list of EID in this column.
patent.inventor.role	c_inventor_role	mtext[]	SENTENCE
v_inventor_role
e_inventor_role	integer[]	list of EID in this column.
patent.inventor.contribution	c_inventor_contribution	int4[]	INTEGER
v_inventor_contribution
e_inventor_contribution	integer[]	list of EID in this column.
patent.inventor.studentcode	c_inventor_studentcode	text[]	EXTID
v_inventor_studentcode
e_inventor_studentcode	integer[]	list of EID in this column.
patent.inventor.affiliate	c_inventor_affiliate	mtext[]	EID
v_inventor_affiliate
e_inventor_affiliate	integer[]	list of EID in this column.
patent.inventor.title	c_inventor_title	mtext[]	EID
v_inventor_title
e_inventor_title	integer[]	list of EID in this column.
patent.applicant	c_applicant	mtext[]	NAME
v_applicant
e_applicant	integer[]	list of EID in this column.
patent.name	c_name	mtext	SENTENCE
v_name
e_name	integer[]	list of EID in this column.
patent.summary	c_summary	mtext	PARAGRAPH
v_summary
e_summary	integer[]	list of EID in this column.
patent.keyword	c_keyword	mtext[]	NAME
v_keyword
e_keyword	integer[]	list of EID in this column.
patent.apply	c_apply	text	TEXT
v_apply
e_apply	integer[]	list of EID in this column.
patent.apply.date	c_apply_date	int4	DATE
v_apply_date
e_apply_date	integer[]	list of EID in this column.
patent.disclosure	c_disclosure	text	TEXT
v_disclosure
e_disclosure	integer[]	list of EID in this column.
patent.disclosure.date	c_disclosure_date	int4	DATE
v_disclosure_date
e_disclosure_date	integer[]	list of EID in this column.
patent.number	c_number	text	TEXT
v_number
e_number	integer[]	list of EID in this column.
patent.date	c_date	int4	DATE
v_date
e_date	integer[]	list of EID in this column.
patent.note	c_note	mtext[]	SENTENCE
v_note
e_note	integer[]	list of EID in this column.
	l_eid	integer[]	list of EID in this tuple.
	l_peid	integer[]	list of authorized EID in this tuple.

XML	column name	SQL definition	description
	Base Columns
patent.organization	r_idx0	integer	subscript in primary tuple.
c_organization	mtext[]	EID
v_organization
e_organization	integer[]	list of EID in this column.

XML	column name	SQL definition	description
	Base Columns
patent.kind	r_idx0	integer	subscript in primary tuple.
c_kind	mtext	EID
v_kind
e_kind	integer[]	list of EID in this column.

XML	column name	SQL definition	description
	Base Columns
patent.kind2	r_idx0	integer	subscript in primary tuple.
c_kind2	mtext	EID
v_kind2
e_kind2	integer[]	list of EID in this column.

XML	column name	SQL definition	description
	Base Columns
patent.inventor	r_idx0	integer	subscript in primary tuple.
c_inventor	mtext	NAME
v_inventor
e_inventor	integer[]	list of EID in this column.
patent.inventor.role	c_inventor_role	mtext	SENTENCE
v_inventor_role
e_inventor_role	integer[]	list of EID in this column.
patent.inventor.contribution	c_inventor_contribution	int4	INTEGER
v_inventor_contribution
e_inventor_contribution	integer[]	list of EID in this column.
patent.inventor.studentcode	c_inventor_studentcode	text	EXTID
v_inventor_studentcode
e_inventor_studentcode	integer[]	list of EID in this column.
patent.inventor.affiliate	c_inventor_affiliate	mtext[]	EID
v_inventor_affiliate
e_inventor_affiliate	integer[]	list of EID in this column.
patent.inventor.title	c_inventor_title	mtext	EID
v_inventor_title
e_inventor_title	integer[]	list of EID in this column.

XML	column name	SQL definition	description
	Base Columns
patent.inventor	r_idx0	integer	subscript in primary tuple.
c_inventor	mtext	NAME
v_inventor
e_inventor	integer[]	list of EID in this column.
patent.inventor.role	r_idx1	integer	subscript in super column.
c_inventor_role	mtext	SENTENCE
v_inventor_role
e_inventor_role	integer[]	list of EID in this column.

XML	column name	SQL definition	description
	Base Columns
patent.inventor	r_idx0	integer	subscript in primary tuple.
c_inventor	mtext	NAME
v_inventor
e_inventor	integer[]	list of EID in this column.
patent.inventor.contribution	r_idx1	integer	subscript in super column.
c_inventor_contribution	int4	INTEGER
v_inventor_contribution
e_inventor_contribution	integer[]	list of EID in this column.

XML	column name	SQL definition	description
	Base Columns
patent.inventor	r_idx0	integer	subscript in primary tuple.
c_inventor	mtext	NAME
v_inventor
e_inventor	integer[]	list of EID in this column.
patent.inventor.studentcode	r_idx1	integer	subscript in super column.
c_inventor_studentcode	text	EXTID
v_inventor_studentcode
e_inventor_studentcode	integer[]	list of EID in this column.

XML	column name	SQL definition	description
	Base Columns
patent.inventor	r_idx0	integer	subscript in primary tuple.
c_inventor	mtext	NAME
v_inventor
e_inventor	integer[]	list of EID in this column.
patent.inventor.affiliate	r_idx1	integer	subscript in super column.
c_inventor_affiliate	mtext[]	EID
v_inventor_affiliate
e_inventor_affiliate	integer[]	list of EID in this column.

XML	column name	SQL definition	description
	Base Columns
patent.inventor	r_idx0	integer	subscript in primary tuple.
c_inventor	mtext	NAME
v_inventor
e_inventor	integer[]	list of EID in this column.
patent.inventor.title	r_idx1	integer	subscript in super column.
c_inventor_title	mtext	EID
v_inventor_title
e_inventor_title	integer[]	list of EID in this column.

XML	column name	SQL definition	description
	Base Columns
patent.applicant	r_idx0	integer	subscript in primary tuple.
c_applicant	mtext[]	NAME
v_applicant
e_applicant	integer[]	list of EID in this column.

XML	column name	SQL definition	description
	Base Columns
patent.name	r_idx0	integer	subscript in primary tuple.
c_name	mtext	SENTENCE
v_name
e_name	integer[]	list of EID in this column.

XML	column name	SQL definition	description
	Base Columns
patent.summary	r_idx0	integer	subscript in primary tuple.
c_summary	mtext	PARAGRAPH
v_summary
e_summary	integer[]	list of EID in this column.

XML	column name	SQL definition	description
	Base Columns
patent.keyword	r_idx0	integer	subscript in primary tuple.
c_keyword	mtext	NAME
v_keyword
e_keyword	integer[]	list of EID in this column.

XML	column name	SQL definition	description
	Base Columns
patent.apply	r_idx0	integer	subscript in primary tuple.
c_apply	text	TEXT
v_apply
e_apply	integer[]	list of EID in this column.
patent.apply.date	c_apply_date	int4	DATE
v_apply_date
e_apply_date	integer[]	list of EID in this column.

XML	column name	SQL definition	description
	Base Columns
patent.apply	r_idx0	integer	subscript in primary tuple.
c_apply	text	TEXT
v_apply
e_apply	integer[]	list of EID in this column.
patent.apply.date	r_idx1	integer	subscript in super column.
c_apply_date	int4	DATE
v_apply_date
e_apply_date	integer[]	list of EID in this column.

XML	column name	SQL definition	description
	Base Columns
patent.disclosure	r_idx0	integer	subscript in primary tuple.
c_disclosure	text	TEXT
v_disclosure
e_disclosure	integer[]	list of EID in this column.
patent.disclosure.date	c_disclosure_date	int4	DATE
v_disclosure_date
e_disclosure_date	integer[]	list of EID in this column.

XML	column name	SQL definition	description
	Base Columns
patent.disclosure	r_idx0	integer	subscript in primary tuple.
c_disclosure	text	TEXT
v_disclosure
e_disclosure	integer[]	list of EID in this column.
patent.disclosure.date	r_idx1	integer	subscript in super column.
c_disclosure_date	int4	DATE
v_disclosure_date
e_disclosure_date	integer[]	list of EID in this column.

XML	column name	SQL definition	description
	Base Columns
patent.number	r_idx0	integer	subscript in primary tuple.
c_number	text	TEXT
v_number
e_number	integer[]	list of EID in this column.

XML	column name	SQL definition	description
	Base Columns
patent.date	r_idx0	integer	subscript in primary tuple.
c_date	int4	DATE
v_date
e_date	integer[]	list of EID in this column.

XML	column name	SQL definition	description
	Base Columns
patent.note	r_idx0	integer	subscript in primary tuple.
c_note	mtext	SENTENCE
v_note
e_note	integer[]	list of EID in this column.

EDB Working Group <edb-admin (at) web (dot) db (dot) tokushima-u (dot) ac (dot) jp> at Thu Nov 28 03:40:01 2024. (p-db6.edb-private:5433:edb_latest v.15.10, o=6/6, c=2, q=107, h=1484)