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


Table Definition : "PatentAndPracticalModel"


Definition of PatentAndPracticalModel.


Relational tables associated with PatentAndPracticalModel.

Primary table: "t_10013"
Columns:
XMLcolumn nameSQL definitiondescription
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:
XMLcolumn nameSQL definitiondescription
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:
XMLcolumn nameSQL definitiondescription
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:
XMLcolumn nameSQL definitiondescription
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:
XMLcolumn nameSQL definitiondescription
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:
XMLcolumn nameSQL definitiondescription
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:
XMLcolumn nameSQL definitiondescription
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:
XMLcolumn nameSQL definitiondescription
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:
XMLcolumn nameSQL definitiondescription
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:
XMLcolumn nameSQL definitiondescription
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:
XMLcolumn nameSQL definitiondescription
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:
XMLcolumn nameSQL definitiondescription
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:
XMLcolumn nameSQL definitiondescription
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:
XMLcolumn nameSQL definitiondescription
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:
XMLcolumn nameSQL definitiondescription
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:
XMLcolumn nameSQL definitiondescription
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:
XMLcolumn nameSQL definitiondescription
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:
XMLcolumn nameSQL definitiondescription
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:
XMLcolumn nameSQL definitiondescription
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:
XMLcolumn nameSQL definitiondescription
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:
XMLcolumn nameSQL definitiondescription
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 Fri Mar 29 03:40:05 2024. (p-db7.edb-private:5433:edb_latest v.15.6, o=8/8, c=2, q=107, h=1484)