transaksi-pengadaan

CREATE TABLE public.catalog_transaction_header (
    id uuid NOT NULL,
    organization_id uuid NULL,
    transaction_date timestamptz NULL,
    transaction_number VARCHAR(50) NULL,
    transaction_note VARCHAR(250) NULL,
    transaction_amount int4 NULL,
    transfer_date timestamptz NULL,
    bank_name VARCHAR(50) NULL,
    bank_code VARCHAR(5) NULL,
    account_number VARCHAR(15) NULL,
    bank_branch VARCHAR(30) NULL,
    procurement_type_id uuid NULL,
    payment_method_name VARCHAR(25) NULL,
    user_name VARCHAR(30) NULL,
    transaction_disc1 NUMERIC(5, 1) NULL DEFAULT 0,
    transaction_disc2 NUMERIC(5, 1) NULL DEFAULT 0,
    transaction_status uuid NULL,
    activation_date 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,
    transaction_discount int4 NULL DEFAULT 0,
    user_infos jsonb NULL,
    transaction_type_id uuid NULL,
    transaction_info jsonb NULL,
    transaction_cancel_reason text NULL,
    transaction_cancel_id uuid NULL,
    transaction_cancel_date timestamptz NULL,
    transaction_cancel_user json NULL,
    transaction_donggel jsonb NULL,
    source_of_funds_id uuid NULL,
    transaction_isdonggle bool NULL DEFAULT FALSE,
    package_id uuid NULL,
    CONSTRAINT catalog_transaction_header_pkey PRIMARY KEY (id)
);


transaction_info
================
{
  "epustaka": [
    {
      "epustaka_id": "35085d12-1f3e-40d5-b1d1-3a8036c55acc",
      "epustaka_logo": "https://storage.edoo.id/fc7776c4-1bc7-43e7-84a6-3421db2bd5ac/images/epustaka-logo/c46c5e8f-941c-49e4-9d3b-69fc6c629fae.png",
      "epustaka_name": "Universitas Kristen Satya Wacana"
    }
  ],
  "bank_code": "",
  "bank_name": "",
  "total_copy": 258,
  "bank_branch": "",
  "total_catalog": 256,
  "transfer_date": NULL,
  "account_number": "",
  "source_fund_name": "Internal",
  "organization_name": "Universitas Kristen Satya Wacana",
  "duedate_activation": "2021-10-01",
  "payment_method_name": "",
  "profit_sharing_aksara": 8569000,
  "profit_sharing_publisher": 12853500
}

-- public.catalog_transaction_detail definition

-- Drop table

-- DROP TABLE public.catalog_transaction_detail;

CREATE TABLE public.catalog_transaction_detail (
    id uuid NOT NULL,
    transaction_id uuid NULL,
    organization_id uuid NULL,
    epustaka_id uuid NULL,
    epustaka_name VARCHAR(200) NULL,
    catalog_id uuid NULL,
    category_id uuid NULL,
    number_of_copy int4 NULL DEFAULT 1,
    catalog_price int4 NULL DEFAULT 0,
    discount_percentage NUMERIC(7, 4) NULL DEFAULT 0,
    discount_amount int4 NULL DEFAULT 0,
    total_amount int4 NULL DEFAULT 0,
    created_at timestamptz NOT NULL DEFAULT CURRENT_TIMESTAMP,
    created_by uuid NULL,
    updated_at timestamptz NOT NULL DEFAULT CURRENT_TIMESTAMP,
    updated_by uuid NULL,
    catalog_info jsonb NULL,
    CONSTRAINT catalog_transaction_detail_pkey PRIMARY KEY (id)
);

catalog_info
============

{
  "catalog_sku": "TMP.01861",
  "catalog_isbn": "000-000-000-00-00",
  "catalog_title": "Wajah Asing Bisnis Ecerean di Indonesia",
  "category_name": "Bisnis & Ekonomi",
  "epustaka_name": "KEJARI TANJUNG PINANG",
  "organization_name": "TEMPO Publishing",
  "organization_group_id": "d5b6e9b3-0f62-4656-adfb-8fcba0d574c9",
  "organization_group_name": "Pusat Data dan Analisa Tempo PT"
}