md object data

Database Table

Name md_object_data
Prefix obd
Group Item Data Object
Initial Build 2006.02

Overview

Columns

Name Description Datatype Notes
obd_key Unique Key av_key  
obd_obj_key Object av_key  
obd_description Description nvarchar(50)  
obd_data_object_prefix Data Object Prefix/Qualifier nvarchar(3)  
obd_table_name Table Name nvarchar(128)  
obd_table_name_ext Extender Table Name nvarchar(128)  
obd_table_prefix Table Prefix nvarchar(3)  
obd_table_prefix_ext Extender Table Prefix nvarchar(3)  
obd_key_field Key Field nvarchar(128)  
obd_key_field_ext   nvarchar(128)  
obd_parent_key Parent/Foreign Key nvarchar(128)  
obd_order Load Order av_integer  
obd_save_order Save Order av_integer  
obd_do_not_save Do Not Save Data? av_flag  
obd_one_to_many One-to-Many? av_flag  
obd_do_not_select Do Not Select av_flag  
obd_late_binding Allow Late Binding av_flag  
obd_delete_flag_field Delete Flag Field nvarchar(128)  
obd_add_user Add User av_user  
obd_add_date Add Date av_date  
obd_change_user Change User av_user  
obd_change_date Change Date av_date  
obd_delete_flag Delete Flag av_delete_flag  
obd_entity_key Entity Key av_key  

Parent Tables

Parent Table Parent Key Child Key Join
md_object obj_key obd_obj_key obd_obj_key = obj_key