Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| obj_oid | int8 | 19 | null |
|
|
|||||
| name | varchar | 2147483647 | 'Agreement Form'::character varying |
|
|
|||||
| description | varchar | 2147483647 | √ | null |
|
|
||||
| checkout_center_oid | int8 | 19 | √ | null |
|
|
||||
| config | json | 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}}'::json |
|
|
|||||
| markup | varchar | 2147483647 | '<custom-markup><terms>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.</terms></custom-markup>'::character varying |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| agreement_form_config_pkey | Primary key | Asc | obj_oid |
Relationships
Close relationships within degrees of separation
