Diccionario de Datos
Diccionario de datos de los modelos de COÉXITO
| 🏠 Menú principal | ← Volver a tablas |
SIMACMOBILE.STATS_TABLE_SIMACMOBILE
Base de datos origen: ORCLSMM
Columnas
| # | Columna | Tipo | Nulo | Default | Comentario |
|---|---|---|---|---|---|
| 1 | STATID | VARCHAR2(128) | SI | ||
| 2 | TYPE | CHAR(1) | SI | ||
| 3 | VERSION | NUMBER | SI | ||
| 4 | FLAGS | NUMBER | SI | ||
| 5 | C1 | VARCHAR2(128) | SI | ||
| 6 | C2 | VARCHAR2(128) | SI | ||
| 7 | C3 | VARCHAR2(128) | SI | ||
| 8 | C4 | VARCHAR2(128) | SI | ||
| 9 | C5 | VARCHAR2(128) | SI | ||
| 10 | C6 | VARCHAR2(128) | SI | ||
| 11 | N1 | NUMBER | SI | ||
| 12 | N2 | NUMBER | SI | ||
| 13 | N3 | NUMBER | SI | ||
| 14 | N4 | NUMBER | SI | ||
| 15 | N5 | NUMBER | SI | ||
| 16 | N6 | NUMBER | SI | ||
| 17 | N7 | NUMBER | SI | ||
| 18 | N8 | NUMBER | SI | ||
| 19 | N9 | NUMBER | SI | ||
| 20 | N10 | NUMBER | SI | ||
| 21 | N11 | NUMBER | SI | ||
| 22 | N12 | NUMBER | SI | ||
| 23 | N13 | NUMBER | SI | ||
| 24 | D1 | DATE | SI | ||
| 25 | T1 | TIMESTAMP(6) WITH TIME ZONE | SI | ||
| 26 | R1 | RAW | SI | ||
| 27 | R2 | RAW | SI | ||
| 28 | R3 | RAW | SI | ||
| 29 | CH1 | VARCHAR2(1000) | SI | ||
| 30 | CL1 | CLOB | SI | ||
| 31 | BL1 | BLOB | SI |
Restricciones
Sin restricciones visibles (P/R/U/C).
DDL
CREATE TABLE "SIMACMOBILE"."STATS_TABLE_SIMACMOBILE"
( "STATID" VARCHAR2(128),
"TYPE" CHAR(1),
"VERSION" NUMBER,
"FLAGS" NUMBER,
"C1" VARCHAR2(128),
"C2" VARCHAR2(128),
"C3" VARCHAR2(128),
"C4" VARCHAR2(128),
"C5" VARCHAR2(128),
"C6" VARCHAR2(128),
"N1" NUMBER,
"N2" NUMBER,
"N3" NUMBER,
"N4" NUMBER,
"N5" NUMBER,
"N6" NUMBER,
"N7" NUMBER,
"N8" NUMBER,
"N9" NUMBER,
"N10" NUMBER,
"N11" NUMBER,
"N12" NUMBER,
"N13" NUMBER,
"D1" DATE,
"T1" TIMESTAMP (6) WITH TIME ZONE,
"R1" RAW(1000),
"R2" RAW(1000),
"R3" RAW(1000),
"CH1" VARCHAR2(1000),
"CL1" CLOB,
"BL1" BLOB
) ;
GRANT DELETE ON "SIMACMOBILE"."STATS_TABLE_SIMACMOBILE" TO "PERM_USUARIOAPP";
GRANT SELECT ON "SIMACMOBILE"."STATS_TABLE_SIMACMOBILE" TO "PERM_USUARIOAPP";
GRANT UPDATE ON "SIMACMOBILE"."STATS_TABLE_SIMACMOBILE" TO "PERM_USUARIOAPP";
GRANT UPDATE ON "SIMACMOBILE"."STATS_TABLE_SIMACMOBILE" TO "APLICACIONES";
GRANT SELECT ON "SIMACMOBILE"."STATS_TABLE_SIMACMOBILE" TO "APLICACIONES";
GRANT INSERT ON "SIMACMOBILE"."STATS_TABLE_SIMACMOBILE" TO "APLICACIONES";
GRANT DELETE ON "SIMACMOBILE"."STATS_TABLE_SIMACMOBILE" TO "APLICACIONES";
GRANT UPDATE ON "SIMACMOBILE"."STATS_TABLE_SIMACMOBILE" TO "CRUD_SIMAC";
GRANT SELECT ON "SIMACMOBILE"."STATS_TABLE_SIMACMOBILE" TO "CRUD_SIMAC";
GRANT INSERT ON "SIMACMOBILE"."STATS_TABLE_SIMACMOBILE" TO "CRUD_SIMAC";
GRANT DELETE ON "SIMACMOBILE"."STATS_TABLE_SIMACMOBILE" TO "CRUD_SIMAC";
GRANT DELETE ON "SIMACMOBILE"."STATS_TABLE_SIMACMOBILE" TO "RAPLICACIONES";
GRANT INSERT ON "SIMACMOBILE"."STATS_TABLE_SIMACMOBILE" TO "RAPLICACIONES";
GRANT SELECT ON "SIMACMOBILE"."STATS_TABLE_SIMACMOBILE" TO "RAPLICACIONES";
GRANT UPDATE ON "SIMACMOBILE"."STATS_TABLE_SIMACMOBILE" TO "RAPLICACIONES";
GRANT INSERT ON "SIMACMOBILE"."STATS_TABLE_SIMACMOBILE" TO "PERM_USUARIOAPP";
GRANT SELECT ON "SIMACMOBILE"."STATS_TABLE_SIMACMOBILE" TO "CONSULTA";
CREATE UNIQUE INDEX "SIMACMOBILE"."SYS_IL0000105436C00031$$" ON "SIMACMOBILE"."STATS_TABLE_SIMACMOBILE" (
;
CREATE UNIQUE INDEX "SIMACMOBILE"."SYS_IL0000105436C00030$$" ON "SIMACMOBILE"."STATS_TABLE_SIMACMOBILE" (
;
CREATE INDEX "SIMACMOBILE"."STATS_TABLE_SIMACMOBILE" ON "SIMACMOBILE"."STATS_TABLE_SIMACMOBILE" ("STATID", "TYPE", "C5", "C1", "C2", "C3", "C4", "VERSION")
;