Advertisement
nubooya

organizations

Feb 22nd, 2022
5,207
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. -- public.organization_groups definition
  2.  
  3. -- Drop table
  4.  
  5. -- DROP TABLE public.organization_groups;
  6.  
  7. CREATE TABLE public.organization_groups (
  8.     id uuid NOT NULL,
  9.     organization_group_name VARCHAR(150) NULL,
  10.     organization_group_address VARCHAR(255) NULL,
  11.     organization_group_email VARCHAR(255) NULL,
  12.     organization_group_website VARCHAR(255) NULL,
  13.     organization_group_logo VARCHAR(255) NULL,
  14.     organization_group_about text NULL,
  15.     organization_group_phone VARCHAR(50) NULL,
  16.     organization_group_fax VARCHAR(50) NULL,
  17.     organization_group_head VARCHAR(50) NULL,
  18.     organization_group_status int4 NULL,
  19.     organization_group_ppn int4 NULL DEFAULT 1,
  20.     organization_group_npwp VARCHAR(15) NULL,
  21.     organization_group_npwp_address VARCHAR(200) NULL,
  22.     organization_group_content jsonb NULL,
  23.     organization_group_profiltsharing jsonb NULL,
  24.     organization_group_isactive int4 NULL DEFAULT 1,
  25.     org_type_id uuid NULL,
  26.     village_id uuid NULL,
  27.     postalcode bpchar(5) NULL,
  28.     organization_group_procurement jsonb NULL,
  29.     deleted_at timestamptz NULL,
  30.     created_at timestamptz NOT NULL DEFAULT CURRENT_TIMESTAMP,
  31.     created_by uuid NULL,
  32.     updated_at timestamptz NOT NULL DEFAULT CURRENT_TIMESTAMP,
  33.     updated_by uuid NULL,
  34.     organization_group_info jsonb NULL,
  35.     organization_group_type uuid NULL,
  36.     organization_group_profitsharing jsonb NULL,
  37.     CONSTRAINT organization_groups_pkey PRIMARY KEY (id)
  38. );
  39.  
  40. -- public.organizations definition
  41.  
  42. -- Drop table
  43.  
  44. -- DROP TABLE public.organizations;
  45.  
  46. CREATE TABLE public.organizations (
  47.     id uuid NOT NULL,
  48.     organization_code VARCHAR(4) NULL,
  49.     organization_name VARCHAR(150) NOT NULL,
  50.     organization_address VARCHAR(255) NULL,
  51.     organization_logo VARCHAR(200) NULL,
  52.     organization_phone VARCHAR(50) NULL,
  53.     organization_fax VARCHAR(50) NULL,
  54.     organization_email VARCHAR(255) NULL,
  55.     organization_website VARCHAR(100) NULL,
  56.     organization_about text NULL,
  57.     organization_isactive int4 NULL DEFAULT 1,
  58.     organization_delete_at timestamptz NULL,
  59.     organization_ppn int4 NULL DEFAULT 1,
  60.     organization_npwp VARCHAR(15) NULL,
  61.     organization_npwp_address VARCHAR(200) NULL,
  62.     organization_group_id uuid NULL,
  63.     regency_id uuid NULL,
  64.     org_type_id uuid NULL,
  65.     village_id uuid NULL,
  66.     postalcode bpchar(5) NULL,
  67.     deleted_at timestamptz NULL,
  68.     created_at timestamptz NOT NULL DEFAULT CURRENT_TIMESTAMP,
  69.     created_by uuid NULL,
  70.     updated_at timestamptz NOT NULL DEFAULT CURRENT_TIMESTAMP,
  71.     updated_by uuid NULL,
  72.     app_id uuid NULL,
  73.     CONSTRAINT organizations_pkey PRIMARY KEY (id)
  74. );
Advertisement
RAW Paste Data Copied
Advertisement