Codex
14 lines
437 B
SQL
14 lines
437 B
SQL
create table if not exists research_council_links (
|
|
id bigserial primary key,
|
|
run_id bigint not null,
|
|
trading_plan_id bigint null,
|
|
candidate_id bigint null,
|
|
signal_id bigint null,
|
|
decision_packet_id bigint null,
|
|
execution_ticket_id bigint null,
|
|
created_ts timestamptz not null
|
|
);
|
|
|
|
create index if not exists idx_research_council_links_run
|
|
on research_council_links (run_id, created_ts desc, id desc);
|