movie_jpac
Tables (11)
BOARD
- BOARDNO — NUMBER(10) — Primary key — NOT NULL
- MEMBERNO — NUMBER(5) — Foreign key → MEMBER.MEMBERNO — NOT NULL
- TITLE — VARCHAR2(255) — NOT NULL
- CONTENT — CLOB — NOT NULL
- CNT — NUMBER(10) — NOT NULL
- FILE1 — VARCHAR2(255)
- FILE1SAVED — VARCHAR2(255)
- THUMB1 — VARCHAR2(255)
- SIZE1 — NUMBER(10)
- RDATE — TIMESTAMP — NOT NULL
- VISIBLE — VARCHAR2(255) — NOT NULL
- NICKNAME — VARCHAR2(255)
CATE
- CATENO — NUMBER(10) — Primary key — NOT NULL
- GRP — VARCHAR2(30) — NOT NULL
- NAME — VARCHAR2(30) — NOT NULL
- CNT — NUMBER(7) — NOT NULL
- SEQNO — NUMBER(5) — NOT NULL
- VISIBLE — VARCHAR2(1) — NOT NULL
- RDATE — TIMESTAMP — NOT NULL
MEMBER
- MEMBERNO — NUMBER(5) — Primary key — NOT NULL
- ID — VARCHAR2(255) — NOT NULL
- PASSWD — VARCHAR2(255) — NOT NULL
- NAME — VARCHAR2(255) — NOT NULL
- NICKNAME — VARCHAR2(255) — NOT NULL
- EMAIL — VARCHAR2(255) — NOT NULL
- PREFER_FEAR — NUMBER(2) — NOT NULL
- JOINDATE — TIMESTAMP — NOT NULL
- GRADE — NUMBER(2) — NOT NULL
MOVIE
- MOVIENO — NUMBER(7) — Primary key — NOT NULL
- TITLE — VARCHAR2(200) — NOT NULL
- GENRE — VARCHAR2(300) — NOT NULL
- FEARINDEX — NUMBER(2) — NOT NULL
- DIRECTOR — VARCHAR2(300) — NOT NULL
- RDATE — DATE — NOT NULL
- CNT — NUMBER(10) — NOT NULL
- OPENDATE — TIMESTAMP
- KOBIS_MOVIE_CD — VARCHAR2(20)
- NATION — VARCHAR2(300)
- RELEASE_DATE — DATE
- RUNTIME — NUMBER(10)
- TITLE_EN — VARCHAR2(300)
- TMDB_ID — NUMBER
- OVERVIEW — CLOB
- POSTER_URL — VARCHAR2(500)
- BACKDROP_URL — VARCHAR2(500)
MOVIE_CATE
- MOVIE_CATE_NO — NUMBER — Primary key — NOT NULL
- MOVIENO — NUMBER — Foreign key → MOVIE.MOVIENO — NOT NULL
- CATENO — NUMBER — Foreign key → CATE.CATENO — NOT NULL
MOVIE_WATCHED
- WATCHEDNO — NUMBER(10) — Primary key — NOT NULL
- MEMBERNO — NUMBER(10) — Foreign key → MEMBER.MEMBERNO — NOT NULL
- MOVIENO — NUMBER(10) — Foreign key → MOVIE.MOVIENO — NOT NULL
- RDATE — DATE — NOT NULL
NOTIFICATION
- NOTIFICATIONNO — NUMBER(10) — Primary key — NOT NULL
- MEMBERNO — NUMBER(10) — Foreign key → MEMBER.MEMBERNO — NOT NULL
- ACTOR_MEMBERNO — NUMBER(10) — Foreign key → MEMBER.MEMBERNO
- TALKNO — NUMBER(10) — Foreign key → TALK.TALKNO
- TYPE — VARCHAR2(30) — NOT NULL
- MESSAGE — VARCHAR2(500) — NOT NULL
- READ_YN — VARCHAR2(1) — NOT NULL
- RDATE — DATE — NOT NULL
TALK
- TALKNO — NUMBER — Primary key — NOT NULL
- MEMBERNO — NUMBER — Foreign key → MEMBER.MEMBERNO — NOT NULL
- THREAD_TYPE — VARCHAR2(30) — NOT NULL
- TITLE — VARCHAR2(300) — NOT NULL
- CONTENT — CLOB — NOT NULL
- SPOILER — CHAR(1) — NOT NULL
- NOTICE — CHAR(1) — NOT NULL
- CNT — NUMBER — NOT NULL
- VISIBLE — CHAR(1) — NOT NULL
- RDATE — DATE — NOT NULL
TALK_LIKE
- TALKLIKENO — NUMBER(10) — Primary key — NOT NULL
- TALKNO — NUMBER(10) — Foreign key → TALK.TALKNO — NOT NULL
- MEMBERNO — NUMBER(10) — Foreign key → MEMBER.MEMBERNO — NOT NULL
- RDATE — DATE — NOT NULL
TALK_MOVIE
- TALK_MOVIE_NO — NUMBER — Primary key — NOT NULL
- TALKNO — NUMBER — Foreign key → TALK.TALKNO — NOT NULL
- MOVIENO — NUMBER — Foreign key → MOVIE.MOVIENO — NOT NULL
TALK_REPLY
- REPLYNO — NUMBER(19) — Primary key — NOT NULL
- CONTENT — VARCHAR2(1000) — NOT NULL
- MEMBERNO — NUMBER(19) — Foreign key → MEMBER.MEMBERNO — NOT NULL
- PARENT_REPLYNO — NUMBER(19) — Foreign key → TALK_REPLY.REPLYNO
- RDATE — TIMESTAMP — NOT NULL
- TALKNO — NUMBER(19) — Foreign key → TALK.TALKNO — NOT NULL
- VISIBLE — VARCHAR2(1) — NOT NULL