coretax

173 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('coretax_id_seq'::regclass)
coretax_detail.id coretax_detail_id_coretax_id_fk R
nomor varchar 50 null
tanggal date 13 null
status bpchar 1 null
tanggal_awal date 13 √ null
tanggal_akhir date 13 √ null
id_kota bpchar 4 √ null
reg_regencies.id coretax_id_kota_reg_regencies_id_fk R
id_area _int4 10 √ null
filename varchar 100 √ null
created_by int4 10 null
pegawai.id coretax_created_by_pegawai_id_fk R
created_at timestamp 29,6 √ now()
updated_by int4 10 null
pegawai.id coretax_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)
coretax_pkey Primary key Asc id
coretax_nomor_unique Must be unique Asc nomor

Relationships

Close relationships within degrees of separation