{"action":"created","issue":{"url":"https://api.github.com/repos/WGBH/stock-sales-admin/issues/2","labels_url":"https://api.github.com/repos/WGBH/stock-sales-admin/issues/2/labels{/name}","comments_url":"https://api.github.com/repos/WGBH/stock-sales-admin/issues/2/comments","events_url":"https://api.github.com/repos/WGBH/stock-sales-admin/issues/2/events","html_url":"https://github.com/WGBH/stock-sales-admin/issues/2","id":89666816,"number":2,"title":"Three level model","user":{"login":"mccalluc","id":730388,"avatar_url":"https://avatars.githubusercontent.com/u/730388?v=3","gravatar_id":"","url":"https://api.github.com/users/mccalluc","html_url":"https://github.com/mccalluc","followers_url":"https://api.github.com/users/mccalluc/followers","following_url":"https://api.github.com/users/mccalluc/following{/other_user}","gists_url":"https://api.github.com/users/mccalluc/gists{/gist_id}","starred_url":"https://api.github.com/users/mccalluc/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mccalluc/subscriptions","organizations_url":"https://api.github.com/users/mccalluc/orgs","repos_url":"https://api.github.com/users/mccalluc/repos","events_url":"https://api.github.com/users/mccalluc/events{/privacy}","received_events_url":"https://api.github.com/users/mccalluc/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":2,"created_at":"2015-06-19T21:42:22Z","updated_at":"2015-06-24T18:17:08Z","closed_at":null,"body":"I want to confirm that this is the right data model for the Stock Sales admin: \r\n- *File* has technical metadata, and higher level program information.\r\n- *Scene* is where the fine grained descriptive information goes.\r\n- *Clip* is separate because it looks like the same scenic information applies to successive clips.\r\n\r\nThis doesn't need to influence anything in the public website, which can still be based on flat records exported from this structure.\r\n\r\nDoes this make sense? I'm not getting into how new records would be created: I want to be sure that this makes sense.\r\n\r\nFile record:\r\n```\r\n                       # Editable data:\r\n                 type: Beta SP\r\n              barcode: Barcode40434\r\n          tape_number: \r\n           drive_name: \r\n          folder_name: \r\n            file_name: \r\n               series: FRONTLINE\r\n              program: \r\n              episode: \r\n               format: \r\n         aspect_ratio: 4:3\r\n    frames_per_second: \r\n           scan_lines: \r\n                codec: \r\n      digital_wrapper: \r\n\r\n                       # Links to scenes:\r\n               Scenes: Counting prayer beads\r\n                       At the market\r\n                       End of Ramadan\r\n```\r\n\r\nScene record:\r\n```\r\nCounting prayer beads\r\n                       # Editable data:\r\n           event_date: 1998-12-01  \r\n       event_location: Khartoum, Sudan, Africa\r\n           clip_title: Counting prayer beads\r\n     clip_description: CU hand holding string of wooden prayer beads\r\n        clip_keywords: mosques, Muslims, prayers, praying\r\n             category: Culture/Society\r\n\r\n                       # Links to clips:\r\n                Clips: 00:03:49;00\r\n                       00:04:05;00\r\n                       00:04:15;00\r\n```\r\n\r\nClip record:\r\n```\r\n              time_in: 00:03:49;00\r\n             time_out: 00:04:05;00\r\n               length: 00:00:15;28\r\n```"},"comment":{"url":"https://api.github.com/repos/WGBH/stock-sales-admin/issues/comments/114967922","html_url":"https://github.com/WGBH/stock-sales-admin/issues/2#issuecomment-114967922","issue_url":"https://api.github.com/repos/WGBH/stock-sales-admin/issues/2","id":114967922,"user":{"login":"afred","id":1507490,"avatar_url":"https://avatars.githubusercontent.com/u/1507490?v=3","gravatar_id":"","url":"https://api.github.com/users/afred","html_url":"https://github.com/afred","followers_url":"https://api.github.com/users/afred/followers","following_url":"https://api.github.com/users/afred/following{/other_user}","gists_url":"https://api.github.com/users/afred/gists{/gist_id}","starred_url":"https://api.github.com/users/afred/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/afred/subscriptions","organizations_url":"https://api.github.com/users/afred/orgs","repos_url":"https://api.github.com/users/afred/repos","events_url":"https://api.github.com/users/afred/events{/privacy}","received_events_url":"https://api.github.com/users/afred/received_events","type":"User","site_admin":false},"created_at":"2015-06-24T18:17:08Z","updated_at":"2015-06-24T18:17:08Z","body":"I would drop the `clip_` prefix from fields in the `scene` table. That's a bit confusing."}}