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)