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