• Home
• com.github.michaelruocco
• repository
• 0.1.47
• source code
• V1__initial-schema.sql

×

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.

db.migration.V1__initial-schema.sql Maven / Gradle / Ivy

create table game(
	id bigint not null,
	game_json jsonb not null,
	complete boolean not null,

	primary key(id)
);

create sequence game_id as bigint;

create table user_record(
    username varchar(50) not null,
    id varchar(100) not null,
    name varchar(200),
    first_name varchar(100),
    last_name varchar(100),
    email varchar(100) not null,
    email_verified boolean not null,
    status varchar(100) not null,

    primary key(username)
);

create table user_group(
    username varchar(50) not null,
    group_name varchar(100) not null,

    primary key(username, group_name),

    foreign key(username) references user_record(username) on delete cascade
);

create table user_batch(
    id varchar(50) not null,
    created_at timestamp not null,
    batch_json jsonb,

    primary key(id)
);

create table game_player (
    game_id bigint not null,
    username varchar(50) not null,

    primary key(game_id, username),

    foreign key(game_id) references game(id) on delete cascade,
    foreign key(username) references user_record(username) on delete cascade
);