program_loyalty

-1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('program_loyalty_id_seq'::regclass)
kontrak_loyalty.id_program_loyalty kontrak_loyalty_id_program_loyalty_program_loyalty_id_fk R
program_loyalty_detail.id program_loyalty_detail_id_program_loyalty_id_fk R
program_loyalty_persetujuan.id program_loyalty_persetujuan_id_program_loyalty_id_fk R
nomor varchar 2147483647 null
tanggal date 13 null
nama varchar 2147483647 null
tanggal_awal date 13 null
tanggal_akhir date 13 null
status char 1 null
keterangan text 2147483647 √ null
catatan text 2147483647 √ null
created_by int4 10 null
pegawai.id program_loyalty_created_by_pegawai_id_fk R
created_at timestamp 29,6 √ now()
updated_by int4 10 null
pegawai.id program_loyalty_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
is_wajib_capai_semua bool 1 false
id_barang _int4 10 √ null
id_brand int4 10 √ null
brand.id program_loyalty_id_brand_brand_id_fk R
id_area _int4 10 √ null
id_customer_jenis _int4 10 √ null
target_persen numeric 0 null

Indexes

Constraint Name Type Sort Column(s)
program_loyalty_pkey Primary key Asc id

Relationships

Close relationships within degrees of separation