movie

Tables (22)

Untitled (게시판1이미지)

  • Key (board1Image_no) — NUMBER — Primary key — NOT NULL
  • Key (board_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
  • Field

Untitled (별점)

  • Key (rating_no) — NUMBER — Primary key — NOT NULL
  • Field (start_num) — NUMBER
  • Field

Untitled (유저-장르)

  • Key (user_genre_no) — NUMBER — Primary key — NOT NULL
  • Key (member_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
  • Key (genrecategory_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
  • Field

Untitled (유저-영화-별점)

  • Key (seq) — NUMBER — Primary key — NOT NULL
  • Key (member_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
  • Key (rating_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
  • Key (movie_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
  • Field

Untitled (관리자게시판1)

  • Key (adminBoard1_no) — NUMBER — Primary key — NOT NULL
  • Key (member_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
  • Key (auth_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
  • Key (member_no2) — NUMBER — Foreign key → Untitled.Key — NOT NULL
  • Key (autncategory_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
  • Field

Untitled (영화-배우)

  • Key (movie_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
  • Key (actor_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL

Untitled (영화-감독)

  • Key (movie_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
  • Key (direct_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL

Untitled (배우)

  • Key (actor_no) — NUMBER — Primary key — NOT NULL
  • Field

Untitled (감독)

  • Key (direct_no) — NUMBER — Primary key — NOT NULL
  • Field

Untitled (한줄리뷰)

  • Key (onelinereview_no) — NUMBER — Primary key — NOT NULL
  • Key (movie_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
  • Key (member_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
  • Field

Untitled (영화추천)

  • Key (moviLike_no) — NUMBER — Primary key — NOT NULL
  • Key (movie_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
  • Key (member_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
  • Key (onelinereview_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
  • Field

Untitled (영화)

  • Key (movie_no) — NUMBER — Primary key — NOT NULL
  • Field (code) — NUMBER
  • Field (subtitle) — VARCHAR2(400)
  • Field (pubDate) — DATE
  • Field2 (nation)
  • Field3 (company)
  • Field4 (prodYear)
  • Field5 (runtime)
  • Field (repRlsDate)

Untitled (메일인증)

  • Key (mainauth_no) — Primary key — NOT NULL
  • Key (member_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL

Untitled (영화이미지)

  • Key (movie_image_no) — NUMBER — Primary key — NOT NULL
  • Key (movie_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
  • Field

Untitled (댓글)

  • Key (reply_no) — NUMBER — Primary key — NOT NULL
  • Key (board_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
  • Key (member_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
  • Field

Untitled (게시판추천)

  • Key (like_no) — NUMBER — Primary key — NOT NULL
  • Key (member_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
  • Key (board_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
  • Field

Untitled (게시판1)

  • Key (board_no) — NUMBER — Primary key — NOT NULL
  • Key (member_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
  • Field

Untitled (유저-권한)

  • Key (auth_no) — NUMBER — Primary key — NOT NULL
  • Key (member_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
  • Key (autncategory_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL

Untitled (권한)

  • Key (autncategory_no) — NUMBER — Primary key — NOT NULL
  • Field (auth_name) — VARCHAR2(100)
  • Field

Untitled (유저)

  • Key (member_no) — NUMBER — Primary key — NOT NULL
  • Field

Untitled (영화-장르)

  • Key (genre_no) — NUMBER — Primary key — NOT NULL
  • Key (genrecategory_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL
  • Key (movie_no) — NUMBER — Foreign key → Untitled.Key — NOT NULL

Untitled (장르)

  • Key (genrecategory_no) — NUMBER — Primary key — NOT NULL
  • Field (action)
  • Field2 (sf)
  • Field3
  • Field4
  • Field5
  • Field6