Notes

create table users
(
id serial not null,
email varchar(255) not null,
username varchar(255) not null,
password text not null,
credit int default 0 not null,
active bool default true not null,
ads bool default false not null,
last_updated_date timestamp,
creation_date timestamp default now() not null
);

create unique index users_id_uindex
on users (id);

alter table users
add constraint users_pk
primary key (id);


create table login_logs
(
id serial not null,
user_id int not null,
user_agent text not null,
ip_addr varchar(50) not null,
last_updated_date timestamp,
creation_date timestamp default now() not null
);

create unique index login_logs_id_uindex
on login_logs (id);

alter table login_logs
add constraint login_logs_pk
primary key (id);


create table errors
(
id serial not null,
error_id int not null,
function_name varchar(255) not null,
error_message varchar(255) not null,
creation_date timestamp default now() not null
);

create unique index errors_id_uindex
on errors (id);

alter table errors
add constraint errors_pk
primary key (id);

create table numbers
(
id serial not null,
user_id int not null,
number varchar(25) not null,
number_author varchar(255) not null,
follow_value int not null,
active bool default true not null,
finish_date timestamp not null,
last_updated_date timestamp,
creation_date timestamp default now() not null
);

create unique index numbers_id_uindex
on numbers (id);

alter table numbers
add constraint numbers_pk
primary key (id);


create table notifications
(
id serial not null,
author_id int not null,
track_id int not null,
status smallint not null,
last_updated_date timestamp,
creation_date timestamp default now() not null
);

create unique index notifications_id_uindex
on notifications (id);

alter table notifications
add constraint notifications_pk
primary key (id);


create table push_notification_keys
(
id serial not null,
user_id int not null,
notif_key varchar(255) not null,
last_updated_date timestamp,
creation_date timestamp default now() not null
);

create unique index push_notification_keys_id_uindex
on push_notification_keys (id);

alter table push_notification_keys
add constraint push_notification_keys_pk
primary key (id);