STADW.ST_ITEMCATEGORY_HIST

Base de datos origen: ADW COEXITO

Columnas

#	Columna	Tipo	Nulo
1	IDMAESTROCARGUE	NUMBER(18,0)	NO
2	CATALOGBASEPEOCATALOGCODE	VARCHAR2(30)	NO
3	CATALOGBASEPEOCATALOGCONTENTCODE	VARCHAR2(30)	SI
4	CATALOGBASEPEOCATEGORYSETID	NUMBER(18,0)	NO
5	CATALOGBASEPEOCONTROLLEVEL	NUMBER(1,0)	NO
6	CATALOGBASEPEODEFAULTCATEGORYID	NUMBER(18,0)	SI
7	CATALOGBASEPEOHIERARCHYENABLED	CHAR(1)	SI
8	CATALOGBASEPEOLASTUPDATEDATE	TIMESTAMP(6)	NO
9	CATALOGBASEPEOMULTITEMCATASSIGNFLAG	CHAR(1)	NO
10	CATALOGBASEPEOSTARTDATE	DATE	SI
11	CATALOGBASEPEOSTRUCTUREID	NUMBER(18,0)	SI
12	CATALOGBASEPEOVALIDATEFLAG	CHAR(1)	NO
13	CATALOGTRANSLATIONPEOCATEGORYSETNAME	VARCHAR2(30)	NO
14	CATALOGTRANSLATIONPEODESCRIPTION	VARCHAR2(240)	SI
15	CATALOGTRANSLATIONPEOLANGUAGE	VARCHAR2(4)	NO
16	CATALOGTRANSLATIONPEOLASTUPDATEDATE	DATE	NO
17	CATEGORYBASEPEOCATEGORYCODE	VARCHAR2(820)	SI
18	CATEGORYBASEPEOCATEGORYCONTENTCODE	VARCHAR2(30)	SI
19	CATEGORYBASEPEOLASTUPDATEDATE	DATE	NO
20	CATEGORYBASEPEOSTARTDATEACTIVE	DATE	SI
21	CATEGORYID	NUMBER(18,0)	NO
22	CATEGORYSETID	NUMBER(18,0)	NO
23	CATEGORYTRANSLATIONPEOCATEGORYNAME	VARCHAR2(250)	NO
24	CATEGORYTRANSLATIONPEODESCRIPTION	VARCHAR2(240)	SI
25	CATEGORYTRANSLATIONPEOLANGUAGE	VARCHAR2(4)	NO
26	CATEGORYTRANSLATIONPEOLASTUPDATEDATE	DATE	NO
27	INVENTORYITEMID	NUMBER(18,0)	NO
28	ITEMCATEGORYPEOCREATEDBY	VARCHAR2(64)	NO
29	ITEMCATEGORYPEOCREATIONDATE	DATE	NO
30	ITEMCATEGORYPEOLASTUPDATEDATE	DATE	NO
31	ITEMCATEGORYPEOLASTUPDATEDBY	VARCHAR2(64)	NO
32	ORGANIZATIONID	NUMBER(18,0)	NO
33	VALIDCATEGORYPEOLASTUPDATEDATE	DATE	NO

Restricciones

CHECK: SYS_C0035966

Estado: ENABLED
Columnas: IDMAESTROCARGUE
Condición: "IDMAESTROCARGUE" IS NOT NULL

CHECK: SYS_C0035967

Estado: ENABLED
Columnas: CATALOGBASEPEOCATALOGCODE
Condición: "CATALOGBASEPEOCATALOGCODE" IS NOT NULL

CHECK: SYS_C0035968

Estado: ENABLED
Columnas: CATALOGBASEPEOCATEGORYSETID
Condición: "CATALOGBASEPEOCATEGORYSETID" IS NOT NULL

CHECK: SYS_C0035969

Estado: ENABLED
Columnas: CATALOGBASEPEOCONTROLLEVEL
Condición: "CATALOGBASEPEOCONTROLLEVEL" IS NOT NULL

CHECK: SYS_C0035970

Estado: ENABLED
Columnas: CATALOGBASEPEOLASTUPDATEDATE
Condición: "CATALOGBASEPEOLASTUPDATEDATE" IS NOT NULL

CHECK: SYS_C0035971

Estado: ENABLED
Columnas: CATALOGBASEPEOMULTITEMCATASSIGNFLAG
Condición: "CATALOGBASEPEOMULTITEMCATASSIGNFLAG" IS NOT NULL

CHECK: SYS_C0035972

Estado: ENABLED
Columnas: CATALOGBASEPEOVALIDATEFLAG
Condición: "CATALOGBASEPEOVALIDATEFLAG" IS NOT NULL

CHECK: SYS_C0035973

Estado: ENABLED
Columnas: CATALOGTRANSLATIONPEOCATEGORYSETNAME
Condición: "CATALOGTRANSLATIONPEOCATEGORYSETNAME" IS NOT NULL

CHECK: SYS_C0035974

Estado: ENABLED
Columnas: CATALOGTRANSLATIONPEOLANGUAGE
Condición: "CATALOGTRANSLATIONPEOLANGUAGE" IS NOT NULL

CHECK: SYS_C0035975

Estado: ENABLED
Columnas: CATALOGTRANSLATIONPEOLASTUPDATEDATE
Condición: "CATALOGTRANSLATIONPEOLASTUPDATEDATE" IS NOT NULL

CHECK: SYS_C0035976

Estado: ENABLED
Columnas: CATEGORYBASEPEOLASTUPDATEDATE
Condición: "CATEGORYBASEPEOLASTUPDATEDATE" IS NOT NULL

CHECK: SYS_C0035977

Estado: ENABLED
Columnas: CATEGORYID
Condición: "CATEGORYID" IS NOT NULL

CHECK: SYS_C0035978

Estado: ENABLED
Columnas: CATEGORYSETID
Condición: "CATEGORYSETID" IS NOT NULL

CHECK: SYS_C0035979

Estado: ENABLED
Columnas: CATEGORYTRANSLATIONPEOCATEGORYNAME
Condición: "CATEGORYTRANSLATIONPEOCATEGORYNAME" IS NOT NULL

CHECK: SYS_C0035980

Estado: ENABLED
Columnas: CATEGORYTRANSLATIONPEOLANGUAGE
Condición: "CATEGORYTRANSLATIONPEOLANGUAGE" IS NOT NULL

CHECK: SYS_C0035981

Estado: ENABLED
Columnas: CATEGORYTRANSLATIONPEOLASTUPDATEDATE
Condición: "CATEGORYTRANSLATIONPEOLASTUPDATEDATE" IS NOT NULL

CHECK: SYS_C0035982

Estado: ENABLED
Columnas: INVENTORYITEMID
Condición: "INVENTORYITEMID" IS NOT NULL

CHECK: SYS_C0035983

Estado: ENABLED
Columnas: ITEMCATEGORYPEOCREATEDBY
Condición: "ITEMCATEGORYPEOCREATEDBY" IS NOT NULL

CHECK: SYS_C0035984

Estado: ENABLED
Columnas: ITEMCATEGORYPEOCREATIONDATE
Condición: "ITEMCATEGORYPEOCREATIONDATE" IS NOT NULL

CHECK: SYS_C0035985

Estado: ENABLED
Columnas: ITEMCATEGORYPEOLASTUPDATEDATE
Condición: "ITEMCATEGORYPEOLASTUPDATEDATE" IS NOT NULL

CHECK: SYS_C0035986

Estado: ENABLED
Columnas: ITEMCATEGORYPEOLASTUPDATEDBY
Condición: "ITEMCATEGORYPEOLASTUPDATEDBY" IS NOT NULL

CHECK: SYS_C0035987

Estado: ENABLED
Columnas: ORGANIZATIONID
Condición: "ORGANIZATIONID" IS NOT NULL

CHECK: SYS_C0035988

Estado: ENABLED
Columnas: VALIDCATEGORYPEOLASTUPDATEDATE
Condición: "VALIDCATEGORYPEOLASTUPDATEDATE" IS NOT NULL

DDL

CREATE TABLE "STADW"."ST_ITEMCATEGORY_HIST" 
   (	"IDMAESTROCARGUE" NUMBER(18,0) NOT NULL ENABLE, 
	"CATALOGBASEPEOCATALOGCODE" VARCHAR2(30) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
	"CATALOGBASEPEOCATALOGCONTENTCODE" VARCHAR2(30) COLLATE "USING_NLS_COMP", 
	"CATALOGBASEPEOCATEGORYSETID" NUMBER(18,0) NOT NULL ENABLE, 
	"CATALOGBASEPEOCONTROLLEVEL" NUMBER(1,0) NOT NULL ENABLE, 
	"CATALOGBASEPEODEFAULTCATEGORYID" NUMBER(18,0), 
	"CATALOGBASEPEOHIERARCHYENABLED" CHAR(1) COLLATE "USING_NLS_COMP", 
	"CATALOGBASEPEOLASTUPDATEDATE" TIMESTAMP (6) NOT NULL ENABLE, 
	"CATALOGBASEPEOMULTITEMCATASSIGNFLAG" CHAR(1) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
	"CATALOGBASEPEOSTARTDATE" DATE, 
	"CATALOGBASEPEOSTRUCTUREID" NUMBER(18,0), 
	"CATALOGBASEPEOVALIDATEFLAG" CHAR(1) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
	"CATALOGTRANSLATIONPEOCATEGORYSETNAME" VARCHAR2(30) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
	"CATALOGTRANSLATIONPEODESCRIPTION" VARCHAR2(240) COLLATE "USING_NLS_COMP", 
	"CATALOGTRANSLATIONPEOLANGUAGE" VARCHAR2(4) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
	"CATALOGTRANSLATIONPEOLASTUPDATEDATE" DATE NOT NULL ENABLE, 
	"CATEGORYBASEPEOCATEGORYCODE" VARCHAR2(820) COLLATE "USING_NLS_COMP", 
	"CATEGORYBASEPEOCATEGORYCONTENTCODE" VARCHAR2(30) COLLATE "USING_NLS_COMP", 
	"CATEGORYBASEPEOLASTUPDATEDATE" DATE NOT NULL ENABLE, 
	"CATEGORYBASEPEOSTARTDATEACTIVE" DATE, 
	"CATEGORYID" NUMBER(18,0) NOT NULL ENABLE, 
	"CATEGORYSETID" NUMBER(18,0) NOT NULL ENABLE, 
	"CATEGORYTRANSLATIONPEOCATEGORYNAME" VARCHAR2(250) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
	"CATEGORYTRANSLATIONPEODESCRIPTION" VARCHAR2(240) COLLATE "USING_NLS_COMP", 
	"CATEGORYTRANSLATIONPEOLANGUAGE" VARCHAR2(4) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
	"CATEGORYTRANSLATIONPEOLASTUPDATEDATE" DATE NOT NULL ENABLE, 
	"INVENTORYITEMID" NUMBER(18,0) NOT NULL ENABLE, 
	"ITEMCATEGORYPEOCREATEDBY" VARCHAR2(64) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
	"ITEMCATEGORYPEOCREATIONDATE" DATE NOT NULL ENABLE, 
	"ITEMCATEGORYPEOLASTUPDATEDATE" DATE NOT NULL ENABLE, 
	"ITEMCATEGORYPEOLASTUPDATEDBY" VARCHAR2(64) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
	"ORGANIZATIONID" NUMBER(18,0) NOT NULL ENABLE, 
	"VALIDCATEGORYPEOLASTUPDATEDATE" DATE NOT NULL ENABLE
   )  DEFAULT COLLATION "USING_NLS_COMP" ;

GRANT ALTER ON "STADW"."ST_ITEMCATEGORY_HIST" TO "BICC";
  GRANT DELETE ON "STADW"."ST_ITEMCATEGORY_HIST" TO "BICC";
  GRANT INDEX ON "STADW"."ST_ITEMCATEGORY_HIST" TO "BICC";
  GRANT INSERT ON "STADW"."ST_ITEMCATEGORY_HIST" TO "BICC";
  GRANT SELECT ON "STADW"."ST_ITEMCATEGORY_HIST" TO "BICC";
  GRANT UPDATE ON "STADW"."ST_ITEMCATEGORY_HIST" TO "BICC";
  GRANT REFERENCES ON "STADW"."ST_ITEMCATEGORY_HIST" TO "BICC";
  GRANT READ ON "STADW"."ST_ITEMCATEGORY_HIST" TO "BICC";
  GRANT ON COMMIT REFRESH ON "STADW"."ST_ITEMCATEGORY_HIST" TO "BICC";
  GRANT QUERY REWRITE ON "STADW"."ST_ITEMCATEGORY_HIST" TO "BICC";
  GRANT DEBUG ON "STADW"."ST_ITEMCATEGORY_HIST" TO "BICC";
  GRANT FLASHBACK ON "STADW"."ST_ITEMCATEGORY_HIST" TO "BICC";
  GRANT ASSERTION REFERENCES ON "STADW"."ST_ITEMCATEGORY_HIST" TO "BICC";

← Volver a tablas de STADW

🏠 Volver al menú principal