File name
Commit message
Commit date
File name
Commit message
Commit date
File name
Commit message
Commit date
File name
Commit message
Commit date
File name
Commit message
Commit date
File name
Commit message
Commit date
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);