#5081·go-zero

goctl model pg "missing primary key"

Author: duanmingze-coderCreated Aug 12, 2025Updated Aug 17, 2026
Labelsstalearea/goctlarea/orm

user goctl model create code, return err

ddl:

create table if not exists order ( order_id int, transaction_id varchar(32), wallet_tx_id int, user_id int, round_id varchar(32), parent_round_id varchar(32), amount int, rtp smallint, status smallint, response smallint, settle_time int, created_at int, updated_at int, -- Table-level constraints constraint pk_order_id primary key (order_id, settle_time), constraint uk_transaction_id unique (transaction_id, settle_time) include (status,amount, user_id) ) partition by range (settle_time);

create index if not exists idx_round_time on order (round_id, settle_time); create index if not exists idx_parent_round_time on order (parent_round_id, settle_time);

goctl erro

db:public, table:bet_order, missing primary key