


CREATE TABLE "Comment"(creationDate TIMESTAMP, id BIGINT, locationIP VARCHAR, browserUsed VARCHAR, "content" VARCHAR, length BIGINT, "type" VARCHAR DEFAULT('Comment'));
CREATE TABLE Comment_hasCreator_Person(creationDate TIMESTAMP, CommentId BIGINT, PersonId BIGINT);
CREATE TABLE Comment_hasTag_Tag(creationDate TIMESTAMP, CommentId BIGINT, TagId BIGINT);
CREATE TABLE Comment_isLocatedIn_Country(creationDate TIMESTAMP, CommentId BIGINT, CountryId BIGINT);
CREATE TABLE Comment_replyOf_Comment(creationDate TIMESTAMP, Comment1Id BIGINT, Comment2Id BIGINT);
CREATE TABLE Comment_replyOf_Post(creationDate TIMESTAMP, CommentId BIGINT, PostId BIGINT);
CREATE TABLE Forum(creationDate TIMESTAMP, id BIGINT, title VARCHAR);
CREATE TABLE Forum_containerOf_Post(creationDate TIMESTAMP, ForumId BIGINT, PostId BIGINT);
CREATE TABLE Forum_hasMember_Person(creationDate TIMESTAMP, ForumId BIGINT, PersonId BIGINT);
CREATE TABLE Forum_hasModerator_Person(creationDate TIMESTAMP, ForumId BIGINT, PersonId BIGINT);
CREATE TABLE Forum_hasTag_Tag(creationDate TIMESTAMP, ForumId BIGINT, TagId BIGINT);
CREATE TABLE Message(creationDate TIMESTAMP, id BIGINT, locationIP VARCHAR, browserUsed VARCHAR, "content" VARCHAR, length BIGINT, "type" VARCHAR, imageFile VARCHAR, "language" VARCHAR, subcategory BIGINT);
CREATE TABLE Message_hasCreator_Person(creationDate TIMESTAMP, MessageId BIGINT, PersonId BIGINT);
CREATE TABLE Message_hasTag_Tag(creationDate TIMESTAMP, MessageId BIGINT, TagId BIGINT);
CREATE TABLE Message_isLocatedIn_Country(creationDate TIMESTAMP, MessageId BIGINT, CountryId BIGINT);
CREATE TABLE Message_replyOf_Message(creationDate TIMESTAMP, Comment1Id BIGINT, Comment2Id BIGINT);
CREATE TABLE Organisation(id BIGINT, "type" VARCHAR, "name" VARCHAR, url VARCHAR, subcategory BIGINT);
CREATE TABLE Organisation_isLocatedIn_Place(OrganisationId BIGINT, PlaceId BIGINT);
CREATE TABLE Person(creationDate TIMESTAMP, id BIGINT, firstName VARCHAR, lastName VARCHAR, gender VARCHAR, birthday TIMESTAMP, locationIP VARCHAR, browserUsed VARCHAR, "language" VARCHAR, email VARCHAR);
CREATE TABLE Person_hasInterest_Tag(creationDate TIMESTAMP, personId BIGINT, interestId BIGINT);
CREATE TABLE Person_isLocatedIn_City(creationDate TIMESTAMP, PersonId BIGINT, CityId BIGINT);
CREATE TABLE Person_knows_Person(creationDate TIMESTAMP, Person1Id BIGINT, Person2Id BIGINT);
CREATE TABLE Person_likes_Comment(creationDate VARCHAR, PersonId VARCHAR, CommentId VARCHAR);
CREATE TABLE Person_likes_Post(creationDate TIMESTAMP, PersonId BIGINT, PostId BIGINT);
CREATE TABLE Person_studyAt_University(creationDate TIMESTAMP, PersonId BIGINT, UniversityId BIGINT, classYear BIGINT);
CREATE TABLE Person_workAt_Company(creationDate TIMESTAMP, PersonId BIGINT, CompanyId BIGINT, workFrom BIGINT);
CREATE TABLE Place(id BIGINT, "name" VARCHAR, url VARCHAR, "type" VARCHAR, subcategory BIGINT);
CREATE TABLE Place_isPartOf_Place(Place1Id BIGINT, Place2Id BIGINT);
CREATE TABLE Post(creationDate TIMESTAMP, id BIGINT, imageFile VARCHAR, locationIP VARCHAR, browserUsed VARCHAR, "language" VARCHAR, "content" VARCHAR, length BIGINT, "type" VARCHAR DEFAULT('Post'));
CREATE TABLE Post_hasCreator_Person(creationDate TIMESTAMP, PostId BIGINT, PersonId BIGINT);
CREATE TABLE Post_hasTag_Tag(creationDate TIMESTAMP, PostId BIGINT, TagId BIGINT);
CREATE TABLE Post_isLocatedIn_Country(creationDate TIMESTAMP, PostId BIGINT, CountryId BIGINT);
CREATE TABLE Tag(id BIGINT, "name" VARCHAR, url VARCHAR);
CREATE TABLE TagClass(id BIGINT, "name" VARCHAR, url VARCHAR);
CREATE TABLE TagClass_isSubclassOf_TagClass(TagClass1Id BIGINT, TagClass2Id BIGINT);
CREATE TABLE Tag_hasType_TagClass(TagId BIGINT, TagClassId BIGINT);




