KH_DB_MINI
Tables (6)
ADMININFO (관리자 정보)
- LOGIN_ID (관리자 아이디) — VARCHAR2(20) — Primary key — NOT NULL
- LOGIN_PW (관리자 비밀번호) — VARCHAR2(20)
FREEBOARD (자유게시판)
- WRITE_NUM (글 번호) — NUMBER(20) — Primary key — NOT NULL
- WRITE_TITLE (제목) — VARCHAR2(100)
- WRITE_CONTENTS (내용) — VARCHAR2(4000)
- REG_DATE (작성날짜) — DATE
- NICKNAME (닉네임) — NUMBER — Foreign key → USERINFO.NICKNAME — NOT NULL
FREEBOARD_REPLY (댓글)
- REPLY_NUM (댓글 번호) — NUMBER(20) — Primary key
- REPLY_WRITE (댓글 작성) — VARCHAR2(300)
- REG_DATE (작성 날짜) — DATE
- WRITE_NUM (글 번호2) — NUMBER(20) — Foreign key → FREEBOARD.WRITE_NUM — NOT NULL
- NICKNAME (닉네임2) — NUMBER(20) — Foreign key → USERINFO.NICKNAME — NOT NULL
MOVIE (영화정보)
- MOVIE_ID (영화 번호) — NUMBER — Primary key — NOT NULL
- TITLE (영화 제목) — VARCHAR2(200)
- OPEN_DATE (개봉일) — DATE
- RUNTIME (상영시간) — NUMBER(4)
- GENRE (장르) — VARCHAR2(50)
- DIRECTOR (감독) — VARCHAR2(100)
- CAST (출연 배우) — VARCHAR2(200)
MOVIE_GRADE (평점)
- GRADE (영화 평점) — NUBER
- COMMENT_1 (한줄평) — VARCHAR2(20)
- NICKNAME (닉네임) — NUMBER — Foreign key → USERINFO.NICKNAME — NOT NULL
- MOVIE_ID (영화 번호2) — NUMBER — Foreign key → MOVIE.MOVIE_ID — NOT NULL
USERINFO (회원정보)
- NICKNAME (닉네임) — VARCHAR2(20) — Primary key — NOT NULL
- LOGIN_ID (아이디) — VARCHAR2(20)
- LOGIN_PWD (비밀번호) — VARCHAR2(20)
- EMAIL (이메일) — VARCHAR2(20)
- PHONE (핸드폰번) — VARCHAR2(20)