New table: tiki_projects_resource_types
New Table that allows different Resource types to be defined.
All the new fields identified so far are as follows, but this is highly likely to be changed/refined once the development is under way:
Tables:
Field | Type | Null | Default | Comments
|
resourceId | int(14) | No | resourceId sequentially assigned by system | |
resource_title | varchar(200) | title of the resource type | ||
resource_description | text | description of the resource type | ||
resource_type | char(3) | 3 character code to designate the resource type | ||
team_id | int(14) | No | teamId reference if the Resource type is a project team | |
last_editor | varchar(200) | userId of whoever edited the resource last | ||
one_time_cost | decimal(10,2) | cost of the resource type that is incurred on a one-time use basis | ||
cost_per_time | decimal(10,2) | cost of the resource type that is incurred on a per hour basis | ||
res_time_unit | char(1) | No | h | minutes (m), hours (h), days (d), weeks (w) or months (m) with a default of hours |
currency | char(4) | ISO4217 currency names eg GBP | ||
Indexes:
Keyname | Type | FieldId(s)
| ||
PRIMARY | PRIMARY | resourceId | ||
Table of contents for section:
Table of contents for main document: