Last active
April 2, 2018 20:39
-
-
Save HFreni/d81ddbf848dbc3e0da772bf5e1e2b0cb to your computer and use it in GitHub Desktop.
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
| { | |
| "productions": [ | |
| { | |
| "production_id": "1", | |
| "production_title": "In The Heights", | |
| "production_type": "Musical", | |
| "production_shoporders": { | |
| "rental_shoporders": { | |
| "shoporder_id": "1", | |
| "shoporder_items": [ | |
| { | |
| "item_id": "1", | |
| "item_name": "Vari*Lite/PRG VL5B", | |
| "item_weight": "25", | |
| "item_type": "Moving Light", | |
| "item_accessories": [ | |
| { | |
| "item": { | |
| "item_id": "2", | |
| "item_name": "VL5B 10 Row Stipple Lens", | |
| "item_weight": "1", | |
| "item_type": "Accessory - Lens", | |
| "item_accessories": { | |
| } | |
| } | |
| } | |
| ] | |
| } | |
| ] | |
| }, | |
| "inventory_shoporders": { | |
| "shoporder_id": "2", | |
| "shoporder_items": [ | |
| { | |
| "item_id": "3", | |
| "item_name": "ETC Source Four Body", | |
| "item_weight": "10", | |
| "item_type": "Conventional Light", | |
| "item_accessories": [ | |
| { | |
| "item": { | |
| "item_id": "4", | |
| "item_name": "ETC Source Four 10 Degree Lens", | |
| "item_weight": "12", | |
| "item_type": "Accessory - Lens", | |
| "item_accessories": { | |
| } | |
| } | |
| }, | |
| { | |
| "item": { | |
| "item_id": "5", | |
| "item_name": "Altman Clamp", | |
| "item_weight": "1", | |
| "item_type": "Accessory - Clamp", | |
| "item_accessories": { | |
| } | |
| } | |
| } | |
| ] | |
| }, | |
| { | |
| "item_id": "6", | |
| "item_name": "Socapex Breakout", | |
| "item_weight": "10", | |
| "item_length": "5", | |
| "item_type": "Multicable", | |
| "item_accessories": [ | |
| { | |
| "item": { | |
| "item_id": "7", | |
| "item_name": "Socapex Extension", | |
| "item_weight": "50", | |
| "item_length": "100", | |
| "item_type": "Multicable", | |
| "item_accessories": { | |
| } | |
| } | |
| } | |
| ] | |
| } | |
| ] | |
| }, | |
| "expendable_shoporders": { | |
| "shoporder_id": "SERIAL INTEGER 11" | |
| } | |
| }, | |
| "shopprep_date": "DATE", | |
| "loadin_date": "DATE", | |
| "show_logo": "URL TO LOGO", | |
| "created_on": "TIMESTAMP ON CREATION", | |
| "edited_on": "TIMESTAMP ON UPDATE" | |
| }, | |
| { | |
| "production_id": "21", | |
| "production_title": "Animal Farm", | |
| "production_type": "Play", | |
| "production_shoporders": { | |
| "rental_shoporders": { | |
| "shoporder_id": "1", | |
| "shoporder_items": [ | |
| { | |
| "item_id": "1", | |
| "item_name": "Vari*Lite/PRG VL5B", | |
| "item_weight": "25", | |
| "item_type": "Moving Light", | |
| "item_accessories": [ | |
| { | |
| "item": { | |
| "item_id": "2", | |
| "item_name": "VL5B 10 Row Stipple Lens", | |
| "item_weight": "1", | |
| "item_type": "Accessory - Lens", | |
| "item_accessories": { | |
| } | |
| } | |
| } | |
| ] | |
| } | |
| ] | |
| }, | |
| "inventory_shoporders": { | |
| "shoporder_id": "2", | |
| "shoporder_items": [ | |
| { | |
| "item_id": "3", | |
| "item_name": "ETC Source Four Body", | |
| "item_weight": "10", | |
| "item_type": "Conventional Light", | |
| "item_accessories": [ | |
| { | |
| "item": { | |
| "item_id": "4", | |
| "item_name": "ETC Source Four 10 Degree Lens", | |
| "item_weight": "12", | |
| "item_type": "Accessory - Lens", | |
| "item_accessories": { | |
| } | |
| } | |
| }, | |
| { | |
| "item": { | |
| "item_id": "5", | |
| "item_name": "Altman Clamp", | |
| "item_weight": "1", | |
| "item_type": "Accessory - Clamp", | |
| "item_accessories": { | |
| } | |
| } | |
| } | |
| ] | |
| }, | |
| { | |
| "item_id": "6", | |
| "item_name": "Socapex Breakout", | |
| "item_weight": "10", | |
| "item_length": "5", | |
| "item_type": "Multicable", | |
| "item_accessories": [ | |
| { | |
| "item": { | |
| "item_id": "7", | |
| "item_name": "Socapex Extension", | |
| "item_weight": "50", | |
| "item_length": "100", | |
| "item_type": "Multicable", | |
| "item_accessories": { | |
| } | |
| } | |
| } | |
| ] | |
| } | |
| ] | |
| }, | |
| "expendable_shoporders": { | |
| "shoporder_id": "SERIAL INTEGER 11" | |
| } | |
| }, | |
| "shopprep_date": "DATE", | |
| "loadin_date": "DATE", | |
| "show_logo": "URL TO LOGO", | |
| "created_on": "TIMESTAMP ON CREATION", | |
| "edited_on": "TIMESTAMP ON UPDATE" | |
| } | |
| ] | |
| } |
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
| { | |
| "production_id": "SERIAL INTEGER 11", | |
| "production_title": "VARCHAR 64", | |
| "production_type": "VARCHAR 16 (REFERENCED)", | |
| "production_shoporders": { | |
| "rental_shoporders": { | |
| "shoporder_id": "SERIAL INTEGER 11", | |
| "item": { | |
| "item_id": "SERIAL INTEGER 11", | |
| "item_weight": "INTEGER 11", | |
| "item_type": "VARCHAR 16 (REFERENCED)", | |
| "item_accessories": { | |
| "item_id": "SERIAL INTEGER 11" | |
| } | |
| } | |
| }, | |
| "inventory_shoporders": { | |
| "shoporder_id": "SERIAL INTEGER 11", | |
| "item": { | |
| "item_id": "SERIAL INTEGER 11", | |
| "item_weight": "INTEGER 11", | |
| "item_type": "VARCHAR 16 (REFERENCED)", | |
| "item_accessories": { | |
| "item_id": "SERIAL INTEGER 11" | |
| } | |
| } | |
| }, | |
| "expendable_shoporders": { | |
| "shoporder_id": "SERIAL INTEGER 11", | |
| "item": { | |
| "item_id": "SERIAL INTEGER 11", | |
| "item_name": "VARCHAR 64", | |
| "item_weight": "INTEGER 11", | |
| "item_type": "VARCHAR 16 (REFERENCED)", | |
| "item_accessories": { | |
| "item_id": "SERIAL INTEGER 11", | |
| "item_weight": "INTEGER 11", | |
| "item_type": "VARCHAR 16 (REFERENCED)", | |
| "item_accessories": { | |
| "item_id": "SERIAL INTEGER 11", | |
| "item_weight": "INTEGER 11", | |
| "item_type": "VARCHAR 16 (REFERENCED)", | |
| } | |
| } | |
| } | |
| } | |
| }, | |
| "shopprep_date": "DATE", | |
| "loadin_date": "DATE", | |
| "show_logo": "URL TO LOGO", | |
| "created_on": "TIMESTAMP ON CREATION", | |
| "edited_on": "TIMESTAMP ON UPDATE" | |
| } |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment