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


Table Definition : "Project"


Definition of Project.


Relational tables associated with Project.

Primary table: "t_175267"
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 project.category c_category mtext EID
 v_category
 e_category integer[] list of EID in this column.
 project.class c_class mtext EID
 v_class
 e_class integer[] list of EID in this column.
 project.name c_name mtext NAME
 v_name
 e_name integer[] list of EID in this column.
 project.organization c_organization mtext[] EID
 v_organization
 e_organization integer[] list of EID in this column.
 project.staff c_staff mtext[] NAME
 v_staff
 e_staff integer[] list of EID in this column.
 project.staff.role c_staff_role mtext[] NAME
 v_staff_role
 e_staff_role integer[] list of EID in this column.
 project.staffs c_staffs int4 INTEGER
 v_staffs
 e_staffs integer[] list of EID in this column.
 project.students c_students int4 INTEGER
 v_students
 e_students integer[] list of EID in this column.
 project.period c_period int8 DATE2
 v_period
 e_period integer[] list of EID in this column.
 project.url c_url text URL
 v_url
 e_url integer[] list of EID in this column.
 project.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_175267_category"     --- associated with project.category
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 project.category r_idx0 integer subscript in primary tuple.
 c_category mtext EID
 v_category
 e_category integer[] list of EID in this column.

"t_175267_class"     --- associated with project.class
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 project.class r_idx0 integer subscript in primary tuple.
 c_class mtext EID
 v_class
 e_class integer[] list of EID in this column.

"t_175267_name"     --- associated with project.name
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 project.name r_idx0 integer subscript in primary tuple.
 c_name mtext NAME
 v_name
 e_name integer[] list of EID in this column.

"t_175267_organization"     --- associated with project.organization
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 project.organization r_idx0 integer subscript in primary tuple.
 c_organization mtext[] EID
 v_organization
 e_organization integer[] list of EID in this column.

"t_175267_staff"     --- associated with project.staff
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 project.staff r_idx0 integer subscript in primary tuple.
 c_staff mtext NAME
 v_staff
 e_staff integer[] list of EID in this column.
 project.staff.role c_staff_role mtext NAME
 v_staff_role
 e_staff_role integer[] list of EID in this column.

"t_175267_staff_role"     --- associated with project.staff.role
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 project.staff r_idx0 integer subscript in primary tuple.
 c_staff mtext NAME
 v_staff
 e_staff integer[] list of EID in this column.
 project.staff.role r_idx1 integer subscript in super column.
 c_staff_role mtext NAME
 v_staff_role
 e_staff_role integer[] list of EID in this column.

"t_175267_staffs"     --- associated with project.staffs
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 project.staffs r_idx0 integer subscript in primary tuple.
 c_staffs int4 INTEGER
 v_staffs
 e_staffs integer[] list of EID in this column.

"t_175267_students"     --- associated with project.students
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 project.students r_idx0 integer subscript in primary tuple.
 c_students int4 INTEGER
 v_students
 e_students integer[] list of EID in this column.

"t_175267_period"     --- associated with project.period
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 project.period r_idx0 integer subscript in primary tuple.
 c_period int8 DATE2
 v_period
 e_period integer[] list of EID in this column.

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

"t_175267_note"     --- associated with project.note
Columns:
XMLcolumn nameSQL definitiondescription
Base Columns
 project.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 Mar 28 03:40:05 2024. (p-db5.edb-private:5433:edb_latest v.15.6, o=8/8, c=2, q=107, h=1531)