데이터베이스

[piedroconti]

TABLE User

user_id    INTEGER NOT NULL [pk],
nickname    VARCHAR2(30),
password    VARCHAR2(30),
name    VARCHAR2(30),
birth    DATE,
gender    VARCHAR2(30),
phone_number    INTEGER,
profile    BLOB,
is_admin    SMALLINT

User(one, partial) - Comments(many, total)
User(one, partial) - ReviewPost(many, total)
User(one, partial) - FreeBoardPost(many, total)
User(one, partial) - Announcement(many, total)
User(one, partial) - DiscussionPost(many, total)

TABLE Comments

comment_id    INTEGER NOT NULL [pk],
contents    VARCHAR2(500),
date_created    DATE,
review_id    INTEGER NOT NULL [fk reference ReviewPost],
user_id    INTEGER NOT NULL [fk reference User]

TABLE ReviewPost

review_id    INTEGER NOT NULL [pk],
title    VARCHAR2(40),
contents    VARCHAR2(1000),
date_created    DATE,
rating    FLOAT,
user_id    INTEGER NOT NULL [fk reference User],
book_id    INTEGER NOT NULL [fk reference Book]

ReviewPost(one, partial) - Comments(many, total)

TABLE Book

book_id    INTEGER NOT NULL [pk],
title    VARCHAR2(40),
author    VARCHAR2(20),
contents    VARCHAR2(500),
cover_image    BLOB,
rating    FLOAT

Book(one, partial) - ReviewPost(many, total)
Book(one, partial) - BookTagAssociation(many, total)

TABLE BookTagAssociation

book_id    INTEGER NOT NULL [fk reference Book],
tag_id    INTEGER NOT NULL [fk reference BookTag]

TABLE BookTag

tag_id    INTEGER NOT NULL,
tag_name    VARCHAR2(20)

BookTag(one, partial) - BookTagAssociation(many, total)

TABLE FreeBoardPost

post_id    INTEGER NOT NULL [pk],
title    VARCHAR2(40),
contents    VARCHAR2(1000),
date_created    DATE,
user_id    INTEGER NOT NULL [fk reference User]

TABLE Announcement

announcement_id    INTEGER NOT NULL [pk],
title    VARCHAR2(40),
contents    VARCHAR2(1000),
date_created    DATE,
user_id    INTEGER NOT NULL [fk reference User]

TABLE DiscussionPost

discussion_id    INTEGER NOT NULL [pk],
title    VARCHAR2(40),
contents    VARCHAR2(1000),
date_created    DATE,
topic_id    INTEGER NOT NULL [fk reference DiscussionTopic],
user_id    INTEGER NOT NULL [fk reference User]

TABLE DiscussionTopic

topic_id    INTEGER NOT NULL [pk],
title    VARCHAR2(100),
date_created    DATE

DiscussionTopic(one, partial) - DiscussionPost(many, total)