jabatan

39 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('jabatan_id_seq'::regclass)
jabatan.atasan jabatan_atasan_jabatan_id_fk N
name varchar 255 null
is_head_departemen bool 1 √ false
atasan int4 10 √ null
jabatan.id jabatan_atasan_jabatan_id_fk N
created_by int4 10 null
pegawai.id jabatan_created_by_pegawai_id_fk R
created_at timestamp 29,6 √ now()
updated_by int4 10 null
pegawai.id jabatan_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)
jabatan_pkey Primary key Asc id
jabatan_name_unique Must be unique Asc name

Relationships

Close relationships within degrees of separation