JavaCodeGenerator .zproject file for PostgreSQL
Last updated
Last updated
Zontroy Generator is a developer tool for generating source code. Zontroy is compatible with Java and all Java frameworks. You can generate Java code using Zontroy IDE or command line of any known IDE such as Visual Studio Code, Eclipse or Netbeans.
{
"Name": "JavaCodeGenerator",
"DatabaseType": "PostgreSQL",
"Server": "localhost",
"DatabaseName": "Pagila",
"ConnectionString": "Server=localhost;Username=postgres;Password=12345;Database=Pagila;Port=5432",
"Username": "postgres",
"Password": "12345",
"Language": "Java",
"Port": "",
"IsIntegratedSecurity": false,
"Entities": [
{
"Name": "payment",
"Type": 1,
"TargetName": "payment",
"AlternativeName": "",
"Label": "payment",
"RowOrder": 0,
"Description": "",
"Extra1": "",
"Extra2": "",
"Extra3": "",
"Extra4": "",
"Extra5": "",
"Extra6": "",
"Extra7": "",
"Extra8": "",
"Extra9": "",
"EntitySchema": {
"Name": "public",
"User": null,
"Password": null,
"TargetName": null,
"AlternativeName": null,
"Label": null,
"RowOrder": null,
"Description": null,
"Extra1": null,
"Extra2": null,
"Extra3": null,
"Extra4": null,
"Extra5": null,
"Extra6": null,
"Extra7": null,
"Extra8": null,
"Extra9": null,
"Catalog": {
"Type": null,
"Name": "Pagila",
"Server": null,
"TargetName": null,
"AlternativeName": null,
"Label": null,
"RowOrder": null,
"Description": null,
"Extra1": null,
"Extra2": null,
"Extra3": null,
"Extra4": null,
"Extra5": null,
"Extra6": null,
"Extra7": null,
"Extra8": null,
"Extra9": null,
"Project": null,
"Schemas": []
},
"Entities": []
},
"Fields": [
{
"Name": "payment_id",
"EntityName": "payment",
"VirtualEntityName": "",
"EntitySchema": "public",
"TargetName": "payment_id",
"AlternativeName": "",
"Label": "payment_id",
"Order": 1,
"Description": "",
"Extra1": "",
"Extra2": "",
"Extra3": "",
"Extra4": "",
"Extra5": "",
"Extra6": "",
"Extra7": "",
"Extra8": "",
"Extra9": ""
},
{
"Name": "customer_id",
"EntityName": "payment",
"VirtualEntityName": "",
"EntitySchema": "public",
"TargetName": "customer_id",
"AlternativeName": "",
"Label": "customer_id",
"Order": 2,
"Description": "",
"Extra1": "",
"Extra2": "",
"Extra3": "",
"Extra4": "",
"Extra5": "",
"Extra6": "",
"Extra7": "",
"Extra8": "",
"Extra9": ""
},
{
"Name": "staff_id",
"EntityName": "payment",
"VirtualEntityName": "",
"EntitySchema": "public",
"TargetName": "staff_id",
"AlternativeName": "",
"Label": "staff_id",
"Order": 3,
"Description": "",
"Extra1": "",
"Extra2": "",
"Extra3": "",
"Extra4": "",
"Extra5": "",
"Extra6": "",
"Extra7": "",
"Extra8": "",
"Extra9": ""
},
{
"Name": "rental_id",
"EntityName": "payment",
"VirtualEntityName": "",
"EntitySchema": "public",
"TargetName": "rental_id",
"AlternativeName": "",
"Label": "rental_id",
"Order": 4,
"Description": "",
"Extra1": "",
"Extra2": "",
"Extra3": "",
"Extra4": "",
"Extra5": "",
"Extra6": "",
"Extra7": "",
"Extra8": "",
"Extra9": ""
},
{
"Name": "amount",
"EntityName": "payment",
"VirtualEntityName": "",
"EntitySchema": "public",
"TargetName": "amount",
"AlternativeName": "",
"Label": "amount",
"Order": 5,
"Description": "",
"Extra1": "",
"Extra2": "",
"Extra3": "",
"Extra4": "",
"Extra5": "",
"Extra6": "",
"Extra7": "",
"Extra8": "",
"Extra9": ""
},
{
"Name": "payment_date",
"EntityName": "payment",
"VirtualEntityName": "",
"EntitySchema": "public",
"TargetName": "payment_date",
"AlternativeName": "",
"Label": "payment_date",
"Order": 6,
"Description": "",
"Extra1": "",
"Extra2": "",
"Extra3": "",
"Extra4": "",
"Extra5": "",
"Extra6": "",
"Extra7": "",
"Extra8": "",
"Extra9": ""
}
],
"DisplayFields": "payment_id"
},
{
"Name": "payment_p2022_07",
"Type": 1,
"TargetName": "payment_p2022_07",
"AlternativeName": "",
"Label": "payment_p2022_07",
"RowOrder": 0,
"Description": "",
"Extra1": "",
"Extra2": "",
"Extra3": "",
"Extra4": "",
"Extra5": "",
"Extra6": "",
"Extra7": "",
"Extra8": "",
"Extra9": "",
"EntitySchema": {
"Name": "public",
"User": null,
"Password": null,
"TargetName": null,
"AlternativeName": null,
"Label": null,
"RowOrder": null,
"Description": null,
"Extra1": null,
"Extra2": null,
"Extra3": null,
"Extra4": null,
"Extra5": null,
"Extra6": null,
"Extra7": null,
"Extra8": null,
"Extra9": null,
"Catalog": {
"Type": null,
"Name": "Pagila",
"Server": null,
"TargetName": null,
"AlternativeName": null,
"Label": null,
"RowOrder": null,
"Description": null,
"Extra1": null,
"Extra2": null,
"Extra3": null,
"Extra4": null,
"Extra5": null,
"Extra6": null,
"Extra7": null,
"Extra8": null,
"Extra9": null,
"Project": null,
"Schemas": []
},
"Entities": []
},
"Fields": [
{
"Name": "payment_id",
"EntityName": "payment_p2022_07",
"VirtualEntityName": "",
"EntitySchema": "public",
"TargetName": "payment_id",
"AlternativeName": "",
"Label": "payment_id",
"Order": 1,
"Description": "",
"Extra1": "",
"Extra2": "",
"Extra3": "",
"Extra4": "",
"Extra5": "",
"Extra6": "",
"Extra7": "",
"Extra8": "",
"Extra9": ""
},
{
"Name": "customer_id",
"EntityName": "payment_p2022_07",
"VirtualEntityName": "",
"EntitySchema": "public",
"TargetName": "customer_id",
"AlternativeName": "",
"Label": "customer_id",
"Order": 2,
"Description": "",
"Extra1": "",
"Extra2": "",
"Extra3": "",
"Extra4": "",
"Extra5": "",
"Extra6": "",
"Extra7": "",
"Extra8": "",
"Extra9": ""
},
{
"Name": "staff_id",
"EntityName": "payment_p2022_07",
"VirtualEntityName": "",
"EntitySchema": "public",
"TargetName": "staff_id",
"AlternativeName": "",
"Label": "staff_id",
"Order": 3,
"Description": "",
"Extra1": "",
"Extra2": "",
"Extra3": "",
"Extra4": "",
"Extra5": "",
"Extra6": "",
"Extra7": "",
"Extra8": "",
"Extra9": ""
},
{
"Name": "rental_id",
"EntityName": "payment_p2022_07",
"VirtualEntityName": "",
"EntitySchema": "public",
"TargetName": "rental_id",
"AlternativeName": "",
"Label": "rental_id",
"Order": 4,
"Description": "",
"Extra1": "",
"Extra2": "",
"Extra3": "",
"Extra4": "",
"Extra5": "",
"Extra6": "",
"Extra7": "",
"Extra8": "",
"Extra9": ""
},
{
"Name": "amount",
"EntityName": "payment_p2022_07",
"VirtualEntityName": "",
"EntitySchema": "public",
"TargetName": "amount",
"AlternativeName": "",
"Label": "amount",
"Order": 5,
"Description": "",
"Extra1": "",
"Extra2": "",
"Extra3": "",
"Extra4": "",
"Extra5": "",
"Extra6": "",
"Extra7": "",
"Extra8": "",
"Extra9": ""
},
{
"Name": "payment_date",
"EntityName": "payment_p2022_07",
"VirtualEntityName": "",
"EntitySchema": "public",
"TargetName": "payment_date",
"AlternativeName": "",
"Label": "payment_date",
"Order": 6,
"Description": "",
"Extra1": "",
"Extra2": "",
"Extra3": "",
"Extra4": "",
"Extra5": "",
"Extra6": "",
"Extra7": "",
"Extra8": "",
"Extra9": ""
}
],
"DisplayFields": "payment_id"
},
{
"Name": "film",
"Type": 1,
"TargetName": "film",
"AlternativeName": "",
"Label": "film",
"RowOrder": 0,
"Description": "",
"Extra1": "",
"Extra2": "",
"Extra3": "",
"Extra4": "",
"Extra5": "",
"Extra6": "",
"Extra7": "",
"Extra8": "",
"Extra9": "",
"EntitySchema": {
"Name": "public",
"User": null,
"Password": null,
"TargetName": null,
"AlternativeName": null,
"Label": null,
"RowOrder": null,
"Description": null,
"Extra1": null,
"Extra2": null,
"Extra3": null,
"Extra4": null,
"Extra5": null,
"Extra6": null,
"Extra7": null,
"Extra8": null,
"Extra9": null,
"Catalog": {
"Type": null,
"Name": "Pagila",
"Server": null,
"TargetName": null,
"AlternativeName": null,
"Label": null,
"RowOrder": null,
"Description": null,
"Extra1": null,
"Extra2": null,
"Extra3": null,
"Extra4": null,
"Extra5": null,
"Extra6": null,
"Extra7": null,
"Extra8": null,
"Extra9": null,
"Project": null,
"Schemas": []
},
"Entities": []
},
"Fields": [
{
"Name": "film_id",
"EntityName": "film",
"VirtualEntityName": "",
"EntitySchema": "public",
"TargetName": "film_id",
"AlternativeName": "",
"Label": "film_id",
"Order": 1,
"Description": "",
"Extra1": "",
"Extra2": "",
"Extra3": "",
"Extra4": "",
"Extra5": "",
"Extra6": "",
"Extra7": "",
"Extra8": "",
"Extra9": ""
},
{
"Name": "release_year",
"EntityName": "film",
"VirtualEntityName": "",
"EntitySchema": "public",
"TargetName": "release_year",
"AlternativeName": "",
"Label": "release_year",
"Order": 4,
"Description": "",
"Extra1": "",
"Extra2": "",
"Extra3": "",
"Extra4": "",
"Extra5": "",
"Extra6": "",
"Extra7": "",
"Extra8": "",
"Extra9": ""
},
{
"Name": "language_id",
"EntityName": "film",
"VirtualEntityName": "",
"EntitySchema": "public",
"TargetName": "language_id",
"AlternativeName": "",
"Label": "language_id",
"Order": 5,
"Description": "",
"Extra1": "",
"Extra2": "",
"Extra3": "",
"Extra4": "",
"Extra5": "",
"Extra6": "",
"Extra7": "",
"Extra8": "",
"Extra9": ""
},
{
"Name": "original_language_id",
"EntityName": "film",
"VirtualEntityName": "",
"EntitySchema": "public",
"TargetName": "original_language_id",
"AlternativeName": "",
"Label": "original_language_id",
"Order": 6,
"Description": "",
"Extra1": "",
"Extra2": "",
"Extra3": "",
"Extra4": "",
"Extra5": "",
"Extra6": "",
"Extra7": "",
"Extra8": "",
"Extra9": ""
},
{
"Name": "rental_duration",
"EntityName": "film",
"VirtualEntityName": "",
"EntitySchema": "public",
"TargetName": "rental_duration",
"AlternativeName": "",
"Label": "rental_duration",
"Order": 7,
"Description": "",
"Extra1": "",
"Extra2": "",
"Extra3": "",
"Extra4": "",
"Extra5": "",
"Extra6": "",
"Extra7": "",
"Extra8": "",
"Extra9": ""
},
{
"Name": "rental_rate",
"EntityName": "film",
"VirtualEntityName": "",
"EntitySchema": "public",
"TargetName": "rental_rate",
"AlternativeName": "",
"Label": "rental_rate",
"Order": 8,
"Description": "",
"Extra1": "",
"Extra2": "",
"Extra3": "",
"Extra4": "",
"Extra5": "",
"Extra6": "",
"Extra7": "",
"Extra8": "",
"Extra9": ""
},
{
"Name": "length",
"EntityName": "film",
"VirtualEntityName": "",
"EntitySchema": "public",
"TargetName": "length",
"AlternativeName": "",
"Label": "length",
"Order": 9,
"Description": "",
"Extra1": "",
"Extra2": "",
"Extra3": "",
"Extra4": "",
"Extra5": "",
"Extra6": "",
"Extra7": "",
"Extra8": "",
"Extra9": ""
},
{
"Name": "replacement_cost",
"EntityName": "film",
"VirtualEntityName": "",
"EntitySchema": "public",
"TargetName": "replacement_cost",
"AlternativeName": "",
"Label": "replacement_cost",
"Order": 10,
"Description": "",
"Extra1": "",
"Extra2": "",
"Extra3": "",
"Extra4": "",
"Extra5": "",
"Extra6": "",
"Extra7": "",
"Extra8": "",
"Extra9": ""
},
{
"Name": "rating",
"EntityName": "film",
"VirtualEntityName": "",
"EntitySchema": "public",
"TargetName": "rating",
"AlternativeName": "",
"Label": "rating",
"Order": 11,
"Description": "",
"Extra1": "",
"Extra2": "",
"Extra3": "",
"Extra4": "",
"Extra5": "",
"Extra6": "",
"Extra7": "",
"Extra8": "",
"Extra9": ""
},
{
"Name": "last_update",
"EntityName": "film",
"VirtualEntityName": "",
"EntitySchema": "public",
"TargetName": "last_update",
"AlternativeName": "",
"Label": "last_update",
"Order": 12,
"Description": "",
"Extra1": "",
"Extra2": "",
"Extra3": "",
"Extra4": "",
"Extra5": "",
"Extra6": "",
"Extra7": "",
"Extra8": "",
"Extra9": ""
},
{
"Name": "fulltext",
"EntityName": "film",
"VirtualEntityName": "",
"EntitySchema": "public",
"TargetName": "fulltext",
"AlternativeName": "",
"Label": "fulltext",
"Order": 14,
"Description": "",
"Extra1": "",
"Extra2": "",
"Extra3": "",
"Extra4": "",
"Extra5": "",
"Extra6": "",
"Extra7": "",
"Extra8": "",
"Extra9": ""
},
{
"Name": "title",
"EntityName": "film",
"VirtualEntityName": "",
"EntitySchema": "public",
"TargetName": "title",
"AlternativeName": "",
"Label": "title",
"Order": 2,
"Description": "",
"Extra1": "",
"Extra2": "",
"Extra3": "",
"Extra4": "",
"Extra5": "",
"Extra6": "",
"Extra7": "",
"Extra8": "",
"Extra9": ""
},
{
"Name": "description",
"EntityName": "film",
"VirtualEntityName": "",
"EntitySchema": "public",
"TargetName": "description",
"AlternativeName": "",
"Label": "description",
"Order": 3,
"Description": "",
"Extra1": "",
"Extra2": "",
"Extra3": "",
"Extra4": "",
"Extra5": "",
"Extra6": "",
"Extra7": "",
"Extra8": "",
"Extra9": ""
},
{
"Name": "special_features",
"EntityName": "film",
"VirtualEntityName": "",
"EntitySchema": "public",
"TargetName": "special_features",
"AlternativeName": "",
"Label": "special_features",
"Order": 13,
"Description": "",
"Extra1": "",
"Extra2": "",
"Extra3": "",
"Extra4": "",
"Extra5": "",
"Extra6": "",
"Extra7": "",
"Extra8": "",
"Extra9": ""
}
],
"DisplayFields": "film_id"
},
{
"Name": "actor",
"Type": 1,
"TargetName": "actor",
"AlternativeName": "",
"Label": "actor",
"RowOrder": 0,
"Description": "",
"Extra1": "",
"Extra2": "",
"Extra3": "",
"Extra4": "",
"Extra5": "",
"Extra6": "",
"Extra7": "",
"Extra8": "",
"Extra9": "",
"EntitySchema": {
"Name": "public",
"User": null,
"Password": null,
"TargetName": null,
"AlternativeName": null,
"Label": null,
"RowOrder": null,
"Description": null,
"Extra1": null,
"Extra2": null,
"Extra3": null,
"Extra4": null,
"Extra5": null,
"Extra6": null,
"Extra7": null,
"Extra8": null,
"Extra9": null,
"Catalog": {
"Type": null,
"Name": "Pagila",
"Server": null,
"TargetName": null,
"AlternativeName": null,
"Label": null,
"RowOrder": null,
"Description": null,
"Extra1": null,
"Extra2": null,
"Extra3": null,
"Extra4": null,
"Extra5": null,
"Extra6": null,
"Extra7": null,
"Extra8": null,
"Extra9": null,
"Project": null,
"Schemas": []
},
"Entities": []
},
"Fields": [
{
"Name": "actor_id",
"EntityName": "actor",
"VirtualEntityName": "",
"EntitySchema": "public",
"TargetName": "actor_id",
"AlternativeName": "",
"Label": "actor_id",
"Order": 1,
"Description": "",
"Extra1": "",
"Extra2": "",
"Extra3": "",
"Extra4": "",
"Extra5": "",
"Extra6": "",
"Extra7": "",
"Extra8": "",
"Extra9": ""
},
{
"Name": "last_update",
"EntityName": "actor",
"VirtualEntityName": "",
"EntitySchema": "public",
"TargetName": "last_update",
"AlternativeName": "",
"Label": "last_update",
"Order": 4,
"Description": "",
"Extra1": "",
"Extra2": "",
"Extra3": "",
"Extra4": "",
"Extra5": "",
"Extra6": "",
"Extra7": "",
"Extra8": "",
"Extra9": ""
},
{
"Name": "first_name",
"EntityName": "actor",
"VirtualEntityName": "",
"EntitySchema": "public",
"TargetName": "first_name",
"AlternativeName": "",
"Label": "first_name",
"Order": 2,
"Description": "",
"Extra1": "",
"Extra2": "",
"Extra3": "",
"Extra4": "",
"Extra5": "",
"Extra6": "",
"Extra7": "",
"Extra8": "",
"Extra9": ""
},
{
"Name": "last_name",
"EntityName": "actor",
"VirtualEntityName": "",
"EntitySchema": "public",
"TargetName": "last_name",
"AlternativeName": "",
"Label": "last_name",
"Order": 3,
"Description": "",
"Extra1": "",
"Extra2": "",
"Extra3": "",
"Extra4": "",
"Extra5": "",
"Extra6": "",
"Extra7": "",
"Extra8": "",
"Extra9": ""
}
],
"DisplayFields": "actor_id"
},
{
"Name": "address",
"Type": 1,
"TargetName": "address",
"AlternativeName": "",
"Label": "address",
"RowOrder": 0,
"Description": "",
"Extra1": "",
"Extra2": "",
"Extra3": "",
"Extra4": "",
"Extra5": "",
"Extra6": "",
"Extra7": "",
"Extra8": "",
"Extra9": "",
"EntitySchema": {
"Name": "public",
"User": null,
"Password": null,
"TargetName": null,
"AlternativeName": null,
"Label": null,
"RowOrder": null,
"Description": null,
"Extra1": null,
"Extra2": null,
"Extra3": null,
"Extra4": null,
"Extra5": null,
"Extra6": null,
"Extra7": null,
"Extra8": null,
"Extra9": null,
"Catalog": {
"Type": null,
"Name": "Pagila",
"Server": null,
"TargetName": null,
"AlternativeName": null,
"Label": null,
"RowOrder": null,
"Description": null,
"Extra1": null,
"Extra2": null,
"Extra3": null,
"Extra4": null,
"Extra5": null,
"Extra6": null,
"Extra7": null,
"Extra8": null,
"Extra9": null,
"Project": null,
"Schemas": []
},
"Entities": []
},
"Fields": [
{
"Name": "address_id",
"EntityName": "address",
"VirtualEntityName": "",
"EntitySchema": "public",
"TargetName": "address_id",
"AlternativeName": "",
"Label": "address_id",
"Order": 1,
"Description": "",
"Extra1": "",
"Extra2": "",
"Extra3": "",
"Extra4": "",
"Extra5": "",
"Extra6": "",
"Extra7": "",
"Extra8": "",
"Extra9": ""
},
{
"Name": "city_id",
"EntityName": "address",
"VirtualEntityName": "",
"EntitySchema": "public",
"TargetName": "city_id",
"AlternativeName": "",
"Label": "city_id",
"Order": 5,
"Description": "",
"Extra1": "",
"Extra2": "",
"Extra3": "",
"Extra4": "",
"Extra5": "",
"Extra6": "",
"Extra7": "",
"Extra8": "",
"Extra9": ""
},
{
"Name": "last_update",
"EntityName": "address",
"VirtualEntityName": "",
"EntitySchema": "public",
"TargetName": "last_update",
"AlternativeName": "",
"Label": "last_update",
"Order": 8,
"Description": "",
"Extra1": "",
"Extra2": "",
"Extra3": "",
"Extra4": "",
"Extra5": "",
"Extra6": "",
"Extra7": "",
"Extra8": "",
"Extra9": ""
},
{
"Name": "address",
"EntityName": "address",
"VirtualEntityName": "",
"EntitySchema": "public",
"TargetName": "address",
"AlternativeName": "",
"Label": "address",
"Order": 2,
"Description": "",
"Extra1": "",
"Extra2": "",
"Extra3": "",
"Extra4": "",
"Extra5": "",
"Extra6": "",
"Extra7": "",
"Extra8": "",
"Extra9": ""
},
{
"Name": "address2",
"EntityName": "address",
"VirtualEntityName": "",
"EntitySchema": "public",
"TargetName": "address2",
"AlternativeName": "",
"Label": "address2",
"Order": 3,
"Description": "",
"Extra1": "",
"Extra2": "",
"Extra3": "",
"Extra4": "",
"Extra5": "",
"Extra6": "",
"Extra7": "",
"Extra8": "",
"Extra9": ""
},
{
"Name": "district",
"EntityName": "address",
"VirtualEntityName": "",
"EntitySchema": "public",
"TargetName": "district",
"AlternativeName": "",
"Label": "district",
"Order": 4,
"Description": "",
"Extra1": "",
"Extra2": "",
"Extra3": "",
"Extra4": "",
"Extra5": "",
"Extra6": "",
"Extra7": "",
"Extra8": "",
"Extra9": ""
},
{
"Name": "postal_code",
"EntityName": "address",
"VirtualEntityName": "",
"EntitySchema": "public",
"TargetName": "postal_code",
"AlternativeName": "",
"Label": "postal_code",
"Order": 6,
"Description": "",
"Extra1": "",
"Extra2": "",
"Extra3": "",
"Extra4": "",
"Extra5": "",
"Extra6": "",
"Extra7": "",
"Extra8": "",
"Extra9": ""
},
{
"Name": "phone",
"EntityName": "address",
"VirtualEntityName": "",
"EntitySchema": "public",
"TargetName": "phone",
"AlternativeName": "",
"Label": "phone",
"Order": 7,
"Description": "",
"Extra1": "",
"Extra2": "",
"Extra3": "",
"Extra4": "",
"Extra5": "",
"Extra6": "",
"Extra7": "",
"Extra8": "",
"Extra9": ""
}
],
"DisplayFields": "address_id"
},
{
"Name": "category",
"Type": 1,
"TargetName": "category",
"AlternativeName": "",
"Label": "category",
"RowOrder": 0,
"Description": "",
"Extra1": "",
"Extra2": "",
"Extra3": "",
"Extra4": "",
"Extra5": "",
"Extra6": "",
"Extra7": "",
"Extra8": "",
"Extra9": "",
"EntitySchema": {
"Name": "public",
"User": null,
"Password": null,
"TargetName": null,
"AlternativeName": null,
"Label": null,
"RowOrder": null,
"Description": null,
"Extra1": null,
"Extra2": null,
"Extra3": null,
"Extra4": null,
"Extra5": null,
"Extra6": null,
"Extra7": null,
"Extra8": null,
"Extra9": null,
"Catalog": {
"Type": null,
"Name": "Pagila",
"Server": null,
"TargetName": null,
"AlternativeName": null,
"Label": null,
"RowOrder": null,
"Description": null,
"Extra1": null,
"Extra2": null,
"Extra3": null,
"Extra4": null,
"Extra5": null,
"Extra6": null,
"Extra7": null,
"Extra8": null,
"Extra9": null,
"Project": null,
"Schemas": []
},
"Entities": []
},
"Fields": [
{
"Name": "category_id",
"EntityName": "category",
"VirtualEntityName": "",
"EntitySchema": "public",
"TargetName": "category_id",
"AlternativeName": "",
"Label": "category_id",
"Order": 1,
"Description": "",
"Extra1": "",
"Extra2": "",
"Extra3": "",
"Extra4": "",
"Extra5": "",
"Extra6": "",
"Extra7": "",
"Extra8": "",
"Extra9": ""
},
{
"Name": "last_update",
"EntityName": "category",
"VirtualEntityName": "",
"EntitySchema": "public",
"TargetName": "last_update",
"AlternativeName": "",
"Label": "last_update",
"Order": 3,
"Description": "",
"Extra1": "",
"Extra2": "",
"Extra3": "",
"Extra4": "",
"Extra5": "",
"Extra6": "",
"Extra7": "",
"Extra8": "",
"Extra9": ""
},
{
"Name": "name",
"EntityName": "category",
"VirtualEntityName": "",
"EntitySchema": "public",
"TargetName": "name",
"AlternativeName": "",
"Label": "name",
"Order": 2,
"Description": "",
"Extra1": "",
"Extra2": "",
"Extra3": "",
"Extra4": "",
"Extra5": "",
"Extra6": "",
"Extra7": "",
"Extra8": "",
"Extra9": ""
}
],
"DisplayFields": "category_id"
},
{
"Name": "city",
"Type": 1,
"TargetName": "city",
"AlternativeName": "",
"Label": "city",
"RowOrder": 0,
"Description": "",
"Extra1": "",
"Extra2": "",
"Extra3": "",
"Extra4": "",
"Extra5": "",
"Extra6": "",
"Extra7": "",
"Extra8": "",
"Extra9": "",
"EntitySchema": {
"Name": "public",
"User": null,
"Password": null,
"TargetName": null,
"AlternativeName": null,
"Label": null,
"RowOrder": null,
"Description": null,
"Extra1": null,
"Extra2": null,
"Extra3": null,
"Extra4": null,
"Extra5": null,
"Extra6": null,
"Extra7": null,
"Extra8": null,
"Extra9": null,
"Catalog": {
"Type": null,
"Name": "Pagila",
"Server": null,
"TargetName": null,
"AlternativeName": null,
"Label": null,
"RowOrder": null,
"Description": null,
"Extra1": null,
"Extra2": null,
"Extra3": null,
"Extra4": null,
"Extra5": null,
"Extra6": null,
"Extra7": null,
"Extra8": null,
"Extra9": null,
"Project": null,
"Schemas": []
},
"Entities": []
},
"Fields": [
{
"Name": "city_id",
"EntityName": "city",
"VirtualEntityName": "",
"EntitySchema": "public",
"TargetName": "city_id",
"AlternativeName": "",
"Label": "city_id",
"Order": 1,
"Description": "",
"Extra1": "",
"Extra2": "",
"Extra3": "",
"Extra4": "",
"Extra5": "",
"Extra6": "",
"Extra7": "",
"Extra8": "",
"Extra9": ""
},
{
"Name": "country_id",
"EntityName": "city",
"VirtualEntityName": "",
"EntitySchema": "public",
"TargetName": "country_id",
"AlternativeName": "",
"Label": "country_id",
"Order": 3,
"Description": "",
"Extra1": "",
"Extra2": "",
"Extra3": "",
"Extra4": "",
"Extra5": "",
"Extra6": "",
"Extra7": "",
"Extra8": "",
"Extra9": ""
},
{
"Name": "last_update",
"EntityName": "city",
"VirtualEntityName": "",
"EntitySchema": "public",
"TargetName": "last_update",
"AlternativeName": "",
"Label": "last_update",
"Order": 4,
"Description": "",
"Extra1": "",
"Extra2": "",
"Extra3": "",
"Extra4": "",
"Extra5": "",
"Extra6": "",
"Extra7": "",
"Extra8": "",
"Extra9": ""
},
{
"Name": "city",
"EntityName": "city",
"VirtualEntityName": "",
"EntitySchema": "public",
"TargetName": "city",
"AlternativeName": "",
"Label": "city",
"Order": 2,
"Description": "",
"Extra1": "",
"Extra2": "",
"Extra3": "",
"Extra4": "",
"Extra5": "",
"Extra6": "",
"Extra7": "",
"Extra8": "",
"Extra9": ""
}
],
"DisplayFields": "city_id"
},
{
"Name": "country",
"Type": 1,
"TargetName": "country",
"AlternativeName": "",
"Label": "country",
"RowOrder": 0,
"Description": "",
"Extra1": "",
"Extra2": "",
"Extra3": "",
"Extra4": "",
"Extra5": "",
"Extra6": "",
"Extra7": "",
"Extra8": "",
"Extra9": "",
"EntitySchema": {
"Name": "public",
"User": null,
"Password": null,
"TargetName": null,
"AlternativeName": null,
"Label": null,
"RowOrder": null,
"Description": null,
"Extra1": null,
"Extra2": null,
"Extra3": null,
"Extra4": null,
"Extra5": null,
"Extra6": null,
"Extra7": null,
"Extra8": null,
"Extra9": null,
"Catalog": {
"Type": null,
"Name": "Pagila",
"Server": null,
"TargetName": null,
"AlternativeName": null,
"Label": null,
"RowOrder": null,
"Description": null,
"Extra1": null,
"Extra2": null,
"Extra3": null,
"Extra4": null,
"Extra5": null,
"Extra6": null,
"Extra7": null,
"Extra8": null,
"Extra9": null,
"Project": null,
"Schemas": []
},
"Entities": []
},
"Fields": [
{
"Name": "country_id",
"EntityName": "country",
"VirtualEntityName": "",
"EntitySchema": "public",
"TargetName": "country_id",
"AlternativeName": "",
"Label": "country_id",
"Order": 1,
"Description": "",
"Extra1": "",
"Extra2": "",
"Extra3": "",
"Extra4": "",
"Extra5": "",
"Extra6": "",
"Extra7": "",
"Extra8": "",
"Extra9": ""
},
{
"Name": "last_update",
"EntityName": "country",
"VirtualEntityName": "",
"EntitySchema": "public",
"TargetName": "last_update",
"AlternativeName": "",
"Label": "last_update",
"Order": 3,
"Description": "",
"Extra1": "",
"Extra2": "",
"Extra3": "",
"Extra4": "",
"Extra5": "",
"Extra6": "",
"Extra7": "",
"Extra8": "",
"Extra9": ""
},
{
"Name": "country",
"EntityName": "country",
"VirtualEntityName": "",
"EntitySchema": "public",
"TargetName": "country",
"AlternativeName": "",
"Label": "country",
"Order": 2,
"Description": "",
"Extra1": "",
"Extra2": "",
"Extra3": "",
"Extra4": "",
"Extra5": "",
"Extra6": "",
"Extra7": "",
"Extra8": "",
"Extra9": ""
}
],
"DisplayFields": "country_id"
},
{
"Name": "customer",
"Type": 1,
"TargetName": "customer",
"AlternativeName": "",
"Label": "customer",
"RowOrder": 0,
"Description": "",
"Extra1": "",
"Extra2": "",
"Extra3": "",
"Extra4": "",
"Extra5": "",
"Extra6": "",
"Extra7": "",
"Extra8": "",
"Extra9": "",
"EntitySchema": {
"Name": "public",
"User": null,
"Password": null,
"TargetName": null,
"AlternativeName": null,
"Label": null,
"RowOrder": null,
"Description": null,
"Extra1": null,
"Extra2": null,
"Extra3": null,
"Extra4": null,
"Extra5": null,
"Extra6": null,
"Extra7": null,
"Extra8": null,
"Extra9": null,
"Catalog": {
"Type": null,
"Name": "Pagila",
"Server": null,
"TargetName": null,
"AlternativeName": null,
"Label": null,
"RowOrder": null,
"Description": null,
"Extra1": null,
"Extra2": null,
"Extra3": null,
"Extra4": null,
"Extra5": null,
"Extra6": null,
"Extra7": null,
"Extra8": null,
"Extra9": null,
"Project": null,
"Schemas": []
},
"Entities": []
},
"Fields": [
{
"Name": "customer_id",
"EntityName": "customer",
"VirtualEntityName": "",
"EntitySchema": "public",
"TargetName": "customer_id",
"AlternativeName": "",
"Label": "customer_id",
"Order": 1,
"Description": "",
"Extra1": "",
"Extra2": "",
"Extra3": "",
"Extra4": "",
"Extra5": "",
"Extra6": "",
"Extra7": "",
"Extra8": "",
"Extra9": ""
},
{
"Name": "store_id",
"EntityName": "customer",
"VirtualEntityName": "",
"EntitySchema": "public",
"TargetName": "store_id",
"AlternativeName": "",
"Label": "store_id",
"Order": 2,
"Description": "",
"Extra1": "",
"Extra2": "",
"Extra3": "",
"Extra4": "",
"Extra5": "",
"Extra6": "",
"Extra7": "",
"Extra8": "",
"Extra9": ""
},
{
"Name": "address_id",
"EntityName": "customer",
"VirtualEntityName": "",
"EntitySchema": "public",
"TargetName": "address_id",
"AlternativeName": "",
"Label": "address_id",
"Order": 6,
"Description": "",
"Extra1": "",
"Extra2": "",
"Extra3": "",
"Extra4": "",
"Extra5": "",
"Extra6": "",
"Extra7": "",
"Extra8": "",
"Extra9": ""
},
{
"Name": "activebool",
"EntityName": "customer",
"VirtualEntityName": "",
"EntitySchema": "public",
"TargetName": "activebool",
"AlternativeName": "",
"Label": "activebool",
"Order": 7,
"Description": "",
"Extra1": "",
"Extra2": "",
"Extra3": "",
"Extra4": "",
"Extra5": "",
"Extra6": "",
"Extra7": "",
"Extra8": "",
"Extra9": ""
},
{
"Name": "create_date",
"EntityName": "customer",
"VirtualEntityName": "",
"EntitySchema": "public",
"TargetName": "create_date",
"AlternativeName": "",
"Label": "create_date",
"Order": 8,
"Description": "",
"Extra1": "",
"Extra2": "",
"Extra3": "",
"Extra4": "",
"Extra5": "",
"Extra6": "",
"Extra7": "",
"Extra8": "",
"Extra9": ""
},
{
"Name": "last_update",
"EntityName": "customer",
"VirtualEntityName": "",
"EntitySchema": "public",
"TargetName": "last_update",
"AlternativeName": "",
"Label": "last_update",
"Order": 9,
"Description": "",
"Extra1": "",
"Extra2": "",
"Extra3": "",
"Extra4": "",
"Extra5": "",
"Extra6": "",
"Extra7": "",
"Extra8": "",
"Extra9": ""
},
{
"Name": "active",
"EntityName": "customer",
"VirtualEntityName": "",
"EntitySchema": "public",
"TargetName": "active",
"AlternativeName": "",
"Label": "active",
"Order": 10,
"Description": "",
"Extra1": "",
"Extra2": "",
"Extra3": "",
"Extra4": "",
"Extra5": "",
"Extra6": "",
"Extra7": "",
"Extra8": "",
"Extra9": ""
},
{
"Name": "first_name",
"EntityName": "customer",
"VirtualEntityName": "",
"EntitySchema": "public",
"TargetName": "first_name",
"AlternativeName": "",
"Label": "first_name",
"Order": 3,
"Description": "",
"Extra1": "",
"Extra2": "",
"Extra3": "",
"Extra4": "",
"Extra5": "",
"Extra6": "",
"Extra7": "",
"Extra8": "",
"Extra9": ""
},
{
"Name": "last_name",
"EntityName": "customer",
"VirtualEntityName": "",
"EntitySchema": "public",
"TargetName": "last_name",
"AlternativeName": "",
"Label": "last_name",
"Order": 4,
"Description": "",
"Extra1": "",
"Extra2": "",
"Extra3": "",
"Extra4": "",
"Extra5": "",
"Extra6": "",
"Extra7": "",
"Extra8": "",
"Extra9": ""
},
{
"Name": "email",
"EntityName": "customer",
"VirtualEntityName": "",
"EntitySchema": "public",
"TargetName": "email",
"AlternativeName": "",
"Label": "email",
"Order": 5,
"Description": "",
"Extra1": "",
"Extra2": "",
"Extra3": "",
"Extra4": "",
"Extra5": "",
"Extra6": "",
"Extra7": "",
"Extra8": "",
"Extra9": ""
}
],
"DisplayFields": "customer_id"
},
{
"Name": "film_actor",
"Type": 1,
"TargetName": "film_actor",
"AlternativeName": "",
"Label": "film_actor",
"RowOrder": 0,
"Description": "",
"Extra1": "",
"Extra2": "",
"Extra3": "",
"Extra4": "",
"Extra5": "",
"Extra6": "",
"Extra7": "",
"Extra8": "",
"Extra9": "",
"EntitySchema": {
"Name": "public",
"User": null,
"Password": null,
"TargetName": null,
"AlternativeName": null,
"Label": null,
"RowOrder": null,
"Description": null,
"Extra1": null,
"Extra2": null,
"Extra3": null,
"Extra4": null,
"Extra5": null,
"Extra6": null,
"Extra7": null,
"Extra8": null,
"Extra9": null,
"Catalog": {
"Type": null,
"Name": "Pagila",
"Server": null,
"TargetName": null,
"AlternativeName": null,
"Label": null,
"RowOrder": null,
"Description": null,
"Extra1": null,
"Extra2": null,
"Extra3": null,
"Extra4": null,
"Extra5": null,
"Extra6": null,
"Extra7": null,
"Extra8": null,
"Extra9": null,
"Project": null,
"Schemas": []
},
"Entities": []
},
"Fields": [
{
"Name": "actor_id",
"EntityName": "film_actor",
"VirtualEntityName": "",
"EntitySchema": "public",
"TargetName": "actor_id",
"AlternativeName": "",
"Label": "actor_id",
"Order": 1,
"Description": "",
"Extra1": "",
"Extra2": "",
"Extra3": "",
"Extra4": "",
"Extra5": "",
"Extra6": "",
"Extra7": "",
"Extra8": "",
"Extra9": ""
},
{
"Name": "film_id",
"EntityName": "film_actor",
"VirtualEntityName": "",
"EntitySchema": "public",
"TargetName": "film_id",
"AlternativeName": "",
"Label": "film_id",
"Order": 2,
"Description": "",
"Extra1": "",
"Extra2": "",
"Extra3": "",
"Extra4": "",
"Extra5": "",
"Extra6": "",
"Extra7": "",
"Extra8": "",
"Extra9": ""
},
{
"Name": "last_update",
"EntityName": "film_actor",
"VirtualEntityName": "",
"EntitySchema": "public",
"TargetName": "last_update",
"AlternativeName": "",
"Label": "last_update",
"Order": 3,
"Description": "",
"Extra1": "",
"Extra2": "",
"Extra3": "",
"Extra4": "",
"Extra5": "",
"Extra6": "",
"Extra7": "",
"Extra8": "",
"Extra9": ""
}
],
"DisplayFields": "actor_id"
},
{
"Name": "film_category",
"Type": 1,
"TargetName": "film_category",
"AlternativeName": "",
"Label": "film_category",
"RowOrder": 0,
"Description": "",
"Extra1": "",
"Extra2": "",
"Extra3": "",
"Extra4": "",
"Extra5": "",
"Extra6": "",
"Extra7": "",
"Extra8": "",
"Extra9": "",
"EntitySchema": {
"Name": "public",
"User": null,
"Password": null,
"TargetName": null,
"AlternativeName": null,
"Label": null,
"RowOrder": null,
"Description": null,
"Extra1": null,
"Extra2": null,
"Extra3": null,
"Extra4": null,
"Extra5": null,
"Extra6": null,
"Extra7": null,
"Extra8": null,
"Extra9": null,
"Catalog": {
"Type": null,
"Name": "Pagila",
"Server": null,
"TargetName": null,
"AlternativeName": null,
"Label": null,
"RowOrder": null,
"Description": null,
"Extra1": null,
"Extra2": null,
"Extra3": null,
"Extra4": null,
"Extra5": null,
"Extra6": null,
"Extra7": null,
"Extra8": null,
"Extra9": null,
"Project": null,
"Schemas": []
},
"Entities": []
},
"Fields": [
{
"Name": "film_id",
"EntityName": "film_category",
"VirtualEntityName": "",
"EntitySchema": "public",
"TargetName": "film_id",
"AlternativeName": "",
"Label": "film_id",
"Order": 1,
"Description": "",
"Extra1": "",
"Extra2": "",
"Extra3": "",
"Extra4": "",
"Extra5": "",
"Extra6": "",
"Extra7": "",
"Extra8": "",
"Extra9": ""
},
{
"Name": "category_id",
"EntityName": "film_category",
"VirtualEntityName": "",
"EntitySchema": "public",
"TargetName": "category_id",
"AlternativeName": "",
"Label": "category_id",
"Order": 2,
"Description": "",
"Extra1": "",
"Extra2": "",
"Extra3": "",
"Extra4": "",
"Extra5": "",
"Extra6": "",
"Extra7": "",
"Extra8": "",
"Extra9": ""
},
{
"Name": "last_update",
"EntityName": "film_category",
"VirtualEntityName": "",
"EntitySchema": "public",
"TargetName": "last_update",
"AlternativeName": "",
"Label": "last_update",
"Order": 3,
"Description": "",
"Extra1": "",
"Extra2": "",
"Extra3": "",
"Extra4": "",
"Extra5": "",
"Extra6": "",
"Extra7": "",
"Extra8": "",
"Extra9": ""
}
],
"DisplayFields": "film_id"
},
{
"Name": "inventory",
"Type": 1,
"TargetName": "inventory",
"AlternativeName": "",
"Label": "inventory",
"RowOrder": 0,
"Description": "",
"Extra1": "",
"Extra2": "",
"Extra3": "",
"Extra4": "",
"Extra5": "",
"Extra6": "",
"Extra7": "",
"Extra8": "",
"Extra9": "",
"EntitySchema": {
"Name": "public",
"User": null,
"Password": null,
"TargetName": null,
"AlternativeName": null,
"Label": null,
"RowOrder": null,
"Description": null,
"Extra1": null,
"Extra2": null,
"Extra3": null,
"Extra4": null,
"Extra5": null,
"Extra6": null,
"Extra7": null,
"Extra8": null,
"Extra9": null,
"Catalog": {
"Type": null,
"Name": "Pagila",
"Server": null,
"TargetName": null,
"AlternativeName": null,
"Label": null,
"RowOrder": null,
"Description": null,
"Extra1": null,
"Extra2": null,
"Extra3": null,
"Extra4": null,
"Extra5": null,
"Extra6": null,
"Extra7": null,
"Extra8": null,
"Extra9": null,
"Project": null,
"Schemas": []
},
"Entities": []
},
"Fields": [
{
"Name": "inventory_id",
"EntityName": "inventory",
"VirtualEntityName": "",
"EntitySchema": "public",
"TargetName": "inventory_id",
"AlternativeName": "",
"Label": "inventory_id",
"Order": 1,
"Description": "",
"Extra1": "",
"Extra2": "",
"Extra3": "",
"Extra4": "",
"Extra5": "",
"Extra6": "",
"Extra7": "",
"Extra8": "",
"Extra9": ""
},
{
"Name": "film_id",
"EntityName": "inventory",
"VirtualEntityName": "",
"EntitySchema": "public",
"TargetName": "film_id",
"AlternativeName": "",
"Label": "film_id",
"Order": 2,
"Description": "",
"Extra1": "",
"Extra2": "",
"Extra3": "",
"Extra4": "",
"Extra5": "",
"Extra6": "",
"Extra7": "",
"Extra8": "",
"Extra9": ""
},
{
"Name": "store_id",
"EntityName": "inventory",
"VirtualEntityName": "",
"EntitySchema": "public",
"TargetName": "store_id",
"AlternativeName": "",
"Label": "store_id",
"Order": 3,
"Description": "",
"Extra1": "",
"Extra2": "",
"Extra3": "",
"Extra4": "",
"Extra5": "",
"Extra6": "",
"Extra7": "",
"Extra8": "",
"Extra9": ""
},
{
"Name": "last_update",
"EntityName": "inventory",
"VirtualEntityName": "",
"EntitySchema": "public",
"TargetName": "last_update",
"AlternativeName": "",
"Label": "last_update",
"Order": 4,
"Description": "",
"Extra1": "",
"Extra2": "",
"Extra3": "",
"Extra4": "",
"Extra5": "",
"Extra6": "",
"Extra7": "",
"Extra8": "",
"Extra9": ""
}
],
"DisplayFields": "inventory_id"
},
{
"Name": "language",
"Type": 1,
"TargetName": "language",
"AlternativeName": "",
"Label": "language",
"RowOrder": 0,
"Description": "",
"Extra1": "",
"Extra2": "",
"Extra3": "",
"Extra4": "",
"Extra5": "",
"Extra6": "",
"Extra7": "",
"Extra8": "",
"Extra9": "",
"EntitySchema": {
"Name": "public",
"User": null,
"Password": null,
"TargetName": null,
"AlternativeName": null,
"Label": null,
"RowOrder": null,
"Description": null,
"Extra1": null,
"Extra2": null,
"Extra3": null,
"Extra4": null,
"Extra5": null,
"Extra6": null,
"Extra7": null,
"Extra8": null,
"Extra9": null,
"Catalog": {
"Type": null,
"Name": "Pagila",
"Server": null,
"TargetName": null,
"AlternativeName": null,
"Label": null,
"RowOrder": null,
"Description": null,
"Extra1": null,
"Extra2": null,
"Extra3": null,
"Extra4": null,
"Extra5": null,
"Extra6": null,
"Extra7": null,
"Extra8": null,
"Extra9": null,
"Project": null,
"Schemas": []
},
"Entities": []
},
"Fields": [
{
"Name": "language_id",
"EntityName": "language",
"VirtualEntityName": "",
"EntitySchema": "public",
"TargetName": "language_id",
"AlternativeName": "",
"Label": "language_id",
"Order": 1,
"Description": "",
"Extra1": "",
"Extra2": "",
"Extra3": "",
"Extra4": "",
"Extra5": "",
"Extra6": "",
"Extra7": "",
"Extra8": "",
"Extra9": ""
},
{
"Name": "last_update",
"EntityName": "language",
"VirtualEntityName": "",
"EntitySchema": "public",
"TargetName": "last_update",
"AlternativeName": "",
"Label": "last_update",
"Order": 3,
"Description": "",
"Extra1": "",
"Extra2": "",
"Extra3": "",
"Extra4": "",
"Extra5": "",
"Extra6": "",
"Extra7": "",
"Extra8": "",
"Extra9": ""
},
{
"Name": "name",
"EntityName": "language",
"VirtualEntityName": "",
"EntitySchema": "public",
"TargetName": "name",
"AlternativeName": "",
"Label": "name",
"Order": 2,
"Description": "",
"Extra1": "",
"Extra2": "",
"Extra3": "",
"Extra4": "",
"Extra5": "",
"Extra6": "",
"Extra7": "",
"Extra8": "",
"Extra9": ""
}
],
"DisplayFields": "name"
},
{
"Name": "rental",
"Type": 1,
"TargetName": "rental",
"AlternativeName": "",
"Label": "rental",
"RowOrder": 0,
"Description": "",
"Extra1": "",
"Extra2": "",
"Extra3": "",
"Extra4": "",
"Extra5": "",
"Extra6": "",
"Extra7": "",
"Extra8": "",
"Extra9": "",
"EntitySchema": {
"Name": "public",
"User": null,
"Password": null,
"TargetName": null,
"AlternativeName": null,
"Label": null,
"RowOrder": null,
"Description": null,
"Extra1": null,
"Extra2": null,
"Extra3": null,
"Extra4": null,
"Extra5": null,
"Extra6": null,
"Extra7": null,
"Extra8": null,
"Extra9": null,
"Catalog": {
"Type": null,
"Name": "Pagila",
"Server": null,
"TargetName": null,
"AlternativeName": null,
"Label": null,
"RowOrder": null,
"Description": null,
"Extra1": null,
"Extra2": null,
"Extra3": null,
"Extra4": null,
"Extra5": null,
"Extra6": null,
"Extra7": null,
"Extra8": null,
"Extra9": null,
"Project": null,
"Schemas": []
},
"Entities": []
},
"Fields": [
{
"Name": "return_date",
"EntityName": "rental",
"VirtualEntityName": "",
"EntitySchema": "public",
"TargetName": "return_date",
"AlternativeName": "",
"Label": "return_date",
"Order": 5,
"Description": "",
"Extra1": "",
"Extra2": "",
"Extra3": "",
"Extra4": "",
"Extra5": "",
"Extra6": "",
"Extra7": "",
"Extra8": "",
"Extra9": ""
},
{
"Name": "staff_id",
"EntityName": "rental",
"VirtualEntityName": "",
"EntitySchema": "public",
"TargetName": "staff_id",
"AlternativeName": "",
"Label": "staff_id",
"Order": 6,
"Description": "",
"Extra1": "",
"Extra2": "",
"Extra3": "",
"Extra4": "",
"Extra5": "",
"Extra6": "",
"Extra7": "",
"Extra8": "",
"Extra9": ""
},
{
"Name": "last_update",
"EntityName": "rental",
"VirtualEntityName": "",
"EntitySchema": "public",
"TargetName": "last_update",
"AlternativeName": "",
"Label": "last_update",
"Order": 7,
"Description": "",
"Extra1": "",
"Extra2": "",
"Extra3": "",
"Extra4": "",
"Extra5": "",
"Extra6": "",
"Extra7": "",
"Extra8": "",
"Extra9": ""
},
{
"Name": "rental_id",
"EntityName": "rental",
"VirtualEntityName": "",
"EntitySchema": "public",
"TargetName": "rental_id",
"AlternativeName": "",
"Label": "rental_id",
"Order": 1,
"Description": "",
"Extra1": "",
"Extra2": "",
"Extra3": "",
"Extra4": "",
"Extra5": "",
"Extra6": "",
"Extra7": "",
"Extra8": "",
"Extra9": ""
},
{
"Name": "rental_date",
"EntityName": "rental",
"VirtualEntityName": "",
"EntitySchema": "public",
"TargetName": "rental_date",
"AlternativeName": "",
"Label": "rental_date",
"Order": 2,
"Description": "",
"Extra1": "",
"Extra2": "",
"Extra3": "",
"Extra4": "",
"Extra5": "",
"Extra6": "",
"Extra7": "",
"Extra8": "",
"Extra9": ""
},
{
"Name": "inventory_id",
"EntityName": "rental",
"VirtualEntityName": "",
"EntitySchema": "public",
"TargetName": "inventory_id",
"AlternativeName": "",
"Label": "inventory_id",
"Order": 3,
"Description": "",
"Extra1": "",
"Extra2": "",
"Extra3": "",
"Extra4": "",
"Extra5": "",
"Extra6": "",
"Extra7": "",
"Extra8": "",
"Extra9": ""
},
{
"Name": "customer_id",
"EntityName": "rental",
"VirtualEntityName": "",
"EntitySchema": "public",
"TargetName": "customer_id",
"AlternativeName": "",
"Label": "customer_id",
"Order": 4,
"Description": "",
"Extra1": "",
"Extra2": "",
"Extra3": "",
"Extra4": "",
"Extra5": "",
"Extra6": "",
"Extra7": "",
"Extra8": "",
"Extra9": ""
}
],
"DisplayFields": "return_date"
},
{
"Name": "staff",
"Type": 1,
"TargetName": "staff",
"AlternativeName": "",
"Label": "staff",
"RowOrder": 0,
"Description": "",
"Extra1": "",
"Extra2": "",
"Extra3": "",
"Extra4": "",
"Extra5": "",
"Extra6": "",
"Extra7": "",
"Extra8": "",
"Extra9": "",
"EntitySchema": {
"Name": "public",
"User": null,
"Password": null,
"TargetName": null,
"AlternativeName": null,
"Label": null,
"RowOrder": null,
"Description": null,
"Extra1": null,
"Extra2": null,
"Extra3": null,
"Extra4": null,
"Extra5": null,
"Extra6": null,
"Extra7": null,
"Extra8": null,
"Extra9": null,
"Catalog": {
"Type": null,
"Name": "Pagila",
"Server": null,
"TargetName": null,
"AlternativeName": null,
"Label": null,
"RowOrder": null,
"Description": null,
"Extra1": null,
"Extra2": null,
"Extra3": null,
"Extra4": null,
"Extra5": null,
"Extra6": null,
"Extra7": null,
"Extra8": null,
"Extra9": null,
"Project": null,
"Schemas": []
},
"Entities": []
},
"Fields": [
{
"Name": "staff_id",
"EntityName": "staff",
"VirtualEntityName": "",
"EntitySchema": "public",
"TargetName": "staff_id",
"AlternativeName": "",
"Label": "staff_id",
"Order": 1,
"Description": "",
"Extra1": "",
"Extra2": "",
"Extra3": "",
"Extra4": "",
"Extra5": "",
"Extra6": "",
"Extra7": "",
"Extra8": "",
"Extra9": ""
},
{
"Name": "address_id",
"EntityName": "staff",
"VirtualEntityName": "",
"EntitySchema": "public",
"TargetName": "address_id",
"AlternativeName": "",
"Label": "address_id",
"Order": 4,
"Description": "",
"Extra1": "",
"Extra2": "",
"Extra3": "",
"Extra4": "",
"Extra5": "",
"Extra6": "",
"Extra7": "",
"Extra8": "",
"Extra9": ""
},
{
"Name": "store_id",
"EntityName": "staff",
"VirtualEntityName": "",
"EntitySchema": "public",
"TargetName": "store_id",
"AlternativeName": "",
"Label": "store_id",
"Order": 6,
"Description": "",
"Extra1": "",
"Extra2": "",
"Extra3": "",
"Extra4": "",
"Extra5": "",
"Extra6": "",
"Extra7": "",
"Extra8": "",
"Extra9": ""
},
{
"Name": "active",
"EntityName": "staff",
"VirtualEntityName": "",
"EntitySchema": "public",
"TargetName": "active",
"AlternativeName": "",
"Label": "active",
"Order": 7,
"Description": "",
"Extra1": "",
"Extra2": "",
"Extra3": "",
"Extra4": "",
"Extra5": "",
"Extra6": "",
"Extra7": "",
"Extra8": "",
"Extra9": ""
},
{
"Name": "last_update",
"EntityName": "staff",
"VirtualEntityName": "",
"EntitySchema": "public",
"TargetName": "last_update",
"AlternativeName": "",
"Label": "last_update",
"Order": 10,
"Description": "",
"Extra1": "",
"Extra2": "",
"Extra3": "",
"Extra4": "",
"Extra5": "",
"Extra6": "",
"Extra7": "",
"Extra8": "",
"Extra9": ""
},
{
"Name": "picture",
"EntityName": "staff",
"VirtualEntityName": "",
"EntitySchema": "public",
"TargetName": "picture",
"AlternativeName": "",
"Label": "picture",
"Order": 11,
"Description": "",
"Extra1": "",
"Extra2": "",
"Extra3": "",
"Extra4": "",
"Extra5": "",
"Extra6": "",
"Extra7": "",
"Extra8": "",
"Extra9": ""
},
{
"Name": "first_name",
"EntityName": "staff",
"VirtualEntityName": "",
"EntitySchema": "public",
"TargetName": "first_name",
"AlternativeName": "",
"Label": "first_name",
"Order": 2,
"Description": "",
"Extra1": "",
"Extra2": "",
"Extra3": "",
"Extra4": "",
"Extra5": "",
"Extra6": "",
"Extra7": "",
"Extra8": "",
"Extra9": ""
},
{
"Name": "last_name",
"EntityName": "staff",
"VirtualEntityName": "",
"EntitySchema": "public",
"TargetName": "last_name",
"AlternativeName": "",
"Label": "last_name",
"Order": 3,
"Description": "",
"Extra1": "",
"Extra2": "",
"Extra3": "",
"Extra4": "",
"Extra5": "",
"Extra6": "",
"Extra7": "",
"Extra8": "",
"Extra9": ""
},
{
"Name": "password",
"EntityName": "staff",
"VirtualEntityName": "",
"EntitySchema": "public",
"TargetName": "password",
"AlternativeName": "",
"Label": "password",
"Order": 9,
"Description": "",
"Extra1": "",
"Extra2": "",
"Extra3": "",
"Extra4": "",
"Extra5": "",
"Extra6": "",
"Extra7": "",
"Extra8": "",
"Extra9": ""
},
{
"Name": "email",
"EntityName": "staff",
"VirtualEntityName": "",
"EntitySchema": "public",
"TargetName": "email",
"AlternativeName": "",
"Label": "email",
"Order": 5,
"Description": "",
"Extra1": "",
"Extra2": "",
"Extra3": "",
"Extra4": "",
"Extra5": "",
"Extra6": "",
"Extra7": "",
"Extra8": "",
"Extra9": ""
},
{
"Name": "username",
"EntityName": "staff",
"VirtualEntityName": "",
"EntitySchema": "public",
"TargetName": "username",
"AlternativeName": "",
"Label": "username",
"Order": 8,
"Description": "",
"Extra1": "",
"Extra2": "",
"Extra3": "",
"Extra4": "",
"Extra5": "",
"Extra6": "",
"Extra7": "",
"Extra8": "",
"Extra9": ""
}
],
"DisplayFields": "staff_id"
},
{
"Name": "store",
"Type": 1,
"TargetName": "store",
"AlternativeName": "",
"Label": "store",
"RowOrder": 0,
"Description": "",
"Extra1": "",
"Extra2": "",
"Extra3": "",
"Extra4": "",
"Extra5": "",
"Extra6": "",
"Extra7": "",
"Extra8": "",
"Extra9": "",
"EntitySchema": {
"Name": "public",
"User": null,
"Password": null,
"TargetName": null,
"AlternativeName": null,
"Label": null,
"RowOrder": null,
"Description": null,
"Extra1": null,
"Extra2": null,
"Extra3": null,
"Extra4": null,
"Extra5": null,
"Extra6": null,
"Extra7": null,
"Extra8": null,
"Extra9": null,
"Catalog": {
"Type": null,
"Name": "Pagila",
"Server": null,
"TargetName": null,
"AlternativeName": null,
"Label": null,
"RowOrder": null,
"Description": null,
"Extra1": null,
"Extra2": null,
"Extra3": null,
"Extra4": null,
"Extra5": null,
"Extra6": null,
"Extra7": null,
"Extra8": null,
"Extra9": null,
"Project": null,
"Schemas": []
},
"Entities": []
},
"Fields": [
{
"Name": "store_id",
"EntityName": "store",
"VirtualEntityName": "",
"EntitySchema": "public",
"TargetName": "store_id",
"AlternativeName": "",
"Label": "store_id",
"Order": 1,
"Description": "",
"Extra1": "",
"Extra2": "",
"Extra3": "",
"Extra4": "",
"Extra5": "",
"Extra6": "",
"Extra7": "",
"Extra8": "",
"Extra9": ""
},
{
"Name": "manager_staff_id",
"EntityName": "store",
"VirtualEntityName": "",
"EntitySchema": "public",
"TargetName": "manager_staff_id",
"AlternativeName": "",
"Label": "manager_staff_id",
"Order": 2,
"Description": "",
"Extra1": "",
"Extra2": "",
"Extra3": "",
"Extra4": "",
"Extra5": "",
"Extra6": "",
"Extra7": "",
"Extra8": "",
"Extra9": ""
},
{
"Name": "address_id",
"EntityName": "store",
"VirtualEntityName": "",
"EntitySchema": "public",
"TargetName": "address_id",
"AlternativeName": "",
"Label": "address_id",
"Order": 3,
"Description": "",
"Extra1": "",
"Extra2": "",
"Extra3": "",
"Extra4": "",
"Extra5": "",
"Extra6": "",
"Extra7": "",
"Extra8": "",
"Extra9": ""
},
{
"Name": "last_update",
"EntityName": "store",
"VirtualEntityName": "",
"EntitySchema": "public",
"TargetName": "last_update",
"AlternativeName": "",
"Label": "last_update",
"Order": 4,
"Description": "",
"Extra1": "",
"Extra2": "",
"Extra3": "",
"Extra4": "",
"Extra5": "",
"Extra6": "",
"Extra7": "",
"Extra8": "",
"Extra9": ""
}
],
"DisplayFields": "store_id"
},
{
"Name": "payment_p2022_01",
"Type": 1,
"TargetName": "payment_p2022_01",
"AlternativeName": "",
"Label": "payment_p2022_01",
"RowOrder": 0,
"Description": "",
"Extra1": "",
"Extra2": "",
"Extra3": "",
"Extra4": "",
"Extra5": "",
"Extra6": "",
"Extra7": "",
"Extra8": "",
"Extra9": "",
"EntitySchema": {
"Name": "public",
"User": null,
"Password": null,
"TargetName": null,
"AlternativeName": null,
"Label": null,
"RowOrder": null,
"Description": null,
"Extra1": null,
"Extra2": null,
"Extra3": null,
"Extra4": null,
"Extra5": null,
"Extra6": null,
"Extra7": null,
"Extra8": null,
"Extra9": null,
"Catalog": {
"Type": null,
"Name": "Pagila",
"Server": null,
"TargetName": null,
"AlternativeName": null,
"Label": null,
"RowOrder": null,
"Description": null,
"Extra1": null,
"Extra2": null,
"Extra3": null,
"Extra4": null,
"Extra5": null,
"Extra6": null,
"Extra7": null,
"Extra8": null,
"Extra9": null,
"Project": null,
"Schemas": []
},
"Entities": []
},
"Fields": [
{
"Name": "payment_id",
"EntityName": "payment_p2022_01",
"VirtualEntityName": "",
"EntitySchema": "public",
"TargetName": "payment_id",
"AlternativeName": "",
"Label": "payment_id",
"Order": 1,
"Description": "",
"Extra1": "",
"Extra2": "",
"Extra3": "",
"Extra4": "",
"Extra5": "",
"Extra6": "",
"Extra7": "",
"Extra8": "",
"Extra9": ""
},
{
"Name": "customer_id",
"EntityName": "payment_p2022_01",
"VirtualEntityName": "",
"EntitySchema": "public",
"TargetName": "customer_id",
"AlternativeName": "",
"Label": "customer_id",
"Order": 2,
"Description": "",
"Extra1": "",
"Extra2": "",
"Extra3": "",
"Extra4": "",
"Extra5": "",
"Extra6": "",
"Extra7": "",
"Extra8": "",
"Extra9": ""
},
{
"Name": "staff_id",
"EntityName": "payment_p2022_01",
"VirtualEntityName": "",
"EntitySchema": "public",
"TargetName": "staff_id",
"AlternativeName": "",
"Label": "staff_id",
"Order": 3,
"Description": "",
"Extra1": "",
"Extra2": "",
"Extra3": "",
"Extra4": "",
"Extra5": "",
"Extra6": "",
"Extra7": "",
"Extra8": "",
"Extra9": ""
},
{
"Name": "rental_id",
"EntityName": "payment_p2022_01",
"VirtualEntityName": "",
"EntitySchema": "public",
"TargetName": "rental_id",
"AlternativeName": "",
"Label": "rental_id",
"Order": 4,
"Description": "",
"Extra1": "",
"Extra2": "",
"Extra3": "",
"Extra4": "",
"Extra5": "",
"Extra6": "",
"Extra7": "",
"Extra8": "",
"Extra9": ""
},
{
"Name": "amount",
"EntityName": "payment_p2022_01",
"VirtualEntityName": "",
"EntitySchema": "public",
"TargetName": "amount",
"AlternativeName": "",
"Label": "amount",
"Order": 5,
"Description": "",
"Extra1": "",
"Extra2": "",
"Extra3": "",
"Extra4": "",
"Extra5": "",
"Extra6": "",
"Extra7": "",
"Extra8": "",
"Extra9": ""
},
{
"Name": "payment_date",
"EntityName": "payment_p2022_01",
"VirtualEntityName": "",
"EntitySchema": "public",
"TargetName": "payment_date",
"AlternativeName": "",
"Label": "payment_date",
"Order": 6,
"Description": "",
"Extra1": "",
"Extra2": "",
"Extra3": "",
"Extra4": "",
"Extra5": "",
"Extra6": "",
"Extra7": "",
"Extra8": "",
"Extra9": ""
}
],
"DisplayFields": "payment_id"
},
{
"Name": "payment_p2022_02",
"Type": 1,
"TargetName": "payment_p2022_02",
"AlternativeName": "",
"Label": "payment_p2022_02",
"RowOrder": 0,
"Description": "",
"Extra1": "",
"Extra2": "",
"Extra3": "",
"Extra4": "",
"Extra5": "",
"Extra6": "",
"Extra7": "",
"Extra8": "",
"Extra9": "",
"EntitySchema": {
"Name": "public",
"User": null,
"Password": null,
"TargetName": null,
"AlternativeName": null,
"Label": null,
"RowOrder": null,
"Description": null,
"Extra1": null,
"Extra2": null,
"Extra3": null,
"Extra4": null,
"Extra5": null,
"Extra6": null,
"Extra7": null,
"Extra8": null,
"Extra9": null,
"Catalog": {
"Type": null,
"Name": "Pagila",
"Server": null,
"TargetName": null,
"AlternativeName": null,
"Label": null,
"RowOrder": null,
"Description": null,
"Extra1": null,
"Extra2": null,
"Extra3": null,
"Extra4": null,
"Extra5": null,
"Extra6": null,
"Extra7": null,
"Extra8": null,
"Extra9": null,
"Project": null,
"Schemas": []
},
"Entities": []
},
"Fields": [
{
"Name": "payment_id",
"EntityName": "payment_p2022_02",
"VirtualEntityName": "",
"EntitySchema": "public",
"TargetName": "payment_id",
"AlternativeName": "",
"Label": "payment_id",
"Order": 1,
"Description": "",
"Extra1": "",
"Extra2": "",
"Extra3": "",
"Extra4": "",
"Extra5": "",
"Extra6": "",
"Extra7": "",
"Extra8": "",
"Extra9": ""
},
{
"Name": "customer_id",
"EntityName": "payment_p2022_02",
"VirtualEntityName": "",
"EntitySchema": "public",
"TargetName": "customer_id",
"AlternativeName": "",
"Label": "customer_id",
"Order": 2,
"Description": "",
"Extra1": "",
"Extra2": "",
"Extra3": "",
"Extra4": "",
"Extra5": "",
"Extra6": "",
"Extra7": "",
"Extra8": "",
"Extra9": ""
},
{
"Name": "staff_id",
"EntityName": "payment_p2022_02",
"VirtualEntityName": "",
"EntitySchema": "public",
"TargetName": "staff_id",
"AlternativeName": "",
"Label": "staff_id",
"Order": 3,
"Description": "",
"Extra1": "",
"Extra2": "",
"Extra3": "",
"Extra4": "",
"Extra5": "",
"Extra6": "",
"Extra7": "",
"Extra8": "",
"Extra9": ""
},
{
"Name": "rental_id",
"EntityName": "payment_p2022_02",
"VirtualEntityName": "",
"EntitySchema": "public",
"TargetName": "rental_id",
"AlternativeName": "",
"Label": "rental_id",
"Order": 4,
"Description": "",
"Extra1": "",
"Extra2": "",
"Extra3": "",
"Extra4": "",
"Extra5": "",
"Extra6": "",
"Extra7": "",
"Extra8": "",
"Extra9": ""
},
{
"Name": "amount",
"EntityName": "payment_p2022_02",
"VirtualEntityName": "",
"EntitySchema": "public",
"TargetName": "amount",
"AlternativeName": "",
"Label": "amount",
"Order": 5,
"Description": "",
"Extra1": "",
"Extra2": "",
"Extra3": "",
"Extra4": "",
"Extra5": "",
"Extra6": "",
"Extra7": "",
"Extra8": "",
"Extra9": ""
},
{
"Name": "payment_date",
"EntityName": "payment_p2022_02",
"VirtualEntityName": "",
"EntitySchema": "public",
"TargetName": "payment_date",
"AlternativeName": "",
"Label": "payment_date",
"Order": 6,
"Description": "",
"Extra1": "",
"Extra2": "",
"Extra3": "",
"Extra4": "",
"Extra5": "",
"Extra6": "",
"Extra7": "",
"Extra8": "",
"Extra9": ""
}
],
"DisplayFields": "payment_id"
},
{
"Name": "payment_p2022_03",
"Type": 1,
"TargetName": "payment_p2022_03",
"AlternativeName": "",
"Label": "payment_p2022_03",
"RowOrder": 0,
"Description": "",
"Extra1": "",
"Extra2": "",
"Extra3": "",
"Extra4": "",
"Extra5": "",
"Extra6": "",
"Extra7": "",
"Extra8": "",
"Extra9": "",
"EntitySchema": {
"Name": "public",
"User": null,
"Password": null,
"TargetName": null,
"AlternativeName": null,
"Label": null,
"RowOrder": null,
"Description": null,
"Extra1": null,
"Extra2": null,
"Extra3": null,
"Extra4": null,
"Extra5": null,
"Extra6": null,
"Extra7": null,
"Extra8": null,
"Extra9": null,
"Catalog": {
"Type": null,
"Name": "Pagila",
"Server": null,
"TargetName": null,
"AlternativeName": null,
"Label": null,
"RowOrder": null,
"Description": null,
"Extra1": null,
"Extra2": null,
"Extra3": null,
"Extra4": null,
"Extra5": null,
"Extra6": null,
"Extra7": null,
"Extra8": null,
"Extra9": null,
"Project": null,
"Schemas": []
},
"Entities": []
},
"Fields": [
{
"Name": "payment_id",
"EntityName": "payment_p2022_03",
"VirtualEntityName": "",
"EntitySchema": "public",
"TargetName": "payment_id",
"AlternativeName": "",
"Label": "payment_id",
"Order": 1,
"Description": "",
"Extra1": "",
"Extra2": "",
"Extra3": "",
"Extra4": "",
"Extra5": "",
"Extra6": "",
"Extra7": "",
"Extra8": "",
"Extra9": ""
},
{
"Name": "customer_id",
"EntityName": "payment_p2022_03",
"VirtualEntityName": "",
"EntitySchema": "public",
"TargetName": "customer_id",
"AlternativeName": "",
"Label": "customer_id",
"Order": 2,
"Description": "",
"Extra1": "",
"Extra2": "",
"Extra3": "",
"Extra4": "",
"Extra5": "",
"Extra6": "",
"Extra7": "",
"Extra8": "",
"Extra9": ""
},
{
"Name": "staff_id",
"EntityName": "payment_p2022_03",
"VirtualEntityName": "",
"EntitySchema": "public",
"TargetName": "staff_id",
"AlternativeName": "",
"Label": "staff_id",
"Order": 3,
"Description": "",
"Extra1": "",
"Extra2": "",
"Extra3": "",
"Extra4": "",
"Extra5": "",
"Extra6": "",
"Extra7": "",
"Extra8": "",
"Extra9": ""
},
{
"Name": "rental_id",
"EntityName": "payment_p2022_03",
"VirtualEntityName": "",
"EntitySchema": "public",
"TargetName": "rental_id",
"AlternativeName": "",
"Label": "rental_id",
"Order": 4,
"Description": "",
"Extra1": "",
"Extra2": "",
"Extra3": "",
"Extra4": "",
"Extra5": "",
"Extra6": "",
"Extra7": "",
"Extra8": "",
"Extra9": ""
},
{
"Name": "amount",
"EntityName": "payment_p2022_03",
"VirtualEntityName": "",
"EntitySchema": "public",
"TargetName": "amount",
"AlternativeName": "",
"Label": "amount",
"Order": 5,
"Description": "",
"Extra1": "",
"Extra2": "",
"Extra3": "",
"Extra4": "",
"Extra5": "",
"Extra6": "",
"Extra7": "",
"Extra8": "",
"Extra9": ""
},
{
"Name": "payment_date",
"EntityName": "payment_p2022_03",
"VirtualEntityName": "",
"EntitySchema": "public",
"TargetName": "payment_date",
"AlternativeName": "",
"Label": "payment_date",
"Order": 6,
"Description": "",
"Extra1": "",
"Extra2": "",
"Extra3": "",
"Extra4": "",
"Extra5": "",
"Extra6": "",
"Extra7": "",
"Extra8": "",
"Extra9": ""
}
],
"DisplayFields": "payment_id"
},
{
"Name": "payment_p2022_04",
"Type": 1,
"TargetName": "payment_p2022_04",
"AlternativeName": "",
"Label": "payment_p2022_04",
"RowOrder": 0,
"Description": "",
"Extra1": "",
"Extra2": "",
"Extra3": "",
"Extra4": "",
"Extra5": "",
"Extra6": "",
"Extra7": "",
"Extra8": "",
"Extra9": "",
"EntitySchema": {
"Name": "public",
"User": null,
"Password": null,
"TargetName": null,
"AlternativeName": null,
"Label": null,
"RowOrder": null,
"Description": null,
"Extra1": null,
"Extra2": null,
"Extra3": null,
"Extra4": null,
"Extra5": null,
"Extra6": null,
"Extra7": null,
"Extra8": null,
"Extra9": null,
"Catalog": {
"Type": null,
"Name": "Pagila",
"Server": null,
"TargetName": null,
"AlternativeName": null,
"Label": null,
"RowOrder": null,
"Description": null,
"Extra1": null,
"Extra2": null,
"Extra3": null,
"Extra4": null,
"Extra5": null,
"Extra6": null,
"Extra7": null,
"Extra8": null,
"Extra9": null,
"Project": null,
"Schemas": []
},
"Entities": []
},
"Fields": [
{
"Name": "payment_id",
"EntityName": "payment_p2022_04",
"VirtualEntityName": "",
"EntitySchema": "public",
"TargetName": "payment_id",
"AlternativeName": "",
"Label": "payment_id",
"Order": 1,
"Description": "",
"Extra1": "",
"Extra2": "",
"Extra3": "",
"Extra4": "",
"Extra5": "",
"Extra6": "",
"Extra7": "",
"Extra8": "",
"Extra9": ""
},
{
"Name": "customer_id",
"EntityName": "payment_p2022_04",
"VirtualEntityName": "",
"EntitySchema": "public",
"TargetName": "customer_id",
"AlternativeName": "",
"Label": "customer_id",
"Order": 2,
"Description": "",
"Extra1": "",
"Extra2": "",
"Extra3": "",
"Extra4": "",
"Extra5": "",
"Extra6": "",
"Extra7": "",
"Extra8": "",
"Extra9": ""
},
{
"Name": "staff_id",
"EntityName": "payment_p2022_04",
"VirtualEntityName": "",
"EntitySchema": "public",
"TargetName": "staff_id",
"AlternativeName": "",
"Label": "staff_id",
"Order": 3,
"Description": "",
"Extra1": "",
"Extra2": "",
"Extra3": "",
"Extra4": "",
"Extra5": "",
"Extra6": "",
"Extra7": "",
"Extra8": "",
"Extra9": ""
},
{
"Name": "rental_id",
"EntityName": "payment_p2022_04",
"VirtualEntityName": "",
"EntitySchema": "public",
"TargetName": "rental_id",
"AlternativeName": "",
"Label": "rental_id",
"Order": 4,
"Description": "",
"Extra1": "",
"Extra2": "",
"Extra3": "",
"Extra4": "",
"Extra5": "",
"Extra6": "",
"Extra7": "",
"Extra8": "",
"Extra9": ""
},
{
"Name": "amount",
"EntityName": "payment_p2022_04",
"VirtualEntityName": "",
"EntitySchema": "public",
"TargetName": "amount",
"AlternativeName": "",
"Label": "amount",
"Order": 5,
"Description": "",
"Extra1": "",
"Extra2": "",
"Extra3": "",
"Extra4": "",
"Extra5": "",
"Extra6": "",
"Extra7": "",
"Extra8": "",
"Extra9": ""
},
{
"Name": "payment_date",
"EntityName": "payment_p2022_04",
"VirtualEntityName": "",
"EntitySchema": "public",
"TargetName": "payment_date",
"AlternativeName": "",
"Label": "payment_date",
"Order": 6,
"Description": "",
"Extra1": "",
"Extra2": "",
"Extra3": "",
"Extra4": "",
"Extra5": "",
"Extra6": "",
"Extra7": "",
"Extra8": "",
"Extra9": ""
}
],
"DisplayFields": "payment_id"
},
{
"Name": "payment_p2022_05",
"Type": 1,
"TargetName": "payment_p2022_05",
"AlternativeName": "",
"Label": "payment_p2022_05",
"RowOrder": 0,
"Description": "",
"Extra1": "",
"Extra2": "",
"Extra3": "",
"Extra4": "",
"Extra5": "",
"Extra6": "",
"Extra7": "",
"Extra8": "",
"Extra9": "",
"EntitySchema": {
"Name": "public",
"User": null,
"Password": null,
"TargetName": null,
"AlternativeName": null,
"Label": null,
"RowOrder": null,
"Description": null,
"Extra1": null,
"Extra2": null,
"Extra3": null,
"Extra4": null,
"Extra5": null,
"Extra6": null,
"Extra7": null,
"Extra8": null,
"Extra9": null,
"Catalog": {
"Type": null,
"Name": "Pagila",
"Server": null,
"TargetName": null,
"AlternativeName": null,
"Label": null,
"RowOrder": null,
"Description": null,
"Extra1": null,
"Extra2": null,
"Extra3": null,
"Extra4": null,
"Extra5": null,
"Extra6": null,
"Extra7": null,
"Extra8": null,
"Extra9": null,
"Project": null,
"Schemas": []
},
"Entities": []
},
"Fields": [
{
"Name": "payment_id",
"EntityName": "payment_p2022_05",
"VirtualEntityName": "",
"EntitySchema": "public",
"TargetName": "payment_id",
"AlternativeName": "",
"Label": "payment_id",
"Order": 1,
"Description": "",
"Extra1": "",
"Extra2": "",
"Extra3": "",
"Extra4": "",
"Extra5": "",
"Extra6": "",
"Extra7": "",
"Extra8": "",
"Extra9": ""
},
{
"Name": "customer_id",
"EntityName": "payment_p2022_05",
"VirtualEntityName": "",
"EntitySchema": "public",
"TargetName": "customer_id",
"AlternativeName": "",
"Label": "customer_id",
"Order": 2,
"Description": "",
"Extra1": "",
"Extra2": "",
"Extra3": "",
"Extra4": "",
"Extra5": "",
"Extra6": "",
"Extra7": "",
"Extra8": "",
"Extra9": ""
},
{
"Name": "staff_id",
"EntityName": "payment_p2022_05",
"VirtualEntityName": "",
"EntitySchema": "public",
"TargetName": "staff_id",
"AlternativeName": "",
"Label": "staff_id",
"Order": 3,
"Description": "",
"Extra1": "",
"Extra2": "",
"Extra3": "",
"Extra4": "",
"Extra5": "",
"Extra6": "",
"Extra7": "",
"Extra8": "",
"Extra9": ""
},
{
"Name": "rental_id",
"EntityName": "payment_p2022_05",
"VirtualEntityName": "",
"EntitySchema": "public",
"TargetName": "rental_id",
"AlternativeName": "",
"Label": "rental_id",
"Order": 4,
"Description": "",
"Extra1": "",
"Extra2": "",
"Extra3": "",
"Extra4": "",
"Extra5": "",
"Extra6": "",
"Extra7": "",
"Extra8": "",
"Extra9": ""
},
{
"Name": "amount",
"EntityName": "payment_p2022_05",
"VirtualEntityName": "",
"EntitySchema": "public",
"TargetName": "amount",
"AlternativeName": "",
"Label": "amount",
"Order": 5,
"Description": "",
"Extra1": "",
"Extra2": "",
"Extra3": "",
"Extra4": "",
"Extra5": "",
"Extra6": "",
"Extra7": "",
"Extra8": "",
"Extra9": ""
},
{
"Name": "payment_date",
"EntityName": "payment_p2022_05",
"VirtualEntityName": "",
"EntitySchema": "public",
"TargetName": "payment_date",
"AlternativeName": "",
"Label": "payment_date",
"Order": 6,
"Description": "",
"Extra1": "",
"Extra2": "",
"Extra3": "",
"Extra4": "",
"Extra5": "",
"Extra6": "",
"Extra7": "",
"Extra8": "",
"Extra9": ""
}
],
"DisplayFields": "payment_id"
},
{
"Name": "payment_p2022_06",
"Type": 1,
"TargetName": "payment_p2022_06",
"AlternativeName": "",
"Label": "payment_p2022_06",
"RowOrder": 0,
"Description": "",
"Extra1": "",
"Extra2": "",
"Extra3": "",
"Extra4": "",
"Extra5": "",
"Extra6": "",
"Extra7": "",
"Extra8": "",
"Extra9": "",
"EntitySchema": {
"Name": "public",
"User": null,
"Password": null,
"TargetName": null,
"AlternativeName": null,
"Label": null,
"RowOrder": null,
"Description": null,
"Extra1": null,
"Extra2": null,
"Extra3": null,
"Extra4": null,
"Extra5": null,
"Extra6": null,
"Extra7": null,
"Extra8": null,
"Extra9": null,
"Catalog": {
"Type": null,
"Name": "Pagila",
"Server": null,
"TargetName": null,
"AlternativeName": null,
"Label": null,
"RowOrder": null,
"Description": null,
"Extra1": null,
"Extra2": null,
"Extra3": null,
"Extra4": null,
"Extra5": null,
"Extra6": null,
"Extra7": null,
"Extra8": null,
"Extra9": null,
"Project": null,
"Schemas": []
},
"Entities": []
},
"Fields": [
{
"Name": "payment_date",
"EntityName": "payment_p2022_06",
"VirtualEntityName": "",
"EntitySchema": "public",
"TargetName": "payment_date",
"AlternativeName": "",
"Label": "payment_date",
"Order": 6,
"Description": "",
"Extra1": "",
"Extra2": "",
"Extra3": "",
"Extra4": "",
"Extra5": "",
"Extra6": "",
"Extra7": "",
"Extra8": "",
"Extra9": ""
},
{
"Name": "payment_id",
"EntityName": "payment_p2022_06",
"VirtualEntityName": "",
"EntitySchema": "public",
"TargetName": "payment_id",
"AlternativeName": "",
"Label": "payment_id",
"Order": 1,
"Description": "",
"Extra1": "",
"Extra2": "",
"Extra3": "",
"Extra4": "",
"Extra5": "",
"Extra6": "",
"Extra7": "",
"Extra8": "",
"Extra9": ""
},
{
"Name": "customer_id",
"EntityName": "payment_p2022_06",
"VirtualEntityName": "",
"EntitySchema": "public",
"TargetName": "customer_id",
"AlternativeName": "",
"Label": "customer_id",
"Order": 2,
"Description": "",
"Extra1": "",
"Extra2": "",
"Extra3": "",
"Extra4": "",
"Extra5": "",
"Extra6": "",
"Extra7": "",
"Extra8": "",
"Extra9": ""
},
{
"Name": "staff_id",
"EntityName": "payment_p2022_06",
"VirtualEntityName": "",
"EntitySchema": "public",
"TargetName": "staff_id",
"AlternativeName": "",
"Label": "staff_id",
"Order": 3,
"Description": "",
"Extra1": "",
"Extra2": "",
"Extra3": "",
"Extra4": "",
"Extra5": "",
"Extra6": "",
"Extra7": "",
"Extra8": "",
"Extra9": ""
},
{
"Name": "rental_id",
"EntityName": "payment_p2022_06",
"VirtualEntityName": "",
"EntitySchema": "public",
"TargetName": "rental_id",
"AlternativeName": "",
"Label": "rental_id",
"Order": 4,
"Description": "",
"Extra1": "",
"Extra2": "",
"Extra3": "",
"Extra4": "",
"Extra5": "",
"Extra6": "",
"Extra7": "",
"Extra8": "",
"Extra9": ""
},
{
"Name": "amount",
"EntityName": "payment_p2022_06",
"VirtualEntityName": "",
"EntitySchema": "public",
"TargetName": "amount",
"AlternativeName": "",
"Label": "amount",
"Order": 5,
"Description": "",
"Extra1": "",
"Extra2": "",
"Extra3": "",
"Extra4": "",
"Extra5": "",
"Extra6": "",
"Extra7": "",
"Extra8": "",
"Extra9": ""
}
],
"DisplayFields": "payment_date"
}
]
}