organizations

-- public.organization_groups definition

-- Drop table

-- DROP TABLE public.organization_groups;

CREATE TABLE public.organization_groups (
    id uuid NOT NULL,
    organization_group_name VARCHAR(150) NULL,
    organization_group_address VARCHAR(255) NULL,
    organization_group_email VARCHAR(255) NULL,
    organization_group_website VARCHAR(255) NULL,
    organization_group_logo VARCHAR(255) NULL,
    organization_group_about text NULL,
    organization_group_phone VARCHAR(50) NULL,
    organization_group_fax VARCHAR(50) NULL,
    organization_group_head VARCHAR(50) NULL,
    organization_group_status int4 NULL,
    organization_group_ppn int4 NULL DEFAULT 1,
    organization_group_npwp VARCHAR(15) NULL,
    organization_group_npwp_address VARCHAR(200) NULL,
    organization_group_content jsonb NULL,
    organization_group_profiltsharing jsonb NULL,
    organization_group_isactive int4 NULL DEFAULT 1,
    org_type_id uuid NULL,
    village_id uuid NULL,
    postalcode bpchar(5) NULL,
    organization_group_procurement jsonb NULL,
    deleted_at timestamptz NULL,
    created_at timestamptz NOT NULL DEFAULT CURRENT_TIMESTAMP,
    created_by uuid NULL,
    updated_at timestamptz NOT NULL DEFAULT CURRENT_TIMESTAMP,
    updated_by uuid NULL,
    organization_group_info jsonb NULL,
    organization_group_type uuid NULL,
    organization_group_profitsharing jsonb NULL,
    CONSTRAINT organization_groups_pkey PRIMARY KEY (id)
);

-- public.organizations definition

-- Drop table

-- DROP TABLE public.organizations;

CREATE TABLE public.organizations (
    id uuid NOT NULL,
    organization_code VARCHAR(4) NULL,
    organization_name VARCHAR(150) NOT NULL,
    organization_address VARCHAR(255) NULL,
    organization_logo VARCHAR(200) NULL,
    organization_phone VARCHAR(50) NULL,
    organization_fax VARCHAR(50) NULL,
    organization_email VARCHAR(255) NULL,
    organization_website VARCHAR(100) NULL,
    organization_about text NULL,
    organization_isactive int4 NULL DEFAULT 1,
    organization_delete_at timestamptz NULL,
    organization_ppn int4 NULL DEFAULT 1,
    organization_npwp VARCHAR(15) NULL,
    organization_npwp_address VARCHAR(200) NULL,
    organization_group_id uuid NULL,
    regency_id uuid NULL,
    org_type_id uuid NULL,
    village_id uuid NULL,
    postalcode bpchar(5) NULL,
    deleted_at timestamptz NULL,
    created_at timestamptz NOT NULL DEFAULT CURRENT_TIMESTAMP,
    created_by uuid NULL,
    updated_at timestamptz NOT NULL DEFAULT CURRENT_TIMESTAMP,
    updated_by uuid NULL,
    app_id uuid NULL,
    CONSTRAINT organizations_pkey PRIMARY KEY (id)
);