OpenAI Batch API呼び出しに使用するクイックSQLによる表定義

openai-batch-schema.quicksql

# prefix: openai
# genpk: no
batch_submissions
    submission_id /pk
    input_file_id     vc80
    endpoint          vc80
    completion_window vc8
    request_file      blob
    batch_object      json
    batch_id          vc80 -- value in batch_object
    output_file_id    vc80 -- value in batch_object
    status            vc20 -- value in batch_object
    response_file     blob
    error_file_id     vc80
    error_file        blob

batch_requests
    custom_id /pk
    submission_id /nn /fk batch_submissions
    method   vc8 /default POST
    url      vc80
    body     json

batch_responses /pk id
    id vc80 /nn
    custom_id /fk batch_requests
    response      json
    status_code   num
    request_id    vc80
    body          json
    first_message clob