source: ether_statistics/persistence/sql/create.sql @ 569

CREATE SEQUENCE S_TABLE_TEST

/*==============================================================*/
/* Table : TABLE_TEST                                      */
/*==============================================================*/
CREATE TABLE TABLE_TEST  (
   TABLE_TEST_ID        NUMBER(9,0)                     NOT NULL,
   CODE                 NVARCHAR2(50)                   NOT NULL,
   VALUE                INTEGER,
   IS_VISIBLE           NUMBER(1,0)                    DEFAULT 0 NOT NULL
      CONSTRAINT CKC_IS_VISIBLE_TABLE_TEST CHECK (IS_VISIBLE IN (0,1)),
   DEFAULT_TRANSLATION  NVARCHAR2(255),
   CONSTRAINT PK_TABLE_TEST PRIMARY KEY (TABLE_TEST_ID),
   CONSTRAINT AK_TABLE_TEST_CO_ACH_ACHI UNIQUE (CODE)
)
/* GO */


COMMENT ON TABLE TABLE_TEST IS
'Table de test'
/* GO */


COMMENT ON COLUMN TABLE_TEST.TABLE_TEST_ID IS
'The identifier of the element'
/* GO */


COMMENT ON COLUMN TABLE_TEST.CODE IS
'The element code'
/* GO */


COMMENT ON COLUMN TABLE_TEST.VALUE IS
'The element value'
/* GO */


COMMENT ON COLUMN TABLE_TEST.IS_VISIBLE IS
'Test for a boolean'
/* GO */


COMMENT ON COLUMN TABLE_TEST.DEFAULT_TRANSLATION IS
'The default translation of the element'
/* GO */