oracle hr 表名称,Oracle ERP INV 模块8个重要表结构_HR_ALL_ORGANIZATION_UNITS

-- Create table

create table HR.HR_ALL_ORGANIZATION_UNITS

(

ORGANIZATION_ID NUMBER(15) not null,

BUSINESS_GROUP_ID NUMBER(15) not null,

COST_ALLOCATION_KEYFLEX_ID NUMBER(9),

LOCATION_ID NUMBER(15),

SOFT_CODING_KEYFLEX_ID NUMBER(15),

DATE_FROM DATE not null,

NAME VARCHAR2(240) not null,

DATE_TO DATE,

INTERNAL_EXTERNAL_FLAG VARCHAR2(30),

INTERNAL_ADDRESS_LINE VARCHAR2(80),

TYPE VARCHAR2(30),

REQUEST_ID NUMBER(15),

PROGRAM_APPLICATION_ID NUMBER(15),

PROGRAM_ID NUMBER(15),

PROGRAM_UPDATE_DATE DATE,

ATTRIBUTE_CATEGORY VARCHAR2(30),

ATTRIBUTE1 VARCHAR2(150),

ATTRIBUTE2 VARCHAR2(150),

ATTRIBUTE3 VARCHAR2(150),

ATTRIBUTE4 VARCHAR2(150),

ATTRIBUTE5 VARCHAR2(150),

ATTRIBUTE6 VARCHAR2(150),

ATTRIBUTE7 VARCHAR2(150),

ATTRIBUTE8 VARCHAR2(150),

ATTRIBUTE9 VARCHAR2(150),

ATTRIBUTE10 VARCHAR2(150),

ATTRIBUTE11 VARCHAR2(150),

ATTRIBUTE12 VARCHAR2(150),

ATTRIBUTE13 VARCHAR2(150),

ATTRIBUTE14 VARCHAR2(150),

ATTRIBUTE15 VARCHAR2(150),

ATTRIBUTE16 VARCHAR2(150),

ATTRIBUTE17 VARCHAR2(150),

ATTRIBUTE18 VARCHAR2(150),

ATTRIBUTE19 VARCHAR2(150),

ATTRIBUTE20 VARCHAR2(150),

LAST_UPDATE_DATE DATE,

LAST_UPDATED_BY NUMBER(15),

LAST_UPDATE_LOGIN NUMBER(15),

CREATED_BY NUMBER(15),

CREATION_DATE DATE,

OBJECT_VERSION_NUMBER NUMBER(9),

PARTY_ID NUMBER(15),

COMMENTS LONG

)

tablespace APPS_TS_TX_DATA

pctfree 10

initrans 10

maxtrans 255

storage

(

initial 128

next 128

minextents 1

maxextents unlimited

pctincrease 0

);

-- Create/Recreate primary, unique and foreign key constraints

alter table HR.HR_ALL_ORGANIZATION_UNITS

add constraint HR_ORGANIZATION_UNITS_PK primary key (ORGANIZATION_ID)

using index

tablespace APPS_TS_TX_IDX

pctfree 0

initrans 11

maxtrans 255

storage

(

initial 128K

next 128K

minextents 1

maxextents unlimited

pctincrease 0

);

alter table HR.HR_ALL_ORGANIZATION_UNITS

add constraint HR_ORGANIZATION_UNITS_UK2 unique (NAME, BUSINESS_GROUP_ID)

using index

tablespace APPS_TS_TX_IDX

pctfree 0

initrans 11

maxtrans 255

storage

(

initial 128K

next 128K

minextents 1

maxextents unlimited

pctincrease 0

);

alter table HR.HR_ALL_ORGANIZATION_UNITS

add constraint HR_ORGANIZATION_UNITS_FK1 foreign key (BUSINESS_GROUP_ID)