books¶ Relationships¶ erDiagram books { int id } items { int id int book varchar name int recasttype int icon mediumint bardeffect int clickeffect int focuseffect int proceffect int scrolleffect int worneffect } books ||--o{ items : "Has-Many" Relationship Type Local Key Relates to Table Foreign Key Has-Many id items book Schema¶ Column Data Type Description id int Book Identifier name varchar Unique Book Identifier txtfile text The text in the book. ` Represents line spaces, `` is two line spaces, ``` is three line spaces, etc. (13 lines per book page) language int Language