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 |