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

Table Definition : "Person"

Definition of Person.


Relational tables associated with Person.

Primary table: "t_10014"
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 person.surname c_surname mtext NAME
 v_surname
 e_surname integer[] list of EID in this column.
 person.givenname c_givenname mtext NAME
 v_givenname
 e_givenname integer[] list of EID in this column.
 person.middlename c_middlename mtext NAME
 v_middlename
 e_middlename integer[] list of EID in this column.
 person.birthday c_birthday int4 DATE
 v_birthday
 e_birthday integer[] list of EID in this column.
 person.sex c_sex mtext EID
 v_sex
 e_sex integer[] list of EID in this column.
 person.degree c_degree mtext[] EID
 v_degree
 e_degree integer[] list of EID in this column.
 person.officialnameofdegree c_nod mtext[] NAME
 v_nod
 e_nod integer[] list of EID in this column.
 person.officialnameofdegree.conferrer c_nod_conferrer mtext[] NAME
 v_nod_conferrer
 e_nod_conferrer integer[] list of EID in this column.
 person.officialnameofdegree.date c_nod_date int4[] DATE
 v_nod_date
 e_nod_date integer[] list of EID in this column.
 person.almamater c_almamater mtext[] NAME
 v_almamater
 e_almamater integer[] list of EID in this column.
 person.almamater.date c_am_date int4 DATE
 v_am_date
 e_am_date integer[] list of EID in this column.
 person.almamater2 c_almamater2 mtext[] NAME
 v_almamater2
 e_almamater2 integer[] list of EID in this column.
 person.almamater2.date c_am_date2 int4 DATE
 v_am_date2
 e_am_date2 integer[] list of EID in this column.
 person.almamater3 c_almamater3 mtext[] NAME
 v_almamater3
 e_almamater3 integer[] list of EID in this column.
 person.almamater3.date c_am_date3 int4 DATE
 v_am_date3
 e_am_date3 integer[] list of EID in this column.
 person.title c_title mtext[] EID
 v_title
 e_title integer[] list of EID in this column.
 person.affiliation c_affiliation mtext[] NAME
 v_affiliation
 e_affiliation integer[] list of EID in this column.
 person.email c_email text EMAIL
 v_email
 e_email integer[] list of EID in this column.
 person.phone c_phone text PHONE
 v_phone
 e_phone integer[] list of EID in this column.
 person.phone2 c_phone2 text PHONE
 v_phone2
 e_phone2 integer[] list of EID in this column.
 person.phone3 c_phone3 text PHONE
 v_phone3
 e_phone3 integer[] list of EID in this column.
 person.fax c_fax text PHONE
 v_fax
 e_fax integer[] list of EID in this column.
 person.nationality c_nationality mtext EID
 v_nationality
 e_nationality integer[] list of EID in this column.
 person.registrateddomicile c_registrateddomicile mtext EID
 v_registrateddomicile
 e_registrateddomicile integer[] list of EID in this column.
 person.postalcode c_postalcode text TEXT
 v_postalcode
 e_postalcode integer[] list of EID in this column.
 person.address c_address mtext SENTENCE
 v_address
 e_address integer[] list of EID in this column.
 person.room c_room mtext NAME
 v_room
 e_room integer[] list of EID in this column.
 person.officehour c_officehour mtext SENTENCE
 v_officehour
 e_officehour integer[] list of EID in this column.
 person.aituid c_aituid text[] EXTID
 v_aituid
 e_aituid integer[] list of EID in this column.
 person.gasr c_gasr text[] EXTID
 v_gasr
 e_gasr integer[] list of EID in this column.
 person.spas c_spas text[] EXTID
 v_spas
 e_spas integer[] list of EID in this column.
 person.personnelnumber c_personnelnumber text[] EXTID
 v_personnelnumber
 e_personnelnumber integer[] list of EID in this column.
 person.sastaffid c_sastaffid text[] EXTID
 v_sastaffid
 e_sastaffid integer[] list of EID in this column.
 person.password c_password text PASSPHRASE
 v_password
 e_password integer[] list of EID in this column.
 person.certificate c_certificate text CERTIFICATE
 v_certificate
 e_certificate integer[] list of EID in this column.
 person.url c_url text URL
 v_url
 e_url integer[] list of EID in this column.
 person.portrait c_portrait mtext EID
 v_portrait
 e_portrait integer[] list of EID in this column.
 person.wos c_wos text[] EXTID
 v_wos
 e_wos integer[] list of EID in this column.
 person.scopus c_scopus text[] EXTID
 v_scopus
 e_scopus integer[] list of EID in this column.
 person.researchmap c_researchmap text[] EXTID
 v_researchmap
 e_researchmap integer[] list of EID in this column.
 person.orcid c_orcid text[] EXTID
 v_orcid
 e_orcid integer[] list of EID in this column.
 person.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_10014_surname"     --- associated with person.surname
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 person.surname r_idx0 integer subscript in primary tuple.
 c_surname mtext NAME
 v_surname
 e_surname integer[] list of EID in this column.

"t_10014_givenname"     --- associated with person.givenname
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 person.givenname r_idx0 integer subscript in primary tuple.
 c_givenname mtext NAME
 v_givenname
 e_givenname integer[] list of EID in this column.

"t_10014_middlename"     --- associated with person.middlename
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 person.middlename r_idx0 integer subscript in primary tuple.
 c_middlename mtext NAME
 v_middlename
 e_middlename integer[] list of EID in this column.

"t_10014_birthday"     --- associated with person.birthday
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 person.birthday r_idx0 integer subscript in primary tuple.
 c_birthday int4 DATE
 v_birthday
 e_birthday integer[] list of EID in this column.

"t_10014_sex"     --- associated with person.sex
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 person.sex r_idx0 integer subscript in primary tuple.
 c_sex mtext EID
 v_sex
 e_sex integer[] list of EID in this column.

"t_10014_degree"     --- associated with person.degree
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 person.degree r_idx0 integer subscript in primary tuple.
 c_degree mtext EID
 v_degree
 e_degree integer[] list of EID in this column.

"t_10014_nod"     --- associated with person.officialnameofdegree
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 person.officialnameofdegree r_idx0 integer subscript in primary tuple.
 c_nod mtext NAME
 v_nod
 e_nod integer[] list of EID in this column.
 person.officialnameofdegree.conferrer c_nod_conferrer mtext[] NAME
 v_nod_conferrer
 e_nod_conferrer integer[] list of EID in this column.
 person.officialnameofdegree.date c_nod_date int4 DATE
 v_nod_date
 e_nod_date integer[] list of EID in this column.

"t_10014_nod_conferrer"     --- associated with person.officialnameofdegree.conferrer
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 person.officialnameofdegree r_idx0 integer subscript in primary tuple.
 c_nod mtext NAME
 v_nod
 e_nod integer[] list of EID in this column.
 person.officialnameofdegree.conferrer r_idx1 integer subscript in super column.
 c_nod_conferrer mtext[] NAME
 v_nod_conferrer
 e_nod_conferrer integer[] list of EID in this column.

"t_10014_nod_date"     --- associated with person.officialnameofdegree.date
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 person.officialnameofdegree r_idx0 integer subscript in primary tuple.
 c_nod mtext NAME
 v_nod
 e_nod integer[] list of EID in this column.
 person.officialnameofdegree.date r_idx1 integer subscript in super column.
 c_nod_date int4 DATE
 v_nod_date
 e_nod_date integer[] list of EID in this column.

"t_10014_almamater"     --- associated with person.almamater
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 person.almamater r_idx0 integer subscript in primary tuple.
 c_almamater mtext[] NAME
 v_almamater
 e_almamater integer[] list of EID in this column.
 person.almamater.date c_am_date int4 DATE
 v_am_date
 e_am_date integer[] list of EID in this column.

"t_10014_am_date"     --- associated with person.almamater.date
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 person.almamater r_idx0 integer subscript in primary tuple.
 c_almamater mtext[] NAME
 v_almamater
 e_almamater integer[] list of EID in this column.
 person.almamater.date r_idx1 integer subscript in super column.
 c_am_date int4 DATE
 v_am_date
 e_am_date integer[] list of EID in this column.

"t_10014_almamater2"     --- associated with person.almamater2
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 person.almamater2 r_idx0 integer subscript in primary tuple.
 c_almamater2 mtext[] NAME
 v_almamater2
 e_almamater2 integer[] list of EID in this column.
 person.almamater2.date c_am_date2 int4 DATE
 v_am_date2
 e_am_date2 integer[] list of EID in this column.

"t_10014_am_date2"     --- associated with person.almamater2.date
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 person.almamater2 r_idx0 integer subscript in primary tuple.
 c_almamater2 mtext[] NAME
 v_almamater2
 e_almamater2 integer[] list of EID in this column.
 person.almamater2.date r_idx1 integer subscript in super column.
 c_am_date2 int4 DATE
 v_am_date2
 e_am_date2 integer[] list of EID in this column.

"t_10014_almamater3"     --- associated with person.almamater3
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 person.almamater3 r_idx0 integer subscript in primary tuple.
 c_almamater3 mtext[] NAME
 v_almamater3
 e_almamater3 integer[] list of EID in this column.
 person.almamater3.date c_am_date3 int4 DATE
 v_am_date3
 e_am_date3 integer[] list of EID in this column.

"t_10014_am_date3"     --- associated with person.almamater3.date
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 person.almamater3 r_idx0 integer subscript in primary tuple.
 c_almamater3 mtext[] NAME
 v_almamater3
 e_almamater3 integer[] list of EID in this column.
 person.almamater3.date r_idx1 integer subscript in super column.
 c_am_date3 int4 DATE
 v_am_date3
 e_am_date3 integer[] list of EID in this column.

"t_10014_title"     --- associated with person.title
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 person.title r_idx0 integer subscript in primary tuple.
 c_title mtext EID
 v_title
 e_title integer[] list of EID in this column.

"t_10014_affiliation"     --- associated with person.affiliation
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 person.affiliation r_idx0 integer subscript in primary tuple.
 c_affiliation mtext[] NAME
 v_affiliation
 e_affiliation integer[] list of EID in this column.

"t_10014_email"     --- associated with person.email
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 person.email r_idx0 integer subscript in primary tuple.
 c_email text EMAIL
 v_email
 e_email integer[] list of EID in this column.

"t_10014_phone"     --- associated with person.phone
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 person.phone r_idx0 integer subscript in primary tuple.
 c_phone text PHONE
 v_phone
 e_phone integer[] list of EID in this column.

"t_10014_phone2"     --- associated with person.phone2
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 person.phone2 r_idx0 integer subscript in primary tuple.
 c_phone2 text PHONE
 v_phone2
 e_phone2 integer[] list of EID in this column.

"t_10014_phone3"     --- associated with person.phone3
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 person.phone3 r_idx0 integer subscript in primary tuple.
 c_phone3 text PHONE
 v_phone3
 e_phone3 integer[] list of EID in this column.

"t_10014_fax"     --- associated with person.fax
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 person.fax r_idx0 integer subscript in primary tuple.
 c_fax text PHONE
 v_fax
 e_fax integer[] list of EID in this column.

"t_10014_nationality"     --- associated with person.nationality
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 person.nationality r_idx0 integer subscript in primary tuple.
 c_nationality mtext EID
 v_nationality
 e_nationality integer[] list of EID in this column.

"t_10014_registrateddomici"     --- associated with person.registrateddomicile
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 person.registrateddomicile r_idx0 integer subscript in primary tuple.
 c_registrateddomicile mtext EID
 v_registrateddomicile
 e_registrateddomicile integer[] list of EID in this column.

"t_10014_postalcode"     --- associated with person.postalcode
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 person.postalcode r_idx0 integer subscript in primary tuple.
 c_postalcode text TEXT
 v_postalcode
 e_postalcode integer[] list of EID in this column.

"t_10014_address"     --- associated with person.address
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 person.address r_idx0 integer subscript in primary tuple.
 c_address mtext SENTENCE
 v_address
 e_address integer[] list of EID in this column.

"t_10014_room"     --- associated with person.room
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 person.room r_idx0 integer subscript in primary tuple.
 c_room mtext NAME
 v_room
 e_room integer[] list of EID in this column.

"t_10014_officehour"     --- associated with person.officehour
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 person.officehour r_idx0 integer subscript in primary tuple.
 c_officehour mtext SENTENCE
 v_officehour
 e_officehour integer[] list of EID in this column.

"t_10014_aituid"     --- associated with person.aituid
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 person.aituid r_idx0 integer subscript in primary tuple.
 c_aituid text EXTID
 v_aituid
 e_aituid integer[] list of EID in this column.

"t_10014_gasr"     --- associated with person.gasr
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 person.gasr r_idx0 integer subscript in primary tuple.
 c_gasr text EXTID
 v_gasr
 e_gasr integer[] list of EID in this column.

"t_10014_spas"     --- associated with person.spas
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 person.spas r_idx0 integer subscript in primary tuple.
 c_spas text EXTID
 v_spas
 e_spas integer[] list of EID in this column.

"t_10014_personnelnumber"     --- associated with person.personnelnumber
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 person.personnelnumber r_idx0 integer subscript in primary tuple.
 c_personnelnumber text EXTID
 v_personnelnumber
 e_personnelnumber integer[] list of EID in this column.

"t_10014_sastaffid"     --- associated with person.sastaffid
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 person.sastaffid r_idx0 integer subscript in primary tuple.
 c_sastaffid text EXTID
 v_sastaffid
 e_sastaffid integer[] list of EID in this column.

"t_10014_password"     --- associated with person.password
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 person.password r_idx0 integer subscript in primary tuple.
 c_password text PASSPHRASE
 v_password
 e_password integer[] list of EID in this column.

"t_10014_certificate"     --- associated with person.certificate
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 person.certificate r_idx0 integer subscript in primary tuple.
 c_certificate text CERTIFICATE
 v_certificate
 e_certificate integer[] list of EID in this column.

"t_10014_url"     --- associated with person.url
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 person.url r_idx0 integer subscript in primary tuple.
 c_url text URL
 v_url
 e_url integer[] list of EID in this column.

"t_10014_portrait"     --- associated with person.portrait
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 person.portrait r_idx0 integer subscript in primary tuple.
 c_portrait mtext EID
 v_portrait
 e_portrait integer[] list of EID in this column.

"t_10014_wos"     --- associated with person.wos
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 person.wos r_idx0 integer subscript in primary tuple.
 c_wos text EXTID
 v_wos
 e_wos integer[] list of EID in this column.

"t_10014_scopus"     --- associated with person.scopus
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 person.scopus r_idx0 integer subscript in primary tuple.
 c_scopus text EXTID
 v_scopus
 e_scopus integer[] list of EID in this column.

"t_10014_researchmap"     --- associated with person.researchmap
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 person.researchmap r_idx0 integer subscript in primary tuple.
 c_researchmap text EXTID
 v_researchmap
 e_researchmap integer[] list of EID in this column.

"t_10014_orcid"     --- associated with person.orcid
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 person.orcid r_idx0 integer subscript in primary tuple.
 c_orcid text EXTID
 v_orcid
 e_orcid integer[] list of EID in this column.

"t_10014_note"     --- associated with person.note
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 person.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 Apr 26 03:40:06 2024. (p-db4.edb-private:5433:edb_latest v.13.14, o=8/8, c=2, q=107, h=1173)