Entity Name |
Entity Definition |
 
|
ACCOUNT |
An Account represents a system account that has elevated privileges or special features/functions needed by the Staff for support. |
 
|
Attribute Name |
Attribute Definition |
Attribute Datatype |
Attribute Is PK |
Attribute Required |
Attribute Is FK |
 
|
Account Identifier |
An Account Identifier is a unique value assigned to represent a certain database account that has special priviledges needed by the Staff to maintain the Application Database. |
INTEGER |
Yes |
Yes |
No |
 
|
Application Database Identifier |
An Application Database Identifier is a unique value that denotes a particular application database. |
INTEGER |
No |
Yes |
Yes |
 
|
User Identifier |
A User Identifier is an alphanumeric value used to depict a Staff or an Application which must access the database. |
VARCHAR(25) |
No |
Yes |
No |
 
|
Account Description |
An Account Description is the free form text that describes the Account or User Identifier |
VARCHAR(150) |
No |
Yes |
No |
 
|
Password Text |
The Password Text is an encrypted value that is a given account's secret code for logging onto the database. |
VARCHAR(50) |
No |
Yes |
No |
APPLICATION |
An Application is a piece or multiple pieces of software that have been coupled together for a specific purpose. |
 
|
Attribute Name |
Attribute Definition |
Attribute Datatype |
Attribute Is PK |
Attribute Required |
Attribute 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) |
No |
Yes |
No |
 
|
Application Description |
An Application Description is the free form description that further clarifies or defines a piece of software |
VARCHAR(150) |
No |
Yes |
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 |
No |
Yes |
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 |
APPLICATION DATABASE |
An Application Database is the part of an application that is used to store data for a given piece of software or pieces of software for a particular set of related functions. |
 
|
Attribute Name |
Attribute Definition |
Attribute Datatype |
Attribute Is PK |
Attribute Required |
Attribute Is FK |
 
|
Application Database Identifier |
An Application Database Identifier is a unique value that denotes a particular application database. |
INTEGER |
Yes |
Yes |
No |
 
|
Application Identifier |
An Application Identifier is a unique value assigned to represent a particular software application. |
INTEGER |
No |
Yes |
Yes |
 
|
Database Instance Name |
A Database Instance Name is the word or words by which a particular instance of an Application Database is known by. |
VARCHAR(50) |
No |
Yes |
No |
 
|
Start Up Procedure Text |
A Start Up Procedure Text is the free form text that describes the steps necessary to bring up the database instance. |
VARCHAR(4000) |
No |
No |
No |
 
|
Shut Down Procedure Text |
A Shut Down Procedure Text is the free form text that describes the steps necessary to bring down the database instance. |
VARCHAR(4000) |
No |
No |
No |
 
|
Login Procedure Text |
A Login Procedure Text is the free form text that describes the steps necessary to log into the application database for a specific purpose, usually maintenance of some kind. |
VARCHAR(4000) |
No |
No |
No |
 
|
Backup Procedure Text |
A Backup Procedure Text is the free form text that describes the steps necessary to backup the database. |
VARCHAR(4000) |
No |
No |
No |
 
|
Environment Code |
An Environment Code is a particular set of letters and/or numbers that represents a particular software domain. |
VARCHAR(10) |
No |
Yes |
Yes |
 
|
Start Date |
A (Application Database) Start Date is the specific 24 hour period on the Gregorian calendar that the Application Database began operations. |
DATE |
No |
Yes |
No |
 
|
End Date |
An (Application Database) End Date is the specific 24 hour period on the Gregorian Calendar that denotes when the Application Database ceased operations. |
DATE |
No |
No |
No |
 
|
Tablespace Name |
A Tablespace Name is the word or words by which a particular tablespace in the database is known. Usually one or more is assigned to a specific database.
|
VARCHAR(50) |
No |
No |
No |
 
|
Current Size Bytes Number |
A Current Size Bytes Number is the numeric value in bytes that shows the current size of the entire Application Database |
NUMBER(15,2) |
No |
No |
No |
 
|
Service Level Agreement Code |
A Service Level Agreement Code is a specific alphanumeric code assigned to represent a particular response time to critical events and the timing of their resolution |
VARCHAR(10) |
No |
Yes |
Yes |
 
|
Database Management System Identifier |
A Database Management System Identifier is a unique value assigned to represent a specific database management system and its specific version. |
INTEGER |
No |
Yes |
Yes |
 
|
Application Database Status Code |
An Application Database Status Code is specific combination of letters and/or numbers that represents the current state of a particular Application Database. |
VARCHAR(10) |
No |
Yes |
Yes |
APPLICATION DATABASE HOST |
An Application Database Host is the main server/computer that has a particular applications database running on it. |
 
|
Attribute Name |
Attribute Definition |
Attribute Datatype |
Attribute Is PK |
Attribute Required |
Attribute Is FK |
 
|
Application Database Host Identifier |
An Application Database Host Identifier is a unique value that represents the assignment of an Application Host and the related Application Database
|
INTEGER |
Yes |
Yes |
No |
 
|
Application Host Identifier |
An Application Host Identifier is a unique value assigned to represent a particular computer functioning as a server. |
INTEGER |
No |
Yes |
Yes |
 
|
Application Database Identifier |
An Application Database Identifier is a unique value that denotes a particular application database. |
INTEGER |
No |
Yes |
Yes |
 
|
Standby Indicator |
A Standby Indicator is a binary representation of whether or not a particular application database host has been configured as a Standby ("Y") database or not ("N"). |
CHAR(1) |
No |
Yes |
No |
APPLICATION DATABASE NOTE |
An Application Database Note is some free form text that is relevant to the application. |
 
|
Attribute Name |
Attribute Definition |
Attribute Datatype |
Attribute Is PK |
Attribute Required |
Attribute Is FK |
 
|
Application Database Note Identifier |
An Application Database Note Identifier is a unique value assigned to represent a particular collection of free form text that pertains to a given application database. |
INTEGER |
Yes |
Yes |
No |
 
|
Application Database Identifier |
An Application Database Identifier is a unique value that denotes a particular application database. |
INTEGER |
No |
Yes |
Yes |
 
|
Note Text |
A Note Text is the free form text that provides additional information or context for a given Application Database. |
VARCHAR(4000) |
No |
Yes |
No |
APPLICATION DATABASE STATUS |
An Application Database Status reflects the known state of a particular application's database. |
 
|
Attribute Name |
Attribute Definition |
Attribute Datatype |
Attribute Is PK |
Attribute Required |
Attribute Is FK |
 
|
Application Database Status Code |
An Application Database Status Code is specific combination of letters and/or numbers that represents the current state of a particular Application Database. |
VARCHAR(10) |
Yes |
Yes |
No |
 
|
Application Database Status Description |
An Application Database Status Description is the free form text that further clarifies or defines a particular Application Database Status. |
VARCHAR(150) |
No |
Yes |
No |
APPLICATION HOST |
A Host is a computer server that usually exists for the purpose of hosting some kind of software (web server, database, application server, etc...) |
 
|
Attribute Name |
Attribute Definition |
Attribute Datatype |
Attribute Is PK |
Attribute Required |
Attribute Is FK |
 
|
Application Host Identifier |
An Application Host Identifier is a unique value assigned to represent a particular computer functioning as a server. |
INTEGER |
Yes |
Yes |
No |
 
|
Application Host Name |
An Application Host Name is the word or words by which a particular computer server is known by. |
VARCHAR(256) |
No |
Yes |
No |
 
|
Location Text |
A Location Text is the free form textual description of where a particular computer server resides. |
VARCHAR(4000) |
No |
No |
No |
 
|
Central Processing Unit Core Count |
A Central Processing Unit Core Count is the number of CPUs a particular host may physically have available. |
INTEGER |
No |
No |
No |
 
|
Operating System Code |
An Operating System Code is the unique value assigned to represent a particular computer operating system and the particular version. |
VARCHAR(10) |
No |
Yes |
Yes |
 
|
Enterprise Data Architecture Group Identifier |
An Enterprise Data Architecture Group Identifier is a unique value that represents a certain collection of individuals within the group |
INTEGER |
No |
Yes |
Yes |
APPLICATION STAFF |
An Application Staff is the association of an individual to a particular application. |
 
|
Attribute Name |
Attribute Definition |
Attribute Datatype |
Attribute Is PK |
Attribute Required |
Attribute Is FK |
 
|
Application Staff Identifier |
An Application Staff Identifier is a unique value that represents the intersection between the person in the organization and the application database that the individual is responsible for. |
INTEGER |
Yes |
Yes |
No |
 
|
Application Identifier |
An Application Identifier is a unique value assigned to represent a particular software application. |
INTEGER |
No |
No |
Yes |
 
|
Staff Identifier |
A Staff Identifier is a unique value assigned to represent a particular person within the organization. |
INTEGER |
No |
Yes |
Yes |
 
|
Staff Role Code |
A Staff Role Code is an alphanumeric code that is used to represent a particular set of functions and responsibilities that an individual in the organization fulfills. |
VARCHAR(10) |
No |
Yes |
Yes |
 
|
Start Date |
An (Application Staff) Start Date denotes the specific 24 hour period on the Gregorian calendar when a particular Staff member became associated with a unique piece of software. |
DATE |
No |
Yes |
No |
 
|
End Date |
An (Application Staff) End Date denotes the specific 24 hour period on the Gregorian calendar when a particular Staff memeber ceases to be associated with a unique piece of software. |
DATE |
No |
No |
No |
AUTHORIZED REQUESTOR |
An Authorized Requestor is an individual who is permitted to request additional resources for a piece of computer hardware |
 
|
Attribute Name |
Attribute Definition |
Attribute Datatype |
Attribute Is PK |
Attribute Required |
Attribute Is FK |
 
|
Authorized Requestor Identifier |
An Authorized Requestor Identifier is a unique value assigned to represent a specific person who is authorized to request hardware changes to a particular application database. |
INTEGER |
Yes |
Yes |
No |
 
|
First Name |
A (Authorized Requestor) First Name is the word or words that a particular individual is commonly addressed by. |
VARCHAR(50) |
No |
No |
No |
 
|
Last Name |
A (Authorized Requestor) Last Name is the word or words that a particular individual is known by in addition to their First Name. |
VARCHAR(50) |
No |
No |
No |
 
|
Electronic Mail Address |
The domain-based address by which a "electronic mailbox" is referred to.
|
VARCHAR(320) |
No |
Yes |
No |
 
|
Telephone Number |
The number that designates the origination or destination of a voice or data transmission via a public telephone carrier. This EXCLUDES the country calling code and any extension number provided by a Private Branch Exchange (PBX).
|
VARCHAR(14) |
No |
No |
No |
CALENDAR EVENT TYPE |
A Calendar Event Type classifies an event that occurs on a particular day in association with a particular staff individual. |
 
|
Attribute Name |
Attribute Definition |
Attribute Datatype |
Attribute Is PK |
Attribute Required |
Attribute Is FK |
 
|
Calendar Event Code
|
A Calendar Event Code is a combination of letters and/or numbers that represents a unique kind of temporal thing. |
VARCHAR(10) |
Yes |
Yes |
No |
 
|
Calendar Event Name |
A Calendar Event Name is the word or words by which a unique temporal thing is known by. |
VARCHAR(50) |
No |
Yes |
No |
DATABASE INSTANCE |
A Database Instance represents processes and the portion of an Oracle database that runs in memory. |
 
|
Attribute Name |
Attribute Definition |
Attribute Datatype |
Attribute Is PK |
Attribute Required |
Attribute Is FK |
 
|
Database Instance Identifier |
A Database Instance Identifier is a unique value assigned to represent a particular instance of a database. |
INTEGER |
Yes |
Yes |
No |
 
|
Database Instance Name |
A Database Instance Name is the word or words by which an exact database instance is known by. |
VARCHAR(50) |
No |
Yes |
No |
 
|
Application Database Host Identifier |
An Application Database Host Identifier is a unique value that represents the assignment of an Application Host and the related Application Database
|
INTEGER |
No |
No |
Yes |
DATABASE INSTANCE SERVICE |
A Database Instance Service is defined as a logical representation of a database, which is the way a database is presented to clients. A database can be presented as multiple services and a service can be implemented as multiple database instances. The service name is a string that is the global database name, that is, a name comprising the database name and domain name, entered during installation or database creation.
http://docs.oracle.com/cd/B19306_01/network.102/b14212/glossary.htm
|
 
|
Attribute Name |
Attribute Definition |
Attribute Datatype |
Attribute Is PK |
Attribute Required |
Attribute Is FK |
 
|
Database Instance Service Identifier |
A Database Instance Service Identifier is the unique value assigned to represent the Service Name running on a particular database instance. |
INTEGER |
Yes |
Yes |
No |
 
|
Database Instance Service Name |
A Database Instance Service Name is the word or words by which a particular database instance is known by. |
VARCHAR(100) |
No |
No |
No |
 
|
Database Instance Identifier |
A Database Instance Identifier is a unique value assigned to represent a particular instance of a database. |
INTEGER |
No |
Yes |
Yes |
DATABASE MANAGEMENT SYSTEM |
A Database Management System is software that handles the storage, retrieval, and updating of data in a computer system. More commonly known as a database.
|
 
|
Attribute Name |
Attribute Definition |
Attribute Datatype |
Attribute Is PK |
Attribute Required |
Attribute Is FK |
 
|
Database Management System Identifier |
A Database Management System Identifier is a unique value assigned to represent a specific database management system and its specific version. |
INTEGER |
Yes |
Yes |
No |
 
|
Database Management System Name |
A Database Management System Name is the word or words by which a particular set of computer programs is known by that is designed for the storage and retrieval of data. |
VARCHAR(75) |
No |
Yes |
No |
 
|
Version Number |
A (DBMS) Version Number is the alphanumeric representation of a given DBMS at particular point in time. |
VARCHAR(100) |
No |
Yes |
No |
 
|
Enterprise Data Architecture Group Identifier |
An Enterprise Data Architecture Group Identifier is a unique value that represents a certain collection of individuals within the group |
INTEGER |
No |
Yes |
Yes |
ENTERPRISE DATA ARCHITECTURE GROUP |
The Enterprise Data Architecture Group classifies a group of people into one of the sub-categories within EDA. |
 
|
Attribute Name |
Attribute Definition |
Attribute Datatype |
Attribute Is PK |
Attribute Required |
Attribute Is FK |
 
|
Enterprise Data Architecture Group Identifier |
An Enterprise Data Architecture Group Identifier is a unique value that represents a certain collection of individuals within the group |
INTEGER |
Yes |
Yes |
No |
 
|
Enterprise Data Architecture Group Name |
An Enterprise Data Architecture Group Name is the word or words by which a certain collection of individuals within the larger group are known by. |
VARCHAR(50) |
No |
Yes |
No |
ENVIRONMENT |
An Environment represents a collection of servers, software, data, etc..for the purposes of either development, quality assurance or the running of a production application or set of applications. |
 
|
Attribute Name |
Attribute Definition |
Attribute Datatype |
Attribute Is PK |
Attribute Required |
Attribute Is FK |
 
|
Environment Code |
An Environment Code is a particular set of letters and/or numbers that represents a particular software domain. |
VARCHAR(10) |
Yes |
Yes |
No |
 
|
Environment Description |
An Environment Description is the free form text that further clarifies or describes a software domain. |
VARCHAR(150) |
No |
Yes |
No |
EVENT |
An Event is somethng that happens that is noteworthy or notable |
 
|
Attribute Name |
Attribute Definition |
Attribute Datatype |
Attribute Is PK |
Attribute Required |
Attribute Is FK |
 
|
Event Identifier |
An Event Identifier is a unique value assigned to represent a temporal incident that occured for a given Application Database. |
INTEGER |
Yes |
Yes |
No |
 
|
Application Database Identifier |
An Application Database Identifier is a unique value that denotes a particular application database. |
INTEGER |
No |
Yes |
Yes |
 
|
Technology Event Type Identifier |
A Technology Event Type Identifier is a unique value that represents kind of computer / software occurence that may be planned or unexpected. |
INTEGER |
No |
Yes |
Yes |
 
|
Summary Text |
A Summary Text is the free form text that describes something that has happened at a particular point in time |
VARCHAR(4000) |
No |
Yes |
No |
 
|
Start Timestamp |
A Start Timestamp is a particular point within the noted 24 hour period on the Gregorian calendar that something was first noticed or started to happen. |
TIMESTAMP |
No |
Yes |
No |
 
|
End Timestamp |
An End Timestamp is a particular point within the noted 24 hour period on the Gregorian calendar that something came to an end. |
TIMESTAMP |
No |
No |
No |
OPERATING SYSTEM |
An Operating System represents a particular collection of software programs centered around a particular kernel that runs a computer. |
 
|
Attribute Name |
Attribute Definition |
Attribute Datatype |
Attribute Is PK |
Attribute Required |
Attribute Is FK |
 
|
Operating System Code |
An Operating System Code is the unique value assigned to represent a particular computer operating system and the particular version. |
VARCHAR(10) |
Yes |
Yes |
No |
 
|
Operating System Name |
An Operating System Name is the word or words by which a particular kernel and related applications are known by. |
VARCHAR(50) |
No |
No |
No |
 
|
Version Number |
A Version Number is an alphanumeric representation of the Operating System at a point in time. |
VARCHAR(100) |
No |
No |
No |
PROVISIONING |
A Provisioning represents one or more Provisoining Requests for additonal resources, usually disk space, but can also be CPUs and memory. |
 
|
Attribute Name |
Attribute Definition |
Attribute Datatype |
Attribute Is PK |
Attribute Required |
Attribute Is FK |
 
|
Provisioning Identifier |
A Provisioning Identifier is a unique value assigned to represent one or more requested hardware changes to an application database server. |
INTEGER |
Yes |
Yes |
No |
 
|
Application Database Identifier |
An Application Database Identifier is a unique value that denotes a particular application database. |
INTEGER |
No |
Yes |
Yes |
 
|
Provisioning Request Timestamp |
A Provisioning Request Timestamp is a certain point in time within the noted 24 hour period on the Gregorian calendear during which additional server resources were asked for. |
TIMESTAMP |
No |
Yes |
No |
 
|
Authorized Requestor Identifier |
An Authorized Requestor Identifier is a unique value assigned to represent a specific person who is authorized to request hardware changes to a particular application database. |
INTEGER |
No |
Yes |
Yes |
 
|
Comment Text |
A Commnet Text is the free form text with provides additional information regarding a particular Provisioning Request. |
VARCHAR(4000) |
No |
Yes |
No |
PROVISIONING REQUEST |
A Provisioning Request represents a specific application for additonal resources, usually disk space, but can also be CPUs and memory. |
 
|
Attribute Name |
Attribute Definition |
Attribute Datatype |
Attribute Is PK |
Attribute Required |
Attribute Is FK |
 
|
Provisioning Request Identifier |
A Provisioning Request Identifier is the unique value that represents precisely what hardware change is being requested by the Authorized Requestor. |
INTEGER |
Yes |
Yes |
No |
 
|
Provisioning Identifier |
A Provisioning Identifier is a unique value assigned to represent one or more requested hardware changes to an application database server. |
INTEGER |
No |
Yes |
Yes |
 
|
Requested Size Count |
A Requested Size Count is the numeric value of the kind of request being made. |
NUMBER(15,2) |
No |
Yes |
No |
 
|
Provisioning Request Type Code |
A Provisioning Request Type Code is a alphanumeric value that classifies the type of Provisioning Request being made. |
VARCHAR(10) |
No |
Yes |
Yes |
 
|
Comment Text |
A Comment Text is the free form text that further clarifies the requested resources. |
VARCHAR(4000) |
No |
No |
No |
PROVISIONING REQUEST TYPE |
A Provisioning Request Type classifies the kind of request being made. In other words, is a request be made for additional CPUs, disk space, or RAM.
|
 
|
Attribute Name |
Attribute Definition |
Attribute Datatype |
Attribute Is PK |
Attribute Required |
Attribute Is FK |
 
|
Provisioning Request Type Code |
A Provisioning Request Type Code is a alphanumeric value that classifies the type of Provisioning Request being made. |
VARCHAR(10) |
Yes |
Yes |
No |
 
|
Provisioning Request Type Description |
A Provisioning Request Type Description is the free form text that clarifies the categorization of the request. |
VARCHAR(150) |
No |
Yes |
No |
SERVICE LEVEL AGREEMENT |
A Service Level Agreement represents a written statement about response and resolution times for various systems varying by their importance to the business. |
 
|
Attribute Name |
Attribute Definition |
Attribute Datatype |
Attribute Is PK |
Attribute Required |
Attribute Is FK |
 
|
Service Level Agreement Code |
A Service Level Agreement Code is a specific alphanumeric code assigned to represent a particular response time to critical events and the timing of their resolution |
VARCHAR(10) |
Yes |
Yes |
No |
 
|
Service Level Agreement Description |
A Service Level Agreement Description is the free form text that further clarifies or defines a particular Service Level Agreement Code. |
VARCHAR(150) |
No |
Yes |
No |
STAFF |
A Staff is an individual who works within the organization |
 
|
Attribute Name |
Attribute Definition |
Attribute Datatype |
Attribute Is PK |
Attribute Required |
Attribute Is FK |
 
|
Staff Identifier |
A Staff Identifier is a unique value assigned to represent a particular person within the organization. |
INTEGER |
Yes |
Yes |
No |
 
|
First Name |
A First Name is the word by which an individual is generaly known by |
VARCHAR(50) |
No |
No |
No |
 
|
Last Name |
A Last Name is the word or words which makes up the last part of an individual's name. |
VARCHAR(50) |
No |
No |
No |
 
|
Staff Role Code |
A Staff Role Code is an alphanumeric code that is used to represent a particular set of functions and responsibilities that an individual in the organization fulfills. |
VARCHAR(10) |
No |
Yes |
Yes |
 
|
Work Telephone Number |
The number that designates the origination or destination of a voice or data transmission via a public telephone carrier. This EXCLUDES the country calling code and any extension number provided by a Private Branch Exchange (PBX).
|
VARCHAR(14) |
No |
No |
No |
 
|
Cell Telephone Number |
The number that designates the origination or destination of a voice or data transmission via a public telephone carrier. This EXCLUDES the country calling code and any extension number provided by a Private Branch Exchange (PBX).
|
VARCHAR(14) |
No |
No |
No |
 
|
Start Date |
A Start Date denotes the specific 24 hour period on the Gregorian calendar that an individual became a part of the Staff |
DATE |
No |
Yes |
No |
 
|
End Date |
An End Date denotes the specific 24 hour period on the Gregorian calendar that an individual ceased to be an active member of the staff. |
DATE |
No |
No |
No |
 
|
Team Code |
A Team Code is an alphanumeric representation of a particalur collection of Staff who either perform the same function or work on the same DBMS. |
VARCHAR(10) |
No |
Yes |
Yes |
 
|
Enterprise Data Architecture Group Identifier |
An Enterprise Data Architecture Group Identifier is a unique value that represents a certain collection of individuals within the group |
INTEGER |
No |
Yes |
Yes |
STAFF CALENDAR |
A Staff Calendar is representation of a series of events that occurs in relation to members of the organization. |
 
|
Attribute Name |
Attribute Definition |
Attribute Datatype |
Attribute Is PK |
Attribute Required |
Attribute Is FK |
 
|
Staff Calendar Event Identifier |
A Staff Calendar Event Identifier is the unique value assigned to represent a particular event that a certain individual within the organization is involved in. |
INTEGER |
Yes |
Yes |
No |
 
|
Start Event Date |
A (Staff Calendar) Start Event Date is a particular 24 hour period on the Gregorian calendar where something relating to a given Staff member begins. |
DATE |
No |
Yes |
No |
 
|
End Event Date |
An (Staff Calendar) End Event Date is the particular 24 hour period on the Gregorian calendar that denotes the conclusion of something relating to a given Staff member. |
DATE |
No |
Yes |
No |
 
|
Enterprise Data Architecture Group Identifier |
An Enterprise Data Architecture Group Identifier is a unique value that represents a certain collection of individuals within the group |
INTEGER |
No |
Yes |
Yes |
 
|
Staff Identifier |
A Staff Identifier is a unique value assigned to represent a particular person within the organization. |
INTEGER |
No |
Yes |
Yes |
 
|
Calendar Event Code
|
A Calendar Event Code is a combination of letters and/or numbers that represents a unique kind of temporal thing. |
VARCHAR(10) |
No |
Yes |
Yes |
STAFF EVENT |
  |
 
|
Attribute Name |
Attribute Definition |
Attribute Datatype |
Attribute Is PK |
Attribute Required |
Attribute Is FK |
 
|
Staff Event Identifier |
  |
INTEGER |
Yes |
Yes |
No |
 
|
Staff Identifier |
A Staff Identifier is a unique value assigned to represent a particular person within the organization. |
INTEGER |
No |
No |
Yes |
 
|
Event Identifier |
An Event Identifier is a unique value assigned to represent a temporal incident that occured for a given Application Database. |
INTEGER |
No |
No |
Yes |
 
|
Start Timestamp |
  |
TIMESTAMP |
No |
No |
No |
 
|
End Timestamp |
  |
TIMESTAMP |
No |
No |
No |
STAFF ROLE |
A Staff Role is a particular job function being fulfilled by a person within the organization |
 
|
Attribute Name |
Attribute Definition |
Attribute Datatype |
Attribute Is PK |
Attribute Required |
Attribute Is FK |
 
|
Staff Role Code |
A Staff Role Code is an alphanumeric code that is used to represent a particular set of functions and responsibilities that an individual in the organization fulfills. |
VARCHAR(10) |
Yes |
Yes |
No |
 
|
Staff Role Description |
A Staff Role Description is the free form text that further clarifies a Staff Role Code. |
VARCHAR(150) |
No |
Yes |
No |
TEAM |
A Team is a group of individuals within the organization that perform similar operations / functions for a specific combination of hardware and software |
 
|
Attribute Name |
Attribute Definition |
Attribute Datatype |
Attribute Is PK |
Attribute Required |
Attribute Is FK |
 
|
Team Code |
A Team Code is an alphanumeric representation of a particalur collection of Staff who either perform the same function or work on the same DBMS. |
VARCHAR(10) |
Yes |
Yes |
No |
 
|
Team Name |
A Team Name is the word or words by which a given group of the Staff is commonly known by. |
VARCHAR(50) |
No |
No |
No |
TECHNOLOGY EVENT TYPE |
A Technology Event Type classifies a specific kind of thing that occured in relation to a given set of hardware and software |
 
|
Attribute Name |
Attribute Definition |
Attribute Datatype |
Attribute Is PK |
Attribute Required |
Attribute Is FK |
 
|
Technology Event Type Identifier |
A Technology Event Type Identifier is a unique value that represents kind of computer / software occurence that may be planned or unexpected. |
INTEGER |
Yes |
Yes |
No |
 
|
Technology Event Type Description |
A Technology Event Type Description is the free form text that further defines or clarifies a something that happens in the context of a computer or technology setting. |
VARCHAR(150) |
No |
Yes |
No |
 
|
Planned Indicator |
A Planned Indicator is a binary representation of whether or not a particular occurrence was preplanned ("Y") or if it was spontaneous ("N"). |
CHAR(1) |
No |
Yes |
No |