Data Dictionary
High Level ViewMedium Level ViewDetailed View Strategic Initiatives Business Processes Information Flows Systems and Services Technology Infrastructure Security Solutions
 
Name Format Length Key Required Description Existing
             
space_systems  
system_id integer 10 PK x unique ID; per identified systems project  
system_name varchar 100   x systems project name USAF Ultra-Low-Latency SATCOM; USAF GeoTalk System; Mars Lander IV; Challenge Athena III Wideband SATCOM
system_descrption varchar 250     description of the systems project  
research_and_development  
rd_project_id integer 10 PK x unique ID; per identified project  
rd_project_name varchar 100   x R&D project name Next-Generation Space Shuttle Avionics Program (NGSSAP); Boeing Dreamliner
rd_project_descrption varchar 250     description of the R&D project  
system_id integer 10 FK x unique ID; per identified systems project from space_systems table
rd_doc_id integer 10 FK x unique ID; per identified project from rd_documentation table
rd_documentation  
rd_doc_id integer 10 PK x unique ID; per identified project  
rd_doc_descrption varchar 250     description of the R&D document  
contracting_and_legal  
cl_project_id integer 10 PK x unique ID; per identified project  
cl_project_name varchar 100   x C&L project name  
cl_project_descrption varchar 250     description of the C&L project  
system_id integer 10 FK x unique ID; per identified systems project from space_systems table
cl_doc_id integer 10 FK x unique ID; per identified project from cl_documentation table
cl_documentation  
cl_doc_id integer 10 PK x unique ID; per identified project  
cl_doc_descrption varchar 250     description of the C&L document  
technical_support  
ts_project_id integer 10 PK x unique ID; per identified project  
ts_project_name varchar 100   x TS project name IT-COE; KW;
ts_project_descrption varchar 250     description of the TS project  
system_id integer 10 FK x unique ID; per identified systems project from space_systems table
ts_doc_id integer 10 FK x unique ID; per identified project from ts_documentation table
ts_documentation  
ts_doc_id integer 10 PK x unique ID; per identified project  
ts_doc_descrption varchar 250     description of the TS document  
customer  
cust_id integer 10 PK x unique ID; per individual part customer  
cust_name varchar 100   x name of customer USAF; USN; USMC; USA; NASA; FAA
cust_address varchar 50   x address of customer  
cust_descrpt varchar 250     description regarding specific customer  
cust_type_id integer 10 FK x unique ID; per individual part customer type from customer_type table
customer_type  
cust_type_id integer 10 PK x unique ID; per individual part customer type  
cust_type_descrpt varchar 250     description of the type of part customer  
shipping  
ship_id integer 10 PK x unique ID; per individual shipment  
date_shipped datetime     x yyyymmdd hh:mm  
shipment_notes varchar 1000     applicable notes regarding the shipment  
cust_id integer 10 FK x unique ID; per individual part customer from customer table
part_id integer 10 FK x unique ID; per defined part from parts table
invoice_id integer 10 FK x unique ID; per individual invoice from invoice table
part_type_id integer 10 FK   unique ID; per defined part type from part_type table
ship_via_id integer 10 FK x unique ID; per identified shipping vendor from shipping_vendor table
system_id integer 10 FK   unique ID; per identified systems project from space_systems table
shipping_vendor  
ship_via_id integer 10 PK x unique ID; per identified shipping vendor  
ship_via_name varchar 50   x shipping vendor name FedEx; USPS; UPS; DTS
ship_address varchar 50   x address of shipping vendor  
ship_via_descrpt varchar 250     applicable notes regarding the shipping vendor  
parts  
part_id integer 10 PK x unique ID; per defined part  
part_name varchar 50   x name of part  
supp_id integer 10 FK x unique ID; per individual part supplier from supplier table
part_type_id integer 10 FK   unique ID; per defined part type from part_type table
part_type  
part_type_id integer 10 PK x unique ID; per defined part type  
part_type_descript varchar 250   x description of part type  
receiving  
order_id integer 10 PK x unique ID; per individual order  
date_received datetime     x yyyymmdd hh:mm  
supp_id integer 10 FK x unique ID; per individual part supplier from supplier table
part_id integer 10 FK x unique ID; per defined part from parts table
invoice_id integer 10 FK x unique ID; per individual invoice from invoice table
invoices  
invoice_id integer 10 PK x unique ID; per individual invoice  
supp_id integer 10 FK   unique ID; per individual part supplier from supplier table
part_id integer 10 FK x unique ID; per defined part from parts table
part_type_id integer 10 FK   unique ID; per defined part type from part_type table
cust_id integer 10 FK   unique ID; per individual part customer from customer table
dept_id integer 10 FK x unique ID; per defined department from department table
system_id integer 10 FK   unique ID; per identified systems project from space_systems table
department  
dept_id integer 10 PK x unique ID; per defined department  
dept_name varchar 50   x name of department Finance; Administration; Technology Support; Contracts & Legal; Shipping & Receiving; Research & Development
dept_descrpt varchar 250   x description of defined department  
system_id integer 10 FK   unique ID; per identified systems project from space_systems table
supplier  
supp_id integer 10 PK x unique ID; per individual part supplier  
supp_name varchar 100   x name of supplier JPL; Boeing; USAF; NASA; Raytheon
supp_address varchar 50   x address of supplier  
supp_descrpt varchar 250     description regarding specific supplier  
supp_type_id integer 10 FK x unique ID; per individual part supplier type from supplier_type table
supplier_type  
supp_type_id integer 10 PK x unique ID; per individual part supplier type  
supp_type_descrpt varchar 250     description of the type of part supplier  
accounts_payable  
ap_acct_id integer 10 PK x unique ID; per defined AP account  
ap_acct_name varchar 100   x name of AP account JPL; Boeing; USAF; NASA; Raytheon;FedEx; Pitney Bowes; USPS; UPS
date_inv_received datetime     x yyyymmdd hh:mm  
date_inv_paid datetime     x yyyymmdd hh:mm  
date_paid datetime     x yyyymmdd hh:mm  
amt_paid double 10   x amount paid on account  
invoice_id integer 10 FK x unique ID; per individual invoice from invoice table
cust_id integer 10 FK   unique ID; per individual part customer from customer table
dept_acct_id integer 10 FK x unique ID; per department account from department_accounts table
system_id integer 10 FK   unique ID; per identified systems project from space_systems table
accounts_receivable  
ar_acct_id integer 10 PK x unique ID; per defined AR account  
ar_acct_name varchar 100   x name of AR account JPL; Boeing; USAF; NASA; Raytheon; USAF; USN; USMC; USA; NASA; FAA
date_pmt_billed datetime     x yyyymmdd hh:mm  
date_pmt_received datetime     x yyyymmdd hh:mm  
amt_received double 20   x amount preceived on invoice  
invoice_id integer 10 FK x unique ID; per individual invoice from invoice table
cust_id integer 10 FK   unique ID; per individual part customer from customer table
dept_acct_id integer 10 FK x unique ID; per department account from department_accounts table
system_id integer 10 FK   unique ID; per identified systems project from space_systems table
department_accounts  
dept_acct_id integer 10 PK x unique ID; per department account  
dept_acct_name varchar 100   x name of department
dept_acct_descrpt varchar 250   x description of department   
dept_amt_paid double 10     payment paid from account  
dept_amt_received double 10     payment paid to account  
dept_acct_balanace double 10     account balance  
dept_id integer 10 FK x unique ID; per defined department from department table
system_id integer 10 FK   unique ID; per identified systems project from space_systems table
system_accounts  
system_acct_id integer 10 PK x unique ID; per system account  
system_acct_name varchar 100   x name of system Commercial Aviation; Defense Systems; Space Systems; 
system_amt_paid double 10     payment paid from account  
system_amt_received double 10     payment paid to account  
system_acct_balanace double 10     account balance  
dept_id integer 10 FK x unique ID; per defined department from department table
system_id integer 10 FK   unique ID; per identified systems project from space_systems table
 
 
 

© 2010 CMU/Boeing Class - all rights reserved