Skip to main content

plm_rs/
schema.rs

1use diesel::table;
2
3table! {
4    builds (id) {
5        id -> Integer,
6        created_at -> Timestamp,
7        updated_at -> Timestamp,
8        estimated_completion -> Timestamp,
9        quantity -> Integer,
10        cost -> Nullable<Float>,
11        complete -> Integer,
12        notes -> Nullable<Text>,
13        part_ver -> Integer,
14        part_id -> Integer,
15    }
16}
17
18table! {
19    inventories (id) {
20        id -> Integer,
21        created_at -> Timestamp,
22        updated_at -> Timestamp,
23        quantity -> Integer,
24        consumed -> Integer,
25        unit_price -> Nullable<Float>,
26        notes -> Nullable<Text>,
27        part_ver -> Integer,
28        part_id -> Integer,
29    }
30}
31
32table! {
33    parts (id) {
34        id -> Integer,
35        created_at -> Timestamp,
36        updated_at -> Timestamp,
37        pn -> Text,
38        mpn -> Text,
39        digikeypn -> Nullable<Text>,
40        descr -> Text,
41        ver -> Integer,
42        val -> Nullable<Text>,
43        mqty -> Integer,
44    }
45}
46
47table! {
48    parts_parts (id) {
49        id -> Integer,
50        created_at -> Timestamp,
51        updated_at -> Timestamp,
52        quantity -> Integer,
53        bom_ver -> Integer,
54        refdes -> Text,
55        nostuff -> Integer,
56        bom_part_id -> Integer,
57        part_id -> Integer,
58    }
59}
60
61joinable!(builds -> parts (part_id));
62joinable!(inventories -> parts (part_id));
63
64allow_tables_to_appear_in_same_query!(builds, inventories, parts, parts_parts,);