21 lines
660 B
SQL
21 lines
660 B
SQL
create table ct_et_templates.w_ODS_TMS_EFFECTIVEROLEPROFILE (
|
|
a_key number(38, 0),
|
|
a_workflow_history_key number(38, 0),
|
|
id varchar2(255 char),
|
|
name varchar2(255 char),
|
|
admin_center_id varchar2(255 char),
|
|
time_zone_id varchar2(255 char),
|
|
menu_name varchar2(255 char),
|
|
web_home_group_id varchar2(255 char),
|
|
flags number(12, 0),
|
|
access_role_id varchar2(255 char),
|
|
access_role_name varchar2(255 char),
|
|
direct_p number(12, 0),
|
|
active_from date,
|
|
active_to date,
|
|
access_profile_id varchar2(255 char),
|
|
access_profile_name varchar2(255 char),
|
|
access_profile_type_id varchar2(255 char),
|
|
access_profile_type_name varchar2(255 char)
|
|
)
|