schema.sql

-- auto-generated definition
create table location
(
    id       serial
        constraint location_pk
            primary key,
    lat_long geography,
    name     text,
    address  text,
    city     text,
    state    text
);

alter table location
    owner to dramus;

-- auto-generated definition
create table users
(
    id       integer not null
        constraint users_pk
            primary key,
    password text
);

alter table users
    owner to dramus;

-- auto-generated definition
create table attendee
(
    id    serial
        constraint attendee_pk
            primary key
        constraint attendee_users_id_fk
            references users
            on delete set null,
    email text not null
        constraint attendee_pk_2
            unique,
    name  text
);

alter table attendee
    owner to dramus;

-- auto-generated definition
create table event
(
    id          serial
        constraint event_pk
            primary key,
    name        text,
    location_id integer
        constraint event_location_id_fk
            references location
            on delete set null,
    event_date  tstzrange
);

alter table event
    owner to dramus;

-- auto-generated definition
create table event_attendee
(
    attendee_id integer not null
        constraint event_attendee_attendee_id_fk
            references attendee
            on delete cascade,
    event_id    integer not null
        constraint event_attendee_event_id_fk
            references event
            on delete cascade,
    constraint event_attendee_pk
        primary key (attendee_id, event_id)
);

alter table event_attendee
    owner to dramus;