ad_storageprovider

1 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ad_client_id numeric 10 NULL::numeric
ad_org_id numeric 10 NULL::numeric
ad_storageprovider_id numeric 10 null
ad_archive.ad_storageprovider_id adstorageprovider_adarchive R
ad_attachment.ad_storageprovider_id adstorageprovider_adattachment R
ad_clientinfo.ad_storageprovider_id adstorageprovider_adclientinfo R
ad_clientinfo.storagearchive_id storagearchive_adclientinfo R
ad_clientinfo.storageimage_id storageimage_adclientinfo R
ad_image.ad_storageprovider_id adstorageprovider_adimage R
ad_storageprovider_uu varchar 36 √ NULL::character varying
created timestamp 29,6 statement_timestamp()
createdby numeric 10 NULL::numeric
folder varchar 255 √ NULL::character varying
isactive bpchar 1 'Y'::bpchar
method varchar 60 √ NULL::character varying
name varchar 60 NULL::character varying
password varchar 255 √ NULL::character varying
updated timestamp 29,6 statement_timestamp()
updatedby numeric 10 NULL::numeric
url varchar 225 √ NULL::character varying
username varchar 60 √ NULL::character varying
isdefault bpchar 1 'N'::bpchar

Indexes

Constraint Name Type Sort Column(s)
ad_storageprovider_pkey Primary key Asc ad_storageprovider_id
ad_storageprovider_uu_idx Must be unique Asc ad_storageprovider_uu

Check Constraints

Constraint Name Constraint
ad_storageprovider_isdefault_check ((isdefault = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))
ad_storageprovider_isactive_check ((isactive = ANY (ARRAY['Y'::bpchar, 'N'::bpchar])))

Relationships

Close relationships within degrees of separation