-- ------------------------------------------------------------------------------------------------
-- [ 시스템관리 ] 오브젝트 테이블 생성
conn system/built123$@ndb;
-- ------------------------------------------------------------------------------------------------
-- 테이블 생성
drop table bsys.sys_object cascade constraints;
create table bsys.sys_object
(
corp_id number not null
,owner varchar2(30) not null
,table_name varchar2(50) not null
,column_name varchar2(200) not null
,column_name_kr varchar2(200)
,key_type varchar2(1)
,rec_name varchar2(20)
,data_type varchar2(50)
,data_type_org varchar2(50)
,default_value varchar2(200)
,param_default_value varchar2(200)
,who_column_yn varchar2(1)
,ml_type varchar2(1)
,lang_column_yn varchar2(1)
,null_yn varchar2(1)
,user_sort number
,all_sort number
,all_sort_min number
,all_sort_max number
,table_sort number
,column_sort number
,column_size number
,column_size_max number
,key_sort number
,create_date timestamp default systimestamp
,create_by varchar2(50) default '-1'
,update_date timestamp default systimestamp
,update_by varchar2(50) default '-1'
);
-- 테이블 설명
comment on table bsys.sys_object is '[시스템관리] 오브젝트';
comment on column bsys.sys_object.corp_id is '법인ID';
comment on column bsys.sys_object.owner is '소유자';
comment on column bsys.sys_object.table_name is '테이블명';
comment on column bsys.sys_object.column_name is '컬럼명';
comment on column bsys.sys_object.column_name_kr is '컬럼영(한글)';
comment on column bsys.sys_object.key_type is '키유형';
comment on column bsys.sys_object.rec_name is '레코드명';
comment on column bsys.sys_object.data_type is '데이터유형';
comment on column bsys.sys_object.data_type_org is '데이터유형(원천)';
comment on column bsys.sys_object.default_value is '기본값';
comment on column bsys.sys_object.param_default_value is '기본값(매개변수)';
comment on column bsys.sys_object.who_column_yn is '후컬럼여부';
comment on column bsys.sys_object.ml_type is '다국테이블구분';
comment on column bsys.sys_object.lang_column_yn is '다국어컬럼여부';
comment on column bsys.sys_object.null_yn is '널여부';
comment on column bsys.sys_object.user_sort is '사용자정렬';
comment on column bsys.sys_object.all_sort is '전체정렬';
comment on column bsys.sys_object.all_sort_min is '전체정렬(최소)';
comment on column bsys.sys_object.all_sort_max is '전체정렬(최대)';
comment on column bsys.sys_object.table_sort is '테이블정렬';
comment on column bsys.sys_object.column_sort is '컬럼정렬';
comment on column bsys.sys_object.column_size is '컬럼자릿수';
comment on column bsys.sys_object.column_size_max is '컬럼자릿수(최대)';
comment on column bsys.sys_object.key_sort is '키정렬';
comment on column bsys.sys_object.create_date is '생성일시';
comment on column bsys.sys_object.create_by is '생성자';
comment on column bsys.sys_object.update_date is '수정일시';
comment on column bsys.sys_object.update_by is '수정자';
-- primary 인덱스
alter table bsys.sys_object add constraint sys_object_pk primary key (corp_id, owner, table_name, column_name) using index tablespace bdb_idx;
-- normal 인덱스
create index bsys.sys_object_ix01 on bsys.sys_object (corp_id, column_name_kr) tablespace bdb_idx;
-- 권한부여
grant select, insert, update, delete on bsys.sys_object to bcom with grant option;
grant select, insert, update, delete on bsys.sys_object to bhrm with grant option;
-- 시노님 생성
conn bcom/1234@ndb;
create or replace synonym sys_object for bsys.sys_object;
conn bhrm/1234@ndb;
create or replace synonym sys_object for bsys.sys_object;
'오라클 > 테이블(시스템관리)' 카테고리의 다른 글
[ 프로파일 ] 테이블 생성을 아래와 같이 진행합니다. (1) | 2024.04.12 |
---|---|
[ 국가 ] 테이블 생성을 아래와 같이 진행합니다. (0) | 2024.04.12 |
[ 데이터이관 ] 테이블 생성을 아래와 같이 진행합니다. (0) | 2024.04.12 |
[ 로그 ] 테이블 생성을 아래와 같이 진행합니다. (0) | 2024.04.12 |
[ 환경정보 ] 테이블 생성을 아래와 같이 진행합니다. (0) | 2024.04.12 |