PHP Classes

File: db.rd.xml

Recommend this page to a friend!
  Classes of Shashwat Mishra   R8 PHP Review System   db.rd.xml   Download  
File: db.rd.xml
Role: Auxiliary data
Content type: text/plain
Description: Auxiliary data
Class: R8 PHP Review System
Add reviews, ratings and recommendations to a site
Author: By
Last change:
Date: 3 years ago
Size: 4,810 bytes
 

Contents

Class file image Download
<?xml version="1.0" encoding="utf-8" ?> <!-- SQL XML created in WWW SQL Designer, https://github.com/ondras/wwwsqldesigner/ --> <!-- To Work on this Database Entity Relationship Diagram, 1). Go to https://ondras.zarovi.cz/sql/demo/?keyword=default 2). Click "Save/Load" on the sidebar 3). Copy this XML and paste it there and click "Load XML". --> <sql> <datatypes db="mysql"> <group label="Numeric" color="rgb(238,238,170)"> <type label="Integer" length="0" sql="INTEGER" quote=""/> <type label="TINYINT" length="0" sql="TINYINT" quote=""/> <type label="SMALLINT" length="0" sql="SMALLINT" quote=""/> <type label="MEDIUMINT" length="0" sql="MEDIUMINT" quote=""/> <type label="INT" length="0" sql="INT" quote=""/> <type label="BIGINT" length="0" sql="BIGINT" quote=""/> <type label="Decimal" length="1" sql="DECIMAL" re="DEC" quote=""/> <type label="Single precision" length="0" sql="FLOAT" quote=""/> <type label="Double precision" length="0" sql="DOUBLE" re="DOUBLE" quote=""/> </group> <group label="Character" color="rgb(255,200,200)"> <type label="Char" length="1" sql="CHAR" quote="'"/> <type label="Varchar" length="1" sql="VARCHAR" quote="'"/> <type label="Text" length="0" sql="MEDIUMTEXT" re="TEXT" quote="'"/> <type label="Binary" length="1" sql="BINARY" quote="'"/> <type label="Varbinary" length="1" sql="VARBINARY" quote="'"/> <type label="BLOB" length="0" sql="BLOB" re="BLOB" quote="'"/> </group> <group label="Date &amp; Time" color="rgb(200,255,200)"> <type label="Date" length="0" sql="DATE" quote="'"/> <type label="Time" length="0" sql="TIME" quote="'"/> <type label="Datetime" length="0" sql="DATETIME" quote="'"/> <type label="Year" length="0" sql="YEAR" quote=""/> <type label="Timestamp" length="0" sql="TIMESTAMP" quote="'"/> </group> <group label="Miscellaneous" color="rgb(200,200,255)"> <type label="ENUM" length="1" sql="ENUM" quote=""/> <type label="SET" length="1" sql="SET" quote=""/> <type label="Bit" length="0" sql="bit" quote=""/> </group> </datatypes><table x="216" y="183" name="Reviews"> <row name="id" null="1" autoincrement="1"> <datatype>INTEGER</datatype> <default>NULL</default></row> <row name="title" null="1" autoincrement="0"> <datatype>VARCHAR</datatype> <default>NULL</default></row> <row name="body" null="1" autoincrement="0"> <datatype>MEDIUMTEXT</datatype> <default>NULL</default></row> <row name="recommend" null="1" autoincrement="0"> <datatype>ENUM</datatype> <default>NULL</default></row> <row name="approved" null="1" autoincrement="0"> <datatype>INT</datatype> <default>NULL</default></row> <row name="user_id" null="1" autoincrement="0"> <datatype>INTEGER</datatype> <default>NULL</default><relation table="User" row="id" /> </row> <row name="reviewable_id" null="1" autoincrement="0"> <datatype>INTEGER</datatype> <default>NULL</default></row> <row name="reviewable_type" null="1" autoincrement="0"> <datatype>VARCHAR</datatype> <default>NULL</default></row> <key type="PRIMARY" name=""> <part>id</part> </key> </table> <table x="498" y="103" name="Ratings"> <row name="id" null="1" autoincrement="1"> <datatype>INTEGER</datatype> <default>NULL</default></row> <row name="review_id" null="1" autoincrement="0"> <datatype>INTEGER</datatype> <default>NULL</default><relation table="Reviews" row="id" /> </row> <row name="type_id" null="1" autoincrement="0"> <datatype>INTEGER</datatype> <default>NULL</default><relation table="Rate_Type" row="id" /> </row> <row name="value" null="1" autoincrement="0"> <datatype>DECIMAL</datatype> <default>NULL</default></row> <key type="PRIMARY" name=""> <part>id</part> </key> </table> <table x="803" y="274" name="Rate_Type"> <row name="id" null="1" autoincrement="1"> <datatype>INTEGER</datatype> <default>NULL</default></row> <row name="slug" null="1" autoincrement="0"> <datatype>VARCHAR</datatype> <default>NULL</default></row> <row name="name" null="1" autoincrement="0"> <datatype>VARCHAR</datatype> <default>NULL</default></row> <key type="PRIMARY" name=""> <part>id</part> </key> </table> <table x="471" y="403" name="User"> <row name="id" null="1" autoincrement="1"> <datatype>INTEGER</datatype> <default>NULL</default></row> <row name="username" null="1" autoincrement="0"> <datatype>VARCHAR</datatype> <default>NULL</default></row> <row name="name" null="1" autoincrement="0"> <datatype>INTEGER</datatype> <default>NULL</default></row> <row name="email" null="1" autoincrement="0"> <datatype>INTEGER</datatype> <default>NULL</default></row> <row name="email_verified_at" null="1" autoincrement="0"> <datatype>INTEGER</datatype> <default>NULL</default></row> <row name="password" null="1" autoincrement="0"> <datatype>INTEGER</datatype> <default>NULL</default></row> <key type="PRIMARY" name=""> <part>id</part> </key> </table> </sql>