create table organization ( id bigserial primary key, org_no varchar(10) not null, org_name varchar(200) not null, channel_slug varchar(40) not null, dept_name varchar(200), manager_name varchar(100), manager_title varchar(100), manager_phone varchar(50), manager_email varchar(200), channel_id_mj varchar(40), channel_id_law varchar(40), created_at timestamptz not null default now(), updated_at timestamptz not null default now(), constraint uq_organization_no_name unique (org_no, org_name) ); create index ix_organization_org_no on organization (org_no);