Table webco_4.4.1.public.agreement_form_config Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
obj_oid int8 19
checkout_center.custom_agreement_form_oid checkout_center_custom_agreement_form_oid_fkey
name varchar 2147483647 'Agreement Form'::character varying
description varchar 2147483647  √  null
checkout_center_oid int8 19  √  null
checkout_center.obj_oid agreement_form_config_checkout_center_oid
config varchar 2147483647 '{"version":"1.0","general":{"pageSize":"letter","units":"in","margin":".5"},"title":{"text":"WebCheckout Agreement","align":"right","logo":"","logoAlign":"left"},"header":{"patron":{"name":true,"ID":false,"telephone":true,"email":true,"address":false,"address2":false,"cityStateZip":false,"contactPerson":true,"barcode":false,"department":false},"operator":"operator ID","eventTitle":false,"renewal":false},"contents":{"active":[{"key":"item","header":"Item","width":"1.5","specifier":"id"},{"key":"desc","header":"Description","width":"2.5","rType":true,"topLevelRType":false,"homeLocation":true,"accessories":false,"components":true,"mediaTitle":false},{"key":"qty","header":"Qty","width":".875"},{"key":"return","header":"Return Time","width":".875"},{"key":"fee","header":"Est''d fee","width":".875"},{"key":"feeSubtotal","header":"Est''d subtotal","width":".875"}],"inactive":[{"key":"aggValue","header":"Aggregate Value","width":".5"},{"key":"condition","header":"Condition Note","width":".5"}]},"footer":{"notes":true,"setup":false,"feeTotal":false},"signatory":{"accompany":false}}'::character varying
markup varchar 2147483647 'The undersigned acknowledges receiving the listed equipment in good condition and accepts full liability for damage or loss including concealed or unreported damage discovered after return.'::character varying

Table contained 0 rows at Fri Mar 24 10:48 CDT 2017

Indexes:
Column(s) Type Sort Constraint Name
obj_oid Primary key Asc agreement_form_config_pkey

Close relationships  within of separation: