moviefinder

Tables (6)

Untitled

  • Key — Primary key — NOT NULL
  • Field
  • Field2

event (이벤트)

  • eventId — NUMBER — Primary key — NOT NULL
  • eventImg — VARCHAR2
  • eventLink — VARCHAR2
  • eventTitle — VARCHAR2
  • eventSubTitle — VARCHAR2
  • eventContent — VARCHAR2

magazine (메거진)

  • magazineId — NUMBER — Primary key — NOT NULL
  • magazineImg — VARCHAR2
  • magazineLink — VARCHAR2
  • magazineTitle — VARCHAR2
  • magazineSubTitle — VARCHAR2
  • magazineContent — VARCHAR2

movieComment (영화 댓글)

  • movieid — NUMBER — Foreign key → privacyMovie.movieid — NOT NULL
  • commentId — NUMBER
  • name — VARCHAR2
  • email — VARCHAR2
  • movieComment — VARCHAR2
  • like — NUMBER
  • date — DATE
  • Field

privacyMovie (영화 기록)

  • movieid — NUMBER — Primary key — NOT NULL
  • key — NUMBER — Foreign key → user.id — NOT NULL
  • id — NUMBER
  • date — DATE
  • movieId — VARCHAR2
  • movieImg — VARCHAR2
  • movieTitle — VARCHAR2
  • movieDate — VARCHAR2
  • movieRate — VARCHAR2

user (유저)

  • id — NUMBER — Primary key — NOT NULL
  • name — VARCHAR2
  • email — VARCHAR2
  • password — VARCHAR2