alextan1105
/
Warroom
1
0
Fork 0
Code Issues Pull Requests Projects Releases Wiki Activity
You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
1 Commit
1 Branch
0 Tags
539 MiB
Branch: master
Branches Tags
${ item.name }
Create tag ${ searchTerm }
Create branch ${ searchTerm }
from 'master'
${ noResults }
Warroom/warroom-system/Library/Mirle.Component.Database.Mo.../Current/DDL/CUR_SOFTWARE_OPERATION_MODE...

51 lines
2.6 KiB
Raw Permalink Normal View History

first
8 months ago
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
​
  1. --------------------------------------------------------
  2. -- DDL for Table CUR_SOFTWARE_OPERATION_MODE
  3. --------------------------------------------------------
  5. CREATE TABLE "MIRLE"."CUR_SOFTWARE_OPERATION_MODE"
  6. (
  7. "SOFTWARE_ID" VARCHAR2(7 CHAR),
  8. "START_TIME" TIMESTAMP (6),
  9. "END_TIME" TIMESTAMP (6),
  10. "OPERATION_MODE" NUMBER(1,0),
  11. "PROGRAM_NAME" VARCHAR2(30 CHAR)
  12. )
  13. SEGMENT CREATION IMMEDIATE
  14. PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
  15. NOCOMPRESS LOGGING
  16. STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  17. PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  18. BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  19. TABLESPACE "SYSTEM" ;
  21. COMMENT ON COLUMN "MIRLE"."CUR_SOFTWARE_OPERATION_MODE"."SOFTWARE_ID" IS '軟體編號';
  22. COMMENT ON COLUMN "MIRLE"."CUR_SOFTWARE_OPERATION_MODE"."START_TIME" IS '起始時間';
  23. COMMENT ON COLUMN "MIRLE"."CUR_SOFTWARE_OPERATION_MODE"."END_TIME" IS '結束時間';
  24. COMMENT ON COLUMN "MIRLE"."CUR_SOFTWARE_OPERATION_MODE"."OPERATION_MODE" IS '操作模式';
  25. COMMENT ON COLUMN "MIRLE"."CUR_SOFTWARE_OPERATION_MODE"."PROGRAM_NAME" IS '程式名稱';
  27. --------------------------------------------------------
  28. -- DDL for Index CUR_SOFTWARE_OPERATION_MODE_PK
  29. --------------------------------------------------------
  31. CREATE UNIQUE INDEX "MIRLE"."CUR_SOFTWARE_OPERATION_MODE_PK" ON "MIRLE"."CUR_SOFTWARE_OPERATION_MODE" ("SOFTWARE_ID", "START_TIME")
  32. PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
  33. STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  34. PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  35. BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  36. TABLESPACE "SYSTEM" ;
  38. --------------------------------------------------------
  39. -- Constraints for Table CUR_SOFTWARE_OPERATION_MODE
  40. --------------------------------------------------------
  42. ALTER TABLE "MIRLE"."CUR_SOFTWARE_OPERATION_MODE" MODIFY ("SOFTWARE_ID" NOT NULL ENABLE);
  43. ALTER TABLE "MIRLE"."CUR_SOFTWARE_OPERATION_MODE" MODIFY ("START_TIME" NOT NULL ENABLE);
  44. ALTER TABLE "MIRLE"."CUR_SOFTWARE_OPERATION_MODE" MODIFY ("OPERATION_MODE" NOT NULL ENABLE);
  45. ALTER TABLE "MIRLE"."CUR_SOFTWARE_OPERATION_MODE" MODIFY ("PROGRAM_NAME" NOT NULL ENABLE);
  46. ALTER TABLE "MIRLE"."CUR_SOFTWARE_OPERATION_MODE" ADD CONSTRAINT "CUR_SOFTWARE_OPERATION_MODE_PK" PRIMARY KEY ("SOFTWARE_ID", "START_TIME")
  47. USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
  48. STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  49. PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  50. BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  51. TABLESPACE "SYSTEM" ENABLE;