dbas19_homework_1.txt

group:homework 1

assets = {
	id:number, type:string, title:string          , publication_date:number
	100      , 'cd'       , 'Best of Phill Colins', 1567696321             
	200      , 'book'     , 'Pippi Långstrump'    , 1567667305             
	300      , 'book'     , 'Madicken'            , 1567663305             
}

stock = {
	id:number, asset_id:number
	1        , 100            
	2        , 100            
	3        , 200            
	4        , 200            
	5        , 300            
}

cast_metadata = {
	id:number, name:string      
	123      , 'Phill Colins'   
	987      , 'Astrid Lindgren'
}

cast = {
	id:number, asset_id:number, metadata_id:number, assignment:string
	1        , 100            , 123               , 'entertainer'    
	2        , 200            , 987               , 'author' 
	3        , 300            , 987               , 'author' 
}

users = {
	id:number, role:string, name:string        , email:string      , password_hash:string  
	231      , 'student'  , 'Oliver Linnarsson', 'oliverli@kth.se' , '33jhfskj4%=dsadk346' 
	411      , 'librarian', 'Bo Janson'        , 'boson@bib.kth.se', '7324kjd/fk%da..#fdsg'
}

renting = {
	id:number, stock_id:number, user_id:number, date_rented:number, date_returned:number
	10       , 1              , 231           , 1567623300        , 1567623300          
	11       , 3              , 231           , 1567523021        , null                
	12       , 5              , 411           , 1567323021        , 1567611100          
}