User Tools

Site Tools


Sidebar

Table listing

Here is the list of all tables created in the database.

Clic on a table name for more informations.

model:project_funding

Table project\_funding

Remarks

The table project_funding was created for knowing which are the projects that fund other projects.

Schema

Name Type Not Null Primary Key Foreign Key Remarks
:———:———:————-:—————-:—————-:————
id_funding integer X X project\_funding(id_funding) This is the primary key of the table.
percentage double precision This is the percentage of funds given relative to the funds expected for the project linked.
id_project_funded integer X project(databaseid) This is a foreign key to the table Project. It corresponds to the Project which receives the funds.
id_project_funding integer X project(databaseid) This is a foreign key to the table Project. It corresponds to the Project which give the funds.

Diagram

model/project_funding.txt · Last modified: 2016/01/11 21:38 (external edit)