now_info

Tables (4)

USERINFO

  • NICKNAME — VARCHAR2(20) — Primary key
  • LOGIN_ID — VARCHAR2(20)
  • LOGIN_PW — VARCHAR2(20)
  • Field4 (EMAIL) — VARCHAR2(20)
  • Field (PHONE) — VARCHAR2(20)

Untitled3 (FREEBBOARD)

  • Field (WRITE_NUM) — NUMBER(20) — Primary key
  • Field3 (WRITE_TITLE) — VARCHAR2(100)
  • Field4 (WRITE_CONTENTS) — VARCHAR2(2000)
  • Field (REG_DATE) — DATE
  • NICKNAME — VARCHAR2(20) — Foreign key → USERINFO.NICKNAME

Untitled4 (FREEBOARD_REPLY)

  • Key (REPLY_NUM) — NUMBER(20) — Primary key — NOT NULL
  • Field (REPLY_WRITE) — NUMBER(20)
  • Field2 (REG_DATE) — DATE
  • NICKNAME — VARCHAR2(20) — Foreign key → USERINFO.NICKNAME
  • Field (WRITE_NUM) — NUMBER(20) — Foreign key → Untitled3.Field

movie_info (MOVIE)

  • MOVIE_ID — number — Primary key
  • TITLE — VARCHAR2(30)
  • OPEN_DATE — DATE
  • RUNTIME — NUMBER
  • GENRE — VARCHAR2(30)
  • DIRECTOR — VARCHAR2(30)
  • CAST — VARCHAR2(30)
  • MOVIE_GRADE — NUMBER
  • COMMENT_1 — VARCHAR2(2000)
  • NICKNAME — VARCHAR2(20) — Foreign key → USERINFO.NICKNAME