White dot for spacing only
The Dice Project


Database Service Data Model


Table: Cost  ENT#INF_COS 
Related Pages

Overview

Cluster Index
Table Index
Field Index
Key Index
Link Index

Name Index
Code Index

DB Table Index
DB Column Index

DB Size Statistics

Data Model Home
Home

Details on the financing of all costs funded from the grant.

Fields


The following box shows the 10 fields in this table.

Name Content Length Empty?
Category Abstract/Set 10 YES
Grant@ Character/Fixed 6 NO
Sub-type Abstract/Set 18 YES
TOTAL! Abstract/Money 4 YES
Type Abstract/Set 12 YES
Year1# Abstract/Money 4 YES
Year2# Abstract/Money 4 YES
Year3# Abstract/Money 4 YES
Year4# Abstract/Money 4 YES
Year5# Abstract/Money 4 YES

Clusters


The following list shows the cluster containing this table.


Keys


There are no primary keys defined in this table.

The following list shows the foreign key posted into this table.

Links


There are no forward links from this table.

The following list shows the reverse link from this table.

Schema


CREATE TABLE cost (
ing_grant CHAR(6) NOT NULL NOT DEFAULT,
category CHAR(10),
type CHAR(12),
sub_type CHAR(18),
year1 MONEY,
year2 MONEY,
year3 MONEY,
year4 MONEY,
year5 MONEY,
_total MONEY
) WITH NODUPLICATES;


 : Doc : Database : Dm : Table 

Mini Informatics Logo - Link to Main Informatics Page
Please contact us with any comments or corrections.
Unless explicitly stated otherwise, all material is copyright The University of Edinburgh
Spacing Line