Datenbank Firebird

(1)

Datenbank Firebird

Employee

'EMP_NO' 'FIRST_NAME' 'LAST_NAME' 'PHONE_EXT' 'HIRE_DATE' 'DEPT_NO' 'JOB_CODE' 'JOB_GRADE' 'JOB_COUNTRY' 'SALARY' 'FULL_NAME'

Department

'DEPT_NO' 'DEPARTMENT' 'HEAD_DEPT' 'MNGR_NO' 'BUDGET' 'LOCATION' 'PHONE_NO'

Employee_project

'EMP_NO' 'PROJ_ID'

Customer

'CUST_NO' 'CUSTOMER' 'CONTACT_FIRST' 'CONTACT_LAST' 'PHONE_NO' 'ADDRESS_LINE1' 'ADDRESS_LINE2' 'CITY'

'STATE_PROVINCE' 'COUNTRY' 'POSTAL_CODE' 'ON_HOLD'

Country

'COUNTRY' 'CURRENCY'

Job

'JOB_CODE' 'JOB_GRADE' 'JOB_COUNTRY' 'JOB_TITLE' 'MIN_SALARY' 'MAX_SALARY' 'JOB_REQUIREMENT' 'LANGUAGE_REQ'

Project

'PROJ_ID' 'PROJ_NAME' 'PROJ_DESC' 'TEAM_LEADER' 'PRODUCT'

(2)

Proj_dept_budget

'FISCAL_YEAR''PROJ_ID' 'DEPT_NO' 'QUART_HEAD_CNT' 'PROJECTED_BUDGET'

Salary_history

'EMP_NO' 'CHANGE_DATE' 'UPDATER_ID' 'OLD_SALARY' 'PERCENT_CHANGE' 'NEW_SALARY'

Sales

'PO_NUMBER' 'CUST_NO' 'SALES_REP' 'ORDER_STATUS' 'ORDER_DATE' 'SHIP_DATE' 'DATE_NEEDED' 'PAID'

'QTY_ORDERED' 'TOTAL_VALUE' 'DISCOUNT' 'ITEM_TYPE' 'AGED'