REVIEWERS

Tables (19)

BOARDNUM

  • BOARDNUM — NUMBER(1,0) — Primary key
  • VALUE — VARCHAR2(30 BYTE)

COMMENTS

  • COMMENT_NUM — NUMBER — Primary key
  • USERID — VARCHAR2(100 BYTE) — Foreign key → USERS.USERID
  • CONTENTS_NUM — NUMBER
  • CONTENTS_TYPE — VARCHAR2(5 BYTE)
  • CONTENT — VARCHAR2(4000 BYTE)
  • REG_DATE — DATE
  • STAR_NUM — NUMBER

COMMENT_LIKE

  • COMMENTLIKE_NUM — NUMBER — Primary key
  • USERID — VARCHAR2(100 BYTE) — Foreign key → USERS.USERID
  • COMMENT_NUM — NUMBER
  • COMMENT_NUM (COMMENT_NUM2) — NUMBER — Foreign key → COMMENTS.COMMENT_NUM

CONTENTS_LIKE

  • CLIKE_NUM — NUMBER — Primary key
  • USERID — VARCHAR2(100 BYTE) — Foreign key → USERS.USERID
  • CONTENTS_NUM — NUMBER
  • CONTENTS_TYPE — VARCHAR2(5 BYTE)

CONTENTS_STAR

  • STAR_NUM — NUMBER — Primary key
  • USERID — VARCHAR2(100 BYTE) — Foreign key → USERS.USERID
  • CONTENTS_NUM — NUMBER
  • CONTENTS_TYPE — VARCHAR2(5 BYTE)
  • STAR — NUMBER(5,1)

FAQ_BOARD

  • BOARD_ID — NUMBER(10,0) — Primary key
  • TABLE_ID — NUMBER(3,0)
  • SUBJECT — VARCHAR2(50 BYTE)
  • TITLE — VARCHAR2(200 BYTE)
  • CONTENT — VARCHAR2(3000 BYTE)
  • IS_DELETED — VARCHAR2(1 BYTE)
  • WRITER — VARCHAR2(100 BYTE)
  • WRITER_ID — VARCHAR2(100 BYTE)
  • WRITE_DATE — DATE

HASHTAG

  • BSEQ — NUMBER(10,0) — Foreign key → REVIEWBOARD.BSEQ
  • TAGS — VARCHAR2(300 BYTE)

MOVIE_GENERS

  • SEQ — NUMBER(3,0) — Primary key
  • MOVIEGENERS — VARCHAR2(100 BYTE)
  • COUNT — NUMBER(3,0)

QNA_BOARD

  • BOARD_ID — NUMBER(10,0) — Primary key
  • TABLE_ID — NUMBER(3,0)
  • SUBJECT — VARCHAR2(50 BYTE)
  • TITLE — VARCHAR2(200 BYTE)
  • CONTENT — VARCHAR2(3000 BYTE)
  • WRITER — VARCHAR2(100 BYTE)
  • WRITER_ID — VARCHAR2(100 BYTE)
  • WRITE_DATE — DATE
  • IS_DELETED — VARCHAR2(1 BYTE)
  • IS_ANSWERED — VARCHAR2(1 BYTE)
  • FILE_PATHS — VARCHAR2(300 BYTE)

QNA_BOARD_CMT

  • COMMENT_ID — NUMBER(10,0) — Primary key
  • BOARD_ID — NUMBER(10,0) — Foreign key → QNA_BOARD.BOARD_ID
  • TABLE_ID — NUMBER(3,0)
  • CONTENT — VARCHAR2(3000 BYTE)
  • WRITER — VARCHAR2(100 BYTE)
  • WRITER_ID — VARCHAR2(100 BYTE)
  • WRITE_DATE — DATE
  • IS_DELETED — VARCHAR2(1 BYTE)

QNA_BOARD_FILE

  • FILE_ID — NUMBER(10,0) — Primary key
  • BOARD_ID — NUMBER(10,0) — Foreign key → QNA_BOARD.BOARD_ID
  • FILE_PATH — VARCHAR2(300 BYTE)

REPLY

  • RSEQ — NUMBER(11,0) — Primary key
  • BSEQ — NUMBER(10,0) — Foreign key → REVIEWBOARD.BSEQ
  • WRITER — VARCHAR2(10 BYTE)
  • CONTENT — VARCHAR2(500 BYTE)
  • REGDATE — DATE
  • REDELETEFLAG — VARCHAR2(1 BYTE)
  • REPARENT — NUMBER(11,0)
  • REDEPTH — NUMBER
  • REORDER — NUMBER

REPORTCOMMENT

  • CSEQ — NUMBER(10,0) — Primary key
  • USERID — VARCHAR2(100 BYTE) — Foreign key → USERS.USERID
  • REPORTSEQ — NUMBER(5,0)
  • TARGETID — VARCHAR2(100 BYTE)
  • TABLENUM — NUMBER(1,0)
  • REPORTOPTION — VARCHAR2(50 BYTE)
  • REPORTDETAIL — VARCHAR2(500 BYTE)
  • REPORT — VARCHAR2(1 BYTE)

REPORTREVIEW

  • REPORTSEQ — NUMBER(5,0) — Primary key
  • BSEQ — NUMBER(10,0) — Foreign key → REVIEWBOARD.BSEQ
  • TARGETID — VARCHAR2(100 BYTE)
  • TABLENUM — NUMBER(1,0)
  • REPORTOPTION — VARCHAR2(50 BYTE)
  • REPORTDETAIL — VARCHAR2(500 BYTE)
  • USERID — VARCHAR2(100 BYTE) — Foreign key → USERS.USERID

REVIEWBOARD

  • BSEQ — NUMBER(10,0) — Primary key
  • USERID — VARCHAR2(100 BYTE) — Foreign key → USERS.USERID
  • BOARDNUM — NUMBER(1,0) — Foreign key → BOARDNUM.BOARDNUM
  • TITLE — VARCHAR2(100 BYTE)
  • NICKNAME — VARCHAR2(100 BYTE)
  • CONTENT — VARCHAR2(3000 BYTE)
  • FILENAME — VARCHAR2(100 BYTE)
  • WRITEDATE — DATE
  • LIKE_NUM — NUMBER(4,0)
  • UNLIKE_NUM — NUMBER(4,0)
  • CNT — NUMBER(5,0)
  • REPORT — VARCHAR2(1 BYTE)
  • MOVIECODE — NUMBER(10,0)
  • CONTENTTYPE — VARCHAR2(30 BYTE)

REVIEWCNTHISTORY

  • BSEQ — NUMBER(10,0) — Foreign key → REVIEWBOARD.BSEQ
  • USERID — VARCHAR2(100 BYTE)

REVIEWLIKE

  • BSEQ — NUMBER(10,0) — Foreign key → REVIEWBOARD.BSEQ
  • USERID — VARCHAR2(100 BYTE)

USERBLACKLIST

  • SEQ — NUMBER(5,0) — Primary key
  • USERID — VARCHAR2(100 BYTE) — Foreign key → USERS.USERID
  • REPORTDATE — DATE
  • ENDDATE — DATE

USERS

  • USERID — VARCHAR2(100 BYTE) — Primary key
  • PASSWORD — VARCHAR2(100 BYTE)
  • TEL — VARCHAR2(100 BYTE)
  • EMAIL — VARCHAR2(100 BYTE)
  • NAME — VARCHAR2(100 BYTE)
  • ROLE — VARCHAR2(100 BYTE)
  • NICKNAME — VARCHAR2(100 BYTE)
  • PROFILEIMG — VARCHAR2(100 BYTE)
  • REPORTCOUNT — NUMBER(5,0)
  • REPORT — VARCHAR2(1 BYTE)