setting_persetujuan

34 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('setting_persetujuan_id_seq'::regclass)
module varchar 2147483647 null
created_by int4 10 null
pegawai.id setting_persetujuan_created_by_pegawai_id_fk R
created_at timestamp 29,6 √ now()
updated_by int4 10 null
pegawai.id setting_persetujuan_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
nama varchar 2147483647 null
id_pegawai_1 int4 10 null
pegawai.id setting_persetujuan_id_pegawai_1_pegawai_id_fk R
id_pegawai_2 int4 10 √ null
pegawai.id setting_persetujuan_id_pegawai_2_pegawai_id_fk R
id_pegawai_3 int4 10 √ null
pegawai.id setting_persetujuan_id_pegawai_3_pegawai_id_fk R
keterangan varchar 2147483647 null
is_active bool 1 true
metode char 1 √ 'T'::"char"

Indexes

Constraint Name Type Sort Column(s)
setting_persetujuan_pkey Primary key Asc id
setting_persetujuan_module_unique Must be unique Asc module
setting_persetujuan_nama_unique Must be unique Asc nama

Relationships

Close relationships within degrees of separation