m2u-upass-admin / DBScript / ib_bank_branch.sql @ 123:a28809b30e98
History | View | Annotate | Download (3.62 KB)
1 |
Rem ===================================================================== |
---|---|
2 |
Rem NAME |
3 |
Rem <ib_bank_branch.sql> |
4 |
Rem DESCRIPTION |
5 |
Rem <IB Bank Branch Content Table>
|
6 |
Rem MODULE |
7 |
Rem <IB Module> |
8 |
Rem MODIFIED (MM/DD/YYYY) |
9 |
Rem Danniell 03/12/2010 - Creation |
10 |
Rem xxxxxx mm/dd/yyyy - Modify |
11 |
Rem ===================================================================== |
12 |
|
13 |
CREATE TABLE IB_BANK_BRANCH |
14 |
( |
15 |
OID NUMBER NOT NULL, |
16 |
CONTENT_CATEGORY_ID NUMBER NOT NULL, |
17 |
BRANCH_NAME VARCHAR2(64 BYTE), |
18 |
BRANCH_CODE VARCHAR2(8 BYTE), |
19 |
BRANCH_ADDR1 VARCHAR2(64 BYTE), |
20 |
BRANCH_ADDR2 VARCHAR2(64 BYTE), |
21 |
BRANCH_ADDR3 VARCHAR2(64 BYTE), |
22 |
BRANCH_ADDR4 VARCHAR2(64 BYTE), |
23 |
BRANCH_ADDR5 VARCHAR2(64 BYTE), |
24 |
BRANCH_POSTCODE VARCHAR2(16 BYTE), |
25 |
BRANCH_CONTACT VARCHAR2(20 BYTE), |
26 |
BRANCH_FAX VARCHAR2(20 BYTE), |
27 |
AREA_CODE VARCHAR2(16 BYTE), |
28 |
STATUS VARCHAR2(1 BYTE), |
29 |
DELETED VARCHAR2(1 BYTE), |
30 |
CREATION_DATE TIMESTAMP(2) DEFAULT SYSDATE NOT NULL, |
31 |
LAST_MOD_DATE TIMESTAMP(2) |
32 |
) |
33 |
TABLESPACE USERS |
34 |
PCTUSED 0
|
35 |
PCTFREE 10
|
36 |
INITRANS 1
|
37 |
MAXTRANS 255
|
38 |
STORAGE ( |
39 |
INITIAL 64K
|
40 |
NEXT 128K
|
41 |
MINEXTENTS 1
|
42 |
MAXEXTENTS UNLIMITED |
43 |
PCTINCREASE 0
|
44 |
FREELISTS 1
|
45 |
FREELIST GROUPS 1
|
46 |
BUFFER_POOL DEFAULT
|
47 |
) |
48 |
LOGGING |
49 |
NOCOMPRESS |
50 |
NOCACHE |
51 |
NOPARALLEL |
52 |
MONITORING; |
53 |
|
54 |
|
55 |
CREATE UNIQUE INDEX IB_BANK_BRANCH_PK ON IB_BANK_BRANCH |
56 |
(OID) |
57 |
LOGGING |
58 |
TABLESPACE USERS |
59 |
PCTFREE 10
|
60 |
INITRANS 2
|
61 |
MAXTRANS 255
|
62 |
STORAGE ( |
63 |
INITIAL 64K
|
64 |
NEXT 128K
|
65 |
MINEXTENTS 1
|
66 |
MAXEXTENTS UNLIMITED |
67 |
PCTINCREASE 0
|
68 |
FREELISTS 1
|
69 |
FREELIST GROUPS 1
|
70 |
BUFFER_POOL DEFAULT
|
71 |
) |
72 |
NOPARALLEL; |
73 |
|
74 |
|
75 |
CREATE UNIQUE INDEX IB_BANK_BRANCH_R02 ON IB_BANK_BRANCH |
76 |
(BRANCH_CODE) |
77 |
LOGGING |
78 |
TABLESPACE USERS |
79 |
PCTFREE 10
|
80 |
INITRANS 2
|
81 |
MAXTRANS 255
|
82 |
STORAGE ( |
83 |
INITIAL 64K
|
84 |
NEXT 128K
|
85 |
MINEXTENTS 1
|
86 |
MAXEXTENTS UNLIMITED |
87 |
PCTINCREASE 0
|
88 |
FREELISTS 1
|
89 |
FREELIST GROUPS 1
|
90 |
BUFFER_POOL DEFAULT
|
91 |
) |
92 |
NOPARALLEL; |
93 |
|
94 |
|
95 |
ALTER TABLE IB_BANK_BRANCH ADD ( |
96 |
CONSTRAINT IB_BANK_BRANCH_PK
|
97 |
PRIMARY KEY |
98 |
(OID) |
99 |
USING INDEX |
100 |
TABLESPACE USERS |
101 |
PCTFREE 10
|
102 |
INITRANS 2
|
103 |
MAXTRANS 255
|
104 |
STORAGE ( |
105 |
INITIAL 64K
|
106 |
NEXT 128K
|
107 |
MINEXTENTS 1
|
108 |
MAXEXTENTS UNLIMITED |
109 |
PCTINCREASE 0
|
110 |
FREELISTS 1
|
111 |
FREELIST GROUPS 1
|
112 |
), |
113 |
CONSTRAINT IB_BANK_BRANCH_R02
|
114 |
UNIQUE (BRANCH_CODE)
|
115 |
USING INDEX |
116 |
TABLESPACE USERS |
117 |
PCTFREE 10
|
118 |
INITRANS 2
|
119 |
MAXTRANS 255
|
120 |
STORAGE ( |
121 |
INITIAL 64K
|
122 |
NEXT 128K
|
123 |
MINEXTENTS 1
|
124 |
MAXEXTENTS UNLIMITED |
125 |
PCTINCREASE 0
|
126 |
FREELISTS 1
|
127 |
FREELIST GROUPS 1
|
128 |
)); |
129 |
|
130 |
ALTER TABLE IB_BANK_BRANCH ADD ( |
131 |
CONSTRAINT IB_BANK_BRANCH_R01
|
132 |
FOREIGN KEY (CONTENT_CATEGORY_ID) |
133 |
REFERENCES IB_CONTENT_CATEGORY (OID)
|
134 |
ON DELETE CASCADE); |