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);
