2 files changed, 36 insertions, 1 deletions

diff --git a/src/models.rs b/src/models.rs
index ce28ac8..fb6122c 100644
--- a/src/models.rs
+++ b/src/models.rs
@@ -1,4 +1,6 @@
-use super::schema::members;
+use super::schema::{members, product};
+
+use bigdecimal::BigDecimal;
 use diesel::{Insertable, Queryable};
 use serde::{Deserialize, Serialize};
 
@@ -19,3 +21,21 @@ pub struct NewMember {
     pub phone_number: String,
     pub email_id: String,
 }
+
+#[derive(Queryable, Serialize)]
+pub struct Product {
+    pub id: i32,
+    pub name: String,
+    pub kind: Option<String>,
+    pub price: f32,
+    pub description: Option<String>,
+}
+
+#[derive(Insertable, Deserialize)]
+#[table_name = "product"]
+pub struct NewProduct {
+    pub name: String,
+    pub kind: Option<String>,
+    pub price: f32,
+    pub description: Option<String>,
+}
diff --git a/src/schema.rs b/src/schema.rs
index 8ed6e58..b6074f2 100644
--- a/src/schema.rs
+++ b/src/schema.rs
@@ -7,3 +7,18 @@ table! {
         email_id -> Varchar,
     }
 }
+
+table! {
+    product (id) {
+        id -> Integer,
+        name -> Varchar,
+        kind -> Nullable<Varchar>,
+        price -> Float,
+        description -> Nullable<Varchar>,
+    }
+}
+
+allow_tables_to_appear_in_same_query!(
+    members,
+    product,
+);