Created
August 7, 2017 08:55
-
-
Save dfanchon/89986c8637606f650a5558bbc22e7975 to your computer and use it in GitHub Desktop.
AMPize DB Sample Model
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
| { | |
| "actor": { | |
| "name": "actor", | |
| "fields": { | |
| "actor_id": { | |
| "name": "actor_id", | |
| "type": "Int", | |
| "required": true | |
| }, | |
| "first_name": { | |
| "name": "first_name", | |
| "type": "String", | |
| "required": true | |
| }, | |
| "last_name": { | |
| "name": "last_name", | |
| "type": "String", | |
| "required": true | |
| }, | |
| "last_update": { | |
| "name": "last_update", | |
| "type": "Date", | |
| "required": true | |
| }, | |
| "fk_film_actor_actor": { | |
| "type": "film_actor", | |
| "multivalued": true, | |
| "args": [], | |
| "relation": { | |
| "actor_id": "actor_id" | |
| } | |
| } | |
| }, | |
| "expose": true, | |
| "multiEndpoint": { | |
| "name": "actor_multi", | |
| "args": { | |
| "last_name": { | |
| "type": "String" | |
| } | |
| } | |
| }, | |
| "singleEndpoint": { | |
| "name": "actor_single", | |
| "args": { | |
| "actor_id": { | |
| "type": "Int", | |
| "required": true | |
| } | |
| } | |
| }, | |
| "connector": { | |
| "type": "sakila", | |
| "configs": { | |
| "table": "actor" | |
| } | |
| } | |
| }, | |
| "address": { | |
| "name": "address", | |
| "fields": { | |
| "address_id": { | |
| "name": "address_id", | |
| "type": "Int", | |
| "required": true | |
| }, | |
| "city_id": { | |
| "name": "city_id", | |
| "type": "Int", | |
| "required": true | |
| }, | |
| "address": { | |
| "name": "address", | |
| "type": "String", | |
| "required": true | |
| }, | |
| "address2": { | |
| "name": "address2", | |
| "type": "String" | |
| }, | |
| "district": { | |
| "name": "district", | |
| "type": "String", | |
| "required": true | |
| }, | |
| "postal_code": { | |
| "name": "postal_code", | |
| "type": "String" | |
| }, | |
| "phone": { | |
| "name": "phone", | |
| "type": "String", | |
| "required": true | |
| }, | |
| "location": { | |
| "name": "location", | |
| "type": "String", | |
| "required": true | |
| }, | |
| "last_update": { | |
| "name": "last_update", | |
| "type": "Date", | |
| "required": true | |
| }, | |
| "fk_address_city": { | |
| "type": "city", | |
| "args": [], | |
| "relation": { | |
| "city_id": "city_id" | |
| } | |
| }, | |
| "fk_customer_address": { | |
| "type": "customer", | |
| "multivalued": true, | |
| "args": { | |
| "last_name": { | |
| "type": "String" | |
| } | |
| }, | |
| "relation": { | |
| "address_id": "address_id" | |
| } | |
| }, | |
| "fk_staff_address": { | |
| "type": "staff", | |
| "multivalued": true, | |
| "args": [], | |
| "relation": { | |
| "address_id": "address_id" | |
| } | |
| }, | |
| "fk_store_address": { | |
| "type": "store", | |
| "multivalued": true, | |
| "args": [], | |
| "relation": { | |
| "address_id": "address_id" | |
| } | |
| } | |
| }, | |
| "expose": true, | |
| "multiEndpoint": { | |
| "name": "address_multi", | |
| "args": { | |
| "location": { | |
| "type": "String" | |
| } | |
| } | |
| }, | |
| "singleEndpoint": { | |
| "name": "address_single", | |
| "args": { | |
| "address_id": { | |
| "type": "Int", | |
| "required": true | |
| } | |
| } | |
| }, | |
| "connector": { | |
| "type": "sakila", | |
| "configs": { | |
| "table": "address" | |
| } | |
| } | |
| }, | |
| "category": { | |
| "name": "category", | |
| "fields": { | |
| "category_id": { | |
| "name": "category_id", | |
| "type": "Int", | |
| "required": true | |
| }, | |
| "name": { | |
| "name": "name", | |
| "type": "String", | |
| "required": true | |
| }, | |
| "last_update": { | |
| "name": "last_update", | |
| "type": "Date", | |
| "required": true | |
| }, | |
| "fk_film_category_category": { | |
| "type": "film_category", | |
| "multivalued": true, | |
| "args": [], | |
| "relation": { | |
| "category_id": "category_id" | |
| } | |
| } | |
| }, | |
| "expose": true, | |
| "multiEndpoint": { | |
| "name": "category_multi", | |
| "args": [] | |
| }, | |
| "singleEndpoint": { | |
| "name": "category_single", | |
| "args": { | |
| "category_id": { | |
| "type": "Int", | |
| "required": true | |
| } | |
| } | |
| }, | |
| "connector": { | |
| "type": "sakila", | |
| "configs": { | |
| "table": "category" | |
| } | |
| } | |
| }, | |
| "city": { | |
| "name": "city", | |
| "fields": { | |
| "city_id": { | |
| "name": "city_id", | |
| "type": "Int", | |
| "required": true | |
| }, | |
| "country_id": { | |
| "name": "country_id", | |
| "type": "Int", | |
| "required": true | |
| }, | |
| "city": { | |
| "name": "city", | |
| "type": "String", | |
| "required": true | |
| }, | |
| "last_update": { | |
| "name": "last_update", | |
| "type": "Date", | |
| "required": true | |
| }, | |
| "fk_address_city": { | |
| "type": "address", | |
| "multivalued": true, | |
| "args": { | |
| "location": { | |
| "type": "String" | |
| } | |
| }, | |
| "relation": { | |
| "city_id": "city_id" | |
| } | |
| }, | |
| "fk_city_country": { | |
| "type": "country", | |
| "args": [], | |
| "relation": { | |
| "country_id": "country_id" | |
| } | |
| } | |
| }, | |
| "expose": true, | |
| "multiEndpoint": { | |
| "name": "city_multi", | |
| "args": [] | |
| }, | |
| "singleEndpoint": { | |
| "name": "city_single", | |
| "args": { | |
| "city_id": { | |
| "type": "Int", | |
| "required": true | |
| } | |
| } | |
| }, | |
| "connector": { | |
| "type": "sakila", | |
| "configs": { | |
| "table": "city" | |
| } | |
| } | |
| }, | |
| "country": { | |
| "name": "country", | |
| "fields": { | |
| "country_id": { | |
| "name": "country_id", | |
| "type": "Int", | |
| "required": true | |
| }, | |
| "country": { | |
| "name": "country", | |
| "type": "String", | |
| "required": true | |
| }, | |
| "last_update": { | |
| "name": "last_update", | |
| "type": "Date", | |
| "required": true | |
| }, | |
| "fk_city_country": { | |
| "type": "city", | |
| "multivalued": true, | |
| "args": [], | |
| "relation": { | |
| "country_id": "country_id" | |
| } | |
| } | |
| }, | |
| "expose": true, | |
| "multiEndpoint": { | |
| "name": "country_multi", | |
| "args": [] | |
| }, | |
| "singleEndpoint": { | |
| "name": "country_single", | |
| "args": { | |
| "country_id": { | |
| "type": "Int", | |
| "required": true | |
| } | |
| } | |
| }, | |
| "connector": { | |
| "type": "sakila", | |
| "configs": { | |
| "table": "country" | |
| } | |
| } | |
| }, | |
| "customer": { | |
| "name": "customer", | |
| "fields": { | |
| "customer_id": { | |
| "name": "customer_id", | |
| "type": "Int", | |
| "required": true | |
| }, | |
| "address_id": { | |
| "name": "address_id", | |
| "type": "Int", | |
| "required": true | |
| }, | |
| "store_id": { | |
| "name": "store_id", | |
| "type": "Int", | |
| "required": true | |
| }, | |
| "first_name": { | |
| "name": "first_name", | |
| "type": "String", | |
| "required": true | |
| }, | |
| "last_name": { | |
| "name": "last_name", | |
| "type": "String", | |
| "required": true | |
| }, | |
| "email": { | |
| "name": "email", | |
| "type": "String" | |
| }, | |
| "active": { | |
| "name": "active", | |
| "type": "Int", | |
| "required": true | |
| }, | |
| "create_date": { | |
| "name": "create_date", | |
| "type": "Date", | |
| "required": true | |
| }, | |
| "last_update": { | |
| "name": "last_update", | |
| "type": "Date", | |
| "required": true | |
| }, | |
| "fk_customer_address": { | |
| "type": "address", | |
| "args": [], | |
| "relation": { | |
| "address_id": "address_id" | |
| } | |
| }, | |
| "fk_customer_store": { | |
| "type": "store", | |
| "args": [], | |
| "relation": { | |
| "store_id": "store_id" | |
| } | |
| }, | |
| "fk_payment_customer": { | |
| "type": "payment", | |
| "multivalued": true, | |
| "args": [], | |
| "relation": { | |
| "customer_id": "customer_id" | |
| } | |
| }, | |
| "fk_rental_customer": { | |
| "type": "rental", | |
| "multivalued": true, | |
| "args": [], | |
| "relation": { | |
| "customer_id": "customer_id" | |
| } | |
| } | |
| }, | |
| "expose": true, | |
| "multiEndpoint": { | |
| "name": "customer_multi", | |
| "args": { | |
| "last_name": { | |
| "type": "String" | |
| } | |
| } | |
| }, | |
| "singleEndpoint": { | |
| "name": "customer_single", | |
| "args": { | |
| "customer_id": { | |
| "type": "Int", | |
| "required": true | |
| } | |
| } | |
| }, | |
| "connector": { | |
| "type": "sakila", | |
| "configs": { | |
| "table": "customer" | |
| } | |
| } | |
| }, | |
| "film": { | |
| "name": "film", | |
| "fields": { | |
| "film_id": { | |
| "name": "film_id", | |
| "type": "Int", | |
| "required": true | |
| }, | |
| "language_id": { | |
| "name": "language_id", | |
| "type": "Int", | |
| "required": true | |
| }, | |
| "original_language_id": { | |
| "name": "original_language_id", | |
| "type": "Int" | |
| }, | |
| "title": { | |
| "name": "title", | |
| "type": "String", | |
| "required": true | |
| }, | |
| "description": { | |
| "name": "description", | |
| "type": "String" | |
| }, | |
| "release_year": { | |
| "name": "release_year", | |
| "type": "Date" | |
| }, | |
| "rental_duration": { | |
| "name": "rental_duration", | |
| "type": "Int", | |
| "required": true | |
| }, | |
| "rental_rate": { | |
| "name": "rental_rate", | |
| "type": "Float", | |
| "required": true | |
| }, | |
| "length": { | |
| "name": "length", | |
| "type": "Int" | |
| }, | |
| "replacement_cost": { | |
| "name": "replacement_cost", | |
| "type": "Float", | |
| "required": true | |
| }, | |
| "rating": { | |
| "name": "rating", | |
| "type": "String" | |
| }, | |
| "special_features": { | |
| "name": "special_features", | |
| "type": "String" | |
| }, | |
| "last_update": { | |
| "name": "last_update", | |
| "type": "Date", | |
| "required": true | |
| }, | |
| "fk_film_language": { | |
| "type": "language", | |
| "args": [], | |
| "relation": { | |
| "language_id": "language_id" | |
| } | |
| }, | |
| "fk_film_language_original": { | |
| "type": "language", | |
| "args": [], | |
| "relation": { | |
| "language_id": "original_language_id" | |
| } | |
| }, | |
| "fk_film_actor_film": { | |
| "type": "film_actor", | |
| "multivalued": true, | |
| "args": [], | |
| "relation": { | |
| "film_id": "film_id" | |
| } | |
| }, | |
| "fk_film_category_film": { | |
| "type": "film_category", | |
| "multivalued": true, | |
| "args": [], | |
| "relation": { | |
| "film_id": "film_id" | |
| } | |
| }, | |
| "fk_inventory_film": { | |
| "type": "inventory", | |
| "multivalued": true, | |
| "args": [], | |
| "relation": { | |
| "film_id": "film_id" | |
| } | |
| } | |
| }, | |
| "expose": true, | |
| "multiEndpoint": { | |
| "name": "film_multi", | |
| "args": { | |
| "title": { | |
| "type": "String" | |
| } | |
| } | |
| }, | |
| "singleEndpoint": { | |
| "name": "film_single", | |
| "args": { | |
| "film_id": { | |
| "type": "Int", | |
| "required": true | |
| } | |
| } | |
| }, | |
| "connector": { | |
| "type": "sakila", | |
| "configs": { | |
| "table": "film" | |
| } | |
| } | |
| }, | |
| "film_actor": { | |
| "name": "film_actor", | |
| "fields": { | |
| "actor_id": { | |
| "name": "actor_id", | |
| "type": "Int", | |
| "required": true | |
| }, | |
| "film_id": { | |
| "name": "film_id", | |
| "type": "Int", | |
| "required": true | |
| }, | |
| "last_update": { | |
| "name": "last_update", | |
| "type": "Date", | |
| "required": true | |
| }, | |
| "fk_film_actor_actor": { | |
| "type": "actor", | |
| "args": [], | |
| "relation": { | |
| "actor_id": "actor_id" | |
| } | |
| }, | |
| "fk_film_actor_film": { | |
| "type": "film", | |
| "args": [], | |
| "relation": { | |
| "film_id": "film_id" | |
| } | |
| } | |
| }, | |
| "expose": true, | |
| "multiEndpoint": { | |
| "name": "film_actor_multi", | |
| "args": [] | |
| }, | |
| "singleEndpoint": { | |
| "name": "film_actor_single", | |
| "args": { | |
| "actor_id": { | |
| "type": "Int", | |
| "required": true | |
| }, | |
| "film_id": { | |
| "type": "Int", | |
| "required": true | |
| } | |
| } | |
| }, | |
| "connector": { | |
| "type": "sakila", | |
| "configs": { | |
| "table": "film_actor" | |
| } | |
| } | |
| }, | |
| "film_category": { | |
| "name": "film_category", | |
| "fields": { | |
| "film_id": { | |
| "name": "film_id", | |
| "type": "Int", | |
| "required": true | |
| }, | |
| "category_id": { | |
| "name": "category_id", | |
| "type": "Int", | |
| "required": true | |
| }, | |
| "last_update": { | |
| "name": "last_update", | |
| "type": "Date", | |
| "required": true | |
| }, | |
| "fk_film_category_category": { | |
| "type": "category", | |
| "args": [], | |
| "relation": { | |
| "category_id": "category_id" | |
| } | |
| }, | |
| "fk_film_category_film": { | |
| "type": "film", | |
| "args": [], | |
| "relation": { | |
| "film_id": "film_id" | |
| } | |
| } | |
| }, | |
| "expose": true, | |
| "multiEndpoint": { | |
| "name": "film_category_multi", | |
| "args": [] | |
| }, | |
| "singleEndpoint": { | |
| "name": "film_category_single", | |
| "args": { | |
| "film_id": { | |
| "type": "Int", | |
| "required": true | |
| }, | |
| "category_id": { | |
| "type": "Int", | |
| "required": true | |
| } | |
| } | |
| }, | |
| "connector": { | |
| "type": "sakila", | |
| "configs": { | |
| "table": "film_category" | |
| } | |
| } | |
| }, | |
| "film_text": { | |
| "name": "film_text", | |
| "fields": { | |
| "film_id": { | |
| "name": "film_id", | |
| "type": "Int", | |
| "required": true | |
| }, | |
| "title": { | |
| "name": "title", | |
| "type": "String", | |
| "required": true | |
| }, | |
| "description": { | |
| "name": "description", | |
| "type": "String" | |
| } | |
| }, | |
| "expose": true, | |
| "multiEndpoint": { | |
| "name": "film_text_multi", | |
| "args": { | |
| "title": { | |
| "type": "String" | |
| }, | |
| "description": { | |
| "type": "String" | |
| } | |
| } | |
| }, | |
| "singleEndpoint": { | |
| "name": "film_text_single", | |
| "args": { | |
| "film_id": { | |
| "type": "Int", | |
| "required": true | |
| } | |
| } | |
| }, | |
| "connector": { | |
| "type": "sakila", | |
| "configs": { | |
| "table": "film_text" | |
| } | |
| } | |
| }, | |
| "inventory": { | |
| "name": "inventory", | |
| "fields": { | |
| "inventory_id": { | |
| "name": "inventory_id", | |
| "type": "Int", | |
| "required": true | |
| }, | |
| "film_id": { | |
| "name": "film_id", | |
| "type": "Int", | |
| "required": true | |
| }, | |
| "store_id": { | |
| "name": "store_id", | |
| "type": "Int", | |
| "required": true | |
| }, | |
| "last_update": { | |
| "name": "last_update", | |
| "type": "Date", | |
| "required": true | |
| }, | |
| "fk_inventory_film": { | |
| "type": "film", | |
| "args": [], | |
| "relation": { | |
| "film_id": "film_id" | |
| } | |
| }, | |
| "fk_inventory_store": { | |
| "type": "store", | |
| "args": [], | |
| "relation": { | |
| "store_id": "store_id" | |
| } | |
| }, | |
| "fk_rental_inventory": { | |
| "type": "rental", | |
| "multivalued": true, | |
| "args": [], | |
| "relation": { | |
| "inventory_id": "inventory_id" | |
| } | |
| } | |
| }, | |
| "expose": true, | |
| "multiEndpoint": { | |
| "name": "inventory_multi", | |
| "args": [] | |
| }, | |
| "singleEndpoint": { | |
| "name": "inventory_single", | |
| "args": { | |
| "inventory_id": { | |
| "type": "Int", | |
| "required": true | |
| } | |
| } | |
| }, | |
| "connector": { | |
| "type": "sakila", | |
| "configs": { | |
| "table": "inventory" | |
| } | |
| } | |
| }, | |
| "language": { | |
| "name": "language", | |
| "fields": { | |
| "language_id": { | |
| "name": "language_id", | |
| "type": "Int", | |
| "required": true | |
| }, | |
| "name": { | |
| "name": "name", | |
| "type": "String", | |
| "required": true | |
| }, | |
| "last_update": { | |
| "name": "last_update", | |
| "type": "Date", | |
| "required": true | |
| }, | |
| "fk_film_language": { | |
| "type": "film", | |
| "multivalued": true, | |
| "args": { | |
| "title": { | |
| "type": "String" | |
| } | |
| }, | |
| "relation": { | |
| "language_id": "language_id" | |
| } | |
| }, | |
| "fk_film_language_original": { | |
| "type": "film", | |
| "multivalued": true, | |
| "args": { | |
| "title": { | |
| "type": "String" | |
| } | |
| }, | |
| "relation": { | |
| "original_language_id": "language_id" | |
| } | |
| } | |
| }, | |
| "expose": true, | |
| "multiEndpoint": { | |
| "name": "language_multi", | |
| "args": [] | |
| }, | |
| "singleEndpoint": { | |
| "name": "language_single", | |
| "args": { | |
| "language_id": { | |
| "type": "Int", | |
| "required": true | |
| } | |
| } | |
| }, | |
| "connector": { | |
| "type": "sakila", | |
| "configs": { | |
| "table": "language" | |
| } | |
| } | |
| }, | |
| "payment": { | |
| "name": "payment", | |
| "fields": { | |
| "payment_id": { | |
| "name": "payment_id", | |
| "type": "Int", | |
| "required": true | |
| }, | |
| "customer_id": { | |
| "name": "customer_id", | |
| "type": "Int", | |
| "required": true | |
| }, | |
| "rental_id": { | |
| "name": "rental_id", | |
| "type": "Int" | |
| }, | |
| "staff_id": { | |
| "name": "staff_id", | |
| "type": "Int", | |
| "required": true | |
| }, | |
| "amount": { | |
| "name": "amount", | |
| "type": "Float", | |
| "required": true | |
| }, | |
| "payment_date": { | |
| "name": "payment_date", | |
| "type": "Date", | |
| "required": true | |
| }, | |
| "last_update": { | |
| "name": "last_update", | |
| "type": "Date", | |
| "required": true | |
| }, | |
| "fk_payment_customer": { | |
| "type": "customer", | |
| "args": [], | |
| "relation": { | |
| "customer_id": "customer_id" | |
| } | |
| }, | |
| "fk_payment_rental": { | |
| "type": "rental", | |
| "args": [], | |
| "relation": { | |
| "rental_id": "rental_id" | |
| } | |
| }, | |
| "fk_payment_staff": { | |
| "type": "staff", | |
| "args": [], | |
| "relation": { | |
| "staff_id": "staff_id" | |
| } | |
| } | |
| }, | |
| "expose": true, | |
| "multiEndpoint": { | |
| "name": "payment_multi", | |
| "args": [] | |
| }, | |
| "singleEndpoint": { | |
| "name": "payment_single", | |
| "args": { | |
| "payment_id": { | |
| "type": "Int", | |
| "required": true | |
| } | |
| } | |
| }, | |
| "connector": { | |
| "type": "sakila", | |
| "configs": { | |
| "table": "payment" | |
| } | |
| } | |
| }, | |
| "rental": { | |
| "name": "rental", | |
| "fields": { | |
| "rental_id": { | |
| "name": "rental_id", | |
| "type": "Int", | |
| "required": true | |
| }, | |
| "customer_id": { | |
| "name": "customer_id", | |
| "type": "Int", | |
| "required": true | |
| }, | |
| "inventory_id": { | |
| "name": "inventory_id", | |
| "type": "Int", | |
| "required": true | |
| }, | |
| "staff_id": { | |
| "name": "staff_id", | |
| "type": "Int", | |
| "required": true | |
| }, | |
| "rental_date": { | |
| "name": "rental_date", | |
| "type": "Date", | |
| "required": true | |
| }, | |
| "return_date": { | |
| "name": "return_date", | |
| "type": "Date" | |
| }, | |
| "last_update": { | |
| "name": "last_update", | |
| "type": "Date", | |
| "required": true | |
| }, | |
| "fk_payment_rental": { | |
| "type": "payment", | |
| "multivalued": true, | |
| "args": [], | |
| "relation": { | |
| "rental_id": "rental_id" | |
| } | |
| }, | |
| "fk_rental_customer": { | |
| "type": "customer", | |
| "args": [], | |
| "relation": { | |
| "customer_id": "customer_id" | |
| } | |
| }, | |
| "fk_rental_inventory": { | |
| "type": "inventory", | |
| "args": [], | |
| "relation": { | |
| "inventory_id": "inventory_id" | |
| } | |
| }, | |
| "fk_rental_staff": { | |
| "type": "staff", | |
| "args": [], | |
| "relation": { | |
| "staff_id": "staff_id" | |
| } | |
| } | |
| }, | |
| "expose": true, | |
| "multiEndpoint": { | |
| "name": "rental_multi", | |
| "args": [] | |
| }, | |
| "singleEndpoint": { | |
| "name": "rental_single", | |
| "args": { | |
| "rental_id": { | |
| "type": "Int", | |
| "required": true | |
| } | |
| } | |
| }, | |
| "connector": { | |
| "type": "sakila", | |
| "configs": { | |
| "table": "rental" | |
| } | |
| } | |
| }, | |
| "staff": { | |
| "name": "staff", | |
| "fields": { | |
| "staff_id": { | |
| "name": "staff_id", | |
| "type": "Int", | |
| "required": true | |
| }, | |
| "address_id": { | |
| "name": "address_id", | |
| "type": "Int", | |
| "required": true | |
| }, | |
| "store_id": { | |
| "name": "store_id", | |
| "type": "Int", | |
| "required": true | |
| }, | |
| "first_name": { | |
| "name": "first_name", | |
| "type": "String", | |
| "required": true | |
| }, | |
| "last_name": { | |
| "name": "last_name", | |
| "type": "String", | |
| "required": true | |
| }, | |
| "picture": { | |
| "name": "picture", | |
| "type": "String" | |
| }, | |
| "email": { | |
| "name": "email", | |
| "type": "String" | |
| }, | |
| "active": { | |
| "name": "active", | |
| "type": "Int", | |
| "required": true | |
| }, | |
| "username": { | |
| "name": "username", | |
| "type": "String", | |
| "required": true | |
| }, | |
| "password": { | |
| "name": "password", | |
| "type": "String" | |
| }, | |
| "last_update": { | |
| "name": "last_update", | |
| "type": "Date", | |
| "required": true | |
| }, | |
| "fk_payment_staff": { | |
| "type": "payment", | |
| "multivalued": true, | |
| "args": [], | |
| "relation": { | |
| "staff_id": "staff_id" | |
| } | |
| }, | |
| "fk_rental_staff": { | |
| "type": "rental", | |
| "multivalued": true, | |
| "args": [], | |
| "relation": { | |
| "staff_id": "staff_id" | |
| } | |
| }, | |
| "fk_staff_address": { | |
| "type": "address", | |
| "args": [], | |
| "relation": { | |
| "address_id": "address_id" | |
| } | |
| }, | |
| "fk_staff_store": { | |
| "type": "store", | |
| "args": [], | |
| "relation": { | |
| "store_id": "store_id" | |
| } | |
| }, | |
| "fk_store_staff": { | |
| "type": "store", | |
| "multivalued": true, | |
| "args": [], | |
| "relation": { | |
| "manager_staff_id": "staff_id" | |
| } | |
| } | |
| }, | |
| "expose": true, | |
| "multiEndpoint": { | |
| "name": "staff_multi", | |
| "args": [] | |
| }, | |
| "singleEndpoint": { | |
| "name": "staff_single", | |
| "args": { | |
| "staff_id": { | |
| "type": "Int", | |
| "required": true | |
| } | |
| } | |
| }, | |
| "connector": { | |
| "type": "sakila", | |
| "configs": { | |
| "table": "staff" | |
| } | |
| } | |
| }, | |
| "store": { | |
| "name": "store", | |
| "fields": { | |
| "store_id": { | |
| "name": "store_id", | |
| "type": "Int", | |
| "required": true | |
| }, | |
| "address_id": { | |
| "name": "address_id", | |
| "type": "Int", | |
| "required": true | |
| }, | |
| "manager_staff_id": { | |
| "name": "manager_staff_id", | |
| "type": "Int", | |
| "required": true | |
| }, | |
| "last_update": { | |
| "name": "last_update", | |
| "type": "Date", | |
| "required": true | |
| }, | |
| "fk_customer_store": { | |
| "type": "customer", | |
| "multivalued": true, | |
| "args": { | |
| "last_name": { | |
| "type": "String" | |
| } | |
| }, | |
| "relation": { | |
| "store_id": "store_id" | |
| } | |
| }, | |
| "fk_inventory_store": { | |
| "type": "inventory", | |
| "multivalued": true, | |
| "args": [], | |
| "relation": { | |
| "store_id": "store_id" | |
| } | |
| }, | |
| "fk_staff_store": { | |
| "type": "staff", | |
| "multivalued": true, | |
| "args": [], | |
| "relation": { | |
| "store_id": "store_id" | |
| } | |
| }, | |
| "fk_store_address": { | |
| "type": "address", | |
| "args": [], | |
| "relation": { | |
| "address_id": "address_id" | |
| } | |
| }, | |
| "fk_store_staff": { | |
| "type": "staff", | |
| "args": [], | |
| "relation": { | |
| "staff_id": "manager_staff_id" | |
| } | |
| } | |
| }, | |
| "expose": true, | |
| "multiEndpoint": { | |
| "name": "store_multi", | |
| "args": [] | |
| }, | |
| "singleEndpoint": { | |
| "name": "store_single", | |
| "args": { | |
| "store_id": { | |
| "type": "Int", | |
| "required": true | |
| } | |
| } | |
| }, | |
| "connector": { | |
| "type": "sakila", | |
| "configs": { | |
| "table": "store" | |
| } | |
| } | |
| } | |
| } |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment