crab_rocket_schema/
schema.rs

1// @generated automatically by Diesel CLI.
2
3diesel::table! {
4    department_table (department_id) {
5        department_id -> Int4,
6        #[max_length = 255]
7        department_name -> Varchar,
8        manager_id -> Nullable<Int4>,
9        #[max_length = 255]
10        location -> Nullable<Varchar>,
11        creation_date -> Nullable<Timestamp>,
12        last_update -> Nullable<Timestamp>,
13        #[max_length = 255]
14        description -> Nullable<Varchar>,
15        budget -> Nullable<Int4>,
16        number_of_employees -> Nullable<Int4>,
17        parent_department_id -> Nullable<Int4>,
18        #[max_length = 255]
19        email -> Nullable<Varchar>,
20        #[max_length = 255]
21        phone_number -> Nullable<Varchar>,
22        #[max_length = 255]
23        address -> Nullable<Varchar>,
24        #[max_length = 255]
25        city -> Nullable<Varchar>,
26        #[max_length = 255]
27        state -> Nullable<Varchar>,
28        #[max_length = 255]
29        postal_code -> Nullable<Varchar>,
30    }
31}
32
33diesel::table! {
34    employee_table (employee_id) {
35        employee_id -> Int4,
36        #[max_length = 255]
37        first_name -> Nullable<Varchar>,
38        #[max_length = 255]
39        last_name -> Nullable<Varchar>,
40        #[max_length = 255]
41        employee_name -> Varchar,
42        #[max_length = 255]
43        gender -> Nullable<Varchar>,
44        date_of_birth -> Nullable<Timestamp>,
45        hire_date -> Nullable<Timestamp>,
46        #[max_length = 255]
47        email -> Nullable<Varchar>,
48        #[max_length = 255]
49        phone_number -> Nullable<Varchar>,
50        department_id -> Nullable<Int4>,
51        #[max_length = 255]
52        job_title -> Nullable<Varchar>,
53        salary -> Nullable<Int4>,
54        manager_id -> Nullable<Int4>,
55        #[max_length = 255]
56        address -> Nullable<Varchar>,
57        #[max_length = 255]
58        city -> Nullable<Varchar>,
59        #[max_length = 255]
60        state -> Nullable<Varchar>,
61        #[max_length = 255]
62        postal_code -> Nullable<Varchar>,
63        valid -> Nullable<Bool>,
64        last_update -> Nullable<Timestamp>,
65        #[max_length = 255]
66        role_name -> Nullable<Varchar>,
67        role_id -> Nullable<Int4>,
68    }
69}
70
71diesel::table! {
72    file_table (id) {
73        id -> Uuid,
74        file_name -> Varchar,
75        file_url -> Varchar,
76        uploaded_at -> Nullable<Timestamp>,
77    }
78}
79
80diesel::table! {
81    follows (follow_id) {
82        following_user_id -> Int4,
83        followed_user_id -> Int4,
84        created_at -> Nullable<Timestamp>,
85        follow_id -> Int4,
86    }
87}
88
89diesel::table! {
90    permission_table (id) {
91        id -> Int4,
92        #[max_length = 255]
93        permission_name -> Varchar,
94        permission_description -> Nullable<Text>,
95        #[max_length = 255]
96        resource -> Varchar,
97        #[max_length = 50]
98        action -> Varchar,
99        is_active -> Nullable<Bool>,
100        created_at -> Nullable<Timestamp>,
101        updated_at -> Nullable<Timestamp>,
102        #[max_length = 255]
103        created_by -> Nullable<Varchar>,
104        #[max_length = 255]
105        updated_by -> Nullable<Varchar>,
106        notes -> Nullable<Text>,
107    }
108}
109
110diesel::table! {
111    posts (post_id) {
112        post_id -> Int4,
113        #[max_length = 255]
114        title -> Nullable<Varchar>,
115        body -> Nullable<Text>,
116        user_id -> Nullable<Int4>,
117        #[max_length = 255]
118        status -> Nullable<Varchar>,
119        created_at -> Nullable<Timestamp>,
120        updated_at -> Nullable<Timestamp>,
121        #[max_length = 255]
122        username -> Nullable<Varchar>,
123    }
124}
125
126diesel::table! {
127    role_table (role_id) {
128        role_id -> Int4,
129        #[max_length = 255]
130        role_name -> Varchar,
131        #[max_length = 255]
132        description -> Nullable<Varchar>,
133        #[max_length = 255]
134        permissions -> Nullable<Varchar>,
135        created_at -> Nullable<Timestamp>,
136        updated_at -> Nullable<Timestamp>,
137    }
138}
139
140diesel::table! {
141    tasks (id) {
142        id -> Int4,
143        title -> Text,
144        content -> Nullable<Text>,
145        created_at -> Nullable<Timestamp>,
146        updated_at -> Nullable<Timestamp>,
147        user_id -> Nullable<Int4>,
148    }
149}
150
151diesel::table! {
152    user_table (user_id) {
153        user_id -> Int4,
154        #[max_length = 255]
155        username -> Varchar,
156        role_id -> Nullable<Int4>,
157        created_at -> Nullable<Timestamp>,
158        #[max_length = 255]
159        email -> Nullable<Varchar>,
160        #[max_length = 255]
161        password -> Varchar,
162        #[max_length = 255]
163        fullname -> Nullable<Varchar>,
164        #[max_length = 255]
165        avatar_url -> Nullable<Varchar>,
166        bio -> Nullable<Text>,
167        updated_at -> Nullable<Timestamp>,
168        #[max_length = 255]
169        mobile_phone -> Varchar,
170    }
171}
172
173diesel::joinable!(tasks -> user_table (user_id));
174diesel::joinable!(user_table -> role_table (role_id));
175
176diesel::allow_tables_to_appear_in_same_query!(
177    department_table,
178    employee_table,
179    file_table,
180    follows,
181    permission_table,
182    posts,
183    role_table,
184    tasks,
185    user_table,
186);
crab_rocket_schema/schema.rs

crab_rocket_schema/
schema.rs
