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