Project Control Database

# Project Control Database

# Default Relational Database Definition

# The user must not revise this database definition other than to change

# column names.

###################################################

# Project Description Data

table number = 101 , number of columns = 6 1 , system_unique_no , integer

2 , project_no , character(15) 3 , project_name , character(40) 4 , job_no , character(40) 5 , company_name , character(40) 6 , plant_name , character(40)

###################################################

# Reference Database Management Data table number = 102, number of columns = 9 1 , type_of_rdb_data , short

2 , approval_status , short

3 , rdb_file_spec , character(14) 4 , path_name , character(36) 5 , network_address , character(26) 6 , lock_owner , character(10) 7 , lock_status , short

8 , lock_date , integer 9 , revision_date , integer

###################################################

# Project Control Data

table number = 103 , number of columns = 39

59

PDS 3D Theory — April 2002

________________

1 , product_version_no , short

2 , report_path , character(36) 3 , report_node , character(26) 4 , report_format_path , character(36) 5 , report_format_node , character(26) 6 , report_filter_path , character(36) 7 , report_filter_node , character(26) 8 , piping_eden_path , character(36) 9 , piping_eden_node , character(26) 10, eden_table_path , character(36) 11, eden_table_node , character(26) 12, piping_spec_path , character(36) 13, piping_spec_node , character(26) 14, assembly_path , character(36) 15, assembly_node , character(26) 16, model_builder_path , character(36) 17, model_builder_node , character(26) 18, design_review_path , character(36) 19, design_review_node , character(26) 20, std_note_lib_path , character(36) 21, std_note_lib_node , character(26) 22, eqp_eden_path , character(36) 23, eqp_eden_node , character(26) 24, tdf_table_path , character(36) 25, tdf_table_node , character(26) 26, clash_report_path , character(36) 27, clash_report_node , character(26) 28, clash_plot_path , character(36) 29, clash_plot_node , character(26)

30, mdl_status_low_dr , short , standard note 1605 31, mdl_status_high_dr , short , standard note 1605 32, mdl_status_low_ic , short , standard note 1605 33, mdl_status_high_ic , short , standard note 1605 34, area_owner_opt_ic , short

35, eqp_insul_opt_ic , short 36, eqp_con_tol_opt_ic , short 37, clash_rpt_index_no , integer 38, report_search_path , character(36) 39, report_search_node , character(26)

###################################################

# Project Archival Management Data

table number = 104, number of columns = 10 1 , archival_index_no , integer

2 , archival_number , character(24) 3 , archival_descript , character(40) 4 , archival_file_spec , character(14) 5 , path_name , character(36) 6 , network_address , character(26) 7 , month_map , integer 8 , day_of_week_map , integer 9 , day_map , integer 10, time_of_day , integer

###################################################

# Model Management Data

2. Database Overview Database Definition Files

________________

# Engineering Discipline Data

table number = 111 , number of columns = 5 1 , discipline_indx_no , short

2 , discipline_name , character(20) 3 , intra_disc_ifc_flg , short

4 , discipline_mtrx_a, integer 5 , discipline_mtrx_b, integer

# Design Area Data

table number = 112 , number of columns = 15 1 , discipline_indx_no , short

2 , area_index_no , short

3 , area_name , character(10) 4 , area_description , character(40) 5 , volume_low_x , integer 6 , volume_low_y , integer 7 , volume_low_z , integer 8 , volume_high_x , integer 9 , volume_high_y , integer 10, volume_high_z , integer 11, interference_mode , short

12, area_lock_owner , character(10) 13, area_lock_status , short

14, area_lock_date , integer 15, clash_rpt_index_no , integer

# Model Data

table number = 113 , number of columns = 17

1 , model_index_no , integer , index 1 2 , discipline_indx_no , short

3 , area_index_no , short 4 , partition_no , short

5 , model_no , character(10) 6 , model_description , character(40) 7 , model_file_spec , character(14) 8 , path_name , character(36) 9 , network_address , character(26) 10, lock_owner , character(10) 11, lock_status , short

12, lock_date , integer 13, verification_date , integer 14, revision_date , integer 15, responsible_disc , short 16, model_type , short

17, model_status , short , standard note 1605

# Piping Model Data

table number = 114 , number of columns = 6 1 , partition_no , short

2 , max_segment_number , integer 3 , max_piping_number , integer

61

PDS 3D Theory — April 2002

________________

4 , max_pipe_number , integer 5 , max_instr_number , integer 6 , max_support_number , integer

# Model Setup Data

table number = 115 , number of columns = 5 1 , discipline_indx_no , short

2 , default_path_name , character(36) 3 , default_node , character(26) 4 , ref_mdl_symbology , short

5 , symbology_display , short

###################################################

# Structural Management Data

# Structural Sub-Project Control Data table number = 116, number of columns = 6 1 , sub_project_ndx_no , short

2 , sub_project_no , character(15) 3 , sub_project_name , character(40) 4 , sub_project_path , character(36) 5 , sub_project_node , character(26) 6 , sub_project_mount , character(50)

# Structural Design Area Per Sub-Project Data table number = 117, number of columns = 2 1 , area_index_no , short

2 , sub_project_ndx_no , short

###################################################

# Inspection Iso Data

table number = 118, number of columns = 3 1 , inspection_iso_id , character(24) 2 , inspection_status , short

3 , max_inspection_key , short

###################################################

###################################################

# Drawing Management Data

# Drawing Data

2. Database Overview Database Definition Files

________________

table number = 121, number of columns = 24

1 , dwg_index_no , integer , index 1 2 , drawing_no , character(24) , index 2 3 , drawing_title , character(40)

4 , default_scale , character(16) 5 , approval_initials , character(4) 6 , approval_date , integer

7 , approval_status , short , standard note 35 8 , completion_status , short

9 , drawing_size , short , standard note 1202

10, drawing_type , short , standard note 2000 , index 3 11, last_revision_no , character(2)

12, drawing_file_spec , character(14) 13, path_name , character(36) 14, network_address , character(26) 15, lock_owner , character(10) 16, lock_status , short

17, lock_date , integer 18, revision_date , integer 19, last_rev_index_no , short

20, release_revision , character(2) 21, release_date , integer

22, checking_status , short , standard note 1610 23, standard_note_no_a , short , standard note 499 24, standard_note_no_b , short , standard note 499

# Drawing View Data

table number = 122, number of columns = 16

1 , dwg_view_index_no , integer , index 1 2 , dwg_view_no , character(6) , index 2 3 , dwg_view_name , character(40)

4 , dwg_view_scale , character(16) 5 , dwg_index_no , integer 6 , saved_view_name , character(6)

7 , viewing_direction , short , standard note 1620 8 , composition_status , short , standard note 1630 9 , dwg_view_x_low , double

10, dwg_view_y_low , double 11, dwg_view_z_low , double 12, dwg_view_x_high , double 13, dwg_view_y_high , double 14, dwg_view_z_high , double 15, vhl_category_index , short 16, drawing_view_type , short

# Drawing View Reference Model Data table number = 123, number of columns = 2 1 , dwg_view_index_no , integer

2 , model_index_no , integer

# Composite Drawing View Data

table number = 124, number of columns = 15

63

PDS 3D Theory — April 2002

________________

1 , comp_dwg_index_no , integer , index 1 2 , comp_dwg_view_no , character(6)

3 , comp_dwg_view_name , character(40) 4 , comp_dwg_v_scale , character(16) 5 , dwg_index_no , integer 6 , dwg_view_index_a , integer 7 , dwg_view_index_b , integer 8 , dwg_view_index_c , integer 9 , dwg_view_index_d , integer 10, dwg_view_index_e , integer 11, dwg_view_index_f , integer 12, dwg_view_index_g , integer 13, dwg_view_index_h , integer 14, dwg_view_index_i , integer 15, dwg_view_index_j , integer

# Drawing Revision Data

table number = 125, number of columns = 7 1 , dwg_index_no , integer

2 , revision_index_no , short

3 , revision_no , character(2) 4 , revision_date , integer 5 , revision_by , character(4) 6 , checked_by , character(4) 7 , rev_description , character(40)

# Drawing Setup Data

table number = 126, number of columns = 16

1 , drawing_type , short , standard note 2000 2 , drawing_size , short , standard note 1202 3 , drawing_scale , character(16)

4 , default_path_name , character(36) 5 , default_node , character(26) 6 , discipline_mask , short

7 , alternate_seed_opt , short

8 , cell_file_spec , character(14) 9 , cell_path_name , character(36) 10, cell_net_address , character(26) 11, plot_catgy_mask_a , integer 12, plot_catgy_mask_b , integer 13, label_mask_a , integer 14, label_mask_b , integer 15, label_mask_c , integer 16, label_mask_d , integer

# Reference Model Display Category Setup Data table number = 127, number of columns = 12

1 , drawing_type , short , standard note 2000 2 , discipline_indx_no , short

3 , category_mask_a , integer 4 , category_mask_b , integer 5 , category_mask_c , integer 6 , category_mask_d , integer 7 , vhl_category_msk_a , integer

2. Database Overview Database Definition Files

________________

8 , vhl_category_msk_b , integer 9 , vhl_category_msk_c , integer 10, vhl_category_msk_d , integer 11, vhl_ref_symbology , short 12, vhl_symbology , short

# Plotting Default Data

table number = 128, number of columns = 6 1 , iplot_index_no , integer

2 , iplot_number , character(24) 3 , iplot_description , character(40) 4 , iplot_file_spec , character(14) 5 , path_name , character(36) 6 , network_address , character(26)

###################################################

# Interference Management Data

# Clash Management Data

table number = 131, number of columns = 15

1 , system_unique_no , integer , index 1 2 , discipline_indx_no , short

3 , area_index_no , short 4 , unique_sequence_no , integer 5 , completion_date , integer 6 , control_user_no , short 7 , env_creation_date , integer

8 , clash_check_option , short , standard note 1208 9 , volume_filter_opt , short , standard note 1209 10, volume_low_x , integer

11, volume_low_y , integer 12, volume_low_z , integer 13, volume_high_x , integer 14, volume_high_y , integer 15, volume_high_z , integer

# Clash Data Per Project

table number = 132, number of columns = 16

1 , unique_clash_id , integer , index 1

2 , if_approval_status , short , standard note 1203 3 , comp_a_unique_id , integer

4 , comp_b_unique_id , integer 5 , model_index_no_a , integer 6 , model_index_no_b , integer 7 , discipline_index_a , short 8 , discipline_index_b , short

9 , recent_clash_type , short , standard note 1204 10, recent_plot_date , integer

11, recent_review_date , integer , index 2 12, recent_sequence_no , integer

65

PDS 3D Theory — April 2002

________________

13, area_index_no , short 14, action_discipline , short 15, recent_seq_no_b , integer 16, area_index_no_b , short

# Clash Data Per Job

table number = 133, number of columns = 16

1 , system_unique_no , integer , index 1 2 , unique_clash_id , integer , index 2 3 , unique_sequence_no , integer

4 , clash_type , short , standard note 1204 5 , comp_a_range_x_lo , integer

6 , comp_a_range_y_lo , integer 7 , comp_a_range_z_lo , integer 8 , comp_a_range_x_hi , integer 9 , comp_a_range_y_hi , integer 10, comp_a_range_z_hi , integer 11, comp_b_range_x_lo , integer 12, comp_b_range_y_lo , integer 13, comp_b_range_z_lo , integer 14, comp_b_range_x_hi , integer 15, comp_b_range_y_hi , integer 16, comp_b_range_z_hi , integer

# Component Clash Data Per Project

table number = 134, number of columns = 7

1 , unique_comp_id , integer , index 1 2 , comp_table_number , short

3 , comp_row_number , integer 4 , model_index_no , integer 5 , primary_descript , character(20) 6 , secondary_descript , character(40) 7 , comp_model_status , short

# Clash Review History Information

table number = 135, number of columns = 8

1 , system_unique_no , integer , index 1 2 , unique_clash_id , integer , index 2 3 , review_date , integer

4 , review_user_no , short 5 , responsib_user_no , short

6 , action , short , standard note 1205

7 , review_comment , character(100)

8 , approval_method , short , standard note 1207

# Clash Plot History Information

table number = 136, number of columns = 4

1 , system_unique_no , integer , index 1 2 , unique_clash_id , integer

3 , plot_date , integer

2. Database Overview Database Definition Files

________________

4 , plot_user_no , short

###################################################

# Report Management Data

# Report Data

table number = 141, number of columns = 20

1 , report_index_no , integer , index 1 2 , report_no , character(24) , index 2 3 , report_title , character(40)

4 , approval_initials , character(4) 5 , approval_date , integer

6 , approval_status , short , standard note 35 7 , last_revision_no , character(2)

8 , report_file_spec , character(14) 9 , path_name , character(36) 10, network_address , character(26) 11, lock_owner , character(10) 12, lock_status , short

13, lock_date , integer 14, revision_date , integer 15, format_index_no , integer 16, filter_index_no , integer 17, last_rev_index_no , short

18, report_source , short , standard note 1310 19, report_type , short , standard note 1312 20, search_index_no , integer

# Report Format Data

table number = 142, number of columns = 11

1 , format_index_no , integer , index 1 2 , format_number , character(24)

3 , format_description , character(40) 4 , format_file_spec , character(14) 5 , path_name , character(36) 6 , network_address , character(26) 7 , lock_owner , character(10) 8 , lock_status , short

9 , lock_date , integer 10, revision_date , integer

11, rpt_format_source , short , standard note 1310

# Report Descrimination Data

table number = 143, number of columns = 11

1 , filter_index_no , integer , index 1 2 , filter_number , character(24)

3 , filter_description , character(40) 4 , filter_file_spec , character(14) 5 , path_name , character(36) 6 , network_address , character(26) 7 , lock_owner , character(10)

67

PDS 3D Theory — April 2002

________________

8 , lock_status , short 9 , lock_date , integer 10, revision_date , integer

11, rpt_filter_source , short , standard note 1310

# Report Revision Data

table number = 144, number of columns = 7 1 , report_index_no , integer

2 , revision_index_no , short

3 , revision_no , character(2) 4 , revision_date , integer 5 , revision_by , character(4) 6 , checked_by , character(4) 7 , rev_description , character(40)

# Report Search Criteria Data

table number = 145, number of columns = 11

1 , search_index_no , integer , index 1 2 , search_number , character(24)

3 , search_description , character(40) 4 , search_file_spec , character(14) 5 , path_name , character(36) 6 , network_address , character(26) 7 , lock_owner , character(10) 8 , lock_status , short

9 , lock_date , integer 10, revision_date , integer

11, rpt_search_source , short , standard note 1310

###################################################

# DesignReview Management Data

table number = 151, number of columns = 25

1 , review_index_no , integer , index 1 2 , review_no , character(24)

3 , review_title , character(40)

4 , review_type , short , standard note 1410 5 , control_file_spec , character(14)

6 , control_path_name , character(36) 7 , control_node , character(26) 8 , control_lock_owner , character(10) 9 , control_lock_stat , short

10, control_lock_date , integer 11, tag_file_spec , character(14) 12, tag_path_name , character(36) 13, tag_node , character(26) 14, tag_lock_owner , character(10) 15, tag_lock_status , short

16, tag_lock_date , integer 17, session_rev_date , integer

2. Database Overview Database Definition Files

________________

18, label_rev_date , integer 19, label_file_spec , character(14) 20, label_path_name , character(36) 21, label_net_address , character(26) 22, month_map , integer 23, day_of_week_map , integer 24, day_map , integer 25, time_of_day , integer

###################################################

# Package/Release Management Data

# Package Data

table number = 161, number of columns = 5

1 , package_index_no , integer , index 1 2 , package_no , character(24)

3 , package_title , character(40) 4 , release_revision , character(2) 5 , release_date , integer

# Document Data

table number = 162, number of columns = 4 1 , document_index_no , integer

2 , package_index_no , integer

3 , document_source , short , standard note 1710 4 , document_type , short , standard note 1720

###################################################

# Isometric Drawing Management Data

# Isometric Files Data

table number = 180, number of columns = 11 1 , isofile_indx_no , integer

2 , isodflt_indx_no , integer 3 , isofile_type , short

4 , isofile_spec , character(14) 5 , path_name , character(36) 6 , network_address , character(26) 7 , iso_description , character(40) 8 , lock_owner , character(10) 9 , lock_status , short

10, lock_date , integer 11, revision_date , integer

# Project Options Data

table number = 181, number of columns = 12

69

PDS 3D Theory — April 2002

________________

1 , isoproj_indx_no , integer , index 1 2 , isoproj_task_opt , short

3 , isoproj_name_opt , short 4 , isoproj_dwg_opt , short 5 , isodflt_indx_no , integer 6 , reserved_1 , character(26) 7 , reserved_2 , character(36) 8 , reserved_3 , character(20) 9 , batch_options , character(20) 10, isoproj_name_label , short

11, isoproj_dwg_label , short 12, sub_directory_opt , short

# Defaults Set Data

table number = 182, number of columns = 4 1 , isodflt_indx_no , integer

2 , isodflt_tag , character(12) , index 1 3 , isodflt_descr , character(40)

4 , isodflt_rev_date , integer

# Isometric Design Area Definition Data table number = 183, number of columns = 22 1 , iso_area_indx_no , integer

2 , area_indx_no1 , short , index 1 3 , area_indx_no2 , short

4 , area_indx_no3 , short 5 , area_indx_no4 , short 6 , area_indx_no5 , short 7 , area_indx_no6 , short 8 , selection_mode , short

9 , iso_area_name , character(10) 10, iso_area_desc , character(40) 11, user_data_indx_no , integer 12, isodflt_indx_no , integer 13, cont_indx_no1 , short 14, cont_indx_no2 , short 15, cont_indx_no3 , short 16, cont_indx_no4 , short 17, cont_indx_no5 , short 18, cont_indx_no6 , short 19, cont_indx_no7 , short 20, cont_indx_no8 , short 21, cont_indx_no9 , short 22, cont_indx_no10 , short

# Isometric User Data

table number = 184, number of columns = 12 1 , user_data_indx_no , integer

2 , type_of_user_data , short

3 , user_data_1 , character(40) 4 , user_data_2 , character(40) 5 , user_data_3 , character(40)

2. Database Overview Database Definition Files

________________

6 , user_data_4 , character(40) 7 , user_data_5 , character(40) 8 , user_data_6 , character(40) 9 , user_data_7 , character(40) 10, user_data_8 , character(40) 11, user_data_9 , character(40) 12, user_data_10 , character(40)

# Isometric Drawing Extraction Data

table number = 185 , number of columns = 19 1 , drawing_indx_no , integer

2 , iso_area_indx_no , integer , index 1 3 , lineid_1 , character(16) , index 2 4 , lineid_2 , character(16)

5 , lineid_3 , character(16) 6 , number_of_sections , short

7 , drawing_number , character(20) 8 , batch_ref_no , character(12) 9 , iso_dgn_name , character(10) 10, model_status_code , character(2) 11, model_revised_date , integer 12, lst_extraction_date, integer 13, tot_no_extractions , short 14, no_sheets_extract , short 15, last_mto_date , integer 16, mto_to_mtl_control , integer 17, no_of_revisions , short 18, user_data_indx_no , integer

19, iso_type , short , index 3

# Isometric Drawing Revision Information table number = 186 , number of columns = 12 1 , draw_rev_indx_no , integer

2 , draw_sht_indx_no , integer , index 1 3 , type_of_revision , short , index 2 4 , revision_number , short , index 3 5 , generated_by , character(3)

6 , checked_by , character(3) 7 , approved_by , character(3) 8 , extraction_date , integer 9 , extraction_no , short 10, sheets_extracted , short

11, rev_description , character(40) 12, isodflt_indx_no , integer

# Isometric Last Used Occurrence Data table number = 187 , number of columns = 2 1 , table_no , integer

2 , last_used , integer

# Isometric Sheet Extraction Data

71

PDS 3D Theory — April 2002

________________

table number = 188 , number of columns = 7 1 , sheet_indx_no , integer

2 , drawing_indx_no , integer , index 1 3 , sheet_no , integer , index 2 4 , last_extract_date , integer

5 , tot_no_extractions , integer 6 , last_mto_date , integer 7 , no_of_revisions , integer

# Isometric Drawing Re-Extraction Data table number = 189 , number of columns = 8

1 , drawing_indx_no , integer , index 1

2 , section_no , short , index 2

3 , start_traversal_x , integer 4 , start_traversal_y , integer 5 , start_traversal_z , integer 6 , start_entity , short 7 , start_comp_occ , integer 8 , start_seg_occ , integer

2. Database Overview Design Database

________________

In document PDS 3DTHEORY.pdf (Page 59-73)