35 constexpr static const char* schema =
"public";
36 constexpr static const char* tablename =
"ores_trading_commodity_instruments_tbl";
38 sqlgen::PrimaryKey<std::string> id;
39 std::string tenant_id;
41 std::string trade_type_code;
42 std::string commodity_code;
44 double quantity = 0.0;
46 std::optional<std::string> start_date;
47 std::optional<std::string> maturity_date;
48 std::optional<double> fixed_price;
49 std::optional<std::string> option_type;
50 std::optional<double> strike_price;
51 std::optional<std::string> exercise_type;
52 std::optional<std::string> average_type;
53 std::optional<std::string> averaging_start_date;
54 std::optional<std::string> averaging_end_date;
55 std::optional<std::string> spread_commodity_code;
56 std::optional<double> spread_amount;
57 std::optional<std::string> strip_frequency_code;
58 std::optional<double> variance_strike;
59 std::optional<double> accumulation_amount;
60 std::optional<double> knock_out_barrier;
61 std::optional<std::string> barrier_type;
62 std::optional<double> lower_barrier;
63 std::optional<double> upper_barrier;
64 std::optional<std::string> basket_json;
65 std::optional<std::string> day_count_code;
66 std::optional<std::string> payment_frequency_code;
67 std::optional<std::string> swaption_expiry_date;
68 std::optional<std::string> description;
69 std::string modified_by;
70 std::string performed_by;
71 std::string change_reason_code;
72 std::string change_commentary;
73 std::optional<sqlgen::Timestamp<
"%Y-%m-%d %H:%M:%S">> valid_from =
"9999-12-31 23:59:59";
74 std::optional<sqlgen::Timestamp<
"%Y-%m-%d %H:%M:%S">> valid_to =
"9999-12-31 23:59:59";