m_bussiness{
    bussiness_id int AI (PK)
    bussiness_email varchar(200)
    bussiness_username varchar(150)
    bussiness_password text
    bussiness_user_limit int
    credit_balance int
    deleted int def 0
    created_at timestamp def curr_timestamp
    created_by int
    edited_at datetime def curr_timestamp
    edited_by int
}
m_user{
    user_id int AI (PK)
    bussiness_id int
    username varchar(150)
    password text
    email varchar(150)
    role int (1=admin;2=user;99=superadmin)
    deleted int def 0
    created_at timestamp def curr_timestamp
    created_by int
    edited_at datetime def curr_timestamp
    edited_by int
}
m_credit_price{
    credit_id int AI (PK)
    credit_title int
    credit_price decimal (10,0)
    credit_amount double
    deleted int def 0
    created_at timestamp def curr_timestamp
    created_by int
    edited_at datetime def curr_timestamp
    edited_by int
}
user_tokens{
    id int AI (PK)
    user_id int
    token text,
    expired_at timestamp,
    user_agent text,
    ip_address text,
    expired_at timestamp,
    revoke boolean default false,
    created_at timestamp def curr_timestamp
}
h_chat{
    chat_id int AI (PK)
    chat_title varchar(150)
    deleted int def 0
    created_at timestamp def curr_timestamp
    created_by int
    edited_at datetime def curr_timestamp
    edited_by int
}
h_chat_detail{
    chat_detail_id int AI (PK)
    chat_id int
    question text
    answer text
    query_result text
    input_token int
    output_token int
    deleted int def 0
    created_at timestamp def curr_timestamp
    created_by int
    edited_at datetime def curr_timestamp
    edited_by int
}
h_saved_report{
    report_id int AI (PK)
    report_name varchar(150)
    query text
    filter_type tinyint (0=static;1=dynamic)
    deleted int def 0
    created_at timestamp def curr_timestamp
    created_by int
    edited_at datetime def curr_timestamp
    edited_by int
}
h_saved_report_filter{
    filter_id int AI (PK)
    filter_name varchar(150)
    filter_query text
    deleted int def 0
    created_at timestamp def curr_timestamp
    created_by int
    edited_at datetime def curr_timestamp
    edited_by int
}
h_payment{
    payment_id int AI (PK)
    bussiness_id int
    credit_id int
    credit_amount decimal (10,0)
    credit_price decimal (10,0)
    deleted int def 0
    created_at timestamp def curr_timestamp
    created_by int
    edited_at datetime def curr_timestamp
    edited_by int
}
settings{
    id int AI (PK)
    bussiness_id int
    setting_code varchar(150)
    setting_value text
    deleted int def 0
    created_at timestamp def curr_timestamp
    created_by int
    edited_at datetime def curr_timestamp
    edited_by int
}