Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
cof_armazenamentonuvem_id | numeric | 10 | null |
|
|
|||||||||
cof_armazenamentonuvem_uu | varchar | 36 | √ | NULL::character varying |
|
|
||||||||
ad_client_id | numeric | 10 | null |
|
|
|||||||||
ad_org_id | numeric | 10 | null |
|
|
|||||||||
isactive | bpchar | 1 | 'Y'::bpchar |
|
|
|||||||||
created | timestamp | 29,6 | null |
|
|
|||||||||
createdby | numeric | 10 | null |
|
|
|||||||||
updated | timestamp | 29,6 | null |
|
|
|||||||||
updatedby | numeric | 10 | null |
|
|
|||||||||
name | varchar | 60 | NULL::character varying |
|
|
|||||||||
description | varchar | 255 | √ | null |
|
|
||||||||
cof_token | varchar | 1000 | √ | null |
|
|
||||||||
servicepath | varchar | 60 | √ | NULL::character varying |
|
|
||||||||
cof_serviconuvem | varchar | 3 | NULL::character varying |
|
|
|||||||||
value | varchar | 40 | √ | NULL::character varying |
|
|
||||||||
cof_sobrescrever | bpchar | 1 | √ | 'N'::bpchar |
|
|
||||||||
name2 | varchar | 60 | √ | NULL::character varying |
|
|
||||||||
cof_gdriveserviceaccountemail | varchar | 2000 | √ | NULL::character varying |
|
|
||||||||
cof_gdrivemime | varchar | 100 | √ | NULL::character varying |
|
|
||||||||
cof_gdrivelinkpasta | varchar | 500 | √ | NULL::character varying |
|
|
||||||||
errormsg | text | 2147483647 | √ | null |
|
|
||||||||
cof_gdrivelinkarquivo | varchar | 500 | √ | NULL::character varying |
|
|
||||||||
cof_cloudaction | bpchar | 1 | √ | 'U'::bpchar |
|
|
Indexes
Constraint Name | Type | Sort | Column(s) |
---|---|---|---|
cof_armazenamentonuvem_key | Primary key | Asc | cof_armazenamentonuvem_id |
cof_armazenamentonuvem_uu_idx | Must be unique | Asc | cof_armazenamentonuvem_uu |
Check Constraints
Constraint Name | Constraint |
---|---|
cof_armazenamentonuvem_isactive_check | ((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |
cof_armazenamentonuvem_cof_sobrescrever_check | ((cof_sobrescrever = ANY (ARRAY['Y'::bpchar, 'N'::bpchar]))) |