Advertisement
nubooya

transaksi-pengadaan

Feb 22nd, 2022
5,113
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. CREATE TABLE public.catalog_transaction_header (
  2.     id uuid NOT NULL,
  3.     organization_id uuid NULL,
  4.     transaction_date timestamptz NULL,
  5.     transaction_number VARCHAR(50) NULL,
  6.     transaction_note VARCHAR(250) NULL,
  7.     transaction_amount int4 NULL,
  8.     transfer_date timestamptz NULL,
  9.     bank_name VARCHAR(50) NULL,
  10.     bank_code VARCHAR(5) NULL,
  11.     account_number VARCHAR(15) NULL,
  12.     bank_branch VARCHAR(30) NULL,
  13.     procurement_type_id uuid NULL,
  14.     payment_method_name VARCHAR(25) NULL,
  15.     user_name VARCHAR(30) NULL,
  16.     transaction_disc1 NUMERIC(5, 1) NULL DEFAULT 0,
  17.     transaction_disc2 NUMERIC(5, 1) NULL DEFAULT 0,
  18.     transaction_status uuid NULL,
  19.     activation_date timestamptz NULL,
  20.     created_at timestamptz NOT NULL DEFAULT CURRENT_TIMESTAMP,
  21.     created_by uuid NULL,
  22.     updated_at timestamptz NOT NULL DEFAULT CURRENT_TIMESTAMP,
  23.     updated_by uuid NULL,
  24.     transaction_discount int4 NULL DEFAULT 0,
  25.     user_infos jsonb NULL,
  26.     transaction_type_id uuid NULL,
  27.     transaction_info jsonb NULL,
  28.     transaction_cancel_reason text NULL,
  29.     transaction_cancel_id uuid NULL,
  30.     transaction_cancel_date timestamptz NULL,
  31.     transaction_cancel_user json NULL,
  32.     transaction_donggel jsonb NULL,
  33.     source_of_funds_id uuid NULL,
  34.     transaction_isdonggle bool NULL DEFAULT FALSE,
  35.     package_id uuid NULL,
  36.     CONSTRAINT catalog_transaction_header_pkey PRIMARY KEY (id)
  37. );
  38.  
  39.  
  40. transaction_info
  41. ================
  42. {
  43.   "epustaka": [
  44.     {
  45.       "epustaka_id": "35085d12-1f3e-40d5-b1d1-3a8036c55acc",
  46.       "epustaka_logo": "https://storage.edoo.id/fc7776c4-1bc7-43e7-84a6-3421db2bd5ac/images/epustaka-logo/c46c5e8f-941c-49e4-9d3b-69fc6c629fae.png",
  47.       "epustaka_name": "Universitas Kristen Satya Wacana"
  48.     }
  49.   ],
  50.   "bank_code": "",
  51.   "bank_name": "",
  52.   "total_copy": 258,
  53.   "bank_branch": "",
  54.   "total_catalog": 256,
  55.   "transfer_date": NULL,
  56.   "account_number": "",
  57.   "source_fund_name": "Internal",
  58.   "organization_name": "Universitas Kristen Satya Wacana",
  59.   "duedate_activation": "2021-10-01",
  60.   "payment_method_name": "",
  61.   "profit_sharing_aksara": 8569000,
  62.   "profit_sharing_publisher": 12853500
  63. }
  64.  
  65. -- public.catalog_transaction_detail definition
  66.  
  67. -- Drop table
  68.  
  69. -- DROP TABLE public.catalog_transaction_detail;
  70.  
  71. CREATE TABLE public.catalog_transaction_detail (
  72.     id uuid NOT NULL,
  73.     transaction_id uuid NULL,
  74.     organization_id uuid NULL,
  75.     epustaka_id uuid NULL,
  76.     epustaka_name VARCHAR(200) NULL,
  77.     catalog_id uuid NULL,
  78.     category_id uuid NULL,
  79.     number_of_copy int4 NULL DEFAULT 1,
  80.     catalog_price int4 NULL DEFAULT 0,
  81.     discount_percentage NUMERIC(7, 4) NULL DEFAULT 0,
  82.     discount_amount int4 NULL DEFAULT 0,
  83.     total_amount int4 NULL DEFAULT 0,
  84.     created_at timestamptz NOT NULL DEFAULT CURRENT_TIMESTAMP,
  85.     created_by uuid NULL,
  86.     updated_at timestamptz NOT NULL DEFAULT CURRENT_TIMESTAMP,
  87.     updated_by uuid NULL,
  88.     catalog_info jsonb NULL,
  89.     CONSTRAINT catalog_transaction_detail_pkey PRIMARY KEY (id)
  90. );
  91.  
  92. catalog_info
  93. ============
  94.  
  95. {
  96.   "catalog_sku": "TMP.01861",
  97.   "catalog_isbn": "000-000-000-00-00",
  98.   "catalog_title": "Wajah Asing Bisnis Ecerean di Indonesia",
  99.   "category_name": "Bisnis & Ekonomi",
  100.   "epustaka_name": "KEJARI TANJUNG PINANG",
  101.   "organization_name": "TEMPO Publishing",
  102.   "organization_group_id": "d5b6e9b3-0f62-4656-adfb-8fcba0d574c9",
  103.   "organization_group_name": "Pusat Data dan Analisa Tempo PT"
  104. }
Advertisement
RAW Paste Data Copied
Advertisement