Query Create Table ms_mhs on Postgres

CREATE TABLE ms_mhs
(
  id_reg_pd uuid NOT NULL DEFAULT uuid_generate_v4(),
  id_pd uuid NOT NULL,
  nipd character varying(18) NOT NULL,
  nm_pd character varying(60),
  jk character(1) NOT NULL,
  nisn character(10),
  nik character(16),
  tmpt_lahir character varying(32),
  tgl_lahir date NOT NULL,
  id_agama smallint NOT NULL,
  id_kk integer NOT NULL,
  jln character varying(80),
  rt numeric(2,0),
  rw numeric(2,0),
  nm_dsn character varying(50),
  ds_kel character varying(50) NOT NULL,
  id_wil character(8) NOT NULL,
  kode_pos character(5),
  id_jns_tinggal numeric(2,0),
  id_alat_transport numeric(2,0),
  telepon_rumah character varying(20),
  telepon_seluler character varying(20),
  email character varying(50),
  a_terima_kps numeric(1,0) NOT NULL,
  no_kps character varying(40),
  stat_pd character(1) NOT NULL,
  nm_ayah character varying(60),
  tgl_lahir_ayah date,
  id_jenjang_pendidikan_ayah numeric(2,0),
  id_pekerjaan_ayah integer,
  id_penghasilan_ayah integer,
  id_kebutuhan_khusus_ayah integer NOT NULL,
  nm_ibu_kandung character varying(60) NOT NULL,
  tgl_lahir_ibu date,
  id_jenjang_pendidikan_ibu numeric(2,0),
  id_penghasilan_ibu integer,
  id_pekerjaan_ibu integer,
  id_kebutuhan_khusus_ibu integer NOT NULL,
  nm_wali character varying(30),
  tgl_lahir_wali date,
  id_jenjang_pendidikan_wali numeric(2,0),
  id_pekerjaan_wali integer,
  id_penghasilan_wali integer,
  kewarganegaraan character(2) NOT NULL,
  id_sms uuid NOT NULL,
  id_sp uuid NOT NULL,
  id_jns_daftar numeric(1,0) NOT NULL,
  tgl_masuk_sp date NOT NULL,
  id_jns_keluar character(1),
  tgl_keluar date,
  ket character varying(128),
  skhun character(20),
  a_pernah_paud numeric(1,0) NOT NULL DEFAULT 0,
  a_pernah_tk numeric(1,0) NOT NULL DEFAULT 0,
  mulai_smt character varying(5),
  sks_diakui numeric(3,0),
  jalur_skripsi numeric(1,0),
  judul_skripsi character varying(250),
  bln_awal_bimbingan date,
  bln_akhir_bimbingan date,
  sk_yudisium character varying(40),
  tgl_sk_yudisium date,
  ipk double precision,
  no_seri_ijazah character varying(40),
  sert_prof character varying(40),
  a_pindah_mhs_asing numeric(1,0),
  nm_pt_asal character varying(50),
  nm_prodi_asal character varying(50)
)