Create a Database for Promotions

[hrithik2200]

As a Promotions Manager I need ability to store, create, delete, and update promotions So that I can make necessary changes to keep the promotions up to date.

Details and Assumptions

• This will be a PostgreSQL database.

• The schema should include ID, ProductID, isActive as well as details about the promotions

  Acceptance Criteria

  Given a promotion needs to be included or removed for the store
  When a CRED request is made
  Then the promotions are maintained as a record based on the current requirements of the store

[mingyi850]

Column headers promotion_id(id), promotion_name(string), promotion_description (string), promotion_type(smallint), product_id (int), start_date(datetime) , expiration_date (datetime), promotion_value (int), promotion_code? , created_by (UUID), created_when (datetime), modified_by? (UUID), modified_when? (datetime)

[mingyi850]

Please add your planning poker estimate with Zenhub @anirudh28