CREATE TABLE SC_IL_Letter
(
  id			int		NOT NULL ,
  name			varchar (1000)	NOT NULL ,
  description		varchar (2000)	NULL ,
  periode			varchar (255)	NULL ,
  instanceId		varchar (50)	NOT NULL
);

CREATE TABLE SC_IL_Publication
(
  id			int		NOT NULL ,
  title			varchar (1000)	NOT NULL ,
  description		varchar (2000)	NULL ,
  parutionDate		varchar (255)	NULL ,
  publicationState	int		NOT NULL ,
  letterId		int		NOT NULL ,
  instanceId		varchar (50)	NOT NULL
);

CREATE TABLE SC_IL_ExtSus
(
  letter			int		NOT NULL ,
  email			varchar (1000)	NOT NULL ,
  instanceId		varchar (50)	NOT NULL
);
