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