ProjectPrometheus/DataBaseSchema

			{{{~cpp book }}}
bookid	isbn	totalpoint	title

			{{{~cpp BtoBRel }}}
uid	bookid	relbookid	relpoint

					{{{~cpp UtoBRel }}}
uid	bookid	userid	viewpoint	hviewpoint	lviewpoint

		puser
userid	password	name

					review
uid	regdate	bookid	userid	title	contents

~cpp DataBase Create Query for MySQL

{{{~cpp CREATE TABLE IF NOT EXISTS BtoBRel( uid int (11) NOT NULL auto_increment, bookid varchar(12) NOT NULL DEFAULT , relbookid varchar(12) NOT NULL DEFAULT , relpoint int(11) NOT NULL DEFAULT 0, PRIMARY KEY (uid) );

CREATE TABLE IF NOT EXISTS UtoBRel( uid int (11) NOT NULL auto_increment, userid varchar(12) NOT NULL DEFAULT , bookid varchar(12) NOT NULL DEFAULT , viewpoint int(11) NOT NULL DEFAULT 0, hviewpoint int(11) NOT NULL DEFAULT 0, lviewpoint int(11) NOT NULL DEFAULT 0, PRIMARY KEY (uid) );

CREATE TABLE IF NOT EXISTS book( bookid varchar(12) NOT NULL DEFAULT , isbn varchar(10) NOT NULL DEFAULT , totalpoint int(11) NOT NULL DEFAULT 0, title varchar(40) NOT NULL DEFAULT , PRIMARY KEY (bookid) );

CREATE TABLE IF NOT EXISTS puser( userid varchar(16) NOT NULL DEFAULT , password varchar(8) NOT NULL DEFAULT , name varchar(8) NOT NULL DEFAULT , PRIMARY KEY(userid) );

CREATE TABLE review( uid int (11) NOT NULL auto_increment, regdate datetime, bookid varchar(12) NOT NULL DEFAULT , userid varchar(16) NOT NULL DEFAULT , title varchar(40) NOT NULL DEFAULT , contents text NOT NULL DEFAULT , PRIMARY KEY(uid) ); }}}

---

ProjectPrometheus/

~cpp DataBaseSchema