STADW.ST_ITEMCATEGORY

Base de datos origen: ADW COEXITO

Columnas

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

Restricciones

CHECK: SYS_C0034287

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

CHECK: SYS_C0034288

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

CHECK: SYS_C0034289

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

CHECK: SYS_C0034290

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

CHECK: SYS_C0034291

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

CHECK: SYS_C0034292

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

CHECK: SYS_C0034293

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

CHECK: SYS_C0034294

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

CHECK: SYS_C0034295

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

CHECK: SYS_C0034296

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

CHECK: SYS_C0034297

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

CHECK: SYS_C0034298

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

CHECK: SYS_C0034299

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

CHECK: SYS_C0034300

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

CHECK: SYS_C0034301

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

CHECK: SYS_C0034302

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

CHECK: SYS_C0034303

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

CHECK: SYS_C0034304

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

CHECK: SYS_C0034305

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

CHECK: SYS_C0034306

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

CHECK: SYS_C0034307

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

CHECK: SYS_C0034308

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

CHECK: SYS_C0034309

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

CHECK: SYS_C0034310

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

PK: SYS_C0034311

Estado: ENABLED
Columnas: ID

DDL

CREATE TABLE "STADW"."ST_ITEMCATEGORY" 
   (	"ID" NUMBER(*,0) GENERATED BY DEFAULT AS IDENTITY MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER  NOCYCLE  NOKEEP  NOSCALE  NOT NULL ENABLE, 
	"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, 
	 PRIMARY KEY ("ID")
  USING INDEX  ENABLE
   )  DEFAULT COLLATION "USING_NLS_COMP" ;

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

CREATE UNIQUE INDEX "STADW"."SYS_C0034311" ON "STADW"."ST_ITEMCATEGORY" ("ID") 
  ;

← Volver a tablas de STADW

🏠 Volver al menú principal