ad_task_trl

6 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ad_task_id numeric 10 null
ad_task.ad_task_id ad_tasktrl C
ad_language varchar 6 null
ad_language.ad_language ad_language_tasktrl R
ad_client_id numeric 10 null
ad_org_id numeric 10 null
isactive bpchar 1 'Y'::bpchar
created timestamp 29,6 now()
createdby numeric 10 null
updated timestamp 29,6 now()
updatedby numeric 10 null
name varchar 60 null
description varchar 255 null
help varchar 2000 null
istranslated bpchar 1 'N'::bpchar
ad_task_trl_uu varchar 36 NULL::character varying
cof_pretranslated bpchar 1 NULL::bpchar
cof_checked bpchar 1 NULL::bpchar

Indexes

Constraint Name Type Sort Column(s)
ad_task_trl_pkey Primary key Asc/Asc ad_task_id + ad_language
ad_task_trl_uu_idx Must be unique Asc ad_task_trl_uu

Check Constraints

Constraint Name Constraint
ad_task_trl_cof_checked_check ((cof_checked = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
ad_task_trl_cof_pretranslated_check ((cof_pretranslated = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
ad_task_trl_isactive_check ((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
ad_task_trl_istranslated_check ((istranslated = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))

Relationships