unit

28 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('unit_id_seq'::regclass)
surat_tanda_terima.id_kendaraan surat_tanda_terima_id_kendaraan_unit_id_fk R
no_polisi varchar 2147483647 null
id_driver int4 10 √ null
pegawai.id unit_id_driver_pegawai_id_fk R
created_by int4 10 null
pegawai.id unit_created_by_pegawai_id_fk R
created_at timestamp 29,6 √ now()
updated_by int4 10 null
pegawai.id unit_updated_by_pegawai_id_fk R
updated_at timestamp 29,6 √ now()
deleted_by int4 10 √ null
deleted_at timestamp 29,6 √ null
deleted_reason text 2147483647 ''::text
tipe varchar 2147483647 '-'::character varying
no_polisi_expired date 13 √ null
no_polisi_nilai numeric 0 '0'::numeric
stnk text 2147483647 √ null
stnk_expired date 13 √ null
stnk_nilai numeric 0 '0'::numeric
kir text 2147483647 √ null
kir_expired date 13 √ null
kir_nilai numeric 0 '0'::numeric
lokasi bpchar 4 √ null
reg_regencies.id unit_lokasi_reg_regencies_id_fk R
foto _text 2147483647 √ null
is_pribadi bool 1 false
jenis_bbm varchar 2147483647 √ null
tanggal_pembelian date 13 √ null

Indexes

Constraint Name Type Sort Column(s)
unit_pkey Primary key Asc id
unit_no_polisi_unique Must be unique Asc no_polisi

Relationships

Close relationships within degrees of separation