Skip to main content

oclock_sqlite/
schema.rs

1table! {
2    events (id) {
3        id -> Integer,
4        event_timestamp -> Integer,
5        task_id -> Nullable<Integer>,
6        system_event_name -> Nullable<Text>,
7    }
8}
9
10table! {
11    tasks (id) {
12        id -> Integer,
13        enabled -> Integer,
14        name -> Text,
15    }
16}
17
18joinable!(events -> tasks (task_id));
19
20table! {
21    v_timesheet (id) {
22        id -> Integer,
23        day -> Text,
24        task_name -> Nullable<Text>,
25        task_id -> Nullable<Integer>,
26        system_event -> Nullable<Text>,
27        amount -> Integer,
28    }
29}