CREATE SEQUENCE S_MCO
/* GO */


/*==============================================================*/
/* Table : USER                                                 */
/*==============================================================*/
CREATE TABLE MCO  (
   MCO_ID         	  NUMBER(9,0)               NOT NULL,
   CODE               NVARCHAR2(20),
   CREATION_DATE      TIMESTAMP                 NOT NULL,
   CLOSING_DATE       TIMESTAMP,
   EMAIL_USER  		  NVARCHAR2(100)			NOT NULL,
   TITLE              NVARCHAR2(100),
   STATE		      NVARCHAR2(20)			    NOT NULL,
   TYPE               NVARCHAR2(20)			    NOT NULL,
   INFORMATIONS       NVARCHAR2(1000),

   CONSTRAINT PK_MCO PRIMARY KEY (MCO_ID)
)
/* GO */


COMMENT ON TABLE MCO IS
'This table contents all the requests from user'
/* GO */


COMMENT ON COLUMN MCO.MCO_ID IS 'The identifier of the mco request'
/* GO */

COMMENT ON COLUMN MCO.CODE IS 'The code of the mco request'
/* GO */

COMMENT ON COLUMN MCO.CREATION_DATE IS 'The creation date of the request. It never changes even the state will be modified'
/* GO */

COMMENT ON COLUMN MCO.CLOSING_DATE IS 'The closing date of the request'
/* GO */

COMMENT ON COLUMN MCO.EMAIL_USER IS 'The email of the user'
/* GO */

COMMENT ON COLUMN MCO.TITLE IS 'The title of the request'
/* GO */

COMMENT ON COLUMN MCO.STATE IS 'The state of the request. Examples : open, close, in work, ...'
/* GO */

COMMENT ON COLUMN MCO.TYPE IS 'The type of the request. Examples : new_account, problem, ...'
/* GO */

COMMENT ON COLUMN MCO.INFORMATIONS IS 'The content of the request, email s users, answers, ...'
/* GO */


/*==============================================================*/
/* VERSION POSTGRES                                             */
/*==============================================================*/
CREATE TABLE "public"."MCO" (
"MCO_ID" int4 DEFAULT NULL NOT NULL,
"CODE" varchar(20) DEFAULT NULL,
"CREATION_DATE" timestamp(6) DEFAULT NULL NOT NULL,
"CLOSING_DATE" timestamp(6) DEFAULT NULL,
"EMAIL_USER" varchar(100) DEFAULT NULL NOT NULL,
"TITLE" varchar(100) DEFAULT NULL,
"STATE" varchar(20) DEFAULT NULL NOT NULL,
"TYPE" varchar(20) DEFAULT NULL NOT NULL,
"INFORMATIONS" varchar(1000) DEFAULT NULL,
CONSTRAINT "MCO_pkey" PRIMARY KEY ("MCO_ID")
)
WITH (OIDS=FALSE)
;

ALTER TABLE "public"."MCO" OWNER TO "postgres";

COMMENT ON TABLE "public"."MCO" IS 'This table contents all the requests from user';

COMMENT ON COLUMN "public"."MCO"."MCO_ID" IS 'The identifier of the mco request';

COMMENT ON COLUMN "public"."MCO"."CODE" IS 'The code of the mco request';

COMMENT ON COLUMN "public"."MCO"."CREATION_DATE" IS 'The creation date of the request. It never changes even the state will be modified';

COMMENT ON COLUMN "public"."MCO"."CLOSING_DATE" IS 'The closing date of the request';

COMMENT ON COLUMN "public"."MCO"."EMAIL_USER" IS 'The email of the user';

COMMENT ON COLUMN "public"."MCO"."TITLE" IS 'The title of the request';

COMMENT ON COLUMN "public"."MCO"."STATE" IS 'The state of the request. Examples : open, close, in work, ...';

COMMENT ON COLUMN "public"."MCO"."TYPE" IS 'The type of the request. Examples : new_account, problem, ...';

COMMENT ON COLUMN "public"."MCO"."INFORMATIONS" IS 'The content of the request, email s users, answers, ...';