Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
AMPize DB Sample Model
{
"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