Skip to content

Instantly share code, notes, and snippets.

@ultimatemonty
Last active August 29, 2015 14:10
Show Gist options
  • Save ultimatemonty/c4a6faa53e4f193dc7eb to your computer and use it in GitHub Desktop.
Save ultimatemonty/c4a6faa53e4f193dc7eb to your computer and use it in GitHub Desktop.
Schema for PaymentTerms table
// 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 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