supplier_kontak

536 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id int4 10 null
supplier.id supplier_kontak_id_supplier_id_fk R
urut int4 10 null
posisi varchar 20 √ null
nama varchar 100 √ null
nomor_ktp varchar 20 √ null
file_ktp varchar 100 √ null
alamat text 2147483647 √ null
ttd varchar 255 √ null
telepon varchar 20 √ null
created_by int4 10 null
pegawai.id supplier_kontak_created_by_pegawai_id_fk R
created_at timestamp 29,6 √ now()
updated_by int4 10 null
pegawai.id supplier_kontak_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

Indexes

Constraint Name Type Sort Column(s)
supplier_kontak_id_urut_pk Primary key Asc/Asc id + urut

Relationships

Close relationships within degrees of separation