|
Name |
Definition |
Datatype |
Required |
Is PK |
Is FK |
|
Application Identifier |
An Application Identifier is a unique value assigned to represent a particular software application. |
INTEGER |
Yes |
Yes |
No |
|
Application Name |
An Application Name is the word or words by which a particular piece of software is known. |
VARCHAR(50) |
Yes |
No |
No |
|
Application Description |
An Application Description is the free form description that further clarifies or defines a piece of software |
VARCHAR(150) |
Yes |
No |
No |
|
Start Date |
A Start Date is the specific 24 hour period on the Gregorian calendar that denotes when the application began active use. |
DATE |
Yes |
No |
No |
|
End Date |
An End Date is the specific 24 hour period on the Gregorian calendar that denotes when the application ceased to be used. |
DATE |
No |
No |
No |