expense_type

3 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('expense_type_id_seq'::regclass)
realisasi_stt_detail.id_expense_type realisasi_stt_detail_id_expense_type_expense_type_id_fk R
nama varchar 2147483647 null
id_account int4 10 null
account.id expense_type_id_account_account_id_fk R
created_by int4 10 null
pegawai.id expense_type_created_by_pegawai_id_fk R
created_at timestamp 29,6 √ now()
updated_by int4 10 null
pegawai.id expense_type_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)
expense_type_pkey Primary key Asc id
expense_type_nama_unique Must be unique Asc nama

Relationships

Close relationships within degrees of separation