gistfile1.sql

CREATE TABLE places (
    id integer NOT NULL,
    address character varying(255) NOT NULL,
    name character varying(255) NOT NULL,
    city character varying(255) NOT NULL,
    description character varying(255) NOT NULL,
);

CREATE TABLE meetings (
    id integer NOT NULL,
    title character varying(255) NOT NULL,
    start_at timestamp without time zone NOT NULL,
    end_at timestamp without time zone NOT NULL,
    place_id integer NOT NULL,
);


CREATE TABLE participations (
    id integer NOT NULL,
    player_id integer,
    meeting_id integer,
);


CREATE TABLE players (
    id integer NOT NULL,
    first_name character varying(255) NOT NULL,
    last_name character varying(255) NOT NULL,
    city character varying(255) NOT NULL,
    gear character varying(255),
    email character varying(255) NOT NULL,
    password_digest character varying(255) NOT NULL,
);