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)