You are a helpful assistant who can create a step-by-step plan on how to generate rows for datasets

You are provided with:

• A scenario description of an interaction between a user and a chatbot. The entities there represent using symbolic variables
• The descriptions of the symbolic variables
• The relations between the variables
• Restrictions on the variables (according to the company policies)
• The system database with the tables and their schema
• [optional] Tables restrictions.

Assume that the tables are already created and are empty. For the given scenario, come up with a list of rows that should be inserted for the databases. At the end of the list, all the symbolic variables should be defined in the databases.

The execution of this list is done step by step, so you should also determine for each row what information is important and what you should get back for the rest of the steps

Guidelines

• You should assume that all the tables are empty!
• The steps must be self-contained. Provide all the necessary information.
• The retrieved information should be only the minimal information that is needed either for the next steps or for the user to interact with the chatbot.

Example:

Enriched scenario:

User 'U1' which is a gift card holder. Call to modify order R1, and replace product Z1 with product Z2, when the chatbot asks to pay the gap between Z1 and Z2, the user wants to reduce it from the gift card credit

Symbolic variable descriptions:

• U1 a user
• R1 a reservation
• Z1 a product
• Z2 a product

Symbolic relations:

• R1 is a reservation made by U1
• Z1 is a product in R1, which the user ask to remove
• Z2 is a product not in R1 and U1 wants to add it to the order

Variables constraints:

• Reservation R1 must booked within 1 hour of the modification request on 2024-05-15 15:00:00 EST.
• Z2 must be available
• Z2 must cost higher than Z1

Tables schema:

• users: ['user_id', 'name', 'gift_card_credit']
• products: ['product_id', 'name', 'available', 'price']
• order: ['order_id', 'user_id', 'paymant_method', 'cost']

Table constraints:

• If a user is ordering a product with a gift card, the gift_card_credit should be higher than the product price

Result steps:

• Step 1: Table: Users, Row: Generate a user U1 which has a gift card credit Y. Retrieved information: The generated user_id, the name and the git card amount
• Step 2: Table: products. Rows: Generate products Z1 and Z2, Z2 must be available and the differences between the price of Z2 and Z1 must be bigger than 0 and smaller than Y. Retrieved information: Z1 product id and name. Z2 product id and name. The price of Z1.
• Step 3: Table: order. Description: Generate an order R1 which includes product Z1 and does not include product Z2, the cost should be bigger than the price of Z1.

{symbolic_info}

Tables schema:

{tables_schema}