Data Dictionary -- Structural Damage Report

Srl. No.	Table Name	Comment
1	bassdr_state_metadata	Table for maintaining state ids in damage report
2	sdr_des_error	Table for maintaining error message and id
3	sdr_sdrassess_deferral_dtls	Table for storing deferral details
4	sdr_sdrassess_reference_dtls	Table for storing reference details.
5	sdr_sdrassess_res_dtls	Table for storing resolution details
6	sdr_sdrdmg_assess_dtls	Table for assessment details in damage report
7	sdr_sdrdmg_chart_dtls	Table for chart details in damage report
8	sdr_sdrdmg_damage_cause_dtls	Table for damage cause in damage report
9	sdr_sdrdmg_damage_dtls	Main table for maintaining damage details
10	sdr_sdrdmg_damage_loc_dtls	Table for location details in damage report
11	sdr_sdrdmg_damage_prt_dtls	Table for storing part details
12	sdr_sdrdmg_damage_typ_dtls	Table for storing type details
13	sdr_sdrdmg_file_att_dtls	Table for storing file attachments
14	sdr_sdrdmg_repair_dtls	Table for storing info under repair details tab.
15	sdr_sdrdp_chart_dent_dtl	Table for maintaining chart screen
16	sdr_sdrdp_damage_report	Main table for storing damage report details.
17	sdr_sdrmst_master_charts	Main table for maintaining master charts.
18	sdr_sdrprm_parameter_details	Table for maintaing desc and codes of metadata.
19	sdr_sdrqc_quick_code	Main table for maintaining quick codes.

Table Name :	bassdr_state_metadata
Comment :	Table for maintaining state ids in damage report

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
sdr_sdrstate_stateid	ctxt_state_name	Char(60)	No	State ID	No
sdr_sdrstate_applicability	udd_designparamcode	varchar(5)	Yes	Applicable	No
sdr_sdrstate_rep_flag	udd_designparamcode	varchar(5)	Yes	Repair Flag	No
sdr_sdrstate_chrt_flag	udd_designparamcode	varchar(5)	Yes	Chart Flag	No
sdr_sdrstate_drstatus	udd_designparamcode	varchar(5)	Yes	Damage Report Status	No
sdr_sdrstate_def_allwd	udd_designparamcode	varchar(5)	Yes	Deferral Flag	No
sdr_sdrstate_corr_flag	udd_designparamcode	varchar(5)	Yes	Corrosion Flag	No
sdr_sdrstate_CPCPTsk_flag	udd_designparamcode	varchar(5)	Yes	CPCPTask	No
sdr_sdrstate_rivet_flag	udd_designparamcode	varchar(5)	Yes	Rivet Flag	No
sdr_sdrstate_dmg_cause	udd_designparamcode	varchar(5)	Yes	Damage Cause	No
sdr_sdrstate_dmg_item	udd_designparamcode	varchar(5)	Yes	Damage Item	No
sdr_sdrstate_task_name	udd_txt150	varchar(150)	Yes	Task Name	No
sdr_sdrstate_service_name	udd_txt150	varchar(150)	Yes	Service Name	No
sdr_sdrstate_replication_key	bigint	Bigint(8)	No	Replication Key	Yes

Table Name :	sdr_des_error
Comment :	Table for maintaining error message and id

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
SDR_errorid	bigint	Bigint(8)	Yes	Error Id	No
SDR_errorsource	udd_flag	varchar(25)	Yes	Error Source	No
SDR_errormessage	udd_txt2000	varchar(2000)	Yes	Error Message	No
SDR_defaultseverity	udd_count	int(4)	Yes	Default Severity	No
SDR_language	udd_ctxt_language	int(4)	Yes	Language	No
SDR_SPname	udd_filename	varchar(50)	Yes	SP name	No
SDR_taskname	udd_filename	varchar(50)	Yes	Task Name	No
sdr_des_replication_key	uniqueidentifier	Varchar(160)	No	Replication Key	No

Table Name :	sdr_sdrassess_deferral_dtls
Comment :	Table for storing deferral details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
sdrassess_def_ouinstance	int	int(4)	No	Organisational Unit	Yes
sdrassess_def_defid	bigint	Bigint(8)	No	Unique ID	Yes
sdrassess_def_dmr_no	udd_documentno	varchar(40)	Yes	Damage Report Number	No
sdrassess_def_defparam	udd_flag	varchar(25)	Yes	Deferral Parameter	No
sdrassess_def_defperiod	udd_numericparamval	numeric(13)	Yes	Deferral Period	No
sdrassess_def_allwd	udd_chkflag	varchar(1)	Yes	Deferral Allowed	No
sdrassess_def_defremarks	udd_txt255	varchar(255)	Yes	Deferral Remarks	No
sdrassess_def_created_by	udd_ctxt_user	varchar(30)	Yes	Created By	No
sdrassess_def_created_date	udd_datetime1	datetime(8)	Yes	Created Date	No
sdrassess_def_modified_by	udd_ctxt_user	varchar(30)	Yes	Modified By	No
sdrassess_def_modified_date	udd_datetime1	datetime(8)	Yes	Modified Date	No

Table Name :	sdr_sdrassess_reference_dtls
Comment :	Table for storing reference details.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
sdrassess_ref_ouinstance	int	int(4)	No	Organisational Unit	Yes
sdrassess_ref_refid	bigint	Bigint(8)	No	Reference ID	Yes
sdrassess_ref_dmr_no	udd_documentno	varchar(40)	Yes	Damage Report Number	No
sdrassess_ref_refcode	udd_filename	varchar(50)	Yes	Referral Code	No
sdrassess_ref_doctype	udd_flag	varchar(25)	Yes	Document Type	No
sdrassess_ref_docno	udd_documentno	varchar(40)	Yes	Document Number	No
sdrassess_ref_docrev	udd_revisionno	varchar(40)	Yes	Document Rev	No
sdrassess_ref_remarks	udd_txt255	varchar(255)	Yes	Remarks	No
sdrassess_ref_created_by	udd_ctxt_user	varchar(30)	Yes	Created By	No
sdrassess_ref_created_date	udd_datetime1	datetime(8)	Yes	Created Date	No
sdrassess_ref_modified_by	udd_ctxt_user	varchar(30)	Yes	Modified By	No
sdrassess_ref_modified_date	udd_datetime1	datetime(8)	Yes	Modified Date	No

Table Name :	sdr_sdrassess_res_dtls
Comment :	Table for storing resolution details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
sdrassess_res_ouinstance	int	int(4)	No	Organisational Unit	Yes
sdrassess_res_resid	bigint	Bigint(8)	No	Resolution ID	Yes
sdrassess_res_dmr_no	udd_documentno	varchar(40)	Yes	Damage Report Number	No
sdrassess_res_resolution	udd_filename	varchar(50)	Yes	Resolution	No
sdrassess_res_details	udd_txt255	varchar(255)	Yes	Details	No
sdrassess_res_rmrks	udd_txt255	varchar(255)	Yes	Remarks	No
sdrassess_res_created_by	udd_ctxt_user	varchar(30)	Yes	Created By	No
sdrassess_res_created_date	udd_datetime1	datetime(8)	Yes	Created Date	No
sdrassess_res_modified_by	udd_ctxt_user	varchar(30)	Yes	Modified By	No
sdrassess_res_modified_date	udd_datetime1	datetime(8)	Yes	Modified Date	No

Table Name :	sdr_sdrdmg_assess_dtls
Comment :	Table for assessment details in damage report

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
sdr_assess_mn_ouinstance	udd_ctxt_ouinstance	int(4)	No	Organisational Unit	Yes
sdr_assess_mn_dmr_no	udd_documentno	varchar(40)	No	Damage Report	Yes
sdr_assess_rs_repair_chk_flag	udd_designparamcode	varchar(5)	Yes	Repair Check Flag	No
sdr_assess_rs_chart_chk_flag	udd_designparamcode	varchar(5)	Yes	Chart Check Flag	No
sdr_assess_rs_ins_chk_flag	udd_designparamcode	varchar(5)	Yes	Ins Check Flag	No
sdr_assess_rs_protect_area	udd_designparamcode	varchar(5)	Yes	Protect Area	No
sdr_assess_rs_rep_category	udd_designparamcode	varchar(5)	Yes	Rep Category	No
sdr_assess_rf_esr_no	udd_documentno	varchar(40)	Yes	ESR Number	No
sdr_assess_df_def_chk_flag	udd_designparamcode	varchar(5)	Yes	Def Check Flag	No
sdr_assess_df_auth_ref	udd_empcode	varchar(15)	Yes	Auth Ref	No
sdr_assess_rs_addl_dtls	udd_txt2000	varchar(2000)	Yes	Rs Additional Details	No
sdr_assess_rf_addl_dtls	udd_txt2000	varchar(2000)	Yes	Rf Additional Details	No
sdr_assess_df_addl_dtls	udd_txt2000	varchar(2000)	Yes	Df Additional Details	No
sdr_assess_rd_eo_no	udd_documentno	varchar(40)	Yes	EO No	No
sdr_assess_rd_eo_rev	udd_revisionno	varchar(40)	Yes	EO Rev No	No
sdr_assess_created_date	udd_datetime1	datetime(8)	Yes	Created Date	No
sdr_assess_created_by	udd_ctxt_user	varchar(30)	Yes	Created By	No
sdr_assess_modified_date	udd_datetime1	datetime(8)	Yes	Modified Date	No
sdr_assess_modified_by	udd_ctxt_user	varchar(30)	Yes	Modified By	No
sdr_assess_timestamp	udd_timestamp	int(4)	Yes	TimeStamp	No

Table Name :	sdr_sdrdmg_chart_dtls
Comment :	Table for chart details in damage report

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
sdr_sdrchart_ouinstance	int	int(4)	No	Organisational Unit	Yes
sdr_sdrchart_dmr_no	udd_documentno	varchar(40)	No	Damage Report Number	No
sdr_sdrchart_chartid	bigint	Bigint(8)	Yes	Chart ID	No
sdr_sdrchart_aff_flag	udd_chkflag	varchar(1)	Yes	Aff Flag	No
sdr_sdrchart_rmrks	udd_txt255	varchar(255)	Yes	Remarks	No
sdr_sdrchart_created_by	udd_ctxt_user	varchar(30)	Yes	Created By	No
sdr_sdrchart_created_date	udd_datetime1	datetime(8)	Yes	Created Date	No
sdr_sdrchart_modified_by	udd_ctxt_user	varchar(30)	Yes	Modified By	No
sdr_sdrchart_modified_date	udd_datetime1	datetime(8)	Yes	Modified Date	No

Table Name :	sdr_sdrdmg_damage_cause_dtls
Comment :	Table for damage cause in damage report

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
sdr_dmgcause_ouinstance	int	int(4)	No	Organisational Unit	Yes
sdr_dmgcause_dcid	bigint	Bigint(8)	No	DCID	Yes
sdr_dmgcause_dmr_no	udd_documentno	varchar(40)	Yes	Damage Report Number	No
sdr_dmgcause_dmg_cause	udd_filename	varchar(50)	Yes	Damage Cause	No
sdr_dmgcause_allwd	udd_chkflag	varchar(1)	Yes	Allowed	No
sdr_dmgcause_remarks	udd_txt255	varchar(255)	Yes	Remarks	No
sdr_dmgcause_created_by	udd_ctxt_user	varchar(30)	Yes	Created By	No
sdr_dmgcause_created_date	udd_datetime1	datetime(8)	Yes	Created Date	No
sdr_dmgcause_modified_by	udd_ctxt_user	varchar(30)	Yes	Modified By	No
sdr_dmgcause_modified_date	udd_datetime1	datetime(8)	Yes	Modified Date	No

Table Name :	sdr_sdrdmg_damage_dtls
Comment :	Main table for maintaining damage details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
sdrdmg_mn_ouinstance	udd_ctxt_ouinstance	int(4)	No	Organisational Unit	Yes
sdrdmg_mn_dmr_no	udd_documentno	varchar(40)	No	Dmage Report No	Yes
sdrdmg_dt_loc_wide	udd_chkflag	varchar(1)	Yes	Loc Wide	No
sdrdmg_di_damaged_item	udd_designparamcode	varchar(5)	Yes	Damaged Item	No
sdrdmg_di_component	udd_componentid	varchar(90)	Yes	Component	No
sdrdmg_di_partno	udd_partno	varchar(40)	Yes	Part No	No
sdrdmg_di_serialno	udd_partserialnumber	varchar(40)	Yes	Serial No	No
sdrdmg_dt_corrosion	udd_designparamcode	varchar(5)	Yes	Corrosion	No
sdrdmg_dt_corr_lvl	udd_designparamcode	varchar(5)	Yes	Corrosion Ivl	No
sdrdmg_dt_corr_flag	udd_designparamcode	varchar(5)	Yes	Corrosion Flag	No
sdrdmg_dt_cpcp_chk_flag	udd_designparamcode	varchar(5)	Yes	Chk Flag	No
sdrdmg_dt_cpcp_taskref	udd_workunitcode	varchar(30)	Yes	CPCP TaskRef	No
sdrdmg_dt_ata	udd_atanumber	varchar(16)	Yes	ATA	No
sdrdmg_dl_workarea	udd_workarea	varchar(15)	Yes	WorkArea	No
sdrdmg_dl_zone	udd_zone	varchar(10)	Yes	Zone	No
sdrdmg_dt_length	udd_hrshours	numeric(5)	Yes	Length	No
sdrdmg_dt_width	udd_hrshours	numeric(5)	Yes	Width	No
sdrdmg_dt_depth	udd_hrshours	numeric(5)	Yes	Depth	No
sdrdmg_dl_prv_rep_area	udd_designparamcode	varchar(5)	Yes	Prv Rep Area	No
sdrdmg_dl_rivetted_area	udd_designparamcode	varchar(5)	Yes	Rivetted Area	No
sdrdmg_dl_rivetted_flag	udd_designparamcode	varchar(5)	Yes	Rivetted Flag	No
sdrdmg_dl_min_dist	udd_hrshours	numeric(5)	Yes	Min Dist	No
sdrdmg_dc_dmg_cause	udd_designparamcode	varchar(5)	Yes	Dmage Cause	No
sdrdmg_di_addl_dtls	udd_txt2000	varchar(2000)	Yes	Di Addl Dtls	No
sdrdmg_dt_addl_dtls	udd_txt2000	varchar(2000)	Yes	Dt Addl Dtls	No
sdrdmg_dl_addl_dtls	udd_txt2000	varchar(2000)	Yes	Dl Addl Dtls	No
sdrdmg_dc_addl_dtls	udd_txt2000	varchar(2000)	Yes	Dc Add Dtls	No
sdrdmg_created_by	udd_ctxt_user	varchar(30)	Yes	Created By	No
sdrdmg_created_date	udd_datetime1	datetime(8)	Yes	Created Date	No
sdrdmg_modified_by	udd_ctxt_user	varchar(30)	Yes	Modified By	No
sdrdmg_modified_date	udd_datetime1	datetime(8)	Yes	Modified Date	No
sdrdmg_timestamp	udd_timestamp	int(4)	Yes	TimeStamp	No

Table Name :	sdr_sdrdmg_damage_loc_dtls
Comment :	Table for location details in damage report

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
sdr_dmgloc_ouinstance	udd_ctxt_ouinstance	int(4)	No	Organisational Unit	Yes
sdr_dmgloc_dcid	bigint	Bigint(8)	No	key column	Yes
sdr_dmgloc_dmr_no	udd_documentno	varchar(40)	No	damage report no.	Yes
sdr_dmgloc_damage_loc	udd_filename	varchar(50)	No	damage location	No
sdr_dmgloc_from	udd_desc20	varchar(20)	No	damage location from	No
sdr_dmgloc_to	udd_desc20	varchar(20)	No	damage location to	No
sdr_dmgloc_allwd	udd_chkflag	varchar(1)	No	allowed(y/n)	No
sdr_dmgloc_remarks	udd_txt255	varchar(255)	No	remarks	No
sdr_dmgloc_created_by	udd_ctxt_user	varchar(30)	No	created by	No
sdr_dmgloc_created_date	udd_datetime1	datetime(8)	No	created date	No
sdr_dmgloc_modified_by	udd_ctxt_user	varchar(30)	No	modified by	No
sdr_dmgloc_modified_date	udd_datetime1	datetime(8)	No	modified date	No

Table Name :	sdr_sdrdmg_damage_prt_dtls
Comment :	Table for storing part details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
sdr_dmgprt_ouinstance	udd_ctxt_ouinstance	int(4)	No	Organisational Unit	Yes
sdr_dmgprt_dpid	bigint	Bigint(8)	No	key column	Yes
sdr_dmgprt_dmr_no	udd_documentno	varchar(40)	No	damage report no.	Yes
sdr_dmgprt_damage_part	udd_filename	varchar(50)	No	damage part	No
sdr_dmgprt_allwd	udd_chkflag	varchar(1)	No	allowed(y/n)	No
sdr_dmgprt_remarks	udd_txt255	varchar(255)	No	remarks	No
sdr_dmgprt_created_by	udd_ctxt_user	varchar(30)	No	created by	No
sdr_dmgprt_created_date	udd_datetime1	datetime(8)	No	created date	No
sdr_dmgprt_modified_by	udd_ctxt_user	varchar(30)	No	modified by	No
sdr_dmgprt_modified_date	udd_datetime1	datetime(8)	No	modified date	No

Table Name :	sdr_sdrdmg_damage_typ_dtls
Comment :	Table for storing type details

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
sdr_dmgtyp_ouinstance	udd_ctxt_ouinstance	int(4)	No	organizational unit	Yes
sdr_dmgtyp_dtid	bigint	Bigint(8)	No	key column	Yes
sdr_dmgtyp_dmr_no	udd_documentno	varchar(40)	No	damage report no.	Yes
sdr_dmgtyp_damage_type	udd_filename	varchar(50)	No	damage type	No
sdr_dmgtyp_allwd	udd_chkflag	varchar(1)	No	allowed(y/n)	No
sdr_dmgtyp_remarks	udd_txt255	varchar(255)	No	remarks	No
sdr_dmgtyp_created_by	udd_ctxt_user	varchar(30)	No	created by	No
sdr_dmgtyp_created_date	udd_datetime1	datetime(8)	No	created date	No
sdr_dmgtyp_modified_by	udd_ctxt_user	varchar(30)	No	modified by	No
sdr_dmgtyp_modified_date	udd_datetime1	datetime(8)	No	modified date	No

Table Name :	sdr_sdrdmg_file_att_dtls
Comment :	Table for storing file attachments

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
sdr_sdrfile_ouinstance	udd_ctxt_ouinstance	int(4)	No	organizational unit	Yes
sdr_sdrfile_fileid	bigint	Bigint(8)	No	file id	Yes
sdr_sdrfile_dmr_no	udd_documentno	varchar(40)	No	damage report no.	Yes
sdr_sdrfile_refdocno	udd_documentno	varchar(40)	No	reference doc. no.	No
sdr_sdrfile_refdoctype	udd_designparamcode	varchar(5)	No	reference doc. Type	No
sdr_sdrfile_folderpath	udd_txt150	varchar(150)	No	folder path	No
sdr_sdrfile_filename	udd_filename	varchar(50)	No	file name	No
sdr_sdrfile_rmrks	udd_txt255	varchar(255)	No	remarks	No
sdr_sdrfile_created_by	udd_ctxt_user	varchar(30)	No	created by	No
sdr_sdrfile_created_date	udd_datetime1	datetime(8)	No	created date	No
sdr_sdrfile_modified_by	udd_ctxt_user	varchar(30)	No	modified by	No
sdr_sdrfile_modified_date	udd_datetime1	datetime(8)	No	modified date	No

Table Name :	sdr_sdrdmg_repair_dtls
Comment :	Table for storing info under repair details tab.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
sdr_sdrrep_ouinstance	int	int(4)	No	organizational unit	Yes
sdr_sdrrep_repid	bigint	Bigint(8)	No	key column	Yes
sdr_sdrrep_dmr_no	udd_desc40	varchar(40)	Yes	damage report no.	No
sdr_sdrrep_rep_type	udd_designparamcode	varchar(5)	Yes	repair type	No
sdr_sdrrep_taskno	udd_workunitcode	varchar(30)	Yes	task no.	No
sdr_sdrrep_tasktype	udd_quickcodes	varchar(25)	Yes	task type	No
sdr_sdrrep_taskdesc	udd_txt150	varchar(150)	Yes	task desc.	No
sdr_sdrrep_repclass	udd_quickcodes	varchar(25)	Yes	Repair Classification	No
sdr_sdrrep_est_manhrs	udd_numericparamval	numeric(13)	Yes	estimated man hours	No
sdr_sdrrep_rmrks	udd_txt255	varchar(255)	Yes	remarks	No
sdr_sdrrep_created_by	udd_ctxt_user	varchar(30)	Yes	created by	No
sdr_sdrrep_created_date	udd_datetime1	datetime(8)	Yes	created date	No
sdr_sdrrep_modified_by	udd_ctxt_user	varchar(30)	Yes	modified by	No
sdr_sdrrep_modified_date	udd_datetime1	datetime(8)	Yes	modified date	No
sdr_sdrrep_taskstatus	udd_status	varchar(25)	Yes	task status	No
Sdr_sdrrep_taskrev	udd_revisionno	varchar(40)	Yes	task revision no.	No
Sdr_sdrrep_seqno	udd_seqno	int(4)	Yes	seq no.	No
sdr_sdrrep_add_exeflag	udd_designparamcode	varchar(5)	Yes	Execution Flag	No
Sdr_sdrrep_exeref	udd_documentno	varchar(40)	Yes	Execution Reference #	No
Sdr_sdrrep_org_trackid	bigint	Bigint(8)	Yes	Original Track ID	No
Sdr_sdrrep_crnt_trackid	bigint	Bigint(8)	Yes	Current Track ID	No
sdr_sdrrep_revno	udd_revisionno	varchar(40)	Yes	revision no.	No

Table Name :	sdr_sdrdp_chart_dent_dtl
Comment :	Table for maintaining chart screen

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
sdr_sdrdent_ouinstance	udd_ctxt_ouinstance	int(4)	No	organizational unit	No
sdr_sdrdent_dmgrpt_no	udd_documentno	varchar(40)	No	damage report no.	No
sdr_sdrdent_chartid	bigint	Bigint(8)	No	chart id	No
sdr_sdrdent_annotate_id	udd_guid	varchar(40)	No	Annotation ID	Yes
sdr_sdrdent_annotate_txt	udd_txt2000	varchar(2000)	No	text	No
sdr_sdrdent_annotate_shape	udd_flag	varchar(25)	No	shape	No
sdr_sdrdent_annotate_xcord	udd_filename	varchar(50)	No	x coordinate	No
sdr_sdrdent_annotate_ycord	udd_filename	varchar(50)	No	y coordinate	No
sdr_sdrdent_annotate_height	udd_filename	varchar(50)	No	height	No
sdr_sdrdent_annotate_width	udd_filename	varchar(50)	No	width	No
sdr_sdrdent_created_date	udd_datetime1	datetime(8)	No	created date	No
sdr_sdrdent_created_by	udd_ctxt_user	varchar(30)	No	created by	No
sdr_sdrdent_modified_date	udd_datetime1	datetime(8)	No	modified date	No
sdr_sdrdent_modifed_by	udd_ctxt_user	varchar(30)	No	modified by	No

Table Name :	sdr_sdrdp_damage_report
Comment :	Main table for storing damage report details.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
sdrdp_dmr_ouinstance	udd_ctxt_ouinstance	int(4)	No	organizational unit	Yes
sdrdp_dmr_no	udd_documentno	varchar(40)	No	damage report no.	Yes
sdrdp_dmr_category	udd_filename	varchar(50)	Yes	category	No
sdrdp_dmr_rec_date	udd_datetime1	datetime(8)	Yes	recorded date	No
sdrdp_dmr_status	udd_designparamcode	varchar(5)	Yes	status	No
sdrdp_dmr_discrepancy	udd_documentno	varchar(40)	Yes	discrepancy no.	No
sdrdp_dmr_report_dtls	udd_txt2000	varchar(2000)	Yes	report details	No
sdrdp_dmr_reported_by	udd_ctxt_user	varchar(30)	Yes	reported by	No
sdrdp_dmr_signoff_by	udd_ctxt_user	varchar(30)	Yes	signoff by	No
sdrdp_dmr_signoff_date	udd_datetime1	datetime(8)	Yes	signoff date	No
sdrdp_dmr_signoff_ref	udd_empcode	varchar(15)	Yes	Sign Off Reference	No
sdrdp_dmr_remarks	udd_txt2000	varchar(2000)	Yes	remarks	No
sdrdp_dmr_created_date	udd_datetime1	datetime(8)	Yes	created date	No
sdrdp_dmr_created_by	udd_ctxt_user	varchar(30)	Yes	created by	No
sdrdp_dmr_modified_date	udd_datetime1	datetime(8)	Yes	modified date	No
sdrdp_dmr_modified_by	udd_ctxt_user	varchar(30)	Yes	modified by	No
sdrdp_dmr_assessed_by	udd_ctxt_user	varchar(30)	Yes	assessed by	No
sdrdp_dmr_assessed_date	udd_datetime1	datetime(8)	Yes	assessed date	No
sdrdp_dmr_confirmed_by	udd_ctxt_user	varchar(30)	Yes	confirmed by	No
sdrdp_dmr_confirmed_date	udd_datetime1	datetime(8)	Yes	confirmed date	No
sdrdp_dmr_closed_date	udd_datetime1	datetime(8)	Yes	closed date	No
sdrdp_dmr_closed_by	udd_ctxt_user	varchar(30)	Yes	closed by	No
sdrdp_dmr_cancelled_date	udd_datetime1	datetime(8)	Yes	cancelled date	No
sdrdp_dmr_cancelled_by	udd_ctxt_user	varchar(30)	Yes	cancelled by	No
sdrdp_dmr_shrtclosed_date	udd_datetime1	datetime(8)	Yes	Short Closed Date	No
sdrdp_dmr_shrtclosed_by	udd_ctxt_user	varchar(30)	Yes	Short Closed By	No
sdrdp_dmr_timestamp	udd_timestamp	int(4)	Yes	time stamp	No

Table Name :	sdr_sdrmst_master_charts
Comment :	Main table for maintaining master charts.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
sdr_sdrmst_ouinstance	udd_ctxt_ouinstance	int(4)	Yes	organizational unit	No
sdr_sdrmst_chart_seqno	bigint	Bigint(8)	No	seq no.	Yes
sdr_sdrmst_objtype	udd_designparamcode	varchar(5)	Yes	object type	No
sdr_sdrmst_aircraftreg	udd_aircraftnumber	varchar(30)	Yes	aircraft reg. no.	No
sdr_sdrmst_model	udd_model	varchar(20)	Yes	aircraft model	No
sdr_sdrmst_component	udd_componentid	varchar(90)	Yes	component no.	No
sdr_sdrmst_partno	udd_partno	varchar(40)	Yes	part no.	No
sdr_sdrmst_serialno	udd_partserialnumber	varchar(40)	Yes	serial no.	No
sdr_sdrmst_config_class	udd_configid	varchar(30)	Yes	configuration class	No
sdr_sdrmst_chart_title	udd_txt255	varchar(255)	Yes	chart title	No
sdr_sdrmst_chart_id	udd_txt20	varchar(20)	Yes	chart id	No
sdr_sdrmst_revision	udd_revisionno	varchar(40)	Yes	revision no.	No
sdr_sdrmst_auto_rev	udd_seqno	int(4)	Yes	auto revision no.	No
sdr_sdrmst_filename	udd_filename	varchar(50)	Yes	file name	No
sdr_sdrmst_folderpath	udd_txt150	varchar(150)	Yes	folder path	No
sdr_sdrmst_chartgrp	udd_filename	varchar(50)	Yes	chart group	No
sdr_sdrmst_status	udd_designparamcode	varchar(5)	Yes	status	No
sdr_sdrmst_remarks	udd_txt255	varchar(255)	Yes	remarks	No
sdr_sdrmst_createdby	udd_ctxt_user	varchar(30)	Yes	created by	No
sdr_sdrmst_createddate	udd_datetime1	datetime(8)	Yes	created date	No
sdr_sdrmst_modifiedby	udd_ctxt_user	varchar(30)	Yes	modified by	No
sdr_sdrmst_modifieddate	udd_datetime1	datetime(8)	Yes	modified date	No
sdr_sdrmst_timestamp	udd_timestamp	int(4)	Yes	time stamp	No
sdr_sdrmst_refchartno	udd_count	int(4)	Yes	reference chart no.	No
sdr_sdrmst_chartclass	udd_model	varchar(20)	Yes	chart class	No

Table Name :	sdr_sdrprm_parameter_details
Comment :	Table for maintaing desc and codes of metadata.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
sdrprm_componentname	udd_txt80	varchar(80)	Yes	component name	No
sdrprm_paramcategory	udd_flag	varchar(25)	Yes	category	No
sdrprm_paramtype	udd_flag	varchar(25)	Yes	type	No
sdrprm_paramcode	udd_designparamcode	varchar(5)	Yes	paramcode	No
sdrprm_langid	udd_ctxt_language	int(4)	Yes	lang id	No
sdrprm_paramdesc	udd_txt80	varchar(80)	Yes	paramdesc	No
sdrprm_sort_by	udd_count	int(4)	Yes	sort by	No
sdrprm_creationdate	udd_datetime1	datetime(8)	Yes	creation date	No
sdr_sdrprm_replication_key	uniqueidentifier	Varchar(160)	No	key column	No

Table Name :	sdr_sdrqc_quick_code
Comment :	Main table for maintaining quick codes.

Column Name	UDD	Data Type	Is NULL?	Comment	Is PK?
sdrqc_ouinstance	udd_ctxt_ouinstance	int(4)	No	organizational unit	Yes
sdrqc_type	udd_designparamcode	varchar(5)	No	quick code type	Yes
sdrqc_quick_code	udd_filename	varchar(50)	No	quick code	Yes
sdrqc_desc	udd_txt255	varchar(255)	Yes	quick code description	No
sdrqc_status	udd_designparamcode	varchar(5)	Yes	status	No
sdrqc_created_by	udd_ctxt_user	varchar(30)	Yes	created by	No
sdrqc_createddate	udd_datetime1	datetime(8)	Yes	created date	No
sdrqc_modified_by	udd_ctxt_user	varchar(30)	Yes	modified by	No
sdrqc_modifieddate	udd_datetime1	datetime(8)	Yes	modified date	No
sdrqc_timestamp	udd_timestamp	int(4)	Yes	time stamp	No
sdrqc_sequenceno	udd_count	int(4)	Yes	seq no.	No