-
Notifications
You must be signed in to change notification settings - Fork 0
/
000001_init.up.sql
33 lines (29 loc) · 969 Bytes
/
000001_init.up.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
-- create database price_bot;
create table users
(
id serial primary key,
chat_id bigint not null,
user_name varchar,
first_name varchar,
last_name varchar,
description varchar,
chat_type varchar not null default 'private',
photo varchar,
title varchar,
all_members_are_admins boolean,
invite_link varchar,
created_at timestamp with time zone,
updated_at timestamp with time zone
);
create table price_alerts
(
id serial primary key,
user_id int not null,
ticker varchar not null,
create_price decimal not null,
alert_price decimal not null,
created_at timestamp with time zone,
constraint fk_price_alerts__user_id_on_users__id
foreign key (user_id)
references users
);