GOBOOKE
Tables (17)
BOOK
- BOOK_SEQ — NUMBER — Primary key — NOT NULL
- BOOK_ID — NUMBER
- BOOK_TITLE — VARCHAR2(500)
- BOOK_LINK — VARCHAR2(1000)
- BOOK_AUTHOR — VARCHAR2(300)
- BOOK_PUBDATE — DATE
- BOOK_DESCRIPTION — CLOB
- BOOK_ISBN — VARCHAR2(20)
- BOOK_ISBN13 — VARCHAR2(20)
- BOOK_PRICESALES — NUMBER(10, 2)
- BOOK_PRICESTANDARD — NUMBER(10, 2)
- BOOK_MALLTYPE — VARCHAR2(100)
- BOOK_STOCKSTATUS — VARCHAR2(100)
- BOOK_MILEAGE — NUMBER(10, 2)
- BOOK_COVER — VARCHAR2(1000)
- BOOK_CATEGORYID — VARCHAR2(100)
- BOOK_CATEGORYNAME — VARCHAR2(300)
- BOOK_PUBLISHER — VARCHAR2(300)
- BOOK_SALESPOINT — NUMBER
- BOOK_ADULT — VARCHAR2(5)
- BOOK_FIXEDPRICE — VARCHAR2(5)
- BOOK_CUSTOMERREVIEWRANK — NUMBER(2,1)
- BOOK_SERIESID — VARCHAR2(100)
- BOOK_SERIESLINK — VARCHAR2(1000)
- BOOK_SERIESNAME — VARCHAR2(300)
- BOOK_SUBINFO — CLOB
BOOK_CATEGORY
- BC_CID — NUMBER — Primary key — NOT NULL
- BC_DEPT — NUMBER
- BC_CID_NAME — VARCHAR2(100)
- BC_COUNTRY — VARCHAR2(20)
- BC_DEPT1_CID — NUMBER
- BC_DEPT1_NAME — VARCHAR2(100)
- BC_DEPT2_CID — NUMBER
- BC_DEPT2_NAME — VARCHAR2(100)
- BC_DEPT3_CID — NUMBER
- BC_DEPT3_NAME — VARCHAR2(100)
- BC_DEPT4_CID — NUMBER
- BC_DEPT4_NAME — VARCHAR2(100)
- BC_DEPT5_CID — NUMBER
- BC_DEPT5_NAME — VARCHAR2(100)
CHAT
- CHAT_SEQ — NUMBER — Primary key — NOT NULL
- CHAT_MESSAGE — VARCHAR2(500)
- CHAT_CREATE_TIME — TIMESTAMP
- USER_SEQ — NUMBER — Foreign key → USER.USER_SEQ — NOT NULL
- STUDY_SEQ — NUMBER — Foreign key → STUDY.STUDY_SEQ — NOT NULL
COMMENTS
- COMMENT_SEQ — NUMBER — Primary key — NOT NULL
- COMMENTS_CONTENTS — VARCHAR2(2000)
- COMMENTS_CREATE_TIME — TIMESTAMP
- COMMENTS_DELETE_TIME — TIMESTAMP
- COMMENTS_EDIT_TIME — TIMESTAMP
- COMMENTS_PARENT_SEQ — NUMBER
- COMMENTS_IS_PUBLIC — VARCHAR2(1)
- USER_SEQ — NUMBER — Foreign key → USER.USER_SEQ — NOT NULL
- REVIEW_SEQ — NUMBER — Foreign key → REVIEW.REVIEW_SEQ — NOT NULL
NOTICE
- NOTICE_SEQ — NUMBER — Primary key — NOT NULL
- NOTICE_TITLE — VARCHAR2(100)
- NOTICE_CREATE_TIME — TIMESTAMP
- NOTICE_EDIT_TIME — TIMESTAMP
- NOTICE_DELETE_TIME — TIMESTAMP
- NOTICE_CONTENTS — VARCHAR2(2000)
PHOTO
- PHOTO_SEQ — NUMBER — Primary key — NOT NULL
- PHOTO_BOARD_SEQ — NUMBER
- PHOTO_RENAMED_NAME — VARCHAR2(100)
PLACE
- PLACE_SEQ — NUMBER — Primary key — NOT NULL
- PLACE_TITLE — VARCHAR2(100)
- PLACE_CONTENTS — VARCHAR2(2000)
- PLACE_CREATE_TIME — TIMESTAMP
- PLACE_DELETE_TIME — TIMESTAMP
- PLACE_ADDRESS — VARCHAR2(100)
- PLACE_LATITUDE — NUMBER
- PLACE_LONGITUDE — NUMBER
- PLACE_IS_PUBLIC — VARCHAR(1)
- USER_SEQ — NUMBER — Foreign key → USER.USER_SEQ — NOT NULL
RECOMMEND
- REC_SEQ — NUMBER — Primary key — NOT NULL
- REC_TYPE — VARCHAR2(1)
- REC_BOARD_SEQ — NUMBER
- USER_SEQ — NUMBER — Foreign key → USER.USER_SEQ — NOT NULL
REPORTS
- REP_SEQ — NUMBER — Primary key — NOT NULL
- REP_REASON — VARCHAR2(100)
- REP_BOARD_SEQ — NUMBER
- REP_CREATE_TIME — TIMESTAMP
- USER_SEQ — NUMBER — Foreign key → USER.USER_SEQ — NOT NULL
REVIEW
- REVIEW_SEQ — NUMBER — Primary key — NOT NULL
- REVIEW_TITLE — VARCHAR2(100)
- REVIEW_CONTENTS — VARCHAR2(2000)
- REVIEW_RATE — NUMBER
- REVIEW_CREATE_TIME — TIMESTAMP
- REVIEW_DELETE_TIME — TIMESTAMP
- REVIEW_EDIT_TIME — TIMESTAMP
- REVIEW_IS_PUBLIC — VARCHAR(1)
- USER_SEQ — NUMBER — Foreign key → USER.USER_SEQ — NOT NULL
- BOOK_SEQ — NUMBER — Foreign key → BOOK.BOOK_SEQ — NOT NULL
SCHEDULE
- SCHEDULE_SEQ — NUMBER — Primary key — NOT NULL
- SCHEDULE_IS_CONFIRM — VARCHAR(1)
- SCHEDULE_DELETE_TIME — TIMESTAMP
- SCHEDULE_CREATE_TIME — TIMESTAMP
- SCHEDULE_DATE — DATE
- SCHEDULE_NOSHOW_YN — VARCHAR(1)
- STUDY_SEQ — NUMBER — Foreign key → STUDY.STUDY_SEQ — NOT NULL
- PLACE_SEQ — NUMBER — Foreign key → PLACE.PLACE_SEQ — NOT NULL
SPEED
- SPD_SEQ — NUMBER — Primary key — NOT NULL
- SPD_POINT — NUMBER
- SPD_DATE — TIMESTAMP
STUDY
- STUDY_SEQ — NUMBER — Primary key — NOT NULL
- STUDY_TITLE — VARCHAR2(100)
- STUDY_CONTENT — VARCHAR(2000)
- STUDY_DATE — TIMESTAMP
- STUDY_MEMBER_LIMIT — NUMBER
- STUDY_EDIT_TIME — TIMESTAMP
- STUDY_CREATE_TIME — TIMESTAMP
- STUDY_PLACE — VARCHAR2(100)
- STUDY_IS_PUBLIC — VARCHAR(1)
- STUDY_DELETE_TIME — TIMESTAMP
- USER_SEQ — NUMBER — Foreign key → USER.USER_SEQ — NOT NULL
- SC_SEQ — NUMBER — Foreign key → STUDY_CATEGORY.SC_SEQ — NOT NULL
STUDY_CATEGORY
- SC_SEQ — NUMBER — Primary key — NOT NULL
- SC_TITLE — VARCHAR2(20)
STUDY_REQUEST
- REQUEST_SEQ — NUMBER — Primary key — NOT NULL
- REQUEST_MSG — VARCHAR2(100)
- REQUEST_CONFIRM — VARCHAR(255)
- REQUEST_DELETE_TIME — TIMESTAMP
- USER_SEQ — NUMBER — Foreign key → USER.USER_SEQ — NOT NULL
- STUDY_SEQ — NUMBER — Foreign key → STUDY.STUDY_SEQ — NOT NULL
USER
- USER_SEQ — NUMBER — Primary key — NOT NULL
- USER_ID — VARCHAR2(50)
- USER_PWD — VARCHAR2(500)
- USER_NICKNAME — VARCHAR2(50)
- USER_GENDER — VARCHAR2(1)
- USER_PHONE — VARCHAR2(20)
- USER_ADDRESS — VARCHAR2(100)
- USER_PROFILE — VARCHAR2(100)
- USER_INTRO — VARCHAR2(500)
- USER_TYPE — VARCHAR2(1)
- USER_EMAIL — VARCHAR2(50)
- USER_CREATE_TIME — TIMESTAMP
- USER_DELETE_TIME — TIMESTAMP
- USER_SPEED — NUMBER
WISHLIST
- WL_SEQ — NUMBER — Primary key — NOT NULL
- USER_SEQ — NUMBER — Foreign key → USER.USER_SEQ — NOT NULL
- BOOK_SEQ — NUMBER — Foreign key → BOOK.BOOK_SEQ — NOT NULL