MTDDB/btl_conditions_tables.sql at main · CMSROMA/MTDDB · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
DROP TABLE CMS_MTD_TMING_COND.LYSOMATRIX_VISUALINSPECTION CASCADE CONSTRAINTS;

CREATE TABLE CMS_MTD_TMING_COND.LYSOMATRIX_VISUALINSPECTION
(
  RECORD_ID                NUMBER(38)           NOT NULL,
  CONDITION_DATA_SET_ID    NUMBER(38)           NOT NULL,
  OPERATOR_COMMENT         VARCHAR2(4000)       NOT NULL
)
TABLESPACE CMS_MTD_PROCERNIT_DATA
PCTUSED    0
PCTFREE    10
INITRANS   1
MAXTRANS   255
STORAGE    (
            INITIAL          10M
            NEXT             1M
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
           )
LOGGING
NOCOMPRESS
NOCACHE;

CREATE UNIQUE INDEX CMS_MTD_TMING_COND.LYSOMATRIX_VISUALINSPECTION_PK ON CMS_MTD_TMING_COND.LYSOMATRIX_VISUALINSPECTION
(RECORD_ID)
LOGGING
TABLESPACE CMS_MTD_TMING_COND
PCTFREE    10
INITRANS   2
MAXTRANS   255
STORAGE    (
            INITIAL          10M
            NEXT             1M
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
           );

ALTER TABLE CMS_MTD_TMING_COND.LYSOMATRIX_VISUALINSPECTION ADD (
  CONSTRAINT LYSOMATRIX_VISUALINSPECTION_PK
  PRIMARY KEY
  (RECORD_ID)
  USING INDEX CMS_MTD_TMING_COND.LYSOMATRIX_VISUALINSPECTION_PK
  ENABLE VALIDATE);


CREATE INDEX CMS_MTD_TMING_COND.LYSOMATRIX_VSLINSPECT_FK_I ON CMS_MTD_TMING_COND.LYSOMATRIX_VISUALINSPECTION
(CONDITION_DATA_SET_ID)
LOGGING
TABLESPACE CMS_MTD_TMING_COND
PCTFREE    10
INITRANS   2
MAXTRANS   255
STORAGE    (
            INITIAL          10M
            NEXT             1M
            MINEXTENTS       1
            MAXEXTENTS       UNLIMITED
            PCTINCREASE      0
            BUFFER_POOL      DEFAULT
           );

ALTER TABLE CMS_MTD_TMING_COND.LYSOMATRIX_VISUALINSPECTION ADD (
  CONSTRAINT LYSOMATRIX_VISUALINSPECTION_FK
  FOREIGN KEY (CONDITION_DATA_SET_ID)
  REFERENCES CMS_MTD_CORE_COND.COND_DATA_SETS (CONDITION_DATA_SET_ID)
  ENABLE VALIDATE);

GRANT SELECT ON CMS_MTD_TMING_COND.LYSOMATRIX_VISUALINSPECTION TO CMS_MTD_TMING_CONDITION_READER;

GRANT SELECT ON CMS_MTD_TMING_COND.LYSOMATRIX_VISUALINSPECTION TO PUBLIC;

/* included by hand to set the relationship between single crystals and comments */
insert into COND_TO_PART_RLTNSHPS (KIND_OF_PART_ID, KIND_OF_CONDITION_ID, DISPLAY_NAME, IS_RECORD_DELETED) VALUES (2001, 1020, 'Visual inspection comment for singleBarXtal', 'F');

/* included by hand to allow writing */
GRANT INSERT ON CMS_MTD_TMING_COND.LYSOMATRIX_VISUALINSPECTION TO CMS_MTD_CORE_CONDITION_WRITER;
GRANT UPDATE ON CMS_MTD_TMING_COND.LYSOMATRIX_VISUALINSPECTION TO CMS_MTD_CORE_CONDITION_WRITER;