🏠 Menú principal

← Volver a tablas

---

STADW.ST_FULFILLLINESTATUS

Base de datos origen: ADW COEXITO

Columnas

#	Columna	Tipo	Nulo	Default	Comentario
1	ID	NUMBER	NO	“STADW”.”ISEQ$$_184214”.nextval
2	IDMAESTROCARGUE	NUMBER(18,0)	NO
3	FULFILLLINESTATUSCREATEDBY	VARCHAR2(64)	NO
4	FULFILLLINESTATUSCREATIONDATE	DATE	NO
5	FULFILLLINESTATUSLASTUPDATEDATE	DATE	NO
6	FULFILLLINESTATUSLASTUPDATEDBY	VARCHAR2(64)	NO
7	FULFILLLINESTATUSSTATUSCODE	VARCHAR2(30)	NO
8	LINESTATUSID	NUMBER(18,0)	NO
9	STATUSTRANSLATIONCREATEDBY	VARCHAR2(64)	NO
10	STATUSTRANSLATIONCREATIONDATE	DATE	NO
11	STATUSTRANSLATIONDISPLAYNAME	VARCHAR2(240)	NO
12	STATUSTRANSLATIONLANGUAGE	VARCHAR2(4)	NO
13	STATUSTRANSLATIONLASTUPDATEDBY	VARCHAR2(64)	NO
14	STATUSTRANSLATIONSOURCELANG	VARCHAR2(4)	NO

Restricciones

CHECK: SYS_C0034272

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

CHECK: SYS_C0034273

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

CHECK: SYS_C0034274

• Estado: ENABLED
• Columnas: FULFILLLINESTATUSCREATEDBY
• Condición: "FULFILLLINESTATUSCREATEDBY" IS NOT NULL

CHECK: SYS_C0034275

• Estado: ENABLED
• Columnas: FULFILLLINESTATUSCREATIONDATE
• Condición: "FULFILLLINESTATUSCREATIONDATE" IS NOT NULL

CHECK: SYS_C0034276

• Estado: ENABLED
• Columnas: FULFILLLINESTATUSLASTUPDATEDATE
• Condición: "FULFILLLINESTATUSLASTUPDATEDATE" IS NOT NULL

CHECK: SYS_C0034277

• Estado: ENABLED
• Columnas: FULFILLLINESTATUSLASTUPDATEDBY
• Condición: "FULFILLLINESTATUSLASTUPDATEDBY" IS NOT NULL

CHECK: SYS_C0034278

• Estado: ENABLED
• Columnas: FULFILLLINESTATUSSTATUSCODE
• Condición: "FULFILLLINESTATUSSTATUSCODE" IS NOT NULL

CHECK: SYS_C0034279

• Estado: ENABLED
• Columnas: LINESTATUSID
• Condición: "LINESTATUSID" IS NOT NULL

CHECK: SYS_C0034280

• Estado: ENABLED
• Columnas: STATUSTRANSLATIONCREATEDBY
• Condición: "STATUSTRANSLATIONCREATEDBY" IS NOT NULL

CHECK: SYS_C0034281

• Estado: ENABLED
• Columnas: STATUSTRANSLATIONCREATIONDATE
• Condición: "STATUSTRANSLATIONCREATIONDATE" IS NOT NULL

CHECK: SYS_C0034282

• Estado: ENABLED
• Columnas: STATUSTRANSLATIONDISPLAYNAME
• Condición: "STATUSTRANSLATIONDISPLAYNAME" IS NOT NULL

CHECK: SYS_C0034283

• Estado: ENABLED
• Columnas: STATUSTRANSLATIONLANGUAGE
• Condición: "STATUSTRANSLATIONLANGUAGE" IS NOT NULL

CHECK: SYS_C0034284

• Estado: ENABLED
• Columnas: STATUSTRANSLATIONLASTUPDATEDBY
• Condición: "STATUSTRANSLATIONLASTUPDATEDBY" IS NOT NULL

CHECK: SYS_C0034285

• Estado: ENABLED
• Columnas: STATUSTRANSLATIONSOURCELANG
• Condición: "STATUSTRANSLATIONSOURCELANG" IS NOT NULL

PK: SYS_C0034286

• Estado: ENABLED
• Columnas: ID

DDL

CREATE TABLE "STADW"."ST_FULFILLLINESTATUS" 
   (	"ID" NUMBER(*,0) GENERATED ALWAYS 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, 
	"FULFILLLINESTATUSCREATEDBY" VARCHAR2(64) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
	"FULFILLLINESTATUSCREATIONDATE" DATE NOT NULL ENABLE, 
	"FULFILLLINESTATUSLASTUPDATEDATE" DATE NOT NULL ENABLE, 
	"FULFILLLINESTATUSLASTUPDATEDBY" VARCHAR2(64) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
	"FULFILLLINESTATUSSTATUSCODE" VARCHAR2(30) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
	"LINESTATUSID" NUMBER(18,0) NOT NULL ENABLE, 
	"STATUSTRANSLATIONCREATEDBY" VARCHAR2(64) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
	"STATUSTRANSLATIONCREATIONDATE" DATE NOT NULL ENABLE, 
	"STATUSTRANSLATIONDISPLAYNAME" VARCHAR2(240) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
	"STATUSTRANSLATIONLANGUAGE" VARCHAR2(4) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
	"STATUSTRANSLATIONLASTUPDATEDBY" VARCHAR2(64) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
	"STATUSTRANSLATIONSOURCELANG" VARCHAR2(4) COLLATE "USING_NLS_COMP" NOT NULL ENABLE, 
	 PRIMARY KEY ("ID")
  USING INDEX  ENABLE
   )  DEFAULT COLLATION "USING_NLS_COMP" ;

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

CREATE UNIQUE INDEX "STADW"."SYS_C0034286" ON "STADW"."ST_FULFILLLINESTATUS" ("ID") 
  ;

---

← Volver a tablas de STADW

🏠 Volver al menú principal