Entity Book

Book - A book.

Database table

Table name: "Book".

Collections

Entity field Field descr. Field type DB table DB pkey DB fkey DB extension DB custom DB test_chain UI full_view
book_id Book Id. unique_id x x          
title Title string[80] x           x
isbn ISBN string[80] x           x
author_id Author Id. link to author x   x        
publisher_id Publisher Id. link to publisher x   x        
status Status enum x           x
num_copies Num. copies range
uint32 [0 - 1000000] 		x           x
author_name Author name string[80]       x     x
pen_name Author pen name string[80]       x      
publisher_name Publisher name string[80]       x     x
get_all_by_title Query by title function         x   x
get_all_by_author_name Query by author name function         x   x
update_status_by_publisher Update by publisher function         x   x
query_result Query result list of book              
new_status New status enum              

Functions

Name Parameters Returns
get_all_by_title string title -> list of book query_result
get_all_by_author_name string author_name -> list of book query_result
update_status_by_publisher link to publisher publisher_id ,
enum new_status 		-> (void)

Enum's

Enum "status"
Id. Descr. Value
ebook_only Ebook only 0
hardcopy Hardcopy available 1
sold_out Sold out 2
Enum "new_status"
Id. Descr. Value
ebook_only Ebook only 0
hardcopy Hardcopy available 1
sold_out Sold out 2

Produced by SoProMach.