oclock_sqlite 0.1.5

Time tracking utility (sqlite component)
Documentation 
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

table! {
    events (id) {
        id -> Integer,
        event_timestamp -> Integer,
        task_id -> Nullable<Integer>,
        system_event_name -> Nullable<Text>,
    }
}

table! {
    tasks (id) {
        id -> Integer,
        enabled -> Integer,
        name -> Text,
    }
}

joinable!(events -> tasks (task_id));

table! {
    v_timesheet (id) {
        id -> Integer,
        day -> Text,
        task_name -> Nullable<Text>,
        task_id -> Nullable<Integer>,
        system_event -> Nullable<Text>,
        amount -> Integer,
    }
}