I have three entities: A, B, and C.
Currently, each one uses a separate sequence for ID generation (seq_A, seq_B, seq_C).
I want all three entities to either share a single common sequence or ensure that the IDs never overlap across A, B, and C.
How can I configure so that A, B, and C either use a shared sequence or generate globally unique IDs?
(i dont want use:
CREATE SEQUENCE seq_a START WITH 1 INCREMENT BY 3;
CREATE SEQUENCE seq_b START WITH 2 INCREMENT BY 3;
CREATE SEQUENCE seq_c START WITH 3 INCREMENT BY 3;
Because table A,B,C have data.
I want 3 tables to share 1 seq (seq has the largest current value)
)