CREATE TABLE publication(
	keypub nvarchar(200) PRIMARY KEY,
	title nvarchar(500) NULL,
	booktitle nvarchar(250) NULL,
	journal nvarchar(250) NULL,
	volume varchar(50) NULL,
	month varchar(50) NULL,
	year varchar(50) NULL,
	cdrom varchar(250) NULL,
	ee varchar(500) NULL,
	publisher varchar(250) NULL,
	pages varchar(50) NULL,
	number varchar(50) NULL,
	url varchar(500) NULL,
	cite varchar(250) NULL,
	address varchar(250) NULL,
	note varchar(500) NULL,
	isbn varchar(50) NULL,
	school varchar(250) NULL,
	chapter varchar(250) NULL,
	crossref varchar(250) NULL,
	type varchar(20) NULL,
	venueClean nvarchar(250) NULL
) ;

CREATE TABLE person(
	keyperson nvarchar(200) UNIQUE KEY,
	author nvarchar(250) NULL,
	title nvarchar(500) NULL,
	note varchar(500) NULL,
	url varchar(500) NULL,
	idperson int NOT NULL PRIMARY KEY
);

CREATE TABLE person_publication(
	idperson int NOT NULL,
	key_publication nvarchar(200) NOT NULL,
 CONSTRAINT PK_Person_Publication PRIMARY KEY 
(
	idperson ASC,
	key_publication ASC
));

CREATE TABLE personSynonym(
	idperson int NOT NULL,
	author nvarchar(250) NOT NULL,
 CONSTRAINT PK_personSynonym PRIMARY KEY CLUSTERED 
(
	idperson ASC,
	author ASC
);