Last active
August 29, 2015 14:10
-
-
Save ultimatemonty/c4a6faa53e4f193dc7eb to your computer and use it in GitHub Desktop.
Schema for PaymentTerms table
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // This schema throws the 102 error with related=* | |
| { | |
| "name": "Currencies", | |
| "label": "Currencies", | |
| "plural": "Currency", | |
| "primary_key": "id", | |
| "name_field": null, | |
| "field": [ | |
| { | |
| "name": "id", | |
| "label": "Id", | |
| "type": "id", | |
| "db_type": "int", | |
| "length": 10, | |
| "precision": 10, | |
| "scale": 0, | |
| "default": null, | |
| "required": false, | |
| "allow_null": false, | |
| "fixed_length": false, | |
| "supports_multibyte": false, | |
| "auto_increment": true, | |
| "is_primary_key": true, | |
| "is_foreign_key": null, | |
| "ref_table": "", | |
| "ref_fields": "", | |
| "validation": null, | |
| "value": [] | |
| }, | |
| { | |
| "name": "currency", | |
| "label": "Currency", | |
| "type": "string", | |
| "db_type": "varchar", | |
| "length": 3, | |
| "precision": 3, | |
| "scale": 0, | |
| "default": null, | |
| "required": true, | |
| "allow_null": false, | |
| "fixed_length": false, | |
| "supports_multibyte": false, | |
| "auto_increment": false, | |
| "is_primary_key": null, | |
| "is_foreign_key": null, | |
| "ref_table": "", | |
| "ref_fields": "", | |
| "validation": null, | |
| "value": [] | |
| }, | |
| { | |
| "name": "description", | |
| "label": "Description", | |
| "type": "string", | |
| "db_type": "varchar", | |
| "length": 255, | |
| "precision": 255, | |
| "scale": 0, | |
| "default": null, | |
| "required": true, | |
| "allow_null": false, | |
| "fixed_length": false, | |
| "supports_multibyte": false, | |
| "auto_increment": false, | |
| "is_primary_key": null, | |
| "is_foreign_key": null, | |
| "ref_table": "", | |
| "ref_fields": "", | |
| "validation": null, | |
| "value": [] | |
| }, | |
| { | |
| "name": "isActive", | |
| "label": "IsActive", | |
| "type": "boolean", | |
| "db_type": "bit", | |
| "length": 0, | |
| "precision": 0, | |
| "scale": 0, | |
| "default": null, | |
| "required": true, | |
| "allow_null": false, | |
| "fixed_length": false, | |
| "supports_multibyte": false, | |
| "auto_increment": false, | |
| "is_primary_key": null, | |
| "is_foreign_key": null, | |
| "ref_table": "", | |
| "ref_fields": "", | |
| "validation": null, | |
| "value": [] | |
| }, | |
| { | |
| "name": "sortOrder", | |
| "label": "SortOrder", | |
| "type": "integer", | |
| "db_type": "int", | |
| "length": 10, | |
| "precision": 10, | |
| "scale": 0, | |
| "default": null, | |
| "required": true, | |
| "allow_null": false, | |
| "fixed_length": false, | |
| "supports_multibyte": false, | |
| "auto_increment": false, | |
| "is_primary_key": null, | |
| "is_foreign_key": null, | |
| "ref_table": "", | |
| "ref_fields": "", | |
| "validation": null, | |
| "value": [] | |
| }, | |
| { | |
| "name": "createdBy", | |
| "label": "CreatedBy", | |
| "type": "integer", | |
| "db_type": "int", | |
| "length": 10, | |
| "precision": 10, | |
| "scale": 0, | |
| "default": null, | |
| "required": true, | |
| "allow_null": false, | |
| "fixed_length": false, | |
| "supports_multibyte": false, | |
| "auto_increment": false, | |
| "is_primary_key": null, | |
| "is_foreign_key": null, | |
| "ref_table": "", | |
| "ref_fields": "", | |
| "validation": null, | |
| "value": [] | |
| }, | |
| { | |
| "name": "createdDate", | |
| "label": "CreatedDate", | |
| "type": "datetime", | |
| "db_type": "datetime", | |
| "length": 0, | |
| "precision": 0, | |
| "scale": 0, | |
| "default": null, | |
| "required": true, | |
| "allow_null": false, | |
| "fixed_length": false, | |
| "supports_multibyte": false, | |
| "auto_increment": false, | |
| "is_primary_key": null, | |
| "is_foreign_key": null, | |
| "ref_table": "", | |
| "ref_fields": "", | |
| "validation": null, | |
| "value": [] | |
| }, | |
| { | |
| "name": "modifiedBy", | |
| "label": "ModifiedBy", | |
| "type": "integer", | |
| "db_type": "int", | |
| "length": 10, | |
| "precision": 10, | |
| "scale": 0, | |
| "default": null, | |
| "required": false, | |
| "allow_null": true, | |
| "fixed_length": false, | |
| "supports_multibyte": false, | |
| "auto_increment": false, | |
| "is_primary_key": null, | |
| "is_foreign_key": null, | |
| "ref_table": "", | |
| "ref_fields": "", | |
| "validation": null, | |
| "value": [] | |
| }, | |
| { | |
| "name": "modifiedDate", | |
| "label": "ModifiedDate", | |
| "type": "datetime", | |
| "db_type": "datetime", | |
| "length": 0, | |
| "precision": 0, | |
| "scale": 0, | |
| "default": null, | |
| "required": false, | |
| "allow_null": true, | |
| "fixed_length": false, | |
| "supports_multibyte": false, | |
| "auto_increment": false, | |
| "is_primary_key": null, | |
| "is_foreign_key": null, | |
| "ref_table": "", | |
| "ref_fields": "", | |
| "validation": null, | |
| "value": [] | |
| } | |
| ], | |
| "related": [ | |
| { | |
| "name": "Vendors_by_currency", | |
| "type": "has_many", | |
| "ref_table": "Vendors", | |
| "ref_field": "currency", | |
| "field": "id" | |
| }, | |
| { | |
| "name": "Country_by_Vendors", | |
| "type": "many_many", | |
| "ref_table": "Countries", | |
| "ref_field": "id", | |
| "join": "Vendors(currency,mailingAddressCountry)", | |
| "field": "id" | |
| }, | |
| { | |
| "name": "Country_by_Vendors", | |
| "type": "many_many", | |
| "ref_table": "Countries", | |
| "ref_field": "id", | |
| "join": "Vendors(currency,shippingAddressCountry)", | |
| "field": "id" | |
| }, | |
| { | |
| "name": "Country_by_Vendors", | |
| "type": "many_many", | |
| "ref_table": "Countries", | |
| "ref_field": "id", | |
| "join": "Vendors(currency,remitToAddressCountry)", | |
| "field": "id" | |
| }, | |
| { | |
| "name": "PaymentTerms_by_Vendors", | |
| "type": "many_many", | |
| "ref_table": "PaymentTerms", | |
| "ref_field": "id", | |
| "join": "Vendors(currency,paymentTerms)", | |
| "field": "id" | |
| }, | |
| { | |
| "name": "Users_by_Vendors", | |
| "type": "many_many", | |
| "ref_table": "Users", | |
| "ref_field": "id", | |
| "join": "Vendors(currency,createdBy)", | |
| "field": "id" | |
| }, | |
| { | |
| "name": "Users_by_Vendors", | |
| "type": "many_many", | |
| "ref_table": "Users", | |
| "ref_field": "id", | |
| "join": "Vendors(currency,modifiedBy)", | |
| "field": "id" | |
| }, | |
| { | |
| "name": "Users_by_Vendors", | |
| "type": "many_many", | |
| "ref_table": "Users", | |
| "ref_field": "id", | |
| "join": "Vendors(currency,deletedBy)", | |
| "field": "id" | |
| }, | |
| { | |
| "name": "Vendors_by_Vendors", | |
| "type": "many_many", | |
| "ref_table": "Vendors", | |
| "ref_field": "id", | |
| "join": "Vendors(currency,id)", | |
| "field": "id" | |
| } | |
| ], | |
| "access": [ | |
| "GET", | |
| "POST", | |
| "PUT", | |
| "PATCH", | |
| "MERGE", | |
| "DELETE", | |
| "ADMIN" | |
| ] | |
| } |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| // This schema works with related=* | |
| { | |
| "name": "Vendors", | |
| "label": "Vendors", | |
| "plural": "Vendors", | |
| "primary_key": "id", | |
| "name_field": null, | |
| "field": [ | |
| { | |
| "name": "id", | |
| "label": "Id", | |
| "type": "id", | |
| "db_type": "int", | |
| "length": 10, | |
| "precision": 10, | |
| "scale": 0, | |
| "default": null, | |
| "required": false, | |
| "allow_null": false, | |
| "fixed_length": false, | |
| "supports_multibyte": false, | |
| "auto_increment": true, | |
| "is_primary_key": true, | |
| "is_foreign_key": true, | |
| "ref_table": "Vendors", | |
| "ref_fields": "id", | |
| "validation": null, | |
| "value": [] | |
| }, | |
| { | |
| "name": "name", | |
| "label": "Name", | |
| "type": "string", | |
| "db_type": "varchar", | |
| "length": 255, | |
| "precision": 255, | |
| "scale": 0, | |
| "default": null, | |
| "required": true, | |
| "allow_null": false, | |
| "fixed_length": false, | |
| "supports_multibyte": false, | |
| "auto_increment": false, | |
| "is_primary_key": null, | |
| "is_foreign_key": null, | |
| "ref_table": "", | |
| "ref_fields": "", | |
| "validation": null, | |
| "value": [] | |
| }, | |
| { | |
| "name": "website", | |
| "label": "Website", | |
| "type": "string", | |
| "db_type": "varchar", | |
| "length": 255, | |
| "precision": 255, | |
| "scale": 0, | |
| "default": null, | |
| "required": false, | |
| "allow_null": true, | |
| "fixed_length": false, | |
| "supports_multibyte": false, | |
| "auto_increment": false, | |
| "is_primary_key": null, | |
| "is_foreign_key": null, | |
| "ref_table": "", | |
| "ref_fields": "", | |
| "validation": null, | |
| "value": [] | |
| }, | |
| { | |
| "name": "currency", | |
| "label": "Currency", | |
| "type": "reference", | |
| "db_type": "int", | |
| "length": 10, | |
| "precision": 10, | |
| "scale": 0, | |
| "default": null, | |
| "required": false, | |
| "allow_null": true, | |
| "fixed_length": false, | |
| "supports_multibyte": false, | |
| "auto_increment": false, | |
| "is_primary_key": null, | |
| "is_foreign_key": true, | |
| "ref_table": "Currencies", | |
| "ref_fields": "id", | |
| "validation": null, | |
| "value": [] | |
| }, | |
| { | |
| "name": "paymentTerms", | |
| "label": "PaymentTerms", | |
| "type": "reference", | |
| "db_type": "int", | |
| "length": 10, | |
| "precision": 10, | |
| "scale": 0, | |
| "default": null, | |
| "required": false, | |
| "allow_null": true, | |
| "fixed_length": false, | |
| "supports_multibyte": false, | |
| "auto_increment": false, | |
| "is_primary_key": null, | |
| "is_foreign_key": true, | |
| "ref_table": "PaymentTerms", | |
| "ref_fields": "id", | |
| "validation": null, | |
| "value": [] | |
| }, | |
| { | |
| "name": "isActive", | |
| "label": "IsActive", | |
| "type": "boolean", | |
| "db_type": "bit", | |
| "length": 0, | |
| "precision": 0, | |
| "scale": 0, | |
| "default": null, | |
| "required": true, | |
| "allow_null": false, | |
| "fixed_length": false, | |
| "supports_multibyte": false, | |
| "auto_increment": false, | |
| "is_primary_key": null, | |
| "is_foreign_key": null, | |
| "ref_table": "", | |
| "ref_fields": "", | |
| "validation": null, | |
| "value": [] | |
| }, | |
| { | |
| "name": "isQAActive", | |
| "label": "IsQAActive", | |
| "type": "boolean", | |
| "db_type": "bit", | |
| "length": 0, | |
| "precision": 0, | |
| "scale": 0, | |
| "default": null, | |
| "required": true, | |
| "allow_null": false, | |
| "fixed_length": false, | |
| "supports_multibyte": false, | |
| "auto_increment": false, | |
| "is_primary_key": null, | |
| "is_foreign_key": null, | |
| "ref_table": "", | |
| "ref_fields": "", | |
| "validation": null, | |
| "value": [] | |
| }, | |
| { | |
| "name": "isDeletedFromApplication", | |
| "label": "IsDeletedFromApplication", | |
| "type": "boolean", | |
| "db_type": "bit", | |
| "length": 0, | |
| "precision": 0, | |
| "scale": 0, | |
| "default": null, | |
| "required": false, | |
| "allow_null": true, | |
| "fixed_length": false, | |
| "supports_multibyte": false, | |
| "auto_increment": false, | |
| "is_primary_key": null, | |
| "is_foreign_key": null, | |
| "ref_table": "", | |
| "ref_fields": "", | |
| "validation": null, | |
| "value": [] | |
| }, | |
| { | |
| "name": "mailingAddressName", | |
| "label": "MailingAddressName", | |
| "type": "string", | |
| "db_type": "varchar", | |
| "length": 255, | |
| "precision": 255, | |
| "scale": 0, | |
| "default": null, | |
| "required": false, | |
| "allow_null": true, | |
| "fixed_length": false, | |
| "supports_multibyte": false, | |
| "auto_increment": false, | |
| "is_primary_key": null, | |
| "is_foreign_key": null, | |
| "ref_table": "", | |
| "ref_fields": "", | |
| "validation": null, | |
| "value": [] | |
| }, | |
| { | |
| "name": "mailingAddressContact", | |
| "label": "MailingAddressContact", | |
| "type": "string", | |
| "db_type": "varchar", | |
| "length": 255, | |
| "precision": 255, | |
| "scale": 0, | |
| "default": null, | |
| "required": false, | |
| "allow_null": true, | |
| "fixed_length": false, | |
| "supports_multibyte": false, | |
| "auto_increment": false, | |
| "is_primary_key": null, | |
| "is_foreign_key": null, | |
| "ref_table": "", | |
| "ref_fields": "", | |
| "validation": null, | |
| "value": [] | |
| }, | |
| { | |
| "name": "mailingAddressLine1", | |
| "label": "MailingAddressLine1", | |
| "type": "string", | |
| "db_type": "varchar", | |
| "length": 255, | |
| "precision": 255, | |
| "scale": 0, | |
| "default": null, | |
| "required": false, | |
| "allow_null": true, | |
| "fixed_length": false, | |
| "supports_multibyte": false, | |
| "auto_increment": false, | |
| "is_primary_key": null, | |
| "is_foreign_key": null, | |
| "ref_table": "", | |
| "ref_fields": "", | |
| "validation": null, | |
| "value": [] | |
| }, | |
| { | |
| "name": "mailingAddressLine2", | |
| "label": "MailingAddressLine2", | |
| "type": "string", | |
| "db_type": "varchar", | |
| "length": 255, | |
| "precision": 255, | |
| "scale": 0, | |
| "default": null, | |
| "required": false, | |
| "allow_null": true, | |
| "fixed_length": false, | |
| "supports_multibyte": false, | |
| "auto_increment": false, | |
| "is_primary_key": null, | |
| "is_foreign_key": null, | |
| "ref_table": "", | |
| "ref_fields": "", | |
| "validation": null, | |
| "value": [] | |
| }, | |
| { | |
| "name": "mailingAddressCity", | |
| "label": "MailingAddressCity", | |
| "type": "string", | |
| "db_type": "varchar", | |
| "length": 255, | |
| "precision": 255, | |
| "scale": 0, | |
| "default": null, | |
| "required": false, | |
| "allow_null": true, | |
| "fixed_length": false, | |
| "supports_multibyte": false, | |
| "auto_increment": false, | |
| "is_primary_key": null, | |
| "is_foreign_key": null, | |
| "ref_table": "", | |
| "ref_fields": "", | |
| "validation": null, | |
| "value": [] | |
| }, | |
| { | |
| "name": "mailingAddressProvince", | |
| "label": "MailingAddressProvince", | |
| "type": "string", | |
| "db_type": "varchar", | |
| "length": 255, | |
| "precision": 255, | |
| "scale": 0, | |
| "default": null, | |
| "required": false, | |
| "allow_null": true, | |
| "fixed_length": false, | |
| "supports_multibyte": false, | |
| "auto_increment": false, | |
| "is_primary_key": null, | |
| "is_foreign_key": null, | |
| "ref_table": "", | |
| "ref_fields": "", | |
| "validation": null, | |
| "value": [] | |
| }, | |
| { | |
| "name": "mailingAddressPostalCode", | |
| "label": "MailingAddressPostalCode", | |
| "type": "string", | |
| "db_type": "varchar", | |
| "length": 20, | |
| "precision": 20, | |
| "scale": 0, | |
| "default": null, | |
| "required": false, | |
| "allow_null": true, | |
| "fixed_length": false, | |
| "supports_multibyte": false, | |
| "auto_increment": false, | |
| "is_primary_key": null, | |
| "is_foreign_key": null, | |
| "ref_table": "", | |
| "ref_fields": "", | |
| "validation": null, | |
| "value": [] | |
| }, | |
| { | |
| "name": "mailingAddressCountry", | |
| "label": "MailingAddressCountry", | |
| "type": "reference", | |
| "db_type": "int", | |
| "length": 10, | |
| "precision": 10, | |
| "scale": 0, | |
| "default": null, | |
| "required": false, | |
| "allow_null": true, | |
| "fixed_length": false, | |
| "supports_multibyte": false, | |
| "auto_increment": false, | |
| "is_primary_key": null, | |
| "is_foreign_key": true, | |
| "ref_table": "Countries", | |
| "ref_fields": "id", | |
| "validation": null, | |
| "value": [] | |
| }, | |
| { | |
| "name": "mailingAddressPhoneNumber", | |
| "label": "MailingAddressPhoneNumber", | |
| "type": "string", | |
| "db_type": "varchar", | |
| "length": 31, | |
| "precision": 31, | |
| "scale": 0, | |
| "default": null, | |
| "required": false, | |
| "allow_null": true, | |
| "fixed_length": false, | |
| "supports_multibyte": false, | |
| "auto_increment": false, | |
| "is_primary_key": null, | |
| "is_foreign_key": null, | |
| "ref_table": "", | |
| "ref_fields": "", | |
| "validation": null, | |
| "value": [] | |
| }, | |
| { | |
| "name": "mailingAddressFaxNumber", | |
| "label": "MailingAddressFaxNumber", | |
| "type": "string", | |
| "db_type": "varchar", | |
| "length": 31, | |
| "precision": 31, | |
| "scale": 0, | |
| "default": null, | |
| "required": false, | |
| "allow_null": true, | |
| "fixed_length": false, | |
| "supports_multibyte": false, | |
| "auto_increment": false, | |
| "is_primary_key": null, | |
| "is_foreign_key": null, | |
| "ref_table": "", | |
| "ref_fields": "", | |
| "validation": null, | |
| "value": [] | |
| }, | |
| { | |
| "name": "mailingAddressEmailAddress", | |
| "label": "MailingAddressEmailAddress", | |
| "type": "string", | |
| "db_type": "varchar", | |
| "length": 50, | |
| "precision": 50, | |
| "scale": 0, | |
| "default": null, | |
| "required": false, | |
| "allow_null": true, | |
| "fixed_length": false, | |
| "supports_multibyte": false, | |
| "auto_increment": false, | |
| "is_primary_key": null, | |
| "is_foreign_key": null, | |
| "ref_table": "", | |
| "ref_fields": "", | |
| "validation": null, | |
| "value": [] | |
| }, | |
| { | |
| "name": "shippingAddressName", | |
| "label": "ShippingAddressName", | |
| "type": "string", | |
| "db_type": "varchar", | |
| "length": 255, | |
| "precision": 255, | |
| "scale": 0, | |
| "default": null, | |
| "required": false, | |
| "allow_null": true, | |
| "fixed_length": false, | |
| "supports_multibyte": false, | |
| "auto_increment": false, | |
| "is_primary_key": null, | |
| "is_foreign_key": null, | |
| "ref_table": "", | |
| "ref_fields": "", | |
| "validation": null, | |
| "value": [] | |
| }, | |
| { | |
| "name": "shippingAddressContact", | |
| "label": "ShippingAddressContact", | |
| "type": "string", | |
| "db_type": "varchar", | |
| "length": 255, | |
| "precision": 255, | |
| "scale": 0, | |
| "default": null, | |
| "required": false, | |
| "allow_null": true, | |
| "fixed_length": false, | |
| "supports_multibyte": false, | |
| "auto_increment": false, | |
| "is_primary_key": null, | |
| "is_foreign_key": null, | |
| "ref_table": "", | |
| "ref_fields": "", | |
| "validation": null, | |
| "value": [] | |
| }, | |
| { | |
| "name": "shippingAddressLine1", | |
| "label": "ShippingAddressLine1", | |
| "type": "string", | |
| "db_type": "varchar", | |
| "length": 255, | |
| "precision": 255, | |
| "scale": 0, | |
| "default": null, | |
| "required": false, | |
| "allow_null": true, | |
| "fixed_length": false, | |
| "supports_multibyte": false, | |
| "auto_increment": false, | |
| "is_primary_key": null, | |
| "is_foreign_key": null, | |
| "ref_table": "", | |
| "ref_fields": "", | |
| "validation": null, | |
| "value": [] | |
| }, | |
| { | |
| "name": "shippingAddressLine2", | |
| "label": "ShippingAddressLine2", | |
| "type": "string", | |
| "db_type": "varchar", | |
| "length": 255, | |
| "precision": 255, | |
| "scale": 0, | |
| "default": null, | |
| "required": false, | |
| "allow_null": true, | |
| "fixed_length": false, | |
| "supports_multibyte": false, | |
| "auto_increment": false, | |
| "is_primary_key": null, | |
| "is_foreign_key": null, | |
| "ref_table": "", | |
| "ref_fields": "", | |
| "validation": null, | |
| "value": [] | |
| }, | |
| { | |
| "name": "shippingAddressCity", | |
| "label": "ShippingAddressCity", | |
| "type": "string", | |
| "db_type": "varchar", | |
| "length": 255, | |
| "precision": 255, | |
| "scale": 0, | |
| "default": null, | |
| "required": false, | |
| "allow_null": true, | |
| "fixed_length": false, | |
| "supports_multibyte": false, | |
| "auto_increment": false, | |
| "is_primary_key": null, | |
| "is_foreign_key": null, | |
| "ref_table": "", | |
| "ref_fields": "", | |
| "validation": null, | |
| "value": [] | |
| }, | |
| { | |
| "name": "shippingAddressProvince", | |
| "label": "ShippingAddressProvince", | |
| "type": "string", | |
| "db_type": "varchar", | |
| "length": 255, | |
| "precision": 255, | |
| "scale": 0, | |
| "default": null, | |
| "required": false, | |
| "allow_null": true, | |
| "fixed_length": false, | |
| "supports_multibyte": false, | |
| "auto_increment": false, | |
| "is_primary_key": null, | |
| "is_foreign_key": null, | |
| "ref_table": "", | |
| "ref_fields": "", | |
| "validation": null, | |
| "value": [] | |
| }, | |
| { | |
| "name": "shippingAddressPostalCode", | |
| "label": "ShippingAddressPostalCode", | |
| "type": "string", | |
| "db_type": "varchar", | |
| "length": 20, | |
| "precision": 20, | |
| "scale": 0, | |
| "default": null, | |
| "required": false, | |
| "allow_null": true, | |
| "fixed_length": false, | |
| "supports_multibyte": false, | |
| "auto_increment": false, | |
| "is_primary_key": null, | |
| "is_foreign_key": null, | |
| "ref_table": "", | |
| "ref_fields": "", | |
| "validation": null, | |
| "value": [] | |
| }, | |
| { | |
| "name": "shippingAddressCountry", | |
| "label": "ShippingAddressCountry", | |
| "type": "reference", | |
| "db_type": "int", | |
| "length": 10, | |
| "precision": 10, | |
| "scale": 0, | |
| "default": null, | |
| "required": false, | |
| "allow_null": true, | |
| "fixed_length": false, | |
| "supports_multibyte": false, | |
| "auto_increment": false, | |
| "is_primary_key": null, | |
| "is_foreign_key": true, | |
| "ref_table": "Countries", | |
| "ref_fields": "id", | |
| "validation": null, | |
| "value": [] | |
| }, | |
| { | |
| "name": "shippingAddressPhoneNumber", | |
| "label": "ShippingAddressPhoneNumber", | |
| "type": "string", | |
| "db_type": "varchar", | |
| "length": 31, | |
| "precision": 31, | |
| "scale": 0, | |
| "default": null, | |
| "required": false, | |
| "allow_null": true, | |
| "fixed_length": false, | |
| "supports_multibyte": false, | |
| "auto_increment": false, | |
| "is_primary_key": null, | |
| "is_foreign_key": null, | |
| "ref_table": "", | |
| "ref_fields": "", | |
| "validation": null, | |
| "value": [] | |
| }, | |
| { | |
| "name": "shippingAddressFaxNumber", | |
| "label": "ShippingAddressFaxNumber", | |
| "type": "string", | |
| "db_type": "varchar", | |
| "length": 31, | |
| "precision": 31, | |
| "scale": 0, | |
| "default": null, | |
| "required": false, | |
| "allow_null": true, | |
| "fixed_length": false, | |
| "supports_multibyte": false, | |
| "auto_increment": false, | |
| "is_primary_key": null, | |
| "is_foreign_key": null, | |
| "ref_table": "", | |
| "ref_fields": "", | |
| "validation": null, | |
| "value": [] | |
| }, | |
| { | |
| "name": "shippingAddressEmailAddress", | |
| "label": "ShippingAddressEmailAddress", | |
| "type": "string", | |
| "db_type": "varchar", | |
| "length": 50, | |
| "precision": 50, | |
| "scale": 0, | |
| "default": null, | |
| "required": false, | |
| "allow_null": true, | |
| "fixed_length": false, | |
| "supports_multibyte": false, | |
| "auto_increment": false, | |
| "is_primary_key": null, | |
| "is_foreign_key": null, | |
| "ref_table": "", | |
| "ref_fields": "", | |
| "validation": null, | |
| "value": [] | |
| }, | |
| { | |
| "name": "remitToAddressName", | |
| "label": "RemitToAddressName", | |
| "type": "string", | |
| "db_type": "varchar", | |
| "length": 255, | |
| "precision": 255, | |
| "scale": 0, | |
| "default": null, | |
| "required": false, | |
| "allow_null": true, | |
| "fixed_length": false, | |
| "supports_multibyte": false, | |
| "auto_increment": false, | |
| "is_primary_key": null, | |
| "is_foreign_key": null, | |
| "ref_table": "", | |
| "ref_fields": "", | |
| "validation": null, | |
| "value": [] | |
| }, | |
| { | |
| "name": "remitToAddressContact", | |
| "label": "RemitToAddressContact", | |
| "type": "string", | |
| "db_type": "varchar", | |
| "length": 255, | |
| "precision": 255, | |
| "scale": 0, | |
| "default": null, | |
| "required": false, | |
| "allow_null": true, | |
| "fixed_length": false, | |
| "supports_multibyte": false, | |
| "auto_increment": false, | |
| "is_primary_key": null, | |
| "is_foreign_key": null, | |
| "ref_table": "", | |
| "ref_fields": "", | |
| "validation": null, | |
| "value": [] | |
| }, | |
| { | |
| "name": "remitToAddressLine1", | |
| "label": "RemitToAddressLine1", | |
| "type": "string", | |
| "db_type": "varchar", | |
| "length": 255, | |
| "precision": 255, | |
| "scale": 0, | |
| "default": null, | |
| "required": false, | |
| "allow_null": true, | |
| "fixed_length": false, | |
| "supports_multibyte": false, | |
| "auto_increment": false, | |
| "is_primary_key": null, | |
| "is_foreign_key": null, | |
| "ref_table": "", | |
| "ref_fields": "", | |
| "validation": null, | |
| "value": [] | |
| }, | |
| { | |
| "name": "remitToAddressLine2", | |
| "label": "RemitToAddressLine2", | |
| "type": "string", | |
| "db_type": "varchar", | |
| "length": 255, | |
| "precision": 255, | |
| "scale": 0, | |
| "default": null, | |
| "required": false, | |
| "allow_null": true, | |
| "fixed_length": false, | |
| "supports_multibyte": false, | |
| "auto_increment": false, | |
| "is_primary_key": null, | |
| "is_foreign_key": null, | |
| "ref_table": "", | |
| "ref_fields": "", | |
| "validation": null, | |
| "value": [] | |
| }, | |
| { | |
| "name": "remitToAddressCity", | |
| "label": "RemitToAddressCity", | |
| "type": "string", | |
| "db_type": "varchar", | |
| "length": 255, | |
| "precision": 255, | |
| "scale": 0, | |
| "default": null, | |
| "required": false, | |
| "allow_null": true, | |
| "fixed_length": false, | |
| "supports_multibyte": false, | |
| "auto_increment": false, | |
| "is_primary_key": null, | |
| "is_foreign_key": null, | |
| "ref_table": "", | |
| "ref_fields": "", | |
| "validation": null, | |
| "value": [] | |
| }, | |
| { | |
| "name": "remitToAddressProvince", | |
| "label": "RemitToAddressProvince", | |
| "type": "string", | |
| "db_type": "varchar", | |
| "length": 255, | |
| "precision": 255, | |
| "scale": 0, | |
| "default": null, | |
| "required": false, | |
| "allow_null": true, | |
| "fixed_length": false, | |
| "supports_multibyte": false, | |
| "auto_increment": false, | |
| "is_primary_key": null, | |
| "is_foreign_key": null, | |
| "ref_table": "", | |
| "ref_fields": "", | |
| "validation": null, | |
| "value": [] | |
| }, | |
| { | |
| "name": "remitToAddressPostalCode", | |
| "label": "RemitToAddressPostalCode", | |
| "type": "string", | |
| "db_type": "varchar", | |
| "length": 20, | |
| "precision": 20, | |
| "scale": 0, | |
| "default": null, | |
| "required": false, | |
| "allow_null": true, | |
| "fixed_length": false, | |
| "supports_multibyte": false, | |
| "auto_increment": false, | |
| "is_primary_key": null, | |
| "is_foreign_key": null, | |
| "ref_table": "", | |
| "ref_fields": "", | |
| "validation": null, | |
| "value": [] | |
| }, | |
| { | |
| "name": "remitToAddressCountry", | |
| "label": "RemitToAddressCountry", | |
| "type": "reference", | |
| "db_type": "int", | |
| "length": 10, | |
| "precision": 10, | |
| "scale": 0, | |
| "default": null, | |
| "required": false, | |
| "allow_null": true, | |
| "fixed_length": false, | |
| "supports_multibyte": false, | |
| "auto_increment": false, | |
| "is_primary_key": null, | |
| "is_foreign_key": true, | |
| "ref_table": "Countries", | |
| "ref_fields": "id", | |
| "validation": null, | |
| "value": [] | |
| }, | |
| { | |
| "name": "remitToAddressPhoneNumber", | |
| "label": "RemitToAddressPhoneNumber", | |
| "type": "string", | |
| "db_type": "varchar", | |
| "length": 31, | |
| "precision": 31, | |
| "scale": 0, | |
| "default": null, | |
| "required": false, | |
| "allow_null": true, | |
| "fixed_length": false, | |
| "supports_multibyte": false, | |
| "auto_increment": false, | |
| "is_primary_key": null, | |
| "is_foreign_key": null, | |
| "ref_table": "", | |
| "ref_fields": "", | |
| "validation": null, | |
| "value": [] | |
| }, | |
| { | |
| "name": "remitToAddressFaxNumber", | |
| "label": "RemitToAddressFaxNumber", | |
| "type": "string", | |
| "db_type": "varchar", | |
| "length": 31, | |
| "precision": 31, | |
| "scale": 0, | |
| "default": null, | |
| "required": false, | |
| "allow_null": true, | |
| "fixed_length": false, | |
| "supports_multibyte": false, | |
| "auto_increment": false, | |
| "is_primary_key": null, | |
| "is_foreign_key": null, | |
| "ref_table": "", | |
| "ref_fields": "", | |
| "validation": null, | |
| "value": [] | |
| }, | |
| { | |
| "name": "remitToAddressEmailAddress", | |
| "label": "RemitToAddressEmailAddress", | |
| "type": "string", | |
| "db_type": "varchar", | |
| "length": 50, | |
| "precision": 50, | |
| "scale": 0, | |
| "default": null, | |
| "required": false, | |
| "allow_null": true, | |
| "fixed_length": false, | |
| "supports_multibyte": false, | |
| "auto_increment": false, | |
| "is_primary_key": null, | |
| "is_foreign_key": null, | |
| "ref_table": "", | |
| "ref_fields": "", | |
| "validation": null, | |
| "value": [] | |
| }, | |
| { | |
| "name": "createdBy", | |
| "label": "CreatedBy", | |
| "type": "reference", | |
| "db_type": "int", | |
| "length": 10, | |
| "precision": 10, | |
| "scale": 0, | |
| "default": null, | |
| "required": true, | |
| "allow_null": false, | |
| "fixed_length": false, | |
| "supports_multibyte": false, | |
| "auto_increment": false, | |
| "is_primary_key": null, | |
| "is_foreign_key": true, | |
| "ref_table": "Users", | |
| "ref_fields": "id", | |
| "validation": null, | |
| "value": [] | |
| }, | |
| { | |
| "name": "createdDate", | |
| "label": "CreatedDate", | |
| "type": "datetime", | |
| "db_type": "datetime", | |
| "length": 0, | |
| "precision": 0, | |
| "scale": 0, | |
| "default": null, | |
| "required": true, | |
| "allow_null": false, | |
| "fixed_length": false, | |
| "supports_multibyte": false, | |
| "auto_increment": false, | |
| "is_primary_key": null, | |
| "is_foreign_key": null, | |
| "ref_table": "", | |
| "ref_fields": "", | |
| "validation": null, | |
| "value": [] | |
| }, | |
| { | |
| "name": "modifiedBy", | |
| "label": "ModifiedBy", | |
| "type": "reference", | |
| "db_type": "int", | |
| "length": 10, | |
| "precision": 10, | |
| "scale": 0, | |
| "default": null, | |
| "required": false, | |
| "allow_null": true, | |
| "fixed_length": false, | |
| "supports_multibyte": false, | |
| "auto_increment": false, | |
| "is_primary_key": null, | |
| "is_foreign_key": true, | |
| "ref_table": "Users", | |
| "ref_fields": "id", | |
| "validation": null, | |
| "value": [] | |
| }, | |
| { | |
| "name": "modifiedDate", | |
| "label": "ModifiedDate", | |
| "type": "datetime", | |
| "db_type": "datetime", | |
| "length": 0, | |
| "precision": 0, | |
| "scale": 0, | |
| "default": null, | |
| "required": false, | |
| "allow_null": true, | |
| "fixed_length": false, | |
| "supports_multibyte": false, | |
| "auto_increment": false, | |
| "is_primary_key": null, | |
| "is_foreign_key": null, | |
| "ref_table": "", | |
| "ref_fields": "", | |
| "validation": null, | |
| "value": [] | |
| }, | |
| { | |
| "name": "deletedBy", | |
| "label": "DeletedBy", | |
| "type": "reference", | |
| "db_type": "int", | |
| "length": 10, | |
| "precision": 10, | |
| "scale": 0, | |
| "default": null, | |
| "required": false, | |
| "allow_null": true, | |
| "fixed_length": false, | |
| "supports_multibyte": false, | |
| "auto_increment": false, | |
| "is_primary_key": null, | |
| "is_foreign_key": true, | |
| "ref_table": "Users", | |
| "ref_fields": "id", | |
| "validation": null, | |
| "value": [] | |
| }, | |
| { | |
| "name": "deletedDate", | |
| "label": "DeletedDate", | |
| "type": "datetime", | |
| "db_type": "datetime", | |
| "length": 0, | |
| "precision": 0, | |
| "scale": 0, | |
| "default": null, | |
| "required": false, | |
| "allow_null": true, | |
| "fixed_length": false, | |
| "supports_multibyte": false, | |
| "auto_increment": false, | |
| "is_primary_key": null, | |
| "is_foreign_key": null, | |
| "ref_table": "", | |
| "ref_fields": "", | |
| "validation": null, | |
| "value": [] | |
| } | |
| ], | |
| "related": [ | |
| { | |
| "name": "Countries_by_mailingAddressCountry", | |
| "type": "belongs_to", | |
| "ref_table": "Countries", | |
| "ref_field": "id", | |
| "field": "mailingAddressCountry" | |
| }, | |
| { | |
| "name": "Countries_by_shippingAddressCountry", | |
| "type": "belongs_to", | |
| "ref_table": "Countries", | |
| "ref_field": "id", | |
| "field": "shippingAddressCountry" | |
| }, | |
| { | |
| "name": "Countries_by_remitToAddressCountry", | |
| "type": "belongs_to", | |
| "ref_table": "Countries", | |
| "ref_field": "id", | |
| "field": "remitToAddressCountry" | |
| }, | |
| { | |
| "name": "Currencies_by_currency", | |
| "type": "belongs_to", | |
| "ref_table": "Currencies", | |
| "ref_field": "id", | |
| "field": "currency" | |
| }, | |
| { | |
| "name": "PaymentTerms_by_paymentTerms", | |
| "type": "belongs_to", | |
| "ref_table": "PaymentTerms", | |
| "ref_field": "id", | |
| "field": "paymentTerms" | |
| }, | |
| { | |
| "name": "Users_by_createdBy", | |
| "type": "belongs_to", | |
| "ref_table": "Users", | |
| "ref_field": "id", | |
| "field": "createdBy" | |
| }, | |
| { | |
| "name": "Users_by_modifiedBy", | |
| "type": "belongs_to", | |
| "ref_table": "Users", | |
| "ref_field": "id", | |
| "field": "modifiedBy" | |
| }, | |
| { | |
| "name": "Users_by_deletedBy", | |
| "type": "belongs_to", | |
| "ref_table": "Users", | |
| "ref_field": "id", | |
| "field": "deletedBy" | |
| }, | |
| { | |
| "name": "Vendors_by_id", | |
| "type": "belongs_to", | |
| "ref_table": "Vendors", | |
| "ref_field": "id", | |
| "field": "id" | |
| }, | |
| { | |
| "name": "VendorDivisions_by_vendor", | |
| "type": "has_many", | |
| "ref_table": "VendorDivisions", | |
| "ref_field": "vendor", | |
| "field": "id" | |
| }, | |
| { | |
| "name": "VendorCategory_by_VendorDivisions", | |
| "type": "many_many", | |
| "ref_table": "VendorCategories", | |
| "ref_field": "id", | |
| "join": "VendorDivisions(vendor,vendorCategory)", | |
| "field": "id" | |
| } | |
| ], | |
| "access": [ | |
| "GET", | |
| "POST", | |
| "PUT", | |
| "PATCH", | |
| "MERGE", | |
| "DELETE", | |
| "ADMIN" | |
| ] | |
| } |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment