# Benefits schema

## benefits (NoSQL/Document based)

**1. Discount verification modality**

{
    "_id" : ObjectId("5e677e22bbbab58c2ea9ade8"),
    "title" : "Artisan Banani",
    "socials":{
        "facebook": "https://fb.com/page/artisan",
        "instagram": "https://instagram.com/page/artisan"
    },
    "address": "Gulshan 2",
    "map_link": "google.com/map/artisan",
    "levels" : [ 
        "silver", 
        "gold", 
        "platinum"
    ],
    "status" : "active",
    "city" : [ 
        "dhaka"
    ],
    "partner_type" : "Clothing",
    "benefit_type": "percentage",
    "benefit_modality" : {
        "platinum": {
            "amount" : NumberLong(20),
            "maxDiscountAmount" : NumberLong(100000000),
            "shortDescription" : "20% discount",
            "description" : "enjoy 20% discount....",
            
        }, 
        "gold": {
            "amount" : NumberLong(10),
            "maxDiscountAmount" : NumberLong(100000000),
            "shortDescription" : "10% discount",
            "description" : "enjoy 10% discount....",
        }, 
        "silver": {
            "amount" : NumberLong(5),
            "maxDiscountAmount" : NumberLong(100000000),
            "shortDescription" : "5% discount",
            "description" : "enjoy 5% discount....",
        }
    },
    "partnerMobileNumber" : "01731375076",
    "visibility" : true,
    "thumbnailUrl" : "https://quicksilver-qa.pathaopay.xyz/images/sampleImage.jpeg",
    "bannerUrl" : "https://quicksilver-qa.pathaopay.xyz/images/sampleImage.jpeg",
    "coverImageURL" : "https://quicksilver-qa.pathaopay.xyz/images/sampleImage.jpeg",
    "shortDescription" : "Upto 20% discount",
    "description" : "Upto 5% for Silver, 10% for Gold, 20% for Platinum users",
    "createdBy" : "Mishu",
    "expiresAt" : ISODate("2021-04-06T00:33:29.000Z"),
    "createdAt" : ISODate("2020-02-23T11:31:58.006Z"),
    "updatedAt" : ISODate("2020-02-23T11:31:58.006Z")
}

**2. Tier verification modality**

{
    "_id" : ObjectId("5e677e22bbbab58c2ea9ade8"),
    "title" : "Artisan Banani",
    "socials":{
        "facebook": "https://fb.com/page/artisan",
        "instagram": "https://instagram.com/page/artisan"
    },
    "address": "Gulshan 2",
    "map_link": "google.com/map/artisan",
    "level" : [ 
        "silver", 
        "gold", 
        "platinum"
    ],
    "status" : "active",
    "city" : [ 
        "dhaka"
    ],
    "partner_type" : "Clothing",
    "benefit_type": "verification",
    "benefit_modality" : {
        "platinum": {
            "shortDescription" : "enjoy tier verification benefit for platinum",
            "description" :"enjoy tier verification benefit for platinum....",
            
        }, 
        "gold": {
            "shortDescription" : "enjoy tier verification benefit for platinum",
            "description" :"enjoy tier verification benefit for platinum....",
        }, 
        "silver": {
            "shortDescription" : "enjoy tier verification benefit for platinum",
            "description" :"enjoy tier verification benefit for platinum....",
        }
    },
    "partnerMobileNumber" : "01731375076",
    "visibility" : true,
    "thumbnailUrl" : "https://quicksilver-qa.pathaopay.xyz/images/sampleImage.jpeg",
    "bannerUrl" : "https://quicksilver-qa.pathaopay.xyz/images/sampleImage.jpeg",
    "coverImageURL" : "https://quicksilver-qa.pathaopay.xyz/images/sampleImage.jpeg",
    "shortDescription" : "Upto 20% discount",
    "description" : "Upto 5% for Silver, 10% for Gold, 20% for Platinum users",
    "createdBy" : "Mishu",
    "expiresAt" : ISODate("2021-04-06T00:33:29.000Z"),
    "createdAt" : ISODate("2020-02-23T11:31:58.006Z"),
    "updatedAt" : ISODate("2020-02-23T11:31:58.006Z")
}

## benefit_transaction_logs (SQL/Relational DB)
1. id [uint, primary, auto-increment]
1. pocket_id [varchar]
1. benefit_id [varchar]
2. benefit_type [varchar] (tier/discount)
3. amount
4. discount_amount
5. note [varchar] (for additional meta info)
6. created_at [timestampz]