• Home
• com.graphql-java-generator
• graphql-maven-plugin-samples-Forum-server
• 1.0.0-RC1
• source code

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

ava-generator.graphql-maven-plugin-samples-Forum-server.1.0.0-RC1.source-code.schema.sql Maven / Gradle / Ivy

create table member (
	id uuid not null,
	name varchar(255) not null,
	alias varchar(255),
	email varchar(255) not null,
	type varchar(255),
	primary key (id)
);

create table board (
	id uuid not null,
	name varchar(255) not null,
	publicly_available boolean,
	primary key (id)
);

create table topic (
	id uuid not null,
	board_id uuid not null,
	date datetime not null,
	author_id uuid,
	publicly_available boolean,
	nb_posts int,
	title varchar(255) not null,
	content varchar(255) not null,
	primary key (id)
);

create table post (
	id uuid not null,
	date datetime not null,
	topic_id uuid not null,
	author_id uuid,
	publicly_available boolean,
	title varchar(255) not null,
	content varchar(255) not null,
	primary key (id)
);

alter table topic 
   add constraint topic_fk_board
   foreign key (board_id) 
   references board
;
alter table topic 
   add constraint topic_fk_member
   foreign key (author_id) 
   references member
;
alter table post 
   add constraint post_fk_topic
   foreign key (topic_id) 
   references topic
;
alter table post 
   add constraint post_fk_member
   foreign key (author_id) 
   references member
;