Diccionario de Datos
Diccionario de datos de los modelos de COÉXITO
| 🏠 Menú principal | ← Volver a tablas |
LACLS.DEPT
Base de datos origen: PDB1
Columnas
| # | Columna | Tipo | Nulo | Default | Comentario |
|---|---|---|---|---|---|
| 1 | DEPTNO | NUMBER(2,0) | NO | ||
| 2 | DNAME | VARCHAR2(14) | SI | ||
| 3 | LOC | VARCHAR2(13) | SI |
Restricciones
PK: SYS_C0014507
- Estado: ENABLED
- Columnas: DEPTNO
DDL
CREATE TABLE "LACLS"."DEPT"
( "DEPTNO" NUMBER(2,0),
"DNAME" VARCHAR2(14),
"LOC" VARCHAR2(13),
PRIMARY KEY ("DEPTNO")
USING INDEX ENABLE
) ;
GRANT DELETE ON "LACLS"."DEPT" TO "SOPORTE_COE";
GRANT INSERT ON "LACLS"."DEPT" TO "SOPORTE_COE";
GRANT SELECT ON "LACLS"."DEPT" TO "SOPORTE_COE";
GRANT UPDATE ON "LACLS"."DEPT" TO "SOPORTE_COE";
CREATE UNIQUE INDEX "LACLS"."SYS_C0014507" ON "LACLS"."DEPT" ("DEPTNO")
;