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