Book-Review-Website

Tables (11)

ATTENDANCE (Untitled11)

  • AT_NO (Key) — NUMBER — Primary key — NOT NULL
  • AT_CONTENT (Field) — VARCHAR2(300)
  • AT_TOTAL (Field2) — NUMBER
  • AT_DATE (Field4) — DATE
  • AT_USERID (Key2) — varchar2(20) — Foreign key → USERTABLE.USERID — NOT NULL

BASKET (Untitled10)

  • BASKETNO (Key) — NUMBER — Primary key — NOT NULL
  • BASKUSERID (Key2) — varchar2(20) — Foreign key → USERTABLE.USERID — NOT NULL
  • BASKUSERNAME (Field) — VARCHAR2(300)
  • BASKBOOKTITLE (Field2) — VARCHAR2(300)
  • BASKPRICE (Field3) — NUMBER
  • BASKISBN (Key3) — number — Foreign key → BOOK.ISBN — NOT NULL
  • BASKQUANTITY (Field4) — NUMBER
  • BASKPICKDATE (Field5) — DATE
  • Field6

BOOK (Untitled3)

  • ISBN (Key) — number — Primary key — NOT NULL
  • BOOKTITLE (Field) — varchar2(200)
  • AUTHOR (Field2) — varchar2(200)
  • PRICESTANDARD (Field3) — number
  • PUBLISHER (Field4) — varchar2(100)

NOTICE (Untitled9)

  • NTC_NO (Key) — NUMBER — Primary key — NOT NULL
  • NTC_TITLE (Field) — VARCHAR2(200)
  • NTC_CONTENT (Field2) — VARCHAR2(3000)
  • NTC_DATE (Field3) — DATE
  • NTC_READCNT (Field4) — NUMBER
  • NTC_ALLOWVIEW (Field5) — CHAR(1)
  • NTC_DELFLAG (Field6) — CHAR(1)

ONELINEREVIEW (Untitled8)

  • OR_NO (Key) — NUMBER — Primary key — NOT NULL
  • OR_ISBN (Key2) — number — Foreign key → BOOK.ISBN — NOT NULL
  • OR_CONTENT (Field) — VARCHAR2(50)
  • OR_STARSCORE (Field2) — NUMBER
  • OR_USERID (Key3) — varchar2(20) — Foreign key → USERTABLE.USERID — NOT NULL
  • OR_NOW (Field3) — DATE
  • OR_DEL_FLAG (Field4) — DATE

REVIEWBOARD (Untitled4)

  • RB_NO (Key) — number — Primary key — NOT NULL
  • RB_BOOKTITLE (Field) — VARCHAR2(500)
  • RB_TITLE (Field2) — VARCHAR2(200)
  • RB_CONTENT (Field3) — VARCHAR2(2000)
  • RB_STARSCORE (Field4) — NUMBER
  • RB_DATE (Field5) — DATE
  • RB_READCNT (Field6) — NUMBER
  • RB_RECOMMEND (Field7) — NUMBER
  • RB_REPORT (Field8) — NUMBER
  • DEL_FLAG (Field9) — CHAR(1)
  • RB_WRITER (Key2) — varchar2(20) — Foreign key → USERTABLE.USERID — NOT NULL
  • RB_ISBN (Key3) — number — Foreign key → BOOK.ISBN — NOT NULL

REVIEWBOARD_COMMENT (Untitled5)

  • RB_COMMENT_NO (Key) — NUMBER — Primary key — NOT NULL
  • RB_REF (Key3) — number — Foreign key → REVIEWBOARD.RB_NO — NOT NULL
  • RB_COMMENT_WRITER (Key2) — varchar2(20) — Foreign key → USERTABLE.USERID — NOT NULL
  • RB_COMMENT_LEVEL (Field) — NUMBER
  • RB_COMMENT_CONTENT (Field2) — VARCHAR2(2000)
  • RB_COMMENT_DATE (Field3) — DATE
  • RB_COMMENT_REF (Key4) — NUMBER — Foreign key → REVIEWBOARD_COMMENT.RB_COMMENT_NO — NOT NULL
  • RB_COMMENT_DELFLAG (Field4) — DATE
  • RB_COMMENT_WRITER_NICKnaME (Key5) — varchar2(20) — Foreign key → USERTABLE.USERID — NOT NULL

REVIEWBOARD_REPORT (Untitled7)

  • RB_REPORTNO (Key) — NUMBER — Primary key — NOT NULL
  • RB_REPORT_RBNO (Key2) — NUMBER — Foreign key → REVIEWBOARD.RB_NO — NOT NULL
  • RB_REPORT_TITLE (Field) — VARCHAR2(500)
  • RB_REPORTSUSPECT (Key3) — varchar2(100) — Foreign key → USERTABLE.USERID — NOT NULL
  • RB_REPORT_WRITER (Key4) — VARCHAR2(500) — Foreign key → USERTABLE.USERID — NOT NULL
  • RB_REPORT_CONTNENT (Field2) — VARCHAR2(2000)
  • RB_REPORT_CLASSES (Field3) — VARCHAR2(500)
  • RB_REPORT_DATE (Field4) — DATE

REVIEW_LIKE (Untitled6)

  • LIKENO (Key) — NUMBER — Primary key — NOT NULL
  • LIKE_RBNO (Key2) — number — Foreign key → REVIEWBOARD.RB_NO — NOT NULL
  • LIKE_COUNTER (Field) — NUMBER
  • LIKE_USERID (Key3) — varchar2(20) — Foreign key → USERTABLE.USERID — NOT NULL

USERTABLE (Untitled)

  • USERID (Key) — varchar2(20) — Primary key — NOT NULL
  • USERPASSWORD (Field) — varchar2(200)
  • USERNAME (Field2) — varchar2(20)
  • USEREMAIL (Field3) — varchar2(30)
  • USERPOING (Field4) — number
  • USERGRADE (Field5) — number
  • JOINDATE (Field6) — date
  • CHANGEDATE (Field7) — date
  • USERNICKNAME (Field8) — varchar2(200)
  • USER_DEL_FLAG (Field9) — Char(1)

USER_POINT_LOG (Untitled2)

  • UPL_NO (Key) — number — Primary key — NOT NULL
  • UPL_DATE (Field) — date
  • UPL_CLASSIFICATION (Field2) — varchar2(20)
  • UPL_GETPTS (Field3) — number
  • USERID (Key2) — varchar2(20) — Foreign key → USERTABLE.USERID — NOT NULL