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 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 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