Last change
on this file since 784 was
105,
checked in by rboipsl, 13 years ago
|
Import du projet NDACC _ module persistence
|
File size:
1.2 KB
|
Line | |
---|
1 | CREATE SEQUENCE S_TABLE_TEST |
---|
2 | |
---|
3 | /*==============================================================*/ |
---|
4 | /* Table : TABLE_TEST */ |
---|
5 | /*==============================================================*/ |
---|
6 | CREATE TABLE TABLE_TEST ( |
---|
7 | TABLE_TEST_ID NUMBER(9,0) NOT NULL, |
---|
8 | CODE NVARCHAR2(50) NOT NULL, |
---|
9 | VALUE INTEGER, |
---|
10 | IS_VISIBLE NUMBER(1,0) DEFAULT 0 NOT NULL |
---|
11 | CONSTRAINT CKC_IS_VISIBLE_TABLE_TEST CHECK (IS_VISIBLE IN (0,1)), |
---|
12 | DEFAULT_TRANSLATION NVARCHAR2(255), |
---|
13 | CONSTRAINT PK_TABLE_TEST PRIMARY KEY (TABLE_TEST_ID), |
---|
14 | CONSTRAINT AK_TABLE_TEST_CO_ACH_ACHI UNIQUE (CODE) |
---|
15 | ) |
---|
16 | /* GO */ |
---|
17 | |
---|
18 | |
---|
19 | COMMENT ON TABLE TABLE_TEST IS |
---|
20 | 'Table de test' |
---|
21 | /* GO */ |
---|
22 | |
---|
23 | |
---|
24 | COMMENT ON COLUMN TABLE_TEST.TABLE_TEST_ID IS |
---|
25 | 'The identifier of the element' |
---|
26 | /* GO */ |
---|
27 | |
---|
28 | |
---|
29 | COMMENT ON COLUMN TABLE_TEST.CODE IS |
---|
30 | 'The element code' |
---|
31 | /* GO */ |
---|
32 | |
---|
33 | |
---|
34 | COMMENT ON COLUMN TABLE_TEST.VALUE IS |
---|
35 | 'The element value' |
---|
36 | /* GO */ |
---|
37 | |
---|
38 | |
---|
39 | COMMENT ON COLUMN TABLE_TEST.IS_VISIBLE IS |
---|
40 | 'Test for a boolean' |
---|
41 | /* GO */ |
---|
42 | |
---|
43 | |
---|
44 | COMMENT ON COLUMN TABLE_TEST.DEFAULT_TRANSLATION IS |
---|
45 | 'The default translation of the element' |
---|
46 | /* GO */ |
---|
Note: See
TracBrowser
for help on using the repository browser.